Fehler bei Installation von Bounce Handling

Tue, 14 Feb 2023 17:03:18 +0000

Message: Could not execute statement 'CREATE TABLE `wcf1_bounce` ( `id` int(10) NULL AUTO_INCREMENT PRIMARY KEY,`uid` int(10) NOT NULL,`body` longblob NULL DEFAULT NULL,`status` smallint(8) NULL DEFAULT NULL,`diagnostic` mediumtext NULL DEFAULT NULL,`email` varchar(191) NOT NULL,`type` enum('verp', 'hard', 'soft') NOT NULL DEFAULT 'verp',`userID` int(10) NULL DEFAULT NULL,`time` int(10) NOT NULL DEFAULT 0,`date` date NOT NULL , KEY `email` (`email`) ) ENGINE=InnoDB ROW_FORMAT=dynamic DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci'

PHP version: 8.1.14-he.0

WoltLab Suite version: 5.5.8

Request URI: POST /acp/index.php?install-package/&t=936312437ce33d8372eb6d34d9a2710f3c137b17614707fa667b4f2849b9b28e-7L8jikuXAmUa4zgRb8ncOQ==

Referrer: https://wohnwagen-forum.de/acp/index.php?…irm/&queueID=53

User Agent: Mozilla/5.0 (Windows NT 10.0; Win64; x64; rv:109.0) Gecko/20100101 Firefox/109.0

Peak Memory Usage: 2496488/268435456

======

Error Class: wcf\system\database\exception\DatabaseQueryExecutionException

Error Message: Could not execute statement 'CREATE TABLE `wcf1_bounce` ( `id` int(10) NULL AUTO_INCREMENT PRIMARY KEY,`uid` int(10) NOT NULL,`body` longblob NULL DEFAULT NULL,`status` smallint(8) NULL DEFAULT NULL,`diagnostic` mediumtext NULL DEFAULT NULL,`email` varchar(191) NOT NULL,`type` enum('verp', 'hard', 'soft') NOT NULL DEFAULT 'verp',`userID` int(10) NULL DEFAULT NULL,`time` int(10) NOT NULL DEFAULT 0,`date` date NOT NULL , KEY `email` (`email`) ) ENGINE=InnoDB ROW_FORMAT=dynamic DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci'

Error Code: 42000

File: /is/htdocs/wp1164256_F5OY0QNS2J/www/lib/system/database/statement/PreparedStatement.class.php (144)

Extra Information: -

