[HM666]

Originally Posted by pratul11

Hi All: I have got a new issue. I have uninstalled the mod completely and then tried reinstalling it..now I get the following error:


Database error in vBulletin 4.2.3:

Invalid SQL:
INSERT INTO `ecommerce_product_types` SET id='1', name='Downloadable', shipping='0', downloads='1';

MySQL Error : Duplicate entry '1' for key 'PRIMARY'
Error Number : 1062
Request Date : Friday, January 13th 2017 @ 06:39:33 AM
Error Date : Friday, January 13th 2017 @ 06:39:34 AM
Script : http://www.occultforums.net/admincp/...=productimport
Referrer : http://www.occultforums.net/admincp/...?do=productadd
IP Address : 103.10.197.2
Username : DarkAdverts
Classname : vB_Database
MySQL Version : 5.5.52-cll-lve

Can you please help me how to solve it? Thanks

That is because when you uninstalled it did not uninstall the database as well. So basically what that error message is saying is that there was already a value for that table in your database and therefore it cannot install until that value is removed. If you have phpMyAdmin you can go into it and remove that table or the tables associated with the ecommerce module and try to reinstall it again. Just be careful because if you remove the wrong thing it can completely and permanently screw up your forum. Your ecommerce tables will labeled as ecommerce_agreements, ecommerce_cart and so on. Every table that has ecommerce_ in it will belong to this mod. Your tables may have a prefix. It depends on what was done when vBulletin was installed. My prefix is vb4 so an eccomerce table in mine would look like vb4_eccommerce_cart.