Danke, das habe ich gemacht, aber da kommt dann anstatt beim News System in der Kundenverwaltung Beitrags Autor ändern anstatt das News System und dass die Domain noch nicht angegeben wurde in der Lizenzverwaltung, obwohl sie angegeben war, wenn man dann die Datei runterläd, ist sie richtig, habs jetzt manuell geupdatet, über den Paketserver ging das nicht.
Beiträge von Shalin im Thema „Fehlerlog läuft voll mit SQLSTATE[42S22]: Column not found: 1054 Unknown column 'news.newsID' in 'where clause'“
-
-
-
Hallo Cyperghost,
das Fehlerlog läuft voll, was ist das für ein Fehler und wie kann man den beheben?
Code
Alles anzeigenSat, 16 Jul 2022 01:15:42 +0000 Message: Could not prepare statement 'SELECT attachment.attachmentID FROM wcf1_attachment attachment WHERE attachment.objectTypeID = ? AND NOT EXISTS(SELECT * FROM news1_news WHERE attachment.objectID = news.newsID)' PHP version: 7.4.28 WoltLab Suite version: 5.4.20 Request URI: POST /index.php?ajax-proxy/&t=214b215f89ad95d4340e9880809f8f68d484a638d47e0310a7d7f20da4cbbd4f-x/AJoMP5XbShQjoQBBEJBw== Referrer: https://borderline-forum.eu/ User Agent: Mozilla/5.0 (Windows NT 10.0; Win64; x64; rv:102.0) Gecko/20100101 Firefox/102.0 Peak Memory Usage: 17378088/268435456 ====== Error Class: wcf\system\database\exception\DatabaseQueryException Error Message: Could not prepare statement 'SELECT attachment.attachmentID FROM wcf1_attachment attachment WHERE attachment.objectTypeID = ? AND NOT EXISTS(SELECT * FROM news1_news WHERE attachment.objectID = news.newsID)' Error Code: 42S22 File: /customers/shalin/home/borderline-forum.eu/lib/system/database/Database.class.php (333) Extra Information: - Stack Trace: [{"file":"\/customers\/shalin\/home\/borderline-forum.eu\/lib\/system\/database\/Database.class.php","line":365,"function":"prepareStatement","class":"wcf\\system\\database\\Database","type":"->","args":[]},{"file":"\/customers\/shalin\/home\/borderline-forum.eu\/news\/lib\/system\/cronjob\/NewsAttachmentCleanUpCronjob.class.php","line":33,"function":"prepare","class":"wcf\\system\\database\\Database","type":"->","args":[]},{"file":"\/customers\/shalin\/home\/borderline-forum.eu\/lib\/system\/cronjob\/CronjobScheduler.class.php","line":274,"function":"execute","class":"news\\system\\cronjob\\NewsAttachmentCleanUpCronjob","type":"->","args":[]},{"file":"\/customers\/shalin\/home\/borderline-forum.eu\/lib\/system\/cronjob\/CronjobScheduler.class.php","line":75,"function":"executeCronjob","class":"wcf\\system\\cronjob\\CronjobScheduler","type":"->","args":[]},{"file":"\/customers\/shalin\/home\/borderline-forum.eu\/lib\/data\/cronjob\/CronjobAction.class.php","line":240,"function":"executeCronjobs","class":"wcf\\system\\cronjob\\CronjobScheduler","type":"->","args":[]},{"file":"\/customers\/shalin\/home\/borderline-forum.eu\/lib\/data\/AbstractDatabaseObjectAction.class.php","line":216,"function":"executeCronjobs","class":"wcf\\data\\cronjob\\CronjobAction","type":"->","args":[]},{"file":"\/customers\/shalin\/home\/borderline-forum.eu\/lib\/action\/AJAXProxyAction.class.php","line":92,"function":"executeAction","class":"wcf\\data\\AbstractDatabaseObjectAction","type":"->","args":[]},{"file":"\/customers\/shalin\/home\/borderline-forum.eu\/lib\/action\/AJAXInvokeAction.class.php","line":111,"function":"invoke","class":"wcf\\action\\AJAXProxyAction","type":"->","args":[]},{"file":"\/customers\/shalin\/home\/borderline-forum.eu\/lib\/action\/AbstractAction.class.php","line":53,"function":"execute","class":"wcf\\action\\AJAXInvokeAction","type":"->","args":[]},{"file":"\/customers\/shalin\/home\/borderline-forum.eu\/lib\/action\/AJAXInvokeAction.class.php","line":65,"function":"__run","class":"wcf\\action\\AbstractAction","type":"->","args":[]},{"file":"\/customers\/shalin\/home\/borderline-forum.eu\/lib\/system\/request\/Request.class.php","line":89,"function":"__run","class":"wcf\\action\\AJAXInvokeAction","type":"->","args":[]},{"file":"\/customers\/shalin\/home\/borderline-forum.eu\/lib\/system\/request\/RequestHandler.class.php","line":121,"function":"execute","class":"wcf\\system\\request\\Request","type":"->","args":[]},{"file":"\/customers\/shalin\/home\/borderline-forum.eu\/index.php","line":11,"function":"handle","class":"wcf\\system\\request\\RequestHandler","type":"->","args":[]}] ====== Error Class: PDOException Error Message: SQLSTATE[42S22]: Column not found: 1054 Unknown column 'news.newsID' in 'where clause' Error Code: 42S22 File: /customers/shalin/home/borderline-forum.eu/lib/system/database/Database.class.php (328) Extra Information: - Stack Trace: [{"file":"\/customers\/shalin\/home\/borderline-forum.eu\/lib\/system\/database\/Database.class.php","line":328,"function":"prepare","class":"PDO","type":"->","args":[]},{"file":"\/customers\/shalin\/home\/borderline-forum.eu\/lib\/system\/database\/Database.class.php","line":365,"function":"prepareStatement","class":"wcf\\system\\database\\Database","type":"->","args":[]},{"file":"\/customers\/shalin\/home\/borderline-forum.eu\/news\/lib\/system\/cronjob\/NewsAttachmentCleanUpCronjob.class.php","line":33,"function":"prepare","class":"wcf\\system\\database\\Database","type":"->","args":[]},{"file":"\/customers\/shalin\/home\/borderline-forum.eu\/lib\/system\/cronjob\/CronjobScheduler.class.php","line":274,"function":"execute","class":"news\\system\\cronjob\\NewsAttachmentCleanUpCronjob","type":"->","args":[]},{"file":"\/customers\/shalin\/home\/borderline-forum.eu\/lib\/system\/cronjob\/CronjobScheduler.class.php","line":75,"function":"executeCronjob","class":"wcf\\system\\cronjob\\CronjobScheduler","type":"->","args":[]},{"file":"\/customers\/shalin\/home\/borderline-forum.eu\/lib\/data\/cronjob\/CronjobAction.class.php","line":240,"function":"executeCronjobs","class":"wcf\\system\\cronjob\\CronjobScheduler","type":"->","args":[]},{"file":"\/customers\/shalin\/home\/borderline-forum.eu\/lib\/data\/AbstractDatabaseObjectAction.class.php","line":216,"function":"executeCronjobs","class":"wcf\\data\\cronjob\\CronjobAction","type":"->","args":[]},{"file":"\/customers\/shalin\/home\/borderline-forum.eu\/lib\/action\/AJAXProxyAction.class.php","line":92,"function":"executeAction","class":"wcf\\data\\AbstractDatabaseObjectAction","type":"->","args":[]},{"file":"\/customers\/shalin\/home\/borderline-forum.eu\/lib\/action\/AJAXInvokeAction.class.php","line":111,"function":"invoke","class":"wcf\\action\\AJAXProxyAction","type":"->","args":[]},{"file":"\/customers\/shalin\/home\/borderline-forum.eu\/lib\/action\/AbstractAction.class.php","line":53,"function":"execute","class":"wcf\\action\\AJAXInvokeAction","type":"->","args":[]},{"file":"\/customers\/shalin\/home\/borderline-forum.eu\/lib\/action\/AJAXInvokeAction.class.php","line":65,"function":"__run","class":"wcf\\action\\AbstractAction","type":"->","args":[]},{"file":"\/customers\/shalin\/home\/borderline-forum.eu\/lib\/system\/request\/Request.class.php","line":89,"function":"__run","class":"wcf\\action\\AJAXInvokeAction","type":"->","args":[]},{"file":"\/customers\/shalin\/home\/borderline-forum.eu\/lib\/system\/request\/RequestHandler.class.php","line":121,"function":"execute","class":"wcf\\system\\request\\Request","type":"->","args":[]},{"file":"\/customers\/shalin\/home\/borderline-forum.eu\/index.php","line":11,"function":"handle","class":"wcf\\system\\request\\RequestHandler","type":"->","args":[]}]