No announcement yet.

error 1062

  • Filter
  • Time
  • Show
Clear All
new posts

  • error 1062

    Database error in vBulletin 3.7.2:

    Invalid SQL:
    INSERT INTO userfield

    MySQL Error : Duplicate entry '18551' for key 1
    Error Number : 1062
    Request Date : Sunday, July 20th 2008 @ 09:16:51 PM
    Error Date : Sunday, July 20th 2008 @ 09:16:51 PM
    Script :
    Referrer :
    IP Address :
    Username : s2kinteg9169
    Classname : vB_Database
    MySQL Version :

    Need help!!!

  • #2
    To fix this run Repair/Optimize in the Admin CP. You may need to run it more than once to fix all errors:

    Admin CP -> Maintenance -> Repair/Optimize Tables -> Check All -> Continue

    If you cannot access the Admin CP you can also use phpMyAdmin to repair tables.

    If you still have this problem after that, run this:

    Admin CP -> Maintenance -> Repair/Optimize Tables -> Fix Unique Indexes
    Steve Machol, former vBulletin Customer Support Manager (and NOT retired!)
    Change CKEditor Colors to Match Style (for 4.1.4 and above)

    Steve Machol Photography

    Mankind is the only creature smart enough to know its own history, and dumb enough to ignore it.


    • #3
      I have done both already by researching the existing threads here i also made another attempt and im still getting the same error

      i also disabled all my plugins and mods as well just in case


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