Unable to uninstall packages

  • Affected Version
    WoltLab Suite 3.1

    Hello everyone!

    I'm encountering an error whenever I try to uninstall any package and can't really understand why.


    This is the error message:

    Requested URL
    /acp/index.php?uninstall-package/&t=2a7739a8c257ea4e107112d313064d124c0b9615
    Referrer
    https://board.aethernal.eu/acp/index.php?package/154/
    Error Message
    Could not prepare statement 'DELETE FROM wcf1_tour WHERE packageID = ?'
    Type
    wcf\system\database\exception\DatabaseQueryException
    File (Line)
    /var/www/vhosts/aethernal.eu/board.aethernal.eu/lib/system/database/Database.class.php (248)
    Stacktrace
    1. /var/www/vhosts/aethernal.eu/board.aethernal.eu/lib/system/package/plugin/AbstractPackageInstallationPlugin.class.php (98): wcf\system\database\Database->prepareStatement(…)
    2. /var/www/vhosts/aethernal.eu/board.aethernal.eu/lib/system/package/plugin/AbstractXMLPackageInstallationPlugin.class.php (76): wcf\system\package\plugin\AbstractPackageInstallationPlugin->uninstall(…)
    3. /var/www/vhosts/aethernal.eu/board.aethernal.eu/lib/system/package/PackageUninstallationDispatcher.class.php (118): wcf\system\package\plugin\AbstractXMLPackageInstallationPlugin->uninstall(…)
    4. /var/www/vhosts/aethernal.eu/board.aethernal.eu/lib/system/package/PackageUninstallationDispatcher.class.php (74): wcf\system\package\PackageUninstallationDispatcher->executePIP(…)
    5. /var/www/vhosts/aethernal.eu/board.aethernal.eu/lib/acp/action/UninstallPackageAction.class.php (112): wcf\system\package\PackageUninstallationDispatcher->uninstall(…)
    6. /var/www/vhosts/aethernal.eu/board.aethernal.eu/lib/action/AbstractDialogAction.class.php (68): wcf\acp\action\UninstallPackageAction->stepUninstall(…)
    7. /var/www/vhosts/aethernal.eu/board.aethernal.eu/lib/action/AbstractAction.class.php (47): wcf\action\AbstractDialogAction->execute(…)
    8. /var/www/vhosts/aethernal.eu/board.aethernal.eu/lib/system/request/Request.class.php (83): wcf\action\AbstractAction->__run(…)
    9. /var/www/vhosts/aethernal.eu/board.aethernal.eu/lib/system/request/RequestHandler.class.php (96): wcf\system\request\Request->execute(…)
    10. /var/www/vhosts/aethernal.eu/board.aethernal.eu/acp/index.php (9): wcf\system\request\RequestHandler->handle(…)
    Error Message
    SQLSTATE[42S02]: Base table or view not found: 1146 Table 'aetherna_board.wcf1_tour' doesn't exist
    Type
    PDOException
    File (Line)
    /var/www/vhosts/aethernal.eu/board.aethernal.eu/lib/system/database/Database.class.php (243)
    Stacktrace
    1. /var/www/vhosts/aethernal.eu/board.aethernal.eu/lib/system/database/Database.class.php (243): PDO->prepare(…)
    2. /var/www/vhosts/aethernal.eu/board.aethernal.eu/lib/system/package/plugin/AbstractPackageInstallationPlugin.class.php (98): wcf\system\database\Database->prepareStatement(…)
    3. /var/www/vhosts/aethernal.eu/board.aethernal.eu/lib/system/package/plugin/AbstractXMLPackageInstallationPlugin.class.php (76): wcf\system\package\plugin\AbstractPackageInstallationPlugin->uninstall(…)
    4. /var/www/vhosts/aethernal.eu/board.aethernal.eu/lib/system/package/PackageUninstallationDispatcher.class.php (118): wcf\system\package\plugin\AbstractXMLPackageInstallationPlugin->uninstall(…)
    5. /var/www/vhosts/aethernal.eu/board.aethernal.eu/lib/system/package/PackageUninstallationDispatcher.class.php (74): wcf\system\package\PackageUninstallationDispatcher->executePIP(…)
    6. /var/www/vhosts/aethernal.eu/board.aethernal.eu/lib/acp/action/UninstallPackageAction.class.php (112): wcf\system\package\PackageUninstallationDispatcher->uninstall(…)
    7. /var/www/vhosts/aethernal.eu/board.aethernal.eu/lib/action/AbstractDialogAction.class.php (68): wcf\acp\action\UninstallPackageAction->stepUninstall(…)
    8. /var/www/vhosts/aethernal.eu/board.aethernal.eu/lib/action/AbstractAction.class.php (47): wcf\action\AbstractDialogAction->execute(…)
    9. /var/www/vhosts/aethernal.eu/board.aethernal.eu/lib/system/request/Request.class.php (83): wcf\action\AbstractAction->__run(…)
    10. /var/www/vhosts/aethernal.eu/board.aethernal.eu/lib/system/request/RequestHandler.class.php (96): wcf\system\request\Request->execute(…)
    11. /var/www/vhosts/aethernal.eu/board.aethernal.eu/acp/index.php (9): wcf\system\request\RequestHandler->handle(…)


    All the best guys!

  • Just a guess, may do nothing . But see you run PHP 7.3. Have you tried droppiong down to a lower PHP version and see if that works

  • Hei, thank you for the reply!

    Unfortunately I don't think it is because of that reason because I did installed and uninstalled packages until yesterday, today it stopped for some reason.


    I hope I didn't mess the whole thing up :D


    all the best

  • I would put a support ticket in to fix it, if that is what you want. They don't like answering anything on the forums when it comes to a problem with your site

  • Hello everyone!

    I'm encountering an error whenever I try to uninstall any package and can't really understand why.


    Hello SupaHigher,


    I may be mistaken, however I seem to recall Alexander Ebert stating that the preferred PHP Version to use is 7.1; additionally, using version 7.2 OR 7.3 can lead to various problems with various apps and plugins - among other problems as well.


    Even on the PHP website they say to use Version 7.1 (and they further identify this version by stating it as 7.1.30)


    If you continue to have a problem with uninstalling packages perhaps you should open a support ticket with Woltlab ...;)

    • Official Post

    Hi

    I may be mistaken, however I seem to recall Alexander Ebert stating that the preferred PHP Version to use is 7.1; additionally, using version 7.2 OR 7.3 can lead to various problems with various apps and plugins - among other problems as well.

    The preferred version is the newest version that supports all your apps and plugins. Apps and plugins from us will support PHP 7.3 just fine!


    Yachtie Apparently a database table the plugin created during installation and tries to remove during uninstallation is missing, leading to this issue. I can second the existing advice to file a ticket so that we can look into it and hopefully fix the database of your community.

  • I may be mistaken, however I seem to recall Alexander Ebert stating that the preferred PHP Version to use is 7.1; additionally, using version 7.2 OR 7.3 can lead to various problems with various apps and plugins - among other problems as well.

    I think you are getting a bit mislead by what he said. He did actually say use the highest PHP version you can in that reply, which is PHP 7.3. And I have run WBB on the same 7.3.x PHP version without getting any error logs that something wasn't working right, the site ran fine. So don't think there is any issues running it on 7.3, but the preferred version at minute is probably 7.2 because that is the most stable PHP version to use over 7.3


    He pointed out that some changes have been made in PHP 7.2 and 7.3 that could lead to problems with other 3rd party apps sold that may need changes/or not to be compatible with PHP version above 7.1. But the WBB official apps sold all work with PHP 7.3

  • Hi

    The preferred version is the newest version that supports all your apps and plugins. Apps and plugins from us will support PHP 7.3 just fine!


    Yachtie Apparently a database table the plugin created during installation and tries to remove during uninstallation is missing, leading to this issue. I can second the existing advice to file a ticket so that we can look into it and hopefully fix the database of your community.

    Hi Tim Düsterhus ,

    I have just filed a ticket I hope we can fix it too =O


    all the best

  • The preferred version is the newest version that supports all your apps and plugins. Apps and plugins from us will support PHP 7.3 just fine!

    Hello Tim Düsterhus,


    At the present time my Hosting Provider has the PHP set at 7.1

    Thus regarding what you stated in your response to me in Post #5, do you think I should have them change the setting to PHP Version 7.3?


    I haven't as yet purchased an install from Woltlab for uploading Version 5.1 to my website (I intend to do this on or about July 1st)

    so if I should have the PHP setting changed FROM 7.1 TO 7.3, now would probably be the time to have the change made.

  • If they have CPanel, then it would be super easy for them to install multiple PHP instances and the best part is they can keep some hostees on 7.1 and make your primary 7.3.

  • Hello guys a little update on this, the issue was cause by a non correctly uninstalled plugin.

    It has been resolved by WoltLab support.


    Thanks to everyone for the reply!

    • Official Post

    Hi

    Thus regarding what you stated in your response to me in Post #5, do you think I should have them change the setting to PHP Version 7.3?

    If you don't run any plugins then I recommend PHP 7.3. If you do you might need to check with the authors whether PHP 7.3 is supported. It should be supported for most.

Participate now!

Don’t have an account yet? Register yourself now and be a part of our community!