O.k. 
, danke dir 
.
Beiträge von Shania im Thema „Fehlermeldung beim Sortieren nach Dateinamen“
-
-
Konntest du dir das inzwischen ansehen? Ich bräuchte die Testumgebung so langsam mal für anderen Zwecke wieder, will da jetzt aber auch nicht zwischenfunken.
-
Ich kann dich problemlos auf die Testumgebung lassen, denn das Forum ist ohne Beiträge, nur mit Testdaten, wenn dir das reicht. Dann müsstest du mir sagen, was zu ändern ist.
-
Ich habe das nun mal getestet. PlugIn gelöscht, neu installiert, aber der Fehler ist wieder genauso da. Kann sich das mit einem anderen PlugIn beißen? Ich hatte mir auch extra nochmal die aktuellste Version herunter geladen.
-
Ach herje, o.k., kann ich das irgendwo dran erkennen? Das war auf einer meiner Testumgebungen, bevor ich das Upgrade meiner Produktion gemacht habe. Da wäre es jetzt nicht so ein Drama.
Versuche ich dann jetzt den Fehler auch auf meiner Produktionsumgebung zu provozieren oder ist das nicht empfehlenswert?
-
Ist nun alles Wichtige enthalten?
-
Auf ein Neues:
Code
Alles anzeigenThu, 15 Nov 2018 20:49:52 +0000 Message: Could not prepare statement 'SELECT user_avatar_select.* FROM wcf1_user_avatar_select user_avatar_select ORDER BY filename ASC, user_avatar_select.avatarID ASC LIMIT 20' PHP version: 7.1.19-nmm1 WoltLab Suite version: 3.1.6 pl 1 Request URI: /forum/wcf/acp/index.php?select-user-avatar-list/&pageNo=1&sortField=filename&sortOrder=ASC Referrer: /forum/wcf/acp/index.php?select-user-avatar-list/ User Agent: Mozilla/5.0 (Windows NT 10.0; Win64; x64) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/70.0.3538.102 Safari/537.36 Peak Memory Usage: 4388464/551550976 ====== Error Class: wcf\system\database\exception\DatabaseQueryException Error Message: Could not prepare statement 'SELECT user_avatar_select.* FROM wcf1_user_avatar_select user_avatar_select ORDER BY filename ASC, user_avatar_select.avatarID ASC LIMIT 20' Error Code: 42 File: /www/htdocs/w018cd45/wsc.nymphensittich-forum.net/forum/wcf/lib/system/database/Database.class.php (248) Extra Information: - Stack Trace: [{"file":"\/www\/htdocs\***\/forum\/wcf\/lib\/data\/DatabaseObjectList.class.php","line":194,"function":"prepareStatement","class":"wcf\\system\\database\\Database","type":"->","args":["SELECT\t\r\n\t\t\t\t\tuser_avatar_select.*\r\n\t\t\t\tFROM\twcf1_user_avatar_select user_avatar_select\r\n\t\t\t\t\t\r\n\t\t\t\t\t\r\n\t\t\t\t\tORDER BY filename ASC, user_avatar_select.avatarID ASC LIMIT 20",20,0]},{"file":"\/www\/htdocs***\/forum\/wcf\/lib\/page\/MultipleLinkPage.class.php","line":163,"function":"readObjects","class":"wcf\\data\\DatabaseObjectList","type":"->","args":[]},{"file":"\/www\/htdocs\/***\/forum\/wcf\/lib\/page\/MultipleLinkPage.class.php","line":131,"function":"readObjects","class":"wcf\\page\\MultipleLinkPage","type":"->","args":[]},{"file":"\/www\/htdocs\***\/forum\/wcf\/lib\/page\/SortablePage.class.php","line":52,"function":"readData","class":"wcf\\page\\MultipleLinkPage","type":"->","args":[]},{"file":"\/www\/htdocs\/***\/forum\/wcf\/lib\/acp\/page\/SelectUserAvatarListPage.class.php","line":110,"function":"readData","class":"wcf\\page\\SortablePage","type":"->","args":[]},{"file":"\/www\/htdocs\/***\/forum\/wcf\/lib\/page\/AbstractPage.class.php","line":291,"function":"readData","class":"wcf\\acp\\page\\SelectUserAvatarListPage","type":"->","args":[]},{"file":"\/www\/htdocs\/***\/forum\/wcf\/lib\/page\/AbstractPage.class.php","line":114,"function":"show","class":"wcf\\page\\AbstractPage","type":"->","args":[]},{"file":"\/www\/htdocs\/****\/forum\/wcf\/lib\/system\/request\/Request.class.php","line":83,"function":"__run","class":"wcf\\page\\AbstractPage","type":"->","args":[]},{"file":"\/www\/htdocs\***\/forum\/wcf\/lib\/system\/request\/RequestHandler.class.php","line":96,"function":"execute","class":"wcf\\system\\request\\Request","type":"->","args":[]},{"file":"\/www\/htdocs\***\/forum\/wcf\/acp\/index.php","line":9,"function":"handle","class":"wcf\\system\\request\\RequestHandler","type":"->","args":["wcf",true]}] ====== Error Class: PDOException Error Message: SQLSTATE[42S22]: Column not found: 1054 Unknown column 'filename' in 'order clause' Error Code: 42 File: /www/htdocs/***/forum/wcf/lib/system/database/Database.class.php (243) Extra Information: - Stack Trace: [{"file":"\/www\/htdocs\/***\/forum\/wcf\/lib\/system\/database\/Database.class.php","line":243,"function":"prepare","class":"PDO","type":"->","args":["SELECT\t\r\n\t\t\t\t\tuser_avatar_select.*\r\n\t\t\t\tFROM\twcf1_user_avatar_select user_avatar_select\r\n\t\t\t\t\t\r\n\t\t\t\t\t\r\n\t\t\t\t\tORDER BY filename ASC, user_avatar_select.avatarID ASC LIMIT 20"]},{"file":"\/www\/htdocs\/***\/forum\/wcf\/lib\/data\/DatabaseObjectList.class.php","line":194,"function":"prepareStatement","class":"wcf\\system\\database\\Database","type":"->","args":["SELECT\t\r\n\t\t\t\t\tuser_avatar_select.*\r\n\t\t\t\tFROM\twcf1_user_avatar_select user_avatar_select\r\n\t\t\t\t\t\r\n\t\t\t\t\t\r\n\t\t\t\t\tORDER BY filename ASC, user_avatar_select.avatarID ASC LIMIT 20",20,0]},{"file":"\/www\/htdocs\/***\/forum\/wcf\/lib\/page\/MultipleLinkPage.class.php","line":163,"function":"readObjects","class":"wcf\\data\\DatabaseObjectList","type":"->","args":[]},{"file":"\/www\/htdocs\/***\/forum\/wcf\/lib\/page\/MultipleLinkPage.class.php","line":131,"function":"readObjects","class":"wcf\\page\\MultipleLinkPage","type":"->","args":[]},{"file":"\/www\/htdocs\/***\/forum\/wcf\/lib\/page\/SortablePage.class.php","line":52,"function":"readData","class":"wcf\\page\\MultipleLinkPage","type":"->","args":[]},{"file":"\/www\/htdocs\/***\/forum\/wcf\/lib\/acp\/page\/SelectUserAvatarListPage.class.php","line":110,"function":"readData","class":"wcf\\page\\SortablePage","type":"->","args":[]},{"file":"\/www\/htdocs\/***\/forum\/wcf\/lib\/page\/AbstractPage.class.php","line":291,"function":"readData","class":"wcf\\acp\\page\\SelectUserAvatarListPage","type":"->","args":[]},{"file":"\/www\/htdocs\/***\/forum\/wcf\/lib\/page\/AbstractPage.class.php","line":114,"function":"show","class":"wcf\\page\\AbstractPage","type":"->","args":[]},{"file":"\/www\/htdocs\/***\/forum\/wcf\/lib\/system\/request\/Request.class.php","line":83,"function":"__run","class":"wcf\\page\\AbstractPage","type":"->","args":[]},{"file":"\/www\/htdocs\/***\/forum\/wcf\/lib\/system\/request\/RequestHandler.class.php","line":96,"function":"execute","class":"wcf\\system\\request\\Request","type":"->","args":[]},{"file":"\/www\/htdocs\/***\/forum\/wcf\/acp\/index.php","line":9,"function":"handle","class":"wcf\\system\\request\\RequestHandler","type":"->","args":["wcf",true]}]Ich hoffe, ich hab alles erwischt.
-
Ich bekam gerade beim Sortieren nach dem Dateinamen diese Fehlermeldung:
Code
Alles anzeigenThu, 15 Nov 2018 20:41:29 +0000 Message: Could not prepare statement 'SELECT user_avatar_select.* FROM wcf1_user_avatar_select user_avatar_select WHERE user_avatar_select.categoryID = ? ORDER BY filename ASC, user_avatar_select.avatarID ASC LIMIT 20' PHP version: 7.1.19-nmm1 WoltLab Suite version: 3.1.6 pl 1 Request URI: /forum/wcf/acp/index.php?select-user-avatar-list/&pageNo=1&sortField=filename&sortOrder=ASC&categoryID=23 Referrer: ***/forum/wcf/acp/index.php?select-user-avatar-list/ User Agent: Mozilla/5.0 (Windows NT 10.0; Win64; x64) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/70.0.3538.102 Safari/537.36 Peak Memory Usage: 4389352/551550976 ====== Error Class: wcf\system\database\exception\DatabaseQueryException Error Message: Could not prepare statement 'SELECT user_avatar_select.* FROM wcf1_user_avatar_select user_avatar_select WHERE user_avatar_select.categoryID = ? ORDER BY filename ASC, user_avatar_select.avatarID ASC LIMIT 20' Error Code: 42 File: /www/htdocs/***/forum/wcf/lib/system/database/Database.class.php (248) Extra Information: -Ich denke mal das reicht so schon, sonst liefere ich den Rest nach, aber da muss ich für die Öffentlichkeit so viel raus löschen.