Announcement

Collapse
No announcement yet.

DB error on posting a thread/post

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

  • Steve Machol
    replied
    Glad to hear it.

    Leave a comment:


  • n.sinha.p
    replied
    Thanks!

    This one worked!

    Leave a comment:


  • Steve Machol
    replied
    It looks like you may have installed an add-on that messed up the indexes.

    Try this:

    Admin CP -> Maintenance -> Repair/Optimize Tables -> Fix Unique Indexes

    Leave a comment:


  • n.sinha.p
    started a topic DB error on posting a thread/post

    DB error on posting a thread/post

    Hi,

    We have upgraded to VB 3.8 today and since are facing problems while posting any new post or thread.

    Here is a sample error that comes:

    Code:
    Invalid SQL:
    INSERT INTO post
     (showsignature, allowsmilie, username, userid, title, pagetext, iconid, visible, dateline, ipaddress, attach, threadid)
    VALUES
     (1, 1, 'SomeUser', 23, 'testing post', 'tesing thread new posting', 6, 1, 1232385168, '122.162.81.57', 0, 10095);
    MySQL Error   : Duplicate entry '41898' for key 1
    Error Number  : 1062
    Request Date  : Monday, January 19th 2009 @ 12:12:48 PM
    Error Date    : Monday, January 19th 2009 @ 12:12:48 PM
    Script        : http://mysite.com/forums/newthread.p...hread&f=80
    Referrer      : http://mysite.com/forums/newthread.p...hread&f=80
    IP Address    : 122.162.81.57
    Username      : SomeUser
    Classname     : vB_Database
    MySQL Version : 5.0.67-community
    Please help!

Related Topics

Collapse

Working...
X