Awww, Danke
Beiträge von zackOmat im Thema „Fehler bei der Installation“
-
-
-
Ahh, ok, alles klar
-
-
Code
Alles anzeigen) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci' Error Code: 42000 File: /Applications/XAMPP/xamppfiles/htdocs/test/lib/system/database/statement/PreparedStatement.class.php (105) Extra Information: YTowOnt9 Stack Trace: [{"file":"\/Applications\/XAMPP\/xamppfiles\/htdocs\/test\/lib\/system\/database\/editor\/MySQLDatabaseEditor.class.php","line":97,"function":"execute","class":"wcf\\system\\database\\statement\\PreparedStatement","type":"->","args":[]},{"file":"\/Applications\/XAMPP\/xamppfiles\/htdocs\/test\/lib\/system\/database\/util\/SQLParser.class.php","line":226,"function":"createTable","class":"wcf\\system\\database\\editor\\MySQLDatabaseEditor","type":"->","args":["wcf1_user_rating",["[redacted]","[redacted]","[redacted]","[redacted]","[redacted]","[redacted]","[redacted]","[redacted]","[redacted]","[redacted]","[redacted]"],[]]},{"file":"\/Applications\/XAMPP\/xamppfiles\/htdocs\/test\/lib\/system\/package\/PackageInstallationSQLParser.class.php","line":271,"function":"executeCreateTableStatement","class":"wcf\\system\\database\\util\\SQLParser","type":"->","args":["wcf1_user_rating",["[redacted]","[redacted]","[redacted]","[redacted]","[redacted]","[redacted]","[redacted]","[redacted]","[redacted]","[redacted]","[redacted]"],[]]},{"file":"\/Applications\/XAMPP\/xamppfiles\/htdocs\/test\/lib\/system\/database\/util\/SQLParser.class.php","line":112,"function":"executeCreateTableStatement","class":"wcf\\system\\package\\PackageInstallationSQLParser","type":"->","args":["wcf1_user_rating",["[redacted]","[redacted]","[redacted]","[redacted]","[redacted]","[redacted]","[redacted]","[redacted]","[redacted]","[redacted]","[redacted]"],[]]},{"file":"\/Applications\/XAMPP\/xamppfiles\/htdocs\/test\/lib\/system\/database\/util\/SQLParser.class.php","line":47,"function":"executeStatement","class":"wcf\\system\\database\\util\\SQLParser","type":"->","args":["CREATE TABLE","CREATE TABLE wcf1_user_rating (\n ratingID int(10) NOT NULL AUTO_INCREMENT,\n userID int(10) NOT NULL,\n username varchar(255) NOT NULL DEFAULT '',\n time int(10) NOT NULL DEFAULT 0,\n rateUserID int(10) NOT NULL,\n subject varchar(255) NOT NULL DEFAULT '',\n message mediumtext NOT NULL,\n link varchar(255) NOT NULL DEFAULT '',\n stars tinyint(1) NOT NULL DEFAULT 1,\n enableHtml tinyint(1) NOT NULL DEFAULT 0,\n isDisabled tinyint(1) NOT NULL DEFAULT 0,\n PRIMARY KEY ratingID (ratingID),\n KEY userID(userID),\n KEY rateUserID(rateUserID)\n)"]},{"file":"\/Applications\/XAMPP\/xamppfiles\/htdocs\/test\/lib\/system\/package\/plugin\/SQLPackageInstallationPlugin.class.php","line":74,"function":"execute","class":"wcf\\system\\database\\util\\SQLParser","type":"->","args":[]},{"file":"\/Applications\/XAMPP\/xamppfiles\/htdocs\/test\/lib\/system\/package\/PackageInstallationDispatcher.class.php","line":673,"function":"install","class":"wcf\\system\\package\\plugin\\SQLPackageInstallationPlugin","type":"->","args":[]},{"file":"\/Applications\/XAMPP\/xamppfiles\/htdocs\/test\/lib\/system\/package\/PackageInstallationDispatcher.class.php","line":144,"function":"executePIP","class":"wcf\\system\\package\\PackageInstallationDispatcher","type":"->","args":[{"attributes":"[redacted]","pip":"[redacted]","value":"[redacted]"}]},{"file":"\/Applications\/XAMPP\/xamppfiles\/htdocs\/test\/lib\/acp\/action\/InstallPackageAction.class.php","line":73,"function":"install","class":"wcf\\system\\package\\PackageInstallationDispatcher","type":"->","args":["cc028797"]},{"file":"\/Applications\/XAMPP\/xamppfiles\/htdocs\/test\/lib\/action\/AbstractDialogAction.class.php","line":68,"function":"stepInstall","class":"wcf\\acp\\action\\InstallPackageAction","type":"->","args":[]},{"file":"\/Applications\/XAMPP\/xamppfiles\/htdocs\/test\/lib\/action\/AbstractAction.class.php","line":47,"function":"execute","class":"wcf\\action\\AbstractDialogAction","type":"->","args":[]},{"file":"\/Applications\/XAMPP\/xamppfiles\/htdocs\/test\/lib\/system\/request\/Request.class.php","line":83,"function":"__run","class":"wcf\\action\\AbstractAction","type":"->","args":[]},{"file":"\/Applications\/XAMPP\/xamppfiles\/htdocs\/test\/lib\/system\/request\/RequestHandler.class.php","line":96,"function":"execute","class":"wcf\\system\\request\\Request","type":"->","args":[]},{"file":"\/Applications\/XAMPP\/xamppfiles\/htdocs\/test\/acp\/index.php","line":9,"function":"handle","class":"wcf\\system\\request\\RequestHandler","type":"->","args":["wcf",true]}] ====== Error Class: PDOException Error Message: SQLSTATE[42000]: Syntax error or access violation: 1075 Incorrect table definition; there can be only one auto column and it must be defined as a key Error Code: 42000 File: /Applications/XAMPP/xamppfiles/htdocs/test/lib/system/database/statement/PreparedStatement.class.php (93) Extra Information: - Stack Trace: [{"file":"\/Applications\/XAMPP\/xamppfiles\/htdocs\/test\/lib\/system\/database\/statement\/PreparedStatement.class.php","line":93,"function":"execute","class":"PDOStatement","type":"->","args":[[]]},{"file":"\/Applications\/XAMPP\/xamppfiles\/htdocs\/test\/lib\/system\/database\/editor\/MySQLDatabaseEditor.class.php","line":97,"function":"execute","class":"wcf\\system\\database\\statement\\PreparedStatement","type":"->","args":[]},{"file":"\/Applications\/XAMPP\/xamppfiles\/htdocs\/test\/lib\/system\/database\/util\/SQLParser.class.php","line":226,"function":"createTable","class":"wcf\\system\\database\\editor\\MySQLDatabaseEditor","type":"->","args":["wcf1_user_rating",["[redacted]","[redacted]","[redacted]","[redacted]","[redacted]","[redacted]","[redacted]","[redacted]","[redacted]","[redacted]","[redacted]"],[]]},{"file":"\/Applications\/XAMPP\/xamppfiles\/htdocs\/test\/lib\/system\/package\/PackageInstallationSQLParser.class.php","line":271,"function":"executeCreateTableStatement","class":"wcf\\system\\database\\util\\SQLParser","type":"->","args":["wcf1_user_rating",["[redacted]","[redacted]","[redacted]","[redacted]","[redacted]","[redacted]","[redacted]","[redacted]","[redacted]","[redacted]","[redacted]"],[]]},{"file":"\/Applications\/XAMPP\/xamppfiles\/htdocs\/test\/lib\/system\/database\/util\/SQLParser.class.php","line":112,"function":"executeCreateTableStatement","class":"wcf\\system\\package\\PackageInstallationSQLParser","type":"->","args":["wcf1_user_rating",["[redacted]","[redacted]","[redacted]","[redacted]","[redacted]","[redacted]","[redacted]","[redacted]","[redacted]","[redacted]","[redacted]"],[]]},{"file":"\/Applications\/XAMPP\/xamppfiles\/htdocs\/test\/lib\/system\/database\/util\/SQLParser.class.php","line":47,"function":"executeStatement","class":"wcf\\system\\database\\util\\SQLParser","type":"->","args":["CREATE TABLE","CREATE TABLE wcf1_user_rating (\n ratingID int(10) NOT NULL AUTO_INCREMENT,\n userID int(10) NOT NULL,\n username varchar(255) NOT NULL DEFAULT '',\n time int(10) NOT NULL DEFAULT 0,\n rateUserID int(10) NOT NULL,\n subject varchar(255) NOT NULL DEFAULT '',\n message mediumtext NOT NULL,\n link varchar(255) NOT NULL DEFAULT '',\n stars tinyint(1) NOT NULL DEFAULT 1,\n enableHtml tinyint(1) NOT NULL DEFAULT 0,\n isDisabled tinyint(1) NOT NULL DEFAULT 0,\n PRIMARY KEY ratingID (ratingID),\n KEY userID(userID),\n KEY rateUserID(rateUserID)\n)"]},{"file":"\/Applications\/XAMPP\/xamppfiles\/htdocs\/test\/lib\/system\/package\/plugin\/SQLPackageInstallationPlugin.class.php","line":74,"function":"execute","class":"wcf\\system\\database\\util\\SQLParser","type":"->","args":[]},{"file":"\/Applications\/XAMPP\/xamppfiles\/htdocs\/test\/lib\/system\/package\/PackageInstallationDispatcher.class.php","line":673,"function":"install","class":"wcf\\system\\package\\plugin\\SQLPackageInstallationPlugin","type":"->","args":[]},{"file":"\/Applications\/XAMPP\/xamppfiles\/htdocs\/test\/lib\/system\/package\/PackageInstallationDispatcher.class.php","line":144,"function":"executePIP","class":"wcf\\system\\package\\PackageInstallationDispatcher","type":"->","args":[{"attributes":"[redacted]","pip":"[redacted]","value":"[redacted]"}]},{"file":"\/Applications\/XAMPP\/xamppfiles\/htdocs\/test\/lib\/acp\/action\/InstallPackageAction.class.php","line":73,"function":"install","class":"wcf\\system\\package\\PackageInstallationDispatcher","type":"->","args":["cc028797"]},{"file":"\/Applications\/XAMPP\/xamppfiles\/htdocs\/test\/lib\/action\/AbstractDialogAction.class.php","line":68,"function":"stepInstall","class":"wcf\\acp\\action\\InstallPackageAction","type":"->","args":[]},{"file":"\/Applications\/XAMPP\/xamppfiles\/htdocs\/test\/lib\/action\/AbstractAction.class.php","line":47,"function":"execute","class":"wcf\\action\\AbstractDialogAction","type":"->","args":[]},{"file":"\/Applications\/XAMPP\/xamppfiles\/htdocs\/test\/lib\/system\/request\/Request.class.php","line":83,"function":"__run","class":"wcf\\action\\AbstractAction","type":"->","args":[]},{"file":"\/Applications\/XAMPP\/xamppfiles\/htdocs\/test\/lib\/system\/request\/RequestHandler.class.php","line":96,"function":"execute","class":"wcf\\system\\request\\Request","type":"->","args":[]},{"file":"\/Applications\/XAMPP\/xamppfiles\/htdocs\/test\/acp\/index.php","line":9,"function":"handle","class":"wcf\\system\\request\\RequestHandler","type":"->","args":["wcf",true]}]
-
Wenn ich versuche die Benutzerbewertung 3.0.0. pl1 in WoltLab Suite 3.1.9 pl 2 zu installieren erhalte ich folgenden Fehler:
Code
Alles anzeigenSat, 04 May 2019 10:23:51 +0000 Message: Could not execute statement 'CREATE TABLE `wcf1_user_rating` ( `ratingID` int(10) NOT NULL AUTO_INCREMENT,`userID` int(10) NOT NULL,`username` varchar(255) NOT NULL DEFAULT '',`time` int(10) NOT NULL DEFAULT 0,`rateUserID` int(10) NOT NULL,`subject` varchar(255) NOT NULL DEFAULT '',`message` mediumtext NOT NULL,`link` varchar(255) NOT NULL DEFAULT '',`stars` tinyint(1) NOT NULL DEFAULT 1,`enableHtml` tinyint(1) NOT NULL DEFAULT 0,`isDisabled` tinyint(1) NOT NULL DEFAULT 0 ) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci' PHP version: 7.1.13 WoltLab Suite version: 3.1.9 pl 2 Request URI: /test/acp/index.php?install-package/&t=c2cf0a26ab8750810ea3802a359626f375ce5640 Referrer: http://localhost/test/acp/index.php?package-installation-confirm/&queueID=359 User Agent: Mozilla/5.0 (Macintosh; Intel Mac OS X 10_14_4) AppleWebKit/605.1.15 (KHTML, like Gecko) Version/12.1 Safari/605.1.15 Peak Memory Usage: 46356184/134217728 ====== Error Class: wcf\system\database\exception\DatabaseQueryExecutionException Error Message: Could not execute statement 'CREATE TABLE `wcf1_user_rating` ( `ratingID` int(10) NOT NULL AUTO_INCREMENT,`userID` int(10) NOT NULL,`username` varchar(255) NOT NULL DEFAULT '',`time` int(10) NOT NULL DEFAULT 0,`rateUserID` int(10) NOT NULL,`subject` varchar(255) NOT NULL DEFAULT '',`message` mediumtext NOT NULL,`link` varchar(255) NOT NULL DEFAULT '',`stars` tinyint(1) NOT NULL DEFAULT 1,`enableHtml` tinyint(1) NOT NULL DEFAULT 0,`isDisabled` tinyint(1) NOT NULL DEFAULT 0