Stack Trace: [{"file":"\/is\/htdocs\/wp1164256_F5OY0QNS2J\/www\/lib\/system\/database\/editor\/MySQLDatabaseEditor.class.php","line":250,"function":"execute","class":"wcf\\system\\database\\statement\\PreparedStatement","type":"->","args":[]},{"file":"\/is\/htdocs\/wp1164256_F5OY0QNS2J\/www\/lib\/system\/database\/util\/SQLParser.class.php","line":294,"function":"createTable","class":"wcf\\system\\database\\editor\\MySQLDatabaseEditor","type":"->","args":["wcf1_bounce",["[redacted]","[redacted]","[redacted]","[redacted]","[redacted]","[redacted]","[redacted]","[redacted]","[redacted]","[redacted]"],["[redacted]"]]},{"file":"\/is\/htdocs\/wp1164256_F5OY0QNS2J\/www\/lib\/system\/package\/PackageInstallationSQLParser.class.php","line":296,"function":"executeCreateTableStatement","class":"wcf\\system\\database\\util\\SQLParser","type":"->","args":["wcf1_bounce",["[redacted]","[redacted]","[redacted]","[redacted]","[redacted]","[redacted]","[redacted]","[redacted]","[redacted]","[redacted]"],["[redacted]"]]},{"file":"\/is\/htdocs\/wp1164256_F5OY0QNS2J\/www\/lib\/system\/database\/util\/SQLParser.class.php","line":150,"function":"executeCreateTableStatement","class":"wcf\\system\\package\\PackageInstallationSQLParser","type":"->","args":["wcf1_bounce",["[redacted]","[redacted]","[redacted]","[redacted]","[redacted]","[redacted]","[redacted]","[redacted]","[redacted]","[redacted]"],["[redacted]"]]},{"file":"\/is\/htdocs\/wp1164256_F5OY0QNS2J\/www\/lib\/system\/database\/util\/SQLParser.class.php","line":58,"function":"executeStatement","class":"wcf\\system\\database\\util\\SQLParser","type":"->","args":["CREATE TABLE","CREATE TABLE wcf1_bounce\n(\n id INT(10) AUTO_INCREMENT PRIMARY KEY,\n uid INT(10) NOT NULL,\n body LONGBLOB DEFAULT NULL,\n status SMALLINT(8) DEFAULT NULL,\n diagnostic MEDIUMTEXT DEFAULT NULL,\n email VARCHAR(191) NOT NULL,\n type ENUM ('verp', 'hard', 'soft') NOT NULL DEFAULT 'verp',\n userID INT(10) DEFAULT NULL,\n time INT(10) NOT NULL DEFAULT 0,\n date DATE NOT NULL,\n KEY email (email)\n)"]},{"file":"\/is\/htdocs\/wp1164256_F5OY0QNS2J\/www\/lib\/system\/package\/plugin\/SQLPackageInstallationPlugin.class.php","line":73,"function":"execute","class":"wcf\\system\\database\\util\\SQLParser","type":"->","args":[]},{"file":"\/is\/htdocs\/wp1164256_F5OY0QNS2J\/www\/lib\/system\/package\/PackageInstallationDispatcher.class.php","line":807,"function":"install","class":"wcf\\system\\package\\plugin\\SQLPackageInstallationPlugin","type":"->","args":[]},{"file":"\/is\/htdocs\/wp1164256_F5OY0QNS2J\/www\/lib\/system\/package\/PackageInstallationDispatcher.class.php","line":155,"function":"executePIP","class":"wcf\\system\\package\\PackageInstallationDispatcher","type":"->","args":[{"attributes":"[redacted]","pip":"[redacted]","value":"[redacted]"}]},{"file":"\/is\/htdocs\/wp1164256_F5OY0QNS2J\/www\/lib\/acp\/action\/InstallPackageAction.class.php","line":82,"function":"install","class":"wcf\\system\\package\\PackageInstallationDispatcher","type":"->","args":["be697ced"]},{"file":"\/is\/htdocs\/wp1164256_F5OY0QNS2J\/www\/lib\/action\/AbstractDialogAction.class.php","line":73,"function":"stepInstall","class":"wcf\\acp\\action\\InstallPackageAction","type":"->","args":[]},{"file":"\/is\/htdocs\/wp1164256_F5OY0QNS2J\/www\/lib\/action\/AbstractAction.class.php","line":57,"function":"execute","class":"wcf\\action\\AbstractDialogAction","type":"->","args":[]},{"file":"\/is\/htdocs\/wp1164256_F5OY0QNS2J\/www\/lib\/system\/request\/Request.class.php","line":90,"function":"__run","class":"wcf\\action\\AbstractAction","type":"->","args":[]},{"file":"\/is\/htdocs\/wp1164256_F5OY0QNS2J\/www\/lib\/system\/request\/RequestHandler.class.php","line":107,"function":"execute","class":"wcf\\system\\request\\Request","type":"->","args":[]},{"file":"\/is\/htdocs\/wp1164256_F5OY0QNS2J\/www\/acp\/index.php","line":11,"function":"handle","class":"wcf\\system\\request\\RequestHandler","type":"->","args":["wcf",true]}]

======

Error Class: PDOException

Error Message: SQLSTATE[42000]: Syntax error or access violation: 1171 All parts of a PRIMARY KEY must be NOT NULL; if you need NULL in a key, use UNIQUE instead

Error Code: 42000

File: /is/htdocs/wp1164256_F5OY0QNS2J/www/lib/system/database/statement/PreparedStatement.class.php (126)