auf einer Testinstallation haben wir ein Update von 8.1.3 auf 9.0.3 durchgeführt, danach Rebuild.
-> PHP 7.3
-> MySQL 8.0
Jetzt werden keine Objekte mehr angezeigt. Die listviews geben nichts aus und auch wenn man das Objekt direkt aufruft kommt nichts, obwohl die Objekte im Backend vorhanden sind.
Im Fehlerlog erscheint ein SQL-Error:
Code: Alles auswählen
MYSQL-ERROR
Fehler: 1064
Detail: You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near 'of.`ID` AS `we_ID`,of.`ParentID` AS `we_ParentID`,of.`Filename` AS `we_Filename`' at line 1
Info:
Query: SELECT of.ID AS OF_ID,ob1.`text_Kurztext` AS we_description,ob1.`input_Produktname` AS we_title,of.`ID` AS `we_ID`,of.`ParentID` AS `we_ParentID`,of.`Filename` AS `we_Filename`,of.`ContentType` AS `we_ContentType`,of.`Creation_Date` AS `we_Creation_Date`,of.`Mod_Date` AS `we_Mod_Date`,of.`Publish_Date` AS `we_Publish_Date`,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.`IsSearchable` AS `we_IsSearchable`,of.`Language` AS `we_Language`,of.`WebUserID` AS `we_WebUserID`,of.`IsClassFolder` AS `we_IsClassFolder`,of.`IsFolder` AS `we_IsFolder`,of.`IsPublished` AS `we_IsPublished`,of.`IsModified` AS `we_IsModified`,of.`CreationDate` AS `we_CreationDate`,of.`ModDate` AS `we_ModDate`,of.`Published` AS `we_Published`,of.`Text` AS `we_Text`,of.`ClassName` AS `we_ClassName`,of.`Charset` AS `we_Charset`,ob1.`input_SEO_URL` AS `SEO_URL`,ob1.`input_Produktname` AS `Produktname`,ob1.`img_Produktfoto` AS `Produktfoto`,ob1.`text_Produktbeschreibung` AS `Produktbeschreibung`,ob1.`input_Produktart` AS `Produktart`,ob1.`checkbox_Neuheit` AS `Neuheit`,ob1.`text_Kurztext` AS `Kurztext`,ob1.`OF_ID` AS `ID`,ob1.`OF_DocumentTable` AS `DocumentTable`
FROM tblObject_1 AS `ob1` JOIN tblObjectFiles `of` ON (of.ID=ob1.OF_ID AND ob1.OF_DocumentTable="tblObjectFiles")
WHERE of.IsSearchable=1 AND (of.Workspaces="" OR CONCAT(",",of.Workspaces,",") REGEXP ",(44|0),") AND ( of.IsPublished=1 ) AND of.isFolder=0 AND of.ParentID IN(2,2) ORDER BY of.Text LIMIT 0,100000000
Backtrace:
#0 we_base_errorHandler::errorHandler called at [:]
#1 we_database_base->query called at [webEdition/we/classes/listview/we_listview_object.class.php:128]
#2 we_listview_object->__construct called at [webEdition/we/classes/tag/we_tag_listview.class.php:182]
#3 we_tag_listview::tag called at [webEdition/we/classes/weTag/we_weTag_util.class.php:108]
#4 we_weTag_util::tag called at [webEdition/generated/templates/templates/produktgruppe.php:260]
#5 include(/is/htdocs/XXX/www/test/webEdition/generated/templates/templates/produktgruppe.php) called at [webEdition/we/classes/editor/we_editor_showTempDocumentData.class.php:47]
#6 we_editor_showTempDocumentData->show called at [webEdition/we/include/we_showDocument.inc.php:100]
#7 require(/is/htdocs/XXX/www/test/webEdition/we/include/we_showDocument.inc.php) called at [produkte/muster.html:4]