Announcement

Collapse
No announcement yet.

MySQL Error : Duplicate entry '2' for key 1

Collapse
X
 
  • Filter
  • Time
  • Show
Clear All
new posts

  • MySQL Error : Duplicate entry '2' for key 1

    Database error in vBulletin 3.6.7:

    Invalid SQL:
    INSERT INTO administrator
    (userid)
    VALUES
    (2);

    MySQL Error : Duplicate entry '2' for key 1
    Error Number : 1062
    Date : Thursday, May 24th 2007 @ 01:07:00 AM
    Script : http://www.xxxx.cl/community/admincp/user.php?do=update
    Referrer : http://www.xxxx.cl/community/admincp...hp?do=edit&u=2
    IP Address : 190.20.110.2
    Username : xxxxxxx
    Classname : vb_database


    to not placed any modification

    Sorry for my bad english.

  • #2
    First, reupload all the original vB non-image files (except install.php). Make sure you upload these in ASCII format and overwrite the ones on the server. Also be sure to upload the admincp files to whichever directory you have set in your config.php file. Then run 'Suspect File Versions' in Diagnostics to make sure you have all the original files for your version:

    Admin CP -> Maintenance -> Diagnostics -> Suspect File Versions

    [Note: In some cases you may also need to remove any of the listed .xml files in the includes/xml directory.]

    Next, disable all plugins.

    Note: To temporarily disable the plugin system, edit config.php and add this line right under <?php

    define('DISABLE_HOOKS', true);


    Do you still have the same problem?
    Kerry-Anne :)

    Twitter Blog

    www.peterska2.com www.worldnewszone.com www.popularusenetgroups.com www.superclickers.co.uk www.forumsforchrist.com www.browsergameplanet.com

    Comment


    • #3
      Originally posted by understyle View Post
      Database error in vBulletin 3.6.7:

      Invalid SQL:
      INSERT INTO administrator
      (userid)
      VALUES
      (2);

      MySQL Error : Duplicate entry '2' for key 1
      Error Number : 1062
      Date : Thursday, May 24th 2007 @ 01:07:00 AM
      Script : http://www.xxxx.cl/community/admincp/user.php?do=update
      Referrer : http://www.xxxx.cl/community/admincp...hp?do=edit&u=2
      IP Address : 190.20.110.2
      Username : xxxxxxx
      Classname : vb_database


      to not placed any modification

      Sorry for my bad english.
      You can go to the admin control panel > maintenance > optimize & repair > fix unique indexes > and let that run.

      That should probably fix it.

      Comment


      • #4
        Tanks Floris...

        Google traslater :

        the answer of Kerry-Anne all says to me the same and I do not understand anything xD but good with the one of floris I am solved thanks

        Comment

        widgetinstance 262 (Related Topics) skipped due to lack of content & hide_module_if_empty option.
        Working...
        X