[maroulis]

Originally Posted by rb290

I got this when installing


Database error in vBulletin 3.5.2:

Invalid SQL:
ALTER TABLE forum
ADD `ucash_perthread` varchar(20) NOT NULL default '',
ADD `ucash_perreply` varchar(20) NOT NULL default '',
ADD `ucash_perview` varchar(20) NOT NULL default '',
ADD `ucash_perdownload` varchar(20) NOT NULL default '';

MySQL Error : Duplicate column name 'ucash_perthread'
Error Number : 1060
Date : Sunday, February 5th 2006 @ 08:08:46 PM
Script : http://thugonline.net/installer/index.php
Referrer : http://thugonline.net/installer/index.php

you need to drop all the uCash/uShop tables and re-install...go to phpMyAdmin and run the following SQL queries... then re-run installer

STEP 1:
-------
DROP TABLE `vb_ushop_action` ,
`vb_ushop_asvs` ,
`vb_ushop_bank` ,
`vb_ushop_category` ,
`vb_ushop_history` ,
`vb_ushop_item` ,
`vb_ushop_item_cat` ;

STEP 2:
-------
ALTER TABLE `vb_forum`
DROP `ucash_perthread` ,
DROP `ucash_perreply` ,
DROP `ucash_perview` ,
DROP `ucash_perdownload` ;

STEP 3:
-------
ALTER TABLE `vb_user`
DROP `ushop_history` ,
DROP `ushop_glow` ,
DROP `ushop_usernamecolor` ,
DROP `ushop_boldusername` ,
DROP `ushop_italicsusername` ,
DROP `ushop_bankdata` ,
DROP `ushop_bankqueue` ,
DROP `ushop_bankwarning` ,
DROP `ushop_profilemidi` ,
DROP `ushop_bypassflood` ,
DROP `ucash` ;

STEP 4:
-------
ALTER TABLE `vb_usergroup`
DROP `ushop_discount`,
DROP `ucash_paycheck`,
DROP `ushop_options`;