Unable to uninstall packages

Yachtie · Jun 13th 2019

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

/var/www/vhosts/aethernal.eu/board.aethernal.eu/lib/system/package/plugin/AbstractPackageInstallationPlugin.class.php (98): wcf\system\database\Database->prepareStatement(…)
/var/www/vhosts/aethernal.eu/board.aethernal.eu/lib/system/package/plugin/AbstractXMLPackageInstallationPlugin.class.php (76): wcf\system\package\plugin\AbstractPackageInstallationPlugin->uninstall(…)
/var/www/vhosts/aethernal.eu/board.aethernal.eu/lib/system/package/PackageUninstallationDispatcher.class.php (118): wcf\system\package\plugin\AbstractXMLPackageInstallationPlugin->uninstall(…)
/var/www/vhosts/aethernal.eu/board.aethernal.eu/lib/system/package/PackageUninstallationDispatcher.class.php (74): wcf\system\package\PackageUninstallationDispatcher->executePIP(…)
/var/www/vhosts/aethernal.eu/board.aethernal.eu/lib/acp/action/UninstallPackageAction.class.php (112): wcf\system\package\PackageUninstallationDispatcher->uninstall(…)
/var/www/vhosts/aethernal.eu/board.aethernal.eu/lib/action/AbstractDialogAction.class.php (68): wcf\acp\action\UninstallPackageAction->stepUninstall(…)
/var/www/vhosts/aethernal.eu/board.aethernal.eu/lib/action/AbstractAction.class.php (47): wcf\action\AbstractDialogAction->execute(…)
/var/www/vhosts/aethernal.eu/board.aethernal.eu/lib/system/request/Request.class.php (83): wcf\action\AbstractAction->__run(…)
/var/www/vhosts/aethernal.eu/board.aethernal.eu/lib/system/request/RequestHandler.class.php (96): wcf\system\request\Request->execute(…)
/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

/var/www/vhosts/aethernal.eu/board.aethernal.eu/lib/system/database/Database.class.php (243): PDO->prepare(…)
/var/www/vhosts/aethernal.eu/board.aethernal.eu/lib/system/package/plugin/AbstractPackageInstallationPlugin.class.php (98): wcf\system\database\Database->prepareStatement(…)
/var/www/vhosts/aethernal.eu/board.aethernal.eu/lib/system/package/plugin/AbstractXMLPackageInstallationPlugin.class.php (76): wcf\system\package\plugin\AbstractPackageInstallationPlugin->uninstall(…)
/var/www/vhosts/aethernal.eu/board.aethernal.eu/lib/system/package/PackageUninstallationDispatcher.class.php (118): wcf\system\package\plugin\AbstractXMLPackageInstallationPlugin->uninstall(…)
/var/www/vhosts/aethernal.eu/board.aethernal.eu/lib/system/package/PackageUninstallationDispatcher.class.php (74): wcf\system\package\PackageUninstallationDispatcher->executePIP(…)
/var/www/vhosts/aethernal.eu/board.aethernal.eu/lib/acp/action/UninstallPackageAction.class.php (112): wcf\system\package\PackageUninstallationDispatcher->uninstall(…)
/var/www/vhosts/aethernal.eu/board.aethernal.eu/lib/action/AbstractDialogAction.class.php (68): wcf\acp\action\UninstallPackageAction->stepUninstall(…)
/var/www/vhosts/aethernal.eu/board.aethernal.eu/lib/action/AbstractAction.class.php (47): wcf\action\AbstractDialogAction->execute(…)
/var/www/vhosts/aethernal.eu/board.aethernal.eu/lib/system/request/Request.class.php (83): wcf\action\AbstractAction->__run(…)
/var/www/vhosts/aethernal.eu/board.aethernal.eu/lib/system/request/RequestHandler.class.php (96): wcf\system\request\Request->execute(…)
/var/www/vhosts/aethernal.eu/board.aethernal.eu/acp/index.php (9): wcf\system\request\RequestHandler->handle(…)

