Step two mysql error (Help!)

[rinkrat]

Database error in vBulletin 3.0.5:

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

mysql error number: 1062

Date: Thursday 30th of June 2005 07:54:37 PM
Script: http://www.letsgokings.com/bbs/admincp/vbacmps_install.php?do=upgrade&step=2


How can I get past this?

[Brian]

If you'll look in the install file for this bit of code:
if ($checkglobal['grouptitle'])
{
$DB_site->query("INSERT INTO " . TABLE_PREFIX . "adv_settinggroup VALUES ('adv_global', 1)");
insert_phrase('settinggroup_adv_global', 'Global vBadvanced Settings', 5000);
}


Replace with this:
if (!$checkglobal['grouptitle'])
{
$DB_site->query("INSERT INTO " . TABLE_PREFIX . "adv_settinggroup VALUES ('adv_global', 1)");
insert_phrase('settinggroup_adv_global', 'Global vBadvanced Settings', 5000);
}


Upload the file and then try the upgrade process again and it should work fine.

[rinkrat]

Thanks for the lightning fast response :)

[rinkrat]

It looks like it installed ok but I'm getting loads of errors from admin script when trying to save my permissions settings.

Warning: implode(): Bad arguments. in /admincp/vba_cmps_admin.php on line 2107

Warning: array_keys(): The first argument should be an array in /admincp/vba_cmps_admin.php on line 2107

Warning: implode(): Bad arguments. in /admincp/vba_cmps_admin.php on line 2107

Warning: array_keys(): The first argument should be an array in /admincp/vba_cmps_admin.php on line 2107


Here's what I have so far:
http://www.letsgokings.com

It won't let people view it.

[Brian]

Hmmm, I haven't seen that one before. Would you mind submitting a support ticket so I can have a look at things?

[rinkrat]

Will do

[rinkrat]

Sorry I forgot my ftp password. I'm trying to remember it.

[rinkrat]

ahh remembered and sent the ticket. Hope you are still up :)