- Affected Version
- WoltLab Suite 5.2
Hilfe
ich komme nur noch ins ACP rein ansonsten lässt sich das WCS nicht aufrufen.
kann mir vielleicht jemand sagen woran das liegt?
Fehlermeldung
Display Spoiler
Tue, 09 Jun 2020 14:51:11 +0000
Message: Could not prepare statement 'INSERT INTO wcf1_visitor
(requestURI,title,host,isRegistered,languageID,pageID,pageObjectID,time)
VALUES (?,?,?,?,?,?,?,?)'
PHP version: 7.4.6
WoltLab Suite version: 5.2.6
Request URI: /
Referrer:
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 Edge/18.18362
Peak Memory Usage: 7192448/134217728
======
Error Class: wcf\system\database\exception\DatabaseQueryException
Error Message: Could not prepare statement 'INSERT INTO wcf1_visitor
(requestURI,title,host,isRegistered,languageID,pageID,pageObjectID,time)
VALUES (?,?,?,?,?,?,?,?)'
Error Code: 42
File: /var/www/vhosts/tus-eschede-tt.de/httpdocs/lib/system/database/Database.class.php (284)
Extra Information: -
Stack Trace: [{"file":"\/var\/www\/vhosts\/tus-eschede-tt.de\/httpdocs\/lib\/data\/DatabaseObjectEditor.class.php","line":36,"function":"prepareStatement","class":"wcf\\system\\database\\Database","type":"->","args":[]},{"function":"create","class":"wcf\\data\\DatabaseObjectEditor","type":"::","file":"[internal function]","line":"?","args":[]},{"file":"\/var\/www\/vhosts\/tus-eschede-tt.de\/httpdocs\/lib\/data\/AbstractDatabaseObjectAction.class.php","line":337,"function":"call_user_func","class":"","type":"","args":[]},{"function":"create","class":"wcf\\data\\AbstractDatabaseObjectAction","type":"->","file":"[internal function]","line":"?","args":[]},{"file":"\/var\/www\/vhosts\/tus-eschede-tt.de\/httpdocs\/lib\/data\/AbstractDatabaseObjectAction.class.php","line":205,"function":"call_user_func","class":"","type":"","args":[]},{"file":"\/var\/www\/vhosts\/tus-eschede-tt.de\/httpdocs\/lib\/system\/event\/listener\/VisitorListener.class.php","line":68,"function":"executeAction","class":"wcf\\data\\AbstractDatabaseObjectAction","type":"->","args":[]},{"file":"\/var\/www\/vhosts\/tus-eschede-tt.de\/httpdocs\/lib\/system\/event\/EventHandler.class.php","line":221,"function":"execute","class":"wcf\\system\\event\\listener\\VisitorListener","type":"->","args":[]},{"file":"\/var\/www\/vhosts\/tus-eschede-tt.de\/httpdocs\/lib\/system\/template\/TemplateEngine.class.php","line":338,"function":"fireAction","class":"wcf\\system\\event\\EventHandler","type":"->","args":[]},{"file":"\/var\/www\/vhosts\/tus-eschede-tt.de\/httpdocs\/lib\/page\/AbstractPage.class.php","line":323,"function":"display","class":"wcf\\system\\template\\TemplateEngine","type":"->","args":[]},{"file":"\/var\/www\/vhosts\/tus-eschede-tt.de\/httpdocs\/lib\/page\/AbstractPage.class.php","line":114,"function":"show","class":"wcf\\page\\AbstractPage","type":"->","args":[]},{"file":"\/var\/www\/vhosts\/tus-eschede-tt.de\/httpdocs\/lib\/system\/request\/Request.class.php","line":83,"function":"__run","class":"wcf\\page\\AbstractPage","type":"->","args":[]},{"file":"\/var\/www\/vhosts\/tus-eschede-tt.de\/httpdocs\/lib\/system\/request\/RequestHandler.class.php","line":107,"function":"execute","class":"wcf\\system\\request\\Request","type":"->","args":[]},{"file":"\/var\/www\/vhosts\/tus-eschede-tt.de\/httpdocs\/index.php","line":9,"function":"handle","class":"wcf\\system\\request\\RequestHandler","type":"->","args":[]}]
======
Error Class: PDOException
Error Message: SQLSTATE[42S22]: Column not found: 1054 Unknown column 'languageID' in 'field list'
Error Code: 42
File: /var/www/vhosts/tus-eschede-tt.de/httpdocs/lib/system/database/Database.class.php (279)
Extra Information: -
Stack Trace: [{"file":"\/var\/www\/vhosts\/tus-eschede-tt.de\/httpdocs\/lib\/system\/database\/Database.class.php","line":279,"function":"prepare","class":"PDO","type":"->","args":[]},{"file":"\/var\/www\/vhosts\/tus-eschede-tt.de\/httpdocs\/lib\/data\/DatabaseObjectEditor.class.php","line":36,"function":"prepareStatement","class":"wcf\\system\\database\\Database","type":"->","args":[]},{"function":"create","class":"wcf\\data\\DatabaseObjectEditor","type":"::","file":"[internal function]","line":"?","args":[]},{"file":"\/var\/www\/vhosts\/tus-eschede-tt.de\/httpdocs\/lib\/data\/AbstractDatabaseObjectAction.class.php","line":337,"function":"call_user_func","class":"","type":"","args":[]},{"function":"create","class":"wcf\\data\\AbstractDatabaseObjectAction","type":"->","file":"[internal function]","line":"?","args":[]},{"file":"\/var\/www\/vhosts\/tus-eschede-tt.de\/httpdocs\/lib\/data\/AbstractDatabaseObjectAction.class.php","line":205,"function":"call_user_func","class":"","type":"","args":[]},{"file":"\/var\/www\/vhosts\/tus-eschede-tt.de\/httpdocs\/lib\/system\/event\/listener\/VisitorListener.class.php","line":68,"function":"executeAction","class":"wcf\\data\\AbstractDatabaseObjectAction","type":"->","args":[]},{"file":"\/var\/www\/vhosts\/tus-eschede-tt.de\/httpdocs\/lib\/system\/event\/EventHandler.class.php","line":221,"function":"execute","class":"wcf\\system\\event\\listener\\VisitorListener","type":"->","args":[]},{"file":"\/var\/www\/vhosts\/tus-eschede-tt.de\/httpdocs\/lib\/system\/template\/TemplateEngine.class.php","line":338,"function":"fireAction","class":"wcf\\system\\event\\EventHandler","type":"->","args":[]},{"file":"\/var\/www\/vhosts\/tus-eschede-tt.de\/httpdocs\/lib\/page\/AbstractPage.class.php","line":323,"function":"display","class":"wcf\\system\\template\\TemplateEngine","type":"->","args":[]},{"file":"\/var\/www\/vhosts\/tus-eschede-tt.de\/httpdocs\/lib\/page\/AbstractPage.class.php","line":114,"function":"show","class":"wcf\\page\\AbstractPage","type":"->","args":[]},{"file":"\/var\/www\/vhosts\/tus-eschede-tt.de\/httpdocs\/lib\/system\/request\/Request.class.php","line":83,"function":"__run","class":"wcf\\page\\AbstractPage","type":"->","args":[]},{"file":"\/var\/www\/vhosts\/tus-eschede-tt.de\/httpdocs\/lib\/system\/request\/RequestHandler.class.php","line":107,"function":"execute","class":"wcf\\system\\request\\Request","type":"->","args":[]},{"file":"\/var\/www\/vhosts\/tus-eschede-tt.de\/httpdocs\/index.php","line":9,"function":"handle","class":"wcf\\system\\request\\RequestHandler","type":"->","args":[]}]
Edit:
Sorry, versehentlich falscher Bereich könnte das einer verschieben?
noch eine Fehlermeldung:
Display Spoiler
Mon, 08 Jun 2020 20:27:39 +0000
Message: Could not execute statement 'CREATE TABLE `wcf1_visitor_url` (
`visitID` int(10) NOT NULL AUTO_INCREMENT PRIMARY KEY,`requestURI` varchar(255) NOT NULL,`title` varchar(255) NOT NULL,`host` varchar(255) NOT NULL,`counter` int(10) NOT NULL DEFAULT 0,`isRegistered` tinyint(1) NOT NULL DEFAULT 0,`languageID` int(10) DEFAULT NULL,`pageID` int(10) DEFAULT NULL,`pageObjectID` int(10) DEFAULT NULL
,
KEY (`requestURI`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci'
PHP version: 7.4.6
WoltLab Suite version: 5.2.6
Request URI: /acp/index.php?install-package/&t=0ef410b82050f57a78e218b3030b2a7925bff461
Referrer: https://tus-eschede-tt.de/acp/index.php?package-update/
User Agent: Mozilla/5.0 (Linux; Android 9; CMR-AL19) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/77.0.3865.116 Safari/537.36 EdgA/45.03.4.4958
Peak Memory Usage: 2731928/134217728
======
Error Class: wcf\system\database\exception\DatabaseQueryExecutionException
Error Message: Could not execute statement 'CREATE TABLE `wcf1_visitor_url` (
`visitID` int(10) NOT NULL AUTO_INCREMENT PRIMARY KEY,`requestURI` varchar(255) NOT NULL,`title` varchar(255) NOT NULL,`host` varchar(255) NOT NULL,`counter` int(10) NOT NULL DEFAULT 0,`isRegistered` tinyint(1) NOT NULL DEFAULT 0,`languageID` int(10) DEFAULT NULL,`pageID` int(10) DEFAULT NULL,`pageObjectID` int(10) DEFAULT NULL
,
KEY (`requestURI`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci'
Error Code: 42000
File: /var/www/vhosts/tus-eschede-tt.de/httpdocs/lib/system/database/statement/PreparedStatement.class.php (105)
Extra Information: YTowOnt9
Stack Trace: [{"file":"\/var\/www\/vhosts\/tus-eschede-tt.de\/httpdocs\/lib\/system\/database\/editor\/MySQLDatabaseEditor.class.php","line":231,"function":"execute","class":"wcf\\system\\database\\statement\\PreparedStatement","type":"->","args":[]},{"file":"\/var\/www\/vhosts\/tus-eschede-tt.de\/httpdocs\/lib\/system\/database\/util\/SQLParser.class.php","line":226,"function":"createTable","class":"wcf\\system\\database\\editor\\MySQLDatabaseEditor","type":"->","args":[]},{"file":"\/var\/www\/vhosts\/tus-eschede-tt.de\/httpdocs\/lib\/system\/package\/PackageInstallationSQLParser.class.php","line":271,"function":"executeCreateTableStatement","class":"wcf\\system\\database\\util\\SQLParser","type":"->","args":[]},{"file":"\/var\/www\/vhosts\/tus-eschede-tt.de\/httpdocs\/lib\/system\/database\/util\/SQLParser.class.php","line":112,"function":"executeCreateTableStatement","class":"wcf\\system\\package\\PackageInstallationSQLParser","type":"->","args":[]},{"file":"\/var\/www\/vhosts\/tus-eschede-tt.de\/httpdocs\/lib\/system\/database\/util\/SQLParser.class.php","line":47,"function":"executeStatement","class":"wcf\\system\\database\\util\\SQLParser","type":"->","args":[]},{"file":"\/var\/www\/vhosts\/tus-eschede-tt.de\/httpdocs\/lib\/system\/package\/plugin\/SQLPackageInstallationPlugin.class.php","line":65,"function":"execute","class":"wcf\\system\\database\\util\\SQLParser","type":"->","args":[]},{"file":"\/var\/www\/vhosts\/tus-eschede-tt.de\/httpdocs\/lib\/system\/package\/plugin\/AbstractPackageInstallationPlugin.class.php","line":70,"function":"install","class":"wcf\\system\\package\\plugin\\SQLPackageInstallationPlugin","type":"->","args":[]},{"file":"\/var\/www\/vhosts\/tus-eschede-tt.de\/httpdocs\/lib\/system\/package\/PackageInstallationDispatcher.class.php","line":743,"function":"update","class":"wcf\\system\\package\\plugin\\AbstractPackageInstallationPlugin","type":"->","args":[]},{"file":"\/var\/www\/vhosts\/tus-eschede-tt.de\/httpdocs\/lib\/system\/package\/PackageInstallationDispatcher.class.php","line":144,"function":"executePIP","class":"wcf\\system\\package\\PackageInstallationDispatcher","type":"->","args":[]},{"file":"\/var\/www\/vhosts\/tus-eschede-tt.de\/httpdocs\/lib\/acp\/action\/InstallPackageAction.class.php","line":73,"function":"install","class":"wcf\\system\\package\\PackageInstallationDispatcher","type":"->","args":[]},{"file":"\/var\/www\/vhosts\/tus-eschede-tt.de\/httpdocs\/lib\/action\/AbstractDialogAction.class.php","line":68,"function":"stepInstall","class":"wcf\\acp\\action\\InstallPackageAction","type":"->","args":[]},{"file":"\/var\/www\/vhosts\/tus-eschede-tt.de\/httpdocs\/lib\/action\/AbstractAction.class.php","line":47,"function":"execute","class":"wcf\\action\\AbstractDialogAction","type":"->","args":[]},{"file":"\/var\/www\/vhosts\/tus-eschede-tt.de\/httpdocs\/lib\/system\/request\/Request.class.php","line":83,"function":"__run","class":"wcf\\action\\AbstractAction","type":"->","args":[]},{"file":"\/var\/www\/vhosts\/tus-eschede-tt.de\/httpdocs\/lib\/system\/request\/RequestHandler.class.php","line":107,"function":"execute","class":"wcf\\system\\request\\Request","type":"->","args":[]},{"file":"\/var\/www\/vhosts\/tus-eschede-tt.de\/httpdocs\/acp\/index.php","line":9,"function":"handle","class":"wcf\\system\\request\\RequestHandler","type":"->","args":[]}]
======
Error Class: PDOException
Error Message: SQLSTATE[42000]: Syntax error or access violation: 1071 Specified key was too long; max key length is 767 bytes
Error Code: 42000
File: /var/www/vhosts/tus-eschede-tt.de/httpdocs/lib/system/database/statement/PreparedStatement.class.php (93)
Extra Information: -
Stack Trace: [{"file":"\/var\/www\/vhosts\/tus-eschede-tt.de\/httpdocs\/lib\/system\/database\/statement\/PreparedStatement.class.php","line":93,"function":"execute","class":"PDOStatement","type":"->","args":[]},{"file":"\/var\/www\/vhosts\/tus-eschede-tt.de\/httpdocs\/lib\/system\/database\/editor\/MySQLDatabaseEditor.class.php","line":231,"function":"execute","class":"wcf\\system\\database\\statement\\PreparedStatement","type":"->","args":[]},{"file":"\/var\/www\/vhosts\/tus-eschede-tt.de\/httpdocs\/lib\/system\/database\/util\/SQLParser.class.php","line":226,"function":"createTable","class":"wcf\\system\\database\\editor\\MySQLDatabaseEditor","type":"->","args":[]},{"file":"\/var\/www\/vhosts\/tus-eschede-tt.de\/httpdocs\/lib\/system\/package\/PackageInstallationSQLParser.class.php","line":271,"function":"executeCreateTableStatement","class":"wcf\\system\\database\\util\\SQLParser","type":"->","args":[]},{"file":"\/var\/www\/vhosts\/tus-eschede-tt.de\/httpdocs\/lib\/system\/database\/util\/SQLParser.class.php","line":112,"function":"executeCreateTableStatement","class":"wcf\\system\\package\\PackageInstallationSQLParser","type":"->","args":[]},{"file":"\/var\/www\/vhosts\/tus-eschede-tt.de\/httpdocs\/lib\/system\/database\/util\/SQLParser.class.php","line":47,"function":"executeStatement","class":"wcf\\system\\database\\util\\SQLParser","type":"->","args":[]},{"file":"\/var\/www\/vhosts\/tus-eschede-tt.de\/httpdocs\/lib\/system\/package\/plugin\/SQLPackageInstallationPlugin.class.php","line":65,"function":"execute","class":"wcf\\system\\database\\util\\SQLParser","type":"->","args":[]},{"file":"\/var\/www\/vhosts\/tus-eschede-tt.de\/httpdocs\/lib\/system\/package\/plugin\/AbstractPackageInstallationPlugin.class.php","line":70,"function":"install","class":"wcf\\system\\package\\plugin\\SQLPackageInstallationPlugin","type":"->","args":[]},{"file":"\/var\/www\/vhosts\/tus-eschede-tt.de\/httpdocs\/lib\/system\/package\/PackageInstallationDispatcher.class.php","line":743,"function":"update","class":"wcf\\system\\package\\plugin\\AbstractPackageInstallationPlugin","type":"->","args":[]},{"file":"\/var\/www\/vhosts\/tus-eschede-tt.de\/httpdocs\/lib\/system\/package\/PackageInstallationDispatcher.class.php","line":144,"function":"executePIP","class":"wcf\\system\\package\\PackageInstallationDispatcher","type":"->","args":[]},{"file":"\/var\/www\/vhosts\/tus-eschede-tt.de\/httpdocs\/lib\/acp\/action\/InstallPackageAction.class.php","line":73,"function":"install","class":"wcf\\system\\package\\PackageInstallationDispatcher","type":"->","args":[]},{"file":"\/var\/www\/vhosts\/tus-eschede-tt.de\/httpdocs\/lib\/action\/AbstractDialogAction.class.php","line":68,"function":"stepInstall","class":"wcf\\acp\\action\\InstallPackageAction","type":"->","args":[]},{"file":"\/var\/www\/vhosts\/tus-eschede-tt.de\/httpdocs\/lib\/action\/AbstractAction.class.php","line":47,"function":"execute","class":"wcf\\action\\AbstractDialogAction","type":"->","args":[]},{"file":"\/var\/www\/vhosts\/tus-eschede-tt.de\/httpdocs\/lib\/system\/request\/Request.class.php","line":83,"function":"__run","class":"wcf\\action\\AbstractAction","type":"->","args":[]},{"file":"\/var\/www\/vhosts\/tus-eschede-tt.de\/httpdocs\/lib\/system\/request\/RequestHandler.class.php","line":107,"function":"execute","class":"wcf\\system\\request\\Request","type":"->","args":[]},{"file":"\/var\/www\/vhosts\/tus-eschede-tt.de\/httpdocs\/acp\/index.php","line":9,"function":"handle","class":"wcf\\system\\request\\RequestHandler","type":"->","args":[]}]
