Results 1 to 6 of 6

Thread: Mysql error

  1. #1

    Default Mysql error

    Hello,

    I installed and uninstalled vBa Links Directory 1 on my vb 3.6 forum.

    When I try to install it again, I get this error :

    Database error in vBulletin 3.6.0:

    Invalid SQL:
    INSERT INTO phrase (languageid, varname, text, fieldname) VALUES (0, 'setting_global_navbar_replace_title', 'Navbar Replacements', 'vbsettings');

    MySQL Error : Duplicate entry 'setting_global_navbar_replace_title-0-vbsettings' for key 2
    Error Number : 1062
    Date : Tuesday, October 17th 2006 @ 12:45:43 PM
    Script : http://virusphoto.com/admincp/vbalinks_install.php
    Referrer : http://virusphoto.com/admincp/vbalinks_install.php
    IP Address : 86.120.165.157
    Username : Jeff
    Classname : vb_database
    I tried to uninstall and install again, but I still get the same error.
    How can I fix that ?

    Thanks.

  2. #2

    Default Re: Mysql error

    Is there any way to fix that ?

    Thanks.

  3. #3
    Join Date
    Jan 2004
    Location
    Georgia, USA
    Posts
    34,466

    Default Re: Mysql error

    Try looking in the admincp/vbalinks_install.php file for this line:
    PHP Code:
    $checkglobal $db->query_first("SELECT grouptitle FROM " TABLE_PREFIX "adv_settinggroup WHERE grouptitle = 'adv_global'"); 
    Replace with this:
    PHP Code:
    $checkglobal $db->query_first("SELECT grouptitle FROM " TABLE_PREFIX "adv_setting WHERE grouptitle = 'adv_global'"); 
    Then try to un-install and re-install again.

  4. #4

    Default Re: Mysql error

    Done. Now i get this error :
    Database error in vBulletin 3.6.0:

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

    MySQL Error : Duplicate entry 'adv_global' for key 1
    Error Number : 1062
    Date : Wednesday, October 18th 2006 @ 09:21:03 PM
    Script : http://virusphoto.com/admincp/vbalinks_install.php
    Referrer : http://virusphoto.com/admincp/vbalinks_install.php
    IP Address : 86.120.165.157
    Username : Jeff
    Classname : vb_database
    How can I fix it ?

  5. #5
    Join Date
    Jan 2004
    Location
    Georgia, USA
    Posts
    34,466

    Default Re: Mysql error

    Strange... I don't see how you would get that, but you should be able to replace this line:
    PHP Code:
    $db->query_write("INSERT INTO " TABLE_PREFIX "adv_settinggroup VALUES ('$name', $gid)"); 
    With this:
    PHP Code:
    $db->query_write("INSERT IGNORE INTO " TABLE_PREFIX "adv_settinggroup VALUES ('$name', $gid)"); 
    And that will keep it from erroring out.

    Though is there any reason why you're installing v1.0? 2.0 was just released a few weeks ago and includes quite a few new options and features.

  6. #6

    Default Re: Mysql error

    issue fixed, thanks.

Thread Information

Users Browsing this Thread

There are currently 1 users browsing this thread. (0 members and 1 guests)

Similar Threads

  1. another MySQL error
    By Delphivi in forum Troubleshooting & Problems
    Replies: 1
    Last Post: 10-09-2006, 02:37 PM
  2. MySQL error in 2.0
    By Delphivi in forum Troubleshooting & Problems
    Replies: 2
    Last Post: 10-04-2006, 08:52 PM
  3. Please HELP MySQL ERROR!!!
    By gtx2 in forum Troubleshooting & Problems
    Replies: 1
    Last Post: 07-07-2006, 11:13 PM

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •