Log in

View Full Version : error help plz


Muderman24
01-10-2005, 05:40 AM
i have gotten this error a few times and i nedd some help on how to fix it

Database error in vBulletin 3.0.4:

Invalid SQL: CREATE TABLE `vbchat_store` (
`sid` int(15) NOT NULL auto_increment,
`s_postby` int(15) NOT NULL default '0',
`s_message` mediumtext NOT NULL default '',
`s_postime` int(15) NOT NULL default '0',
`s_foruser` int(15) not null default '0',
PRIMARY KEY (`sid`)
) TYPE=MyISAM;
mysql error: Table 'vbchat_store' already exists

mysql error number: 1050

Marco van Herwaarden
01-10-2005, 08:40 AM
Look like you're trying to install a vbchat on a board that already had the install script run before. The tables simply already exist.

Best would be to ask how to handle this in the thread of this hack.

rake
01-11-2005, 06:08 PM
DROP TABLE IF EXISTS `vbchat_store`; to remove the table and then install the hack again.