WBB Installation

  • Affected Version
    WoltLab Suite 5.3

    Hello,

    I just bought the forum licence, and trying to install it on a already installed product, things are, i can't get it installed at all, each time i try, multiples errors pops out, and my installation is going bad until i delete the cache (can't access to anything in the ACP nor the website himself). Even if the installation fails, the package still show up as installed in the ACP

    But isn't working at all (obviously, installation got aborded, but well, hoping is a thing)


    So i was wondering if there was a tool that could check the installation "health" and maybe repair the wrongly installated packages on the current installation ? It would be problematic to do a whole re-installation and i want to avoid that


    Thanks in advance ! :)

  • Here is the error i'm currently getting when trying to install WB forum on my installation:


    Code
    SQLSTATE[HY000]: General error: 1005 Can't create table `table_name`.`wbb1_thread` (errno: 150 "Foreign key constraint is incorrectly formed")
  • Hello,


    Please provide the error message in full, there is a lot more to it that helps us to understand the cause of this error message.

    Alexander Ebert
    Senior Developer WoltLab® GmbH

  • Requested URL
    POST /acp/index.php?install-package/&t=95f6b032803c5b4c96ca4dc21a061209cd2ea220
    Referrer
    https://mods.sp-tarkov.com/acp/index.php?package-installation-confirm/&queueID=134
    Error Message
    Could not execute statement 'CREATE TABLE `wbb1_thread` ( `threadID` int(10) NOT NULL AUTO_INCREMENT PRIMARY KEY,`boardID` int(10) NOT NULL,`languageID` int(10),`topic` varchar(255) NOT NULL DEFAULT '',`firstPostID` int(10),`time` int(10) NOT NULL DEFAULT 0,`userID` int(10),`username` varchar(255) NOT NULL DEFAULT '',`lastPostID` int(10),`lastPostTime` int(10) NOT NULL DEFAULT 0,`lastPosterID` int(10),`lastPoster` varchar(255) NOT NULL DEFAULT '',`replies` int(10) NOT NULL DEFAULT 0,`views` int(10) NOT NULL DEFAULT 0,`attachments` int(10) NOT NULL DEFAULT 0,`polls` int(10) NOT NULL DEFAULT 0,`isAnnouncement` tinyint(1) NOT NULL DEFAULT 0,`isSticky` tinyint(1) NOT NULL DEFAULT 0,`isDisabled` tinyint(1) NOT NULL DEFAULT 0,`isClosed` tinyint(1) NOT NULL DEFAULT 0,`isDeleted` tinyint(1) NOT NULL DEFAULT 0,`movedThreadID` int(10),`movedTime` int(10) NOT NULL DEFAULT 0,`isDone` tinyint(1) NOT NULL DEFAULT 0,`cumulativeLikes` mediumint(7) NOT NULL DEFAULT 0,`hasLabels` tinyint(1) NOT NULL DEFAULT 0,`deleteTime` int(10) NOT NULL DEFAULT 0,`bestAnswerPostID` int(10) , KEY (`lastPostTime`),KEY (`boardID`,`isAnnouncement`,`isSticky`,`lastPostTime`,`isDeleted`,`isDisabled`),KEY (`boardID`,`isDeleted`,`isDisabled`,`movedThreadID`),KEY (`isDeleted`),KEY (`isDisabled`),KEY (`movedTime`),KEY `privateLastPost` (`boardID`,`isDeleted`,`isDisabled`,`movedThreadID`,`userID`,`lastPostTime`,`languageID`) ) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci'
    Type
    wcf\system\database\exception\DatabaseQueryExecutionException
    File (Line)
    /var/www/html/aki/mods/lib/system/database/statement/PreparedStatement.class.php (105)
    Stacktrace
    1. /var/www/html/aki/mods/lib/system/database/editor/MySQLDatabaseEditor.class.php (232): wcf\system\database\statement\PreparedStatement->execute(…)
    2. /var/www/html/aki/mods/lib/system/database/util/SQLParser.class.php (226): wcf\system\database\editor\MySQLDatabaseEditor->createTable(…)
    3. /var/www/html/aki/mods/lib/system/package/PackageInstallationSQLParser.class.php (271): wcf\system\database\util\SQLParser->executeCreateTableStatement(…)
    4. /var/www/html/aki/mods/lib/system/database/util/SQLParser.class.php (112): wcf\system\package\PackageInstallationSQLParser->executeCreateTableStatement(…)
    5. /var/www/html/aki/mods/lib/system/database/util/SQLParser.class.php (47): wcf\system\database\util\SQLParser->executeStatement(…)
    6. /var/www/html/aki/mods/lib/system/package/plugin/SQLPackageInstallationPlugin.class.php (65): wcf\system\database\util\SQLParser->execute(…)
    7. /var/www/html/aki/mods/lib/system/package/PackageInstallationDispatcher.class.php (747): wcf\system\package\plugin\SQLPackageInstallationPlugin->install(…)
    8. /var/www/html/aki/mods/lib/system/package/PackageInstallationDispatcher.class.php (144): wcf\system\package\PackageInstallationDispatcher->executePIP(…)
    9. /var/www/html/aki/mods/lib/acp/action/InstallPackageAction.class.php (73): wcf\system\package\PackageInstallationDispatcher->install(…)
    10. /var/www/html/aki/mods/lib/action/AbstractDialogAction.class.php (68): wcf\acp\action\InstallPackageAction->stepInstall(…)
    11. /var/www/html/aki/mods/lib/action/AbstractAction.class.php (47): wcf\action\AbstractDialogAction->execute(…)
    12. /var/www/html/aki/mods/lib/system/request/Request.class.php (83): wcf\action\AbstractAction->__run(…)
    13. /var/www/html/aki/mods/lib/system/request/RequestHandler.class.php (107): wcf\system\request\Request->execute(…)
    14. /var/www/html/aki/mods/acp/index.php (9): wcf\system\request\RequestHandler->handle(…)
    Error Message
    SQLSTATE[HY000]: General error: 1005 Can't create table `aki_mods`.`wbb1_thread` (errno: 150 "Foreign key constraint is incorrectly formed")
    Type
    PDOException
    File (Line)
    /var/www/html/aki/mods/lib/system/database/statement/PreparedStatement.class.php (93)
    Stacktrace
    1. /var/www/html/aki/mods/lib/system/database/statement/PreparedStatement.class.php (93): PDOStatement->execute(…)
    2. /var/www/html/aki/mods/lib/system/database/editor/MySQLDatabaseEditor.class.php (232): wcf\system\database\statement\PreparedStatement->execute(…)
    3. /var/www/html/aki/mods/lib/system/database/util/SQLParser.class.php (226): wcf\system\database\editor\MySQLDatabaseEditor->createTable(…)
    4. /var/www/html/aki/mods/lib/system/package/PackageInstallationSQLParser.class.php (271): wcf\system\database\util\SQLParser->executeCreateTableStatement(…)
    5. /var/www/html/aki/mods/lib/system/database/util/SQLParser.class.php (112): wcf\system\package\PackageInstallationSQLParser->executeCreateTableStatement(…)
    6. /var/www/html/aki/mods/lib/system/database/util/SQLParser.class.php (47): wcf\system\database\util\SQLParser->executeStatement(…)
    7. /var/www/html/aki/mods/lib/system/package/plugin/SQLPackageInstallationPlugin.class.php (65): wcf\system\database\util\SQLParser->execute(…)
    8. /var/www/html/aki/mods/lib/system/package/PackageInstallationDispatcher.class.php (747): wcf\system\package\plugin\SQLPackageInstallationPlugin->install(…)
    9. /var/www/html/aki/mods/lib/system/package/PackageInstallationDispatcher.class.php (144): wcf\system\package\PackageInstallationDispatcher->executePIP(…)
    10. /var/www/html/aki/mods/lib/acp/action/InstallPackageAction.class.php (73): wcf\system\package\PackageInstallationDispatcher->install(…)
    11. /var/www/html/aki/mods/lib/action/AbstractDialogAction.class.php (68): wcf\acp\action\InstallPackageAction->stepInstall(…)
    12. /var/www/html/aki/mods/lib/action/AbstractAction.class.php (47): wcf\action\AbstractDialogAction->execute(…)
    13. /var/www/html/aki/mods/lib/system/request/Request.class.php (83): wcf\action\AbstractAction->__run(…)
    14. /var/www/html/aki/mods/lib/system/request/RequestHandler.class.php (107): wcf\system\request\Request->execute(…)
    15. /var/www/html/aki/mods/acp/index.php (9): wcf\system\request\RequestHandler->handle(…)

    Hello, here is the full error message

  • There appear to be one or more orphaned foreign keys that are still pointing to the thread table and that are incompatible. This can only be the result of a previous attempt that was incorrectly reverted or otherwise the result of an improper modification of the database.


    This query should list the offending tables and columns:

    Alexander Ebert
    Senior Developer WoltLab® GmbH