Running vBulletin 4.0.1
Recieving this error on product import:
Code:
Database error in vBulletin 4.0.1:
Invalid SQL:
ALTER TABLE market_items CHANGE `marketid` `mid` INT( 10 ) UNSIGNED NOT NULL AUTO_INCREMENT;
MySQL Error : Duplicate column name 'mid'
Error Number : 1060
Request Date : Monday, April 18th 2011 @ 11:09:54 PM
Error Date : Monday, April 18th 2011 @ 11:09:55 PM
Classname : vB_Database
MySQL Version : 5.0.91-community-log
Completed removed market_ tables and attempted to install again and recieved the following error.
Code:
Database error in vBulletin 4.0.1:
Invalid SQL:
ALTER TABLE market_store ADD `image_big_3` INT( 12 ) NOT NULL AFTER `image_big_3`;
MySQL Error : Duplicate column name 'image_big_3'
Error Number : 1060
Request Date : Wednesday, April 20th 2011 @ 02:10:08 AM
Error Date : Wednesday, April 20th 2011 @ 02:10:09 AM
Script : http://hostedtalk.com/admincp/plugin.php?do=productimport
Referrer : http://hostedtalk.com/admincp/plugin.php?do=productadd
IP Address : 99.35.212.62
Username : Cory
Classname : vB_Database
MySQL Version : 5.0.91-community-log
Old Error isn't relevant anymore as I've removed the tables one more time manually and attempted to install and I get the same error; so this could be duplicated.
I'm running uCash.