Problem with either Shop 3.0.2 or Shop Effects Store
-----
| Author | Message | |
|---|---|---|
|
BlinkyBill01 |
||
| Mon Sep 18, 2006 1:11 pm Post subject: Problem with either Shop 3.0.2 or Shop Effects Store | ||
|
Hey Thoul,
I installed the newest version of Shop3 and then your newest Effects Store, now I get an error in the Admin panel when I click on Shop Settings. Quote: Fatal Error with Transaction Code!
Unknown column 'user_id' in 'field list' I have no idea where to look to fix this error. |
||
|
Thoul |
||
| Mon Sep 18, 2006 10:37 pm Post subject: re: Problem with either Shop 3.0.2 or Shop Effects Store | ||
|
Oh, that's going to be hard to debug. That error shouldn't be generated by the effects shop, but there are about 11 points where it could appear in Shop 3's admin file.
Try replacing your admin/admin_shop.php with a fresh copy from the Shop 3.0.2 download and see what that does. If it works, then try reapplying the Effects Store edits to the file. |
||
|
BlinkyBill01 |
||
| Tue Sep 19, 2006 12:42 pm Post subject: | ||
|
Tried it and it didn't work. Do you know what I need to remove from the MySQL that is associated with shop 3.0.2 and the effects shop? I want to try a fully clean install of it.
I do remember you told me how to remove the shop 2 and when I installed shop 3 it, I got a message saying that a few things already existed, so I don't think I got everything. I want to try and duplicate this and figure it out because I have too many members breathing down my neck for this darn thing 
|
||
|
Thoul |
||
| Tue Sep 19, 2006 1:56 pm Post subject: re: Problem with either Shop 3.0.2 or Shop Effects Store | ||
|
For the effects shop, there's an uninstall option in the installer script. Just reupload install.php.
For the base shop, these should do it: Code: DROP TABLE phpbb_shops;
DROP TABLE phpbb_transactions; DROP TABLE phpbb_user_items; DELETE FROM phpbb_config WHERE config_name='multibuys'; DELETE FROM phpbb_config WHERE config_name='restocks'; DELETE FROM phpbb_config WHERE config_name='sellrate'; DELETE FROM phpbb_config WHERE config_name='viewtopic'; DELETE FROM phpbb_config WHERE config_name='viewprofile'; DELETE FROM phpbb_config WHERE config_name='viewinventory'; DELETE FROM phpbb_config WHERE config_name='viewtopiclimit'; DELETE FROM phpbb_config WHERE config_name='shop_orderby'; DELETE FROM phpbb_config WHERE config_name='shop_give'; DELETE FROM phpbb_config WHERE config_name='shop_trade'; DELETE FROM phpbb_config WHERE config_name='shop_discard'; DELETE FROM phpbb_config WHERE config_name='shop_invlimit'; DELETE FROM phpbb_config WHERE config_name='shop_owners'; DELETE FROM phpbb_config WHERE config_name='shop_districts'; ALTER TABLE phpbb_users DROP `user_trade`; |
||
Page 1 of 1