Project

General

Profile

Actions
Copy link

Support #6661

closed

SQL hint: Unknown column '...' in 'on clause'

Added by Carsten Rose over 5 years ago. Updated over 5 years ago.

Status:
Closed
Priority:
Normal
Assignee:
Elias Villiger
Target version:
18.9.1
Start date:
11.09.2018
Due date:
% Done:

0%

Estimated time:
Discuss:
Prio Planung:
Vote:

Description

Falls ein Fehler "[ mysqli: 1054 ] Unknown column 'v.gr_id' in 'on clause' " kommt:

  • Check ob hinter dem FROM mehr als eine Tabelle kommt und diese nicht in runden Klammern eingeschlossen sind.
... FROM vorlesung AS v, pers_funktion AS pf, gruppe_member AS gmPriv LEFT JOIN Privilege AS priv ON priv.grId2=v.gr_id ... ...

Related issues

Related to QFQ - Feature #6944: SQL hint: double commaClosedElias Villiger10.10.2018

Actions
Actions
Copy link
 #1

Updated by Carsten Rose over 5 years ago

  • Assignee changed from Carsten Rose to Elias Villiger
Actions
Copy link
 #2

Updated by Elias Villiger over 5 years ago

  • Status changed from New to In Progress
Actions
Copy link
 #3

Updated by Elias Villiger over 5 years ago

  • Status changed from In Progress to Closed

Ist bereits implementiert!

Actions
Copy link
 #4

Updated by Carsten Rose over 5 years ago

Actions
Copy link

Also available in: Atom PDF