PDA

View Full Version : new install error



gowri
05-19-2010, 12:37 AM
HI All

we are installing on vb 4.0.3 & we are getting below error

****************
Database error in vBulletin 4.0.3:

Invalid SQL:

CREATE TABLE adv_dyna_attachmentperms (
permissionid int(10) unsigned NOT NULL auto_increment,
extension varchar(20) NOT NULL,
usergroupid int(10) unsigned NOT NULL default '0',
permissions text NOT NULL,
PRIMARY KEY (permissionid),
UNIQUE KEY extension (extension,usergroupid)
) TYPE=MyISAM;

MySQL Error : Table 'adv_dyna_attachmentperms' already exists
Error Number : 1050
Request Date : Wednesday, May 19th 2010 @ 09:57:42 AM
Error Date : Wednesday, May 19th 2010 @ 09:58:10 AM
Script : http://localhost/vb/admincp/vbadyna_install.php
Referrer : http://localhost/vb/admincp/vbadyna_install.php
IP Address : 127.0.0.1
Username : Admin
Classname : vB_Database
MySQL Version : 5.0.77-log

***************************************

let us know what will be the problem

Note: we deleted entire database created from backup still same error


Thanks
gowri

Brian
05-20-2010, 11:38 AM
Looks like you have some tables left over from a previous installation. If you go to the admincp/vbadyna_install.php file and use the Uninstall option then it will remove those tables and you should be able to re-install afterward.