WBB Installation

  • Betroffene 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 ! :)

  • Hi

    which version of woltlan you already have install :?:

    if it is old then you have to start and install the one that is after the one you have etc.

    or install the new and imported the old forum :thumbup::thumbup:

    Norwegian language files to (WSC 5.2 + 5.3 WSC 5.4 + 5.5 and The New 6.0 ) *no.xml* Unofficial Language Packs

  • 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")
  • Aufgerufene URL
    POST /acp/index.php?install-package/&t=95f6b032803c5b4c96ca4dc21a061209cd2ea220
    Referrer
    https://mods.sp-tarkov.com/acp/index.php?package-installation-confirm/&queueID=134
    WoltLab Suite
    5.3.5
    PHP
    7.3.19-1~deb10u1
    Fehlermeldung
    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'
    Art
    wcf\system\database\exception\DatabaseQueryExecutionException
    Datei (Zeile)
    /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(…)
    Fehlermeldung
    SQLSTATE[HY000]: General error: 1005 Can't create table `aki_mods`.`wbb1_thread` (errno: 150 "Foreign key constraint is incorrectly formed")
    Art
    PDOException
    Datei (Zeile)
    /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

    • Offizieller Beitrag

    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:

Jetzt mitmachen!

Sie haben noch kein Benutzerkonto auf unserer Seite? Registrieren Sie sich kostenlos und nehmen Sie an unserer Community teil!