I have problem with Shop 3.0.0
-----
| Author | Message | |
|---|---|---|
|
alien13 |
||
| Mon Aug 28, 2006 1:42 am Post subject: I have problem with Shop 3.0.0 | ||
|
Hi, I have Shop Mod 2.60, but I decide to uninstall. I remove all shop files, put backup files and uninstall the database (like here). After that I install Shop Mod 3.0.0. Еverything in the installalition work fine, but when I inastlled Shop Mod 3.0.0 in admin menu, all Global Shop Settings cannot be changed and when I create shop and acces it, it show's me:
Code: Fatal Error: You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near '' at line 4
I any case, I want to ask how to uninstall the database for Shop mod 3.0.0 |
||
|
Thoul |
||
| Mon Aug 28, 2006 11:10 am Post subject: re: I have problem with Shop 3.0.0 | ||
|
The problem with the global settings not saving sounds could happen if the Shop 3 database didn't fully install. Was there anything else in the error message, like a file name or such?
To uninstall the Shop 3 database, run these queries: Code: DROP TABLE phpbb_shopitems;
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; |
||
|
alien13 |
||
| Mon Aug 28, 2006 1:50 pm Post subject: | ||
|
Thanx Thoul, I solved my problem
|
||
|
Thoul |
||
| Mon Aug 28, 2006 2:03 pm Post subject: re: I have problem with Shop 3.0.0 | ||
|
No problem, I'm glad you got it resolved.
|
||
Page 1 of 1