Database Error Installing mod

[blind-eddie]

>>>>>>>>>>>>BACKUP YOUR DATABASE BEFORE YOU PROCEED<<<<<<<<<<<<

Go into your host account, phpMyAdmin, click on your sites database, find user table... click it, on the right, look for column name 'market_points', remove them.... now try to reinstall.

You may run into this issue again for other tables that were created in one of your installs of this plugin.

[A Dead Puppie]

As i posted above, i've already tried that multiple times. I've cleared every table with the prefix market_ and tried to install and the same issue pops up

[tbworld]

Originally Posted by A Dead Puppie

I'm trying to install a mod, (Point Market 3) and i keep getting a database error with the following:

[code]Database error in vBulletin 4.2.2:

Invalid SQL:
ALTER TABLE user ADD market_points DECIMAL( 18, 3 ) NOT NULL DEFAULT '1.000';

Have you looked at the table clearly marked above? That will not have a 'market_ 'prefix on it. That is an existing vBulletin table.

table: user
column: market_points

[vBNinja]

the issue is not a duplicate table, its a duplicate column in the user table

go to phpmyadmin and run this query:

PHP Code:

ALTER TABLE user DROP market_points; 


[A Dead Puppie]

Wooh! it worked! Thank you guys so much!