new server but a error

Collapse
X
 
  • Time
  • Show
Clear All
new posts
  • Hollowmaster
    New Member
    • Aug 2004
    • 1

    new server but a error

    Hello,

    we have copied the whole site from the old server to the new server.
    i have imported the whole database and everything went wel.

    But:

    when i post an new message /topic/ thread i get an error
    Code:
    Database error in vBulletin 3.6.7:
    
    Invalid SQL:
    INSERT INTO post
        (showsignature, allowsmilie, username, userid, title, pagetext, iconid, visible, dateline, ipaddress, attach, threadid)
    VALUES
        (1, 1, 'Frank', 1, 'test', 'test hlwsklwj;clkwc', 0, 1, 1183114015, '87.208.33.126', 0, -1);
    
    MySQL Error  : Duplicate entry '0' for key 1
    Error Number : 1062
    Date         : Friday, June 29th 2007 @ 12:46:55 PM
    Script       : http://www.ayoplaza.nl/AYO/newthread.php?do=postthread&f=155
    Referrer     : http://www.ayoplaza.nl/AYO/newthread.php?do=newthread&f=155
    IP Address   : 87.208.33.126
    Username     : Frank
    Classname    : vb_database
    i cant find the problem can anyone help me ?
    tnx
  • Colin F
    Senior Member
    • May 2004
    • 17689

    #2
    Follow these instructions: http://www.vbulletin.com/docs/html/mysql_duplicatekey
    Best Regards
    Colin Frei

    Please don't contact me per PM.

    Comment

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