Woran kan das liegen?
Es gibt folgende Fehlermeldungen:
Code: Alles auswählen
Error type:
SQL Error
Error message:
MYSQL-ERROR
Fehler: 1054
Detail: Unknown column 'ob1.object_5' in 'on clause'
Info:
Query: SELECT of.ID FROM tblObject_6 AS ob6 LEFT JOIN tblObjectFiles of5 ON (of5.ID=ob1.object_5 AND of5.Published>0) LEFT JOIN tblObject_5 AS ob5 ON (ob5.OF_ID=of5.ID) LEFT JOIN tblObjectFiles of3 ON (of3.ID=ob6.object_3 AND of3.Published>0) LEFT JOIN tblObject_3 AS ob3 ON (ob3.OF_ID=of3.ID) LEFT JOIN tblObjectFiles of1 ON (of1.ID=ob6.object_1 AND of1.Published>0) LEFT JOIN tblObject_1 AS ob1 ON (ob1.OF_ID=of1.ID) JOIN tblObjectFiles `of` ON of.ID=ob6.OF_ID WHERE of.IsSearchable=1 AND (of.Workspaces="" OR FIND_IN_SET(0,of.Workspaces)) AND ( of.Published>0 ) GROUP BY of.ID
Code: Alles auswählen
Error type:
SQL Error
Error message:
MYSQL-ERROR
Fehler: 1054
Detail: Unknown column 'Thema' in 'order clause'
Info:
Query: SELECT of.ID AS OF_ID,ob3.`input_Themen` AS we_title,of.ID AS we_ID,of.ParentID AS we_ParentID,of.Text AS we_Text,of.IsFolder AS we_IsFolder,of.ContentType AS we_ContentType,of.CreationDate AS we_CreationDate,of.ModDate AS we_ModDate,of.Published AS we_Published,of.Path AS we_Path,of.Url AS we_Url,of.TriggerID AS we_TriggerID,of.CreatorID AS we_CreatorID,of.ModifierID AS we_ModifierID,of.RestrictOwners AS we_RestrictOwners,of.Owners AS we_Owners,of.OwnersReadOnly AS we_OwnersReadOnly,of.Workspaces AS we_Workspaces,of.TableID AS we_TableID,of.Category AS we_Category,of.ClassName AS we_ClassName,of.IsClassFolder AS we_IsClassFolder,of.IsSearchable AS we_IsSearchable,of.Charset AS we_Charset,of.Language AS we_Language,of.WebUserID AS we_WebUserID,ob3.`input_Themen` AS `Themen`,ob3.`OF_ID` AS `ID` FROM tblObject_3 AS ob3 JOIN tblObjectFiles `of` ON of.ID=ob3.OF_ID WHERE of.IsSearchable=1 AND (of.Workspaces="" OR FIND_IN_SET(0,of.Workspaces)) AND ( of.Published>0 ) ORDER BY `Thema` LIMIT 0,100000000