Announcement

Collapse
No announcement yet.

Database error

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

  • Steve Machol
    replied
    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

    Leave a comment:


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

    Leave a comment:


  • Gursimran
    started a topic Database error

    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
widgetinstance 262 (Related Topics) skipped due to lack of content & hide_module_if_empty option.
Working...
X