WSC: 5.5.4
Hey,
Code
Original Error
Error Type:
PDOException
Error Message:
SQLSTATE[HY000]: General error: 1005 Can't create table `wsc5.5`.`workplace1_task` (errno: 150 "Foreign key constraint is incorrectly formed")
Error Code:
HY000
File:
*/lib/system/database/statement/PreparedStatement.class.php (126)
Stack Trace:
#0 */lib/system/database/statement/PreparedStatement.class.php (126):
PDOStatement->execute([ ])
#1 */lib/system/database/editor/MySQLDatabaseEditor.class.php (384):
wcf\system\database\statement\PreparedStatement->execute()
#2 */lib/system/database/util/SQLParser.class.php (343):
wcf\system\database\editor\MySQLDatabaseEditor->addForeignKey('workplace1_task', 'e70ccfd04dc2f96729b3c2bcb00d9548_fk', [ columns => , referencedTable => , referencedColumns => , ON DELETE => , ON UPDATE => ])
#3 */lib/system/package/PackageInstallationSQLParser.class.php (390):
wcf\system\database\util\SQLParser->executeAddForeignKeyStatement('workplace1_task', 'e70ccfd04dc2f96729b3c2bcb00d9548_fk', [ columns => , referencedTable => , referencedColumns => , ON DELETE => , ON UPDATE => ])
#4 */lib/system/database/util/SQLParser.class.php (184):
wcf\system\package\PackageInstallationSQLParser->executeAddForeignKeyStatement('workplace1_task', 'e70ccfd04dc2f96729b3c2bcb00d9548_fk', [ columns => , referencedTable => , referencedColumns => , ON DELETE => , ON UPDATE => ])
#5 */lib/system/database/util/SQLParser.class.php (58):
wcf\system\database\util\SQLParser->executeStatement('ALTER TABLE', 'ALTER TABLE workplace1_task ADD FOREIGN KEY (messageID) REFERENCES wcf1_conversation_message (messageID) ON DELETE SET NULL')
#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('6a40a04f')
#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\DatabaseQueryExecutionException
Error Message:
Could not execute statement 'ALTER TABLE `workplace1_task` ADD CONSTRAINT `e70ccfd04dc2f96729b3c2bcb00d9548_fk` FOREIGN KEY (`messageID`) REFERENCES `wcf1_conversation_message` (`messageID`) ON DELETE SET NULL'
Error Code:
HY000
File:
*/lib/system/database/statement/PreparedStatement.class.php (144)
Stack Trace:
#0 */lib/system/database/editor/MySQLDatabaseEditor.class.php (384):
wcf\system\database\statement\PreparedStatement->execute()
#1 */lib/system/database/util/SQLParser.class.php (343):
wcf\system\database\editor\MySQLDatabaseEditor->addForeignKey('workplace1_task', 'e70ccfd04dc2f96729b3c2bcb00d9548_fk', [ columns => , referencedTable => , referencedColumns => , ON DELETE => , ON UPDATE => ])
#2 */lib/system/package/PackageInstallationSQLParser.class.php (390):
wcf\system\database\util\SQLParser->executeAddForeignKeyStatement('workplace1_task', 'e70ccfd04dc2f96729b3c2bcb00d9548_fk', [ columns => , referencedTable => , referencedColumns => , ON DELETE => , ON UPDATE => ])
#3 */lib/system/database/util/SQLParser.class.php (184):
wcf\system\package\PackageInstallationSQLParser->executeAddForeignKeyStatement('workplace1_task', 'e70ccfd04dc2f96729b3c2bcb00d9548_fk', [ columns => , referencedTable => , referencedColumns => , ON DELETE => , ON UPDATE => ])
#4 */lib/system/database/util/SQLParser.class.php (58):
wcf\system\database\util\SQLParser->executeStatement('ALTER TABLE', 'ALTER TABLE workplace1_task ADD FOREIGN KEY (messageID) REFERENCES wcf1_conversation_message (messageID) ON DELETE SET NULL')
#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('6a40a04f')
#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
Bekomme diese Fehlermeldung bei einer frischen Installation vom Arbeitsplatz.
Verwendete Version vom Arbeitsplatz: 5.5.0 pl 2
MfG