Upgrading Problems

[xtremeoff-road]

Hey everyone, I attempted to upgrade and received this error...any thoughts??

Database error in vBulletin 3.0.3:

Invalid SQL: INSERT INTO vb3_adv_settinggroup VALUES ('adv_global', 1)
mysql error: Duplicate entry 'adv_global' for key 1

mysql error number: 1062

Date: Thursday 21st of July 2005 11:23:30 PM
Script: xxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxx
Referer:
Username: xxxxxxxx
IP Address: xx.xx.xx.xx

[xtremeoff-road]

Ok tried the fix that was mentioned in previous threads...here is the new error:

Database error in vBulletin 3.0.3:

Invalid SQL:
ALTER TABLE vb3_adv_modules
ADD parent varchar(255) NOT NULL default '',
ADD colspan smallint(3) unsigned NOT NULL default '0',
ADD formcode text NOT NULL,
ADD cleanoutput smallint(3) unsigned NOT NULL default '0',
ADD useshell smallint(3) unsigned NOT NULL default '0',
ADD link varchar(255) NOT NULL default '',
ADD options text NOT NULL,
CHANGE filename filename text NOT NULL,
CHANGE inctype inctype varchar(20) NOT NULL default ''

mysql error: Duplicate column name 'parent'

[xtremeoff-road]

This is the fix I used:

http://www.vbadvanced.com/forum/showpost.php?p=48570&postcount=5

However it does not work???

Anyone...anyone?

[banuchi2]

Anyone figure this one out. I'm having a similar problem:

Database error in vBulletin 3.5.0 Release Candidate 1:

Invalid SQL:
INSERT INTO datastore VALUES ('adv_portal_opts', '');

MySQL Error : Duplicate entry 'adv_portal_opts' for key 1
Error Number : 1062
Date : Wednesday, July 27th 2005 @ 10:08:08 AM

[xtremeoff-road]

Any ideas about this???

[Brian]

It sounds like you already installed/upgraded the script...

[xtremeoff-road]

Actually no, I have version CMPS v1.0.0 installed. I then upgrade my VB to 3.0.7 and try to install/upgrade to the correct CMPS...that is the error I get??