Announcement

Collapse
No announcement yet.

Database error

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

  • Database error

    I am getting this database error while posting thread

    Code:
    Database error in vBulletin 3.8.2:
    
    Invalid SQL:
    INSERT INTO vb_post
        (showsignature, allowsmilie, username, userid, title, pagetext, iconid, visible, dateline, ipaddress, attach, threadid)
    VALUES
        (1, 1, 'Gursimran', 1, 'hullo', 'testing testing testing testing testing testing testing testing testing testing testing testing testing testing testing testing testing testing testing testing testing testing testing testing testing testing testing testing testing testing testing testing testing testing testing testing testing testing testing', 0, 1, 1246947552, '117.199.80.126', 0, 5003);
    
    MySQL Error   : Duplicate entry '52456' for key 1
    Error Number  : 1062
    Request Date  : Tuesday, July 7th 2009 @ 02:19:12 AM
    Error Date    : Tuesday, July 7th 2009 @ 02:19:12 AM
    Script        : http://www.nannu.info/forum/newthread.php?do=postthread&f=40
    Referrer      : http://www.nannu.info/forum/newthread.php?do=newthread&f=40
    IP Address    : 117.199.80.126
    Username      : Gursimran
    Classname     : vB_Database
    MySQL Version : 5.0.62
    Can somebody explain what is is wrong

  • #2
    I'm getting the same exact database error. Waiting on a response from the support team.

    Comment


    • #3
      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.


      Comment

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