Fehlermeldung beim Sortieren nach Dateinamen

Thu, 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: -

Thu, 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]}]