MySQL Error : Duplicate entry 'adv_global' for key 1 : SOLVED

[jim6763nva]

Database error in vBulletin 3.5.0:

Invalid SQL:
INSERT INTO vb_adv_settinggroup VALUES ('adv_global', 1);

MySQL Error : Duplicate entry 'adv_global' for key 1
Error Number : 1062
Date : Saturday, October 22nd 2005 @ 12:51:58 PM
Script : http://www.nova-classifieds.com/admincp/vbalinks_install.php
Referrer : http://www.nova-classifieds.com/admincp/vbalinks_install.php
IP Address : 69.243.37.133
Username : Admin
Classname : vb_database


I'm not sure if this will solve every instance of this error but this is what I did to correct the issue:

1. Run the uninstall option.

2. I went into the vb_adv_settingsgroup table and removed the "adv_global" record

3. re-run the install from the very top.

I was able to run through the whole install script without a burp.

Hopefully this will help someone else,

Jim MacDiarmid
Adminstrator
NOVA-Classifieds.com (http://www.nova-classifieds.com)
Classified Ads site for the Northern Virginia Community.

[Brian]

Did you get this error on a new install or an upgrade?

[kyle]

Did you get this error on a new install or an upgrade?

I got this error with links 2.0 beta 2 and vb 3.6.2. Did the suggestion above and it installed fine. For the record I only have vbcmps installed on this site, never links.