Sat, 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

             ) 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]}]