Thu, 13 Jun 2019 20:21:15 +0000
Message: Could not prepare statement 'DELETE FROM	wcf1_tour 			WHERE		packageID = ?'
PHP version: 7.3.6
WoltLab Suite version: 3.1.9 pl 2
Request URI: /acp/index.php?uninstall-package/&t=2a7739a8c257ea4e107112d313064d124c0b9615
Referrer: https://board.aethernal.eu/acp/index.php?package/154/
User Agent: Mozilla/5.0 (Windows NT 10.0; Win64; x64) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/75.0.3770.80 Safari/537.36
Peak Memory Usage: 3176168/134217728
======
Error Class: wcf\system\database\exception\DatabaseQueryException
Error Message: Could not prepare statement 'DELETE FROM	wcf1_tour 			WHERE		packageID = ?'
Error Code: 42
File: /var/www/vhosts/aethernal.eu/board.aethernal.eu/lib/system/database/Database.class.php (248)
Extra Information: -
Stack Trace: [{"file":"\/var\/www\/vhosts\/aethernal.eu\/board.aethernal.eu\/lib\/system\/package\/plugin\/AbstractPackageInstallationPlugin.class.php","line":98,"function":"prepareStatement","class":"wcf\\system\\database\\Database","type":"->","args":["DELETE FROM\twcf1_tour\n\t\t\tWHERE\t\tpackageID = ?"]},{"file":"\/var\/www\/vhosts\/aethernal.eu\/board.aethernal.eu\/lib\/system\/package\/plugin\/AbstractXMLPackageInstallationPlugin.class.php","line":76,"function":"uninstall","class":"wcf\\system\\package\\plugin\\AbstractPackageInstallationPlugin","type":"->","args":[]},{"file":"\/var\/www\/vhosts\/aethernal.eu\/board.aethernal.eu\/lib\/system\/package\/PackageUninstallationDispatcher.class.php","line":118,"function":"uninstall","class":"wcf\\system\\package\\plugin\\AbstractXMLPackageInstallationPlugin","type":"->","args":[]},{"file":"\/var\/www\/vhosts\/aethernal.eu\/board.aethernal.eu\/lib\/system\/package\/PackageUninstallationDispatcher.class.php","line":74,"function":"executePIP","class":"wcf\\system\\package\\PackageUninstallationDispatcher","type":"->","args":[{"pluginName":"[redacted]","className":"[redacted]"}]},{"file":"\/var\/www\/vhosts\/aethernal.eu\/board.aethernal.eu\/lib\/acp\/action\/UninstallPackageAction.class.php","line":112,"function":"uninstall","class":"wcf\\system\\package\\PackageUninstallationDispatcher","type":"->","args":["e9cb2dbf"]},{"file":"\/var\/www\/vhosts\/aethernal.eu\/board.aethernal.eu\/lib\/action\/AbstractDialogAction.class.php","line":68,"function":"stepUninstall","class":"wcf\\acp\\action\\UninstallPackageAction","type":"->","args":[]},{"file":"\/var\/www\/vhosts\/aethernal.eu\/board.aethernal.eu\/lib\/action\/AbstractAction.class.php","line":47,"function":"execute","class":"wcf\\action\\AbstractDialogAction","type":"->","args":[]},{"file":"\/var\/www\/vhosts\/aethernal.eu\/board.aethernal.eu\/lib\/system\/request\/Request.class.php","line":83,"function":"__run","class":"wcf\\action\\AbstractAction","type":"->","args":[]},{"file":"\/var\/www\/vhosts\/aethernal.eu\/board.aethernal.eu\/lib\/system\/request\/RequestHandler.class.php","line":96,"function":"execute","class":"wcf\\system\\request\\Request","type":"->","args":[]},{"file":"\/var\/www\/vhosts\/aethernal.eu\/board.aethernal.eu\/acp\/index.php","line":9,"function":"handle","class":"wcf\\system\\request\\RequestHandler","type":"->","args":["wcf",true]}]
======
Error Class: PDOException
Error Message: SQLSTATE[42S02]: Base table or view not found: 1146 Table 'aetherna_board.wcf1_tour' doesn't exist
Error Code: 42
File: /var/www/vhosts/aethernal.eu/board.aethernal.eu/lib/system/database/Database.class.php (243)
Extra Information: -
Stack Trace: [{"file":"\/var\/www\/vhosts\/aethernal.eu\/board.aethernal.eu\/lib\/system\/database\/Database.class.php","line":243,"function":"prepare","class":"PDO","type":"->","args":["DELETE FROM\twcf1_tour\n\t\t\tWHERE\t\tpackageID = ?"]},{"file":"\/var\/www\/vhosts\/aethernal.eu\/board.aethernal.eu\/lib\/system\/package\/plugin\/AbstractPackageInstallationPlugin.class.php","line":98,"function":"prepareStatement","class":"wcf\\system\\database\\Database","type":"->","args":["DELETE FROM\twcf1_tour\n\t\t\tWHERE\t\tpackageID = ?"]},{"file":"\/var\/www\/vhosts\/aethernal.eu\/board.aethernal.eu\/lib\/system\/package\/plugin\/AbstractXMLPackageInstallationPlugin.class.php","line":76,"function":"uninstall","class":"wcf\\system\\package\\plugin\\AbstractPackageInstallationPlugin","type":"->","args":[]},{"file":"\/var\/www\/vhosts\/aethernal.eu\/board.aethernal.eu\/lib\/system\/package\/PackageUninstallationDispatcher.class.php","line":118,"function":"uninstall","class":"wcf\\system\\package\\plugin\\AbstractXMLPackageInstallationPlugin","type":"->","args":[]},{"file":"\/var\/www\/vhosts\/aethernal.eu\/board.aethernal.eu\/lib\/system\/package\/PackageUninstallationDispatcher.class.php","line":74,"function":"executePIP","class":"wcf\\system\\package\\PackageUninstallationDispatcher","type":"->","args":[{"pluginName":"[redacted]","className":"[redacted]"}]},{"file":"\/var\/www\/vhosts\/aethernal.eu\/board.aethernal.eu\/lib\/acp\/action\/UninstallPackageAction.class.php","line":112,"function":"uninstall","class":"wcf\\system\\package\\PackageUninstallationDispatcher","type":"->","args":["e9cb2dbf"]},{"file":"\/var\/www\/vhosts\/aethernal.eu\/board.aethernal.eu\/lib\/action\/AbstractDialogAction.class.php","line":68,"function":"stepUninstall","class":"wcf\\acp\\action\\UninstallPackageAction","type":"->","args":[]},{"file":"\/var\/www\/vhosts\/aethernal.eu\/board.aethernal.eu\/lib\/action\/AbstractAction.class.php","line":47,"function":"execute","class":"wcf\\action\\AbstractDialogAction","type":"->","args":[]},{"file":"\/var\/www\/vhosts\/aethernal.eu\/board.aethernal.eu\/lib\/system\/request\/Request.class.php","line":83,"function":"__run","class":"wcf\\action\\AbstractAction","type":"->","args":[]},{"file":"\/var\/www\/vhosts\/aethernal.eu\/board.aethernal.eu\/lib\/system\/request\/RequestHandler.class.php","line":96,"function":"execute","class":"wcf\\system\\request\\Request","type":"->","args":[]},{"file":"\/var\/www\/vhosts\/aethernal.eu\/board.aethernal.eu\/acp\/index.php","line":9,"function":"handle","class":"wcf\\system\\request\\RequestHandler","type":"->","args":["wcf",true]}]

All the best guys!

NicoleSophie · Jun 13th 2019

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

Yachtie · Jun 13th 2019

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

all the best

NicoleSophie · Jun 13th 2019

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

Ruff Seas · Jun 13th 2019

Quote from SupaHigher

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 ...

Yachtie · Jun 13th 2019

Thanks guy I will do as advised

**Tim Düsterhus** · Jun 13th 2019

Hi

Quote from Ruff Seas

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.

NicoleSophie · Jun 13th 2019

Quote from Ruff Seas

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

Yachtie · Jun 13th 2019

Quote from Tim Düsterhus

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

all the best

Ruff Seas · Jun 14th 2019

Quote from Tim Düsterhus

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.

kbarg · Jun 15th 2019

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.

Yachtie · Jun 15th 2019

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!

**Tim Düsterhus** · Jun 15th 2019

Hi

Quote from Ruff Seas

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.

Unable to uninstall packages

Participate now!

Share

Users Viewing This Thread