it happened to me and i just repeated what you have just done and it somehow worked, i didnt do it cos i knew what i was doing, i was just trying different things on phpmyadmin and it worked

its ok i had to remove the edit from ucash in the memberinfo template

Try this one.

Is there a query I can run to remove anything refering to or containing ushop?

Fatal error: Call to undefined function: replace_template_variables() in /web/www.mysite.com/html/installer/class_installer.php on line 708

guys here are the tables I've dropped so far.. maybe Jay since he's done this already can add maybe I missed a few and the superbowl is starting :)

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`;

Hmm. Try

Hi, im doing a fresh install got this problem:

Database error in vBulletin 3.5.3:

Invalid SQL:
CREATE TABLE ushop_action (
`actionid` int(5) NOT NULL auto_increment,
`categoryid` smallint(5) NOT NULL default '1',
`shortname` varchar(255) NOT NULL default '',
`name` varchar(255) NOT NULL default '',
`description` text NOT NULL,
`displayorder` int(10) NOT NULL default '0',
`cost` varchar(20) NOT NULL default '',
`tax` varchar(20) NOT NULL default '',
`sold` bigint(10) NOT NULL default '0',
`defaultquantity` bigint(10) NOT NULL default '0',
`quantity` bigint(10) NOT NULL default '0',
`allowedgroups` varchar(255) NOT NULL default '',
`deniedgroups` varchar(255) NOT NULL default '',
`expiration` int(15) NOT NULL default '0',
`noexpiremarkup` decimal(20,2) NOT NULL default '0.00',
`filelocation` varchar(255) NOT NULL default '',
`imagelocation` varchar(255) NOT NULL default '',
`disablecoupon` tinyint(1) NOT NULL default '0',
`showinstore` tinyint(1) NOT NULL default '0',
`active` tinyint(1) NOT NULL default '0',
`saf_name` varchar(50) NOT NULL default '',
`asvs` text NOT NULL,
`itemcatcache` text NOT NULL,
`itemcache` text NOT NULL,
PRIMARY KEY (`actionid`)
);

MySQL Error : Table 'ushop_action' already exists
Error Number : 1050
Date : Monday, February 6th 2006 @ 12:38:52 AM
Script : http://ourhabboforum.be/installer/index.php
Referrer : http://ourhabboforum.be/installer/index.php
IP Address : 82.34.122.216
Username : xRoyal15
Classname : vb_database

You sure this is your first time running this install?

yer, i had ebux before if that might be why...