PDA

View Full Version : DB Queries Error


ryne661
07-17-2005, 12:57 AM
vBulletin Version 3.0.7
uShop & uCash 0.95b
Error happens when it is suppose to do DB queries in install.

Exact error....
Database error in vBulletin 3.0.7:

Invalid SQL: CREATE TABLE utt_store_action (
`actionid` int(5) NOT NULL auto_increment,
`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 '',
`filelocation` varchar(255) NOT NULL default '',
`imagelocation` varchar(255) NOT NULL default '',
`showinstore` tinyint(1) NOT NULL default '0',
`active` tinyint(1) NOT NULL default '0',
`asvs` TEXT NOT NULL,
PRIMARY KEY (`actionid`)
) TYPE=MyISAM AUTO_INCREMENT=18
mysql error: Table 'utt_store_action' already exists

mysql error number: 1050


Alright, I figured out why it is already there, but now how can I bypass the Database step?