Heh. I've got an installation problem. I lost my internet connectivity while running the installation file (admincp/install.php). Now, when I try to install, the first step yields an error (as expected) that says the table has already been added. Is there any way to skip to the step I want or to correct this problem?
Code:
Database error in vBulletin 3.0.6:
Invalid SQL:
CREATE TABLE `article` (
`articleid` int(10) unsigned NOT NULL auto_increment,
`title` varchar(250) NOT NULL default '',
`firstpostid` int(10) unsigned NOT NULL default '0',
`lastcommentid` int(10) unsigned default NULL,
`lastcommentdateline` int(10) unsigned NOT NULL default '0',
`lastcommentposter` varchar(50) default NULL,
`lastcommentposterid` int(10) unsigned default NULL,
`categoryid` int(10) unsigned NOT NULL default '0',
`open` smallint(2) NOT NULL default '0',
`commentcount` int(10) unsigned NOT NULL default '0',
`articleusername` varchar(50) NOT NULL default '',
`articleuserid` int(4) unsigned NOT NULL default '0',
`dateline` int(10) unsigned NOT NULL default '0',
`views` int(10) unsigned NOT NULL default '0',
`iconid` int(10) unsigned NOT NULL default '0',
`votenum` smallint(5) unsigned NOT NULL default '0',
`votetotal` smallint(5) unsigned NOT NULL default '0',
`articlehash` varchar(32) NOT NULL default '',
PRIMARY KEY (`articleid`)
) TYPE=MyISAM
mysql error: Table 'article' already exists
mysql error number: 1050
Date: Sunday 30th of January 2005 12:21:35 PM
Script: http://forums.foreverbeyond.net/admincp/install.php
Referer: http://forums.foreverbeyond.net/admincp/install.php
I tried running the query "
DELETE FROM articles WHERE 1>0;" but to no result..
Thanks in advance. I appreciate the efforts of anyone who is helpful.