Hallo,
Wenn ich zu den Videokanälen gehe, dort nach letzter Synchronisation sortieren möchte, kommt folgender Fehler:
Code
Mon, 21 Aug 2023 20:36:16 +0000
Message: Could not prepare statement 'SELECT video_channel.* FROM easymedia1_video_channel video_channel ORDER BY lastSyncTime DESC, video_channel.channelID DESC LIMIT 20'
PHP version: 8.1.22
WoltLab Suite version: 5.5.15
Request URI: GET /mediathek/video-channel-list/?sortField=lastSyncTime&sortOrder=DESC&pageNo=0&categoryID=94
Referrer: https://www.spirit.jetzt/mediathek/video-channel-list/?sortField=time&sortOrder=DESC&pageNo=0&categoryID=94
User Agent: Mozilla/5.0 (Windows NT 10.0; Win64; x64; rv:109.0) Gecko/20100101 Firefox/116.0
Peak Memory Usage: 7779288/268435456
======
Error Class: wcf\system\database\exception\DatabaseQueryException
Error Message: Could not prepare statement 'SELECT video_channel.* FROM easymedia1_video_channel video_channel ORDER BY lastSyncTime DESC, video_channel.channelID DESC LIMIT 20'
Error Code: 42S22
File: /var/www/vhosts/spirit.jetzt/httpdocs/lib/system/database/Database.class.php (333)
Extra Information: -
Stack Trace: [{"file":"\/var\/www\/vhosts\/spirit.jetzt\/httpdocs\/lib\/data\/DatabaseObjectList.class.php","line":203,"function":"prepareStatement","class":"wcf\\system\\database\\Database","type":"->","args":["SELECT \n video_channel.*\n FROM easymedia1_video_channel video_channel\n \n \n ORDER BY lastSyncTime DESC, video_channel.channelID DESC LIMIT 20",20,0]},{"file":"\/var\/www\/vhosts\/spirit.jetzt\/httpdocs\/mediathek\/lib\/data\/video\/channel\/VideoChannelList.class.php","line":39,"function":"readObjects","class":"wcf\\data\\DatabaseObjectList","type":"->","args":[]},{"file":"\/var\/www\/vhosts\/spirit.jetzt\/httpdocs\/mediathek\/lib\/data\/video\/channel\/ViewableVideoChannelList.class.php","line":51,"function":"readObjects","class":"easymedia\\data\\video\\channel\\VideoChannelList","type":"->","args":[]},{"file":"\/var\/www\/vhosts\/spirit.jetzt\/httpdocs\/lib\/page\/MultipleLinkPage.class.php","line":172,"function":"readObjects","class":"easymedia\\data\\video\\channel\\ViewableVideoChannelList","type":"->","args":[]},{"file":"\/var\/www\/vhosts\/spirit.jetzt\/httpdocs\/lib\/page\/MultipleLinkPage.class.php","line":137,"function":"readObjects","class":"wcf\\page\\MultipleLinkPage","type":"->","args":[]},{"file":"\/var\/www\/vhosts\/spirit.jetzt\/httpdocs\/lib\/page\/SortablePage.class.php","line":61,"function":"readData","class":"wcf\\page\\MultipleLinkPage","type":"->","args":[]},{"file":"\/var\/www\/vhosts\/spirit.jetzt\/httpdocs\/mediathek\/lib\/page\/VideoChannelListPage.class.php","line":123,"function":"readData","class":"wcf\\page\\SortablePage","type":"->","args":[]},{"file":"\/var\/www\/vhosts\/spirit.jetzt\/httpdocs\/lib\/page\/AbstractPage.class.php","line":353,"function":"readData","class":"easymedia\\page\\VideoChannelListPage","type":"->","args":[]},{"file":"\/var\/www\/vhosts\/spirit.jetzt\/httpdocs\/lib\/page\/AbstractPage.class.php","line":135,"function":"show","class":"wcf\\page\\AbstractPage","type":"->","args":[]},{"file":"\/var\/www\/vhosts\/spirit.jetzt\/httpdocs\/lib\/system\/request\/Request.class.php","line":90,"function":"__run","class":"wcf\\page\\AbstractPage","type":"->","args":[]},{"file":"\/var\/www\/vhosts\/spirit.jetzt\/httpdocs\/lib\/system\/request\/RequestHandler.class.php","line":107,"function":"execute","class":"wcf\\system\\request\\Request","type":"->","args":[]},{"file":"\/var\/www\/vhosts\/spirit.jetzt\/httpdocs\/mediathek\/index.php","line":10,"function":"handle","class":"wcf\\system\\request\\RequestHandler","type":"->","args":["easymedia"]}]
======
Error Class: PDOException
Error Message: SQLSTATE[42S22]: Column not found: 1054 Unknown column 'lastSyncTime' in 'order clause'
Error Code: 42S22
File: /var/www/vhosts/spirit.jetzt/httpdocs/lib/system/database/Database.class.php (328)
Extra Information: -
Stack Trace: [{"file":"\/var\/www\/vhosts\/spirit.jetzt\/httpdocs\/lib\/system\/database\/Database.class.php","line":328,"function":"prepare","class":"PDO","type":"->","args":["SELECT \n video_channel.*\n FROM easymedia1_video_channel video_channel\n \n \n ORDER BY lastSyncTime DESC, video_channel.channelID DESC LIMIT 20"]},{"file":"\/var\/www\/vhosts\/spirit.jetzt\/httpdocs\/lib\/data\/DatabaseObjectList.class.php","line":203,"function":"prepareStatement","class":"wcf\\system\\database\\Database","type":"->","args":["SELECT \n video_channel.*\n FROM easymedia1_video_channel video_channel\n \n \n ORDER BY lastSyncTime DESC, video_channel.channelID DESC LIMIT 20",20,0]},{"file":"\/var\/www\/vhosts\/spirit.jetzt\/httpdocs\/mediathek\/lib\/data\/video\/channel\/VideoChannelList.class.php","line":39,"function":"readObjects","class":"wcf\\data\\DatabaseObjectList","type":"->","args":[]},{"file":"\/var\/www\/vhosts\/spirit.jetzt\/httpdocs\/mediathek\/lib\/data\/video\/channel\/ViewableVideoChannelList.class.php","line":51,"function":"readObjects","class":"easymedia\\data\\video\\channel\\VideoChannelList","type":"->","args":[]},{"file":"\/var\/www\/vhosts\/spirit.jetzt\/httpdocs\/lib\/page\/MultipleLinkPage.class.php","line":172,"function":"readObjects","class":"easymedia\\data\\video\\channel\\ViewableVideoChannelList","type":"->","args":[]},{"file":"\/var\/www\/vhosts\/spirit.jetzt\/httpdocs\/lib\/page\/MultipleLinkPage.class.php","line":137,"function":"readObjects","class":"wcf\\page\\MultipleLinkPage","type":"->","args":[]},{"file":"\/var\/www\/vhosts\/spirit.jetzt\/httpdocs\/lib\/page\/SortablePage.class.php","line":61,"function":"readData","class":"wcf\\page\\MultipleLinkPage","type":"->","args":[]},{"file":"\/var\/www\/vhosts\/spirit.jetzt\/httpdocs\/mediathek\/lib\/page\/VideoChannelListPage.class.php","line":123,"function":"readData","class":"wcf\\page\\SortablePage","type":"->","args":[]},{"file":"\/var\/www\/vhosts\/spirit.jetzt\/httpdocs\/lib\/page\/AbstractPage.class.php","line":353,"function":"readData","class":"easymedia\\page\\VideoChannelListPage","type":"->","args":[]},{"file":"\/var\/www\/vhosts\/spirit.jetzt\/httpdocs\/lib\/page\/AbstractPage.class.php","line":135,"function":"show","class":"wcf\\page\\AbstractPage","type":"->","args":[]},{"file":"\/var\/www\/vhosts\/spirit.jetzt\/httpdocs\/lib\/system\/request\/Request.class.php","line":90,"function":"__run","class":"wcf\\page\\AbstractPage","type":"->","args":[]},{"file":"\/var\/www\/vhosts\/spirit.jetzt\/httpdocs\/lib\/system\/request\/RequestHandler.class.php","line":107,"function":"execute","class":"wcf\\system\\request\\Request","type":"->","args":[]},{"file":"\/var\/www\/vhosts\/spirit.jetzt\/httpdocs\/mediathek\/index.php","line":10,"function":"handle","class":"wcf\\system\\request\\RequestHandler","type":"->","args":["easymedia"]}]
Alles anzeigen
Gerne würden wir die Standard-Sortierung der Videokanäle so haben: Letzte Synchronisierung -> Absteigend