Problems uninstalling and re-installing Mod Shop

[geezmo]

Our forum crashed the other time so I had to uninstall all mods. For Mod Shop, I encountered unsintallation errors so what I did was undo all edits in ALL the files associated with Mod Shop AND dropped the smf_shop_items and smf_inventory tables.

Yet when I tried to re-install the Mod Shop, I got an error saying the database already exists. What do I do then to properly re-install it?

[Daniel15]

What do I do then to properly re-install it?

The installer checks for the shopVersion field in the smf_settings database table. You'll need to remove all the shop settings from the smf_settings table.

[geezmo]

Ok, how do I do that? remove all shop settings from smf_settings table?

[Daniel15]

Alright, go into phpMyAdmin. Then, run these queries:

Code: [Select]

DELETE FROM `smf_settings` WHERE `variable` = 'shopVersion' LIMIT 1;
DELETE FROM `smf_settings` WHERE `variable` = 'shopDate' LIMIT 1;
DELETE FROM `smf_settings` WHERE `variable` = 'shopBuild' LIMIT 1;
DELETE FROM `smf_settings` WHERE `variable` = 'shopCurrencyPrefix' LIMIT 1;
DELETE FROM `smf_settings` WHERE `variable` = 'shopCurrencySuffix' LIMIT 1;
DELETE FROM `smf_settings` WHERE `variable` = 'shopPointsPerTopic' LIMIT 1;
DELETE FROM `smf_settings` WHERE `variable` = 'shopPointsPerPost' LIMIT 1;
DELETE FROM `smf_settings` WHERE `variable` = 'shopInterest' LIMIT 1;
DELETE FROM `smf_settings` WHERE `variable` = 'shopBankEnabled' LIMIT 1;
DELETE FROM `smf_settings` WHERE `variable` = 'shopImageWidth' LIMIT 1;
DELETE FROM `smf_settings` WHERE `variable` = 'shopImageHeight' LIMIT 1;
DELETE FROM `smf_settings` WHERE `variable` = 'shopTradeEnabled' LIMIT 1;
DELETE FROM `smf_settings` WHERE `variable` = shopItemsPerPage' LIMIT 1;