Hey Marcel Beckers ,
Muss dich leider enttäuschen, funktioniert weiterhin nicht
Der gleiche Fehler wie oben.
Ich verwende bei jeder fehlgeschlagenen Intallation vom Arbeitsplatz eine neue WSC Installation.
EDIT:
Code
System Information
PHP Version:
8.1.6
WoltLab Suite Core:
5.5.4
Peak Memory Usage:
4.559/512 MiB
Request URI:
POST /acp/index.php?install-package/&t=5ceb931f17484db662dccb8208b3c952af1886f72c34aa6cda229320efc1320d-6bd44iYPrxZUBnlwDpNB7Q==
Referrer:
http://localhost/acp/index.php?package-installation-confirm/&queueID=2
User Agent:
Mozilla/5.0 (Windows NT 10.0; Win64; x64) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/103.0.5060.134 Safari/537.36 OPR/89.0.4447.91
Original Error
Error Type:
PDOException
Error Message:
SQLSTATE[42000]: Syntax error or access violation: 1067 Invalid default value for 'messageID'
Error Code:
42000
File:
*/lib/system/database/Database.class.php (328)
Stack Trace:
#0 */lib/system/database/Database.class.php (328):
PDO->prepare('CREATE TABLE `workplace1_task` ( `taskID` int(10) NOT NULL AUTO_INCREMENT PRIMARY KEY,`typeID` int(10) NULL DEFAULT NULL,`userID` int(10) NULL,`username` varchar(255) NOT NULL DEFAULT '',`isOpen` tinyint(1) NOT NULL DEFAULT 0,`time` int(10) NOT NULL DEFAULT 0,`taskDate` text NULL,`firstTaskDateID` int(10) NULL,`categoryID` int(10) NULL,`attachments` smallint(5) NOT NULL DEFAULT 0,`comments` smallint(5) NOT NULL DEFAULT 0,`cumulativeLikes` mediumint(7) NOT NULL DEFAULT 0,`enableComments` tinyint(1) NOT NULL DEFAULT 1,`isDisabled` tinyint(1) NOT NULL DEFAULT 0,`isDeleted` tinyint(1) NOT NULL DEFAULT 0,`isPrivate` tinyint(1) NOT NULL DEFAULT 0,`maxAuthors` int(10) NULL DEFAULT 0,`maxResponsibles` int(10) NULL DEFAULT 0,`deleteTime` int(10) NOT NULL DEFAULT 0,`ipAddress` varchar(39) NOT NULL DEFAULT '',`hasLabels` tinyint(1) NOT NULL DEFAULT 0,`editorID` int(10) NULL,`editor` varchar(255) NOT NULL DEFAULT '',`lastEditTime` int(10) NOT NULL DEFAULT 0,`editCount` mediumint(7) NOT NULL DEFAULT 0,`editReason` text NULL,`messageID` int(10) NOT NULL DEFAULT NULL , KEY (`userID`),KEY (`messageID`),KEY (`editorID`),KEY (`time`) ) ENGINE=InnoDB ROW_FORMAT=dynamic DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci -- '/acp/index.php?install-package/&t=5ceb931f17484db662dccb8208b3c952af1886f72c34aa6cda229320efc1320d-6bd44iYPrxZUBnlwDpNB7Q=='')
#1 */lib/system/database/editor/MySQLDatabaseEditor.class.php (249):
wcf\system\database\Database->prepareStatement('CREATE TABLE `workplace1_task` ( `taskID` int(10) NOT NULL AUTO_INCREMENT PRIMARY KEY,`typeID` int(10) NULL DEFAULT NULL,`userID` int(10) NULL,`username` varchar(255) NOT NULL DEFAULT '',`isOpen` tinyint(1) NOT NULL DEFAULT 0,`time` int(10) NOT NULL DEFAULT 0,`taskDate` text NULL,`firstTaskDateID` int(10) NULL,`categoryID` int(10) NULL,`attachments` smallint(5) NOT NULL DEFAULT 0,`comments` smallint(5) NOT NULL DEFAULT 0,`cumulativeLikes` mediumint(7) NOT NULL DEFAULT 0,`enableComments` tinyint(1) NOT NULL DEFAULT 1,`isDisabled` tinyint(1) NOT NULL DEFAULT 0,`isDeleted` tinyint(1) NOT NULL DEFAULT 0,`isPrivate` tinyint(1) NOT NULL DEFAULT 0,`maxAuthors` int(10) NULL DEFAULT 0,`maxResponsibles` int(10) NULL DEFAULT 0,`deleteTime` int(10) NOT NULL DEFAULT 0,`ipAddress` varchar(39) NOT NULL DEFAULT '',`hasLabels` tinyint(1) NOT NULL DEFAULT 0,`editorID` int(10) NULL,`editor` varchar(255) NOT NULL DEFAULT '',`lastEditTime` int(10) NOT NULL DEFAULT 0,`editCount` mediumint(7) NOT NULL DEFAULT 0,`editReason` text NULL,`messageID` int(10) NOT NULL DEFAULT NULL , KEY (`userID`),KEY (`messageID`),KEY (`editorID`),KEY (`time`) ) ENGINE=InnoDB ROW_FORMAT=dynamic DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci')
#2 */lib/system/database/util/SQLParser.class.php (294):
wcf\system\database\editor\MySQLDatabaseEditor->createTable('workplace1_task', [ 27 items ], [ 0 => , 1 => , 2 => , 3 => ])
#3 */lib/system/package/PackageInstallationSQLParser.class.php (296):
wcf\system\database\util\SQLParser->executeCreateTableStatement('workplace1_task', [ 27 items ], [ 0 => , 1 => , 2 => , 3 => ])
#4 */lib/system/database/util/SQLParser.class.php (150):
wcf\system\package\PackageInstallationSQLParser->executeCreateTableStatement('workplace1_task', [ 27 items ], [ 0 => , 1 => , 2 => , 3 => ])
#5 */lib/system/database/util/SQLParser.class.php (58):
wcf\system\database\util\SQLParser->executeStatement('CREATE TABLE', 'CREATE TABLE workplace1_task ( taskID INT(10) NOT NULL AUTO_INCREMENT PRIMARY KEY, typeID INT(10) NULL DEFAULT NULL, userID INT(10), username VARCHAR(255) NOT NULL DEFAULT '', isOpen TINYINT(1) NOT NULL DEFAULT 0, time INT(10) NOT NULL DEFAULT 0, taskDate TEXT, firstTaskDateID INT(10), categoryID INT(10), attachments SMALLINT(5) NOT NULL DEFAULT 0, comments SMALLINT(5) NOT NULL DEFAULT 0, cumulativeLikes MEDIUMINT(7) NOT NULL DEFAULT 0, enableComments TINYINT(1) NOT NULL DEFAULT 1, isDisabled TINYINT(1) NOT NULL DEFAULT 0, isDeleted TINYINT(1) NOT NULL DEFAULT 0, isPrivate TINYINT(1) NOT NULL DEFAULT 0, maxAuthors INT(10) DEFAULT 0, maxResponsibles INT(10) DEFAULT 0, deleteTime INT(10) NOT NULL DEFAULT 0, ipAddress VARCHAR(39) NOT NULL DEFAULT '', hasLabels TINYINT(1) NOT NULL DEFAULT 0, editorID INT(10), editor VARCHAR(255) NOT NULL DEFAULT '', lastEditTime INT(10) NOT NULL DEFAULT 0, editCount MEDIUMINT(7) NOT NULL DEFAULT 0, editReason TEXT, messageID INT(10) NOT NULL DEFAULT NULL, KEY (userID), KEY (messageID), KEY (editorID), KEY (time) )')
#6 */lib/system/package/plugin/SQLPackageInstallationPlugin.class.php (73):
wcf\system\database\util\SQLParser->execute()
#7 */lib/system/package/PackageInstallationDispatcher.class.php (807):
wcf\system\package\plugin\SQLPackageInstallationPlugin->install()
#8 */lib/system/package/PackageInstallationDispatcher.class.php (155):
wcf\system\package\PackageInstallationDispatcher->executePIP([ attributes => , pip => , value => ])
#9 */lib/acp/action/InstallPackageAction.class.php (82):
wcf\system\package\PackageInstallationDispatcher->install('cb57dfa7')
#10 */lib/action/AbstractDialogAction.class.php (73):
wcf\acp\action\InstallPackageAction->stepInstall()
#11 */lib/action/AbstractAction.class.php (57):
wcf\action\AbstractDialogAction->execute()
#12 */lib/system/request/Request.class.php (90):
wcf\action\AbstractAction->__run()
#13 */lib/system/request/RequestHandler.class.php (107):
wcf\system\request\Request->execute()
#14 */acp/index.php (11):
wcf\system\request\RequestHandler->handle('wcf', true)
Final Error
Error Type:
wcf\system\database\exception\DatabaseQueryException
Error Message:
Could not prepare statement 'CREATE TABLE `workplace1_task` ( `taskID` int(10) NOT NULL AUTO_INCREMENT PRIMARY KEY,`typeID` int(10) NULL DEFAULT NULL,`userID` int(10) NULL,`username` varchar(255) NOT NULL DEFAULT '',`isOpen` tinyint(1) NOT NULL DEFAULT 0,`time` int(10) NOT NULL DEFAULT 0,`taskDate` text NULL,`firstTaskDateID` int(10) NULL,`categoryID` int(10) NULL,`attachments` smallint(5) NOT NULL DEFAULT 0,`comments` smallint(5) NOT NULL DEFAULT 0,`cumulativeLikes` mediumint(7) NOT NULL DEFAULT 0,`enableComments` tinyint(1) NOT NULL DEFAULT 1,`isDisabled` tinyint(1) NOT NULL DEFAULT 0,`isDeleted` tinyint(1) NOT NULL DEFAULT 0,`isPrivate` tinyint(1) NOT NULL DEFAULT 0,`maxAuthors` int(10) NULL DEFAULT 0,`maxResponsibles` int(10) NULL DEFAULT 0,`deleteTime` int(10) NOT NULL DEFAULT 0,`ipAddress` varchar(39) NOT NULL DEFAULT '',`hasLabels` tinyint(1) NOT NULL DEFAULT 0,`editorID` int(10) NULL,`editor` varchar(255) NOT NULL DEFAULT '',`lastEditTime` int(10) NOT NULL DEFAULT 0,`editCount` mediumint(7) NOT NULL DEFAULT 0,`editReason` text NULL,`messageID` int(10) NOT NULL DEFAULT NULL , KEY (`userID`),KEY (`messageID`),KEY (`editorID`),KEY (`time`) ) ENGINE=InnoDB ROW_FORMAT=dynamic DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci'
Error Code:
42000
File:
*/lib/system/database/Database.class.php (333)
Stack Trace:
#0 */lib/system/database/editor/MySQLDatabaseEditor.class.php (249):
wcf\system\database\Database->prepareStatement('CREATE TABLE `workplace1_task` ( `taskID` int(10) NOT NULL AUTO_INCREMENT PRIMARY KEY,`typeID` int(10) NULL DEFAULT NULL,`userID` int(10) NULL,`username` varchar(255) NOT NULL DEFAULT '',`isOpen` tinyint(1) NOT NULL DEFAULT 0,`time` int(10) NOT NULL DEFAULT 0,`taskDate` text NULL,`firstTaskDateID` int(10) NULL,`categoryID` int(10) NULL,`attachments` smallint(5) NOT NULL DEFAULT 0,`comments` smallint(5) NOT NULL DEFAULT 0,`cumulativeLikes` mediumint(7) NOT NULL DEFAULT 0,`enableComments` tinyint(1) NOT NULL DEFAULT 1,`isDisabled` tinyint(1) NOT NULL DEFAULT 0,`isDeleted` tinyint(1) NOT NULL DEFAULT 0,`isPrivate` tinyint(1) NOT NULL DEFAULT 0,`maxAuthors` int(10) NULL DEFAULT 0,`maxResponsibles` int(10) NULL DEFAULT 0,`deleteTime` int(10) NOT NULL DEFAULT 0,`ipAddress` varchar(39) NOT NULL DEFAULT '',`hasLabels` tinyint(1) NOT NULL DEFAULT 0,`editorID` int(10) NULL,`editor` varchar(255) NOT NULL DEFAULT '',`lastEditTime` int(10) NOT NULL DEFAULT 0,`editCount` mediumint(7) NOT NULL DEFAULT 0,`editReason` text NULL,`messageID` int(10) NOT NULL DEFAULT NULL , KEY (`userID`),KEY (`messageID`),KEY (`editorID`),KEY (`time`) ) ENGINE=InnoDB ROW_FORMAT=dynamic DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci')
#1 */lib/system/database/util/SQLParser.class.php (294):
wcf\system\database\editor\MySQLDatabaseEditor->createTable('workplace1_task', [ 27 items ], [ 0 => , 1 => , 2 => , 3 => ])
#2 */lib/system/package/PackageInstallationSQLParser.class.php (296):
wcf\system\database\util\SQLParser->executeCreateTableStatement('workplace1_task', [ 27 items ], [ 0 => , 1 => , 2 => , 3 => ])
#3 */lib/system/database/util/SQLParser.class.php (150):
wcf\system\package\PackageInstallationSQLParser->executeCreateTableStatement('workplace1_task', [ 27 items ], [ 0 => , 1 => , 2 => , 3 => ])
#4 */lib/system/database/util/SQLParser.class.php (58):
wcf\system\database\util\SQLParser->executeStatement('CREATE TABLE', 'CREATE TABLE workplace1_task ( taskID INT(10) NOT NULL AUTO_INCREMENT PRIMARY KEY, typeID INT(10) NULL DEFAULT NULL, userID INT(10), username VARCHAR(255) NOT NULL DEFAULT '', isOpen TINYINT(1) NOT NULL DEFAULT 0, time INT(10) NOT NULL DEFAULT 0, taskDate TEXT, firstTaskDateID INT(10), categoryID INT(10), attachments SMALLINT(5) NOT NULL DEFAULT 0, comments SMALLINT(5) NOT NULL DEFAULT 0, cumulativeLikes MEDIUMINT(7) NOT NULL DEFAULT 0, enableComments TINYINT(1) NOT NULL DEFAULT 1, isDisabled TINYINT(1) NOT NULL DEFAULT 0, isDeleted TINYINT(1) NOT NULL DEFAULT 0, isPrivate TINYINT(1) NOT NULL DEFAULT 0, maxAuthors INT(10) DEFAULT 0, maxResponsibles INT(10) DEFAULT 0, deleteTime INT(10) NOT NULL DEFAULT 0, ipAddress VARCHAR(39) NOT NULL DEFAULT '', hasLabels TINYINT(1) NOT NULL DEFAULT 0, editorID INT(10), editor VARCHAR(255) NOT NULL DEFAULT '', lastEditTime INT(10) NOT NULL DEFAULT 0, editCount MEDIUMINT(7) NOT NULL DEFAULT 0, editReason TEXT, messageID INT(10) NOT NULL DEFAULT NULL, KEY (userID), KEY (messageID), KEY (editorID), KEY (time) )')
#5 */lib/system/package/plugin/SQLPackageInstallationPlugin.class.php (73):
wcf\system\database\util\SQLParser->execute()
#6 */lib/system/package/PackageInstallationDispatcher.class.php (807):
wcf\system\package\plugin\SQLPackageInstallationPlugin->install()
#7 */lib/system/package/PackageInstallationDispatcher.class.php (155):
wcf\system\package\PackageInstallationDispatcher->executePIP([ attributes => , pip => , value => ])
#8 */lib/acp/action/InstallPackageAction.class.php (82):
wcf\system\package\PackageInstallationDispatcher->install('cb57dfa7')
#9 */lib/action/AbstractDialogAction.class.php (73):
wcf\acp\action\InstallPackageAction->stepInstall()
#10 */lib/action/AbstractAction.class.php (57):
wcf\action\AbstractDialogAction->execute()
#11 */lib/system/request/Request.class.php (90):
wcf\action\AbstractAction->__run()
#12 */lib/system/request/RequestHandler.class.php (107):
wcf\system\request\Request->execute()
#13 */acp/index.php (11):
wcf\system\request\RequestHandler->handle('wcf', true)
Alles anzeigen