No announcement yet.

Help please?

  • Filter
  • Time
  • Show
Clear All
new posts

  • Help please?

    I recently upgraded from 3.8.9 vbulletin to 3.8.11
    on all new posts i'm getting this message appear.
    The post appears to post to the DB but i'm getting this over and over and over
    how can I fix this issue?

    Database error in vBulletin 3.8.11:

    Invalid SQL:

    INSERT INTO postlog
    (postid, useragent, ipaddress, dateline)
    (5334, 'Mozilla/5.0 (Windows NT 10.0; Win64; x64) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/66.0.3359.181 Safari/537.36', '', 1528929926);

    MySQL Error : Duplicate entry '5334' for key 'PRIMARY'
    Error Number : 1062
    Request Date : Wednesday, June 13th 2018 @ 06:45:26 PM
    Error Date : Wednesday, June 13th 2018 @ 06:45:26 PM

  • #2
    You have to make sure the autoincrement for postid on the post table is higher than 5334. This shouldn't have changed during a normal upgrade. Were there any errors while upgrading?
    Translations provided by Google.

    Wayne Luke
    The Rabid Badger - a vBulletin Cloud customization and demonstration site.
    vBulletin 5 Documentation - Updated every Friday. Report issues here.
    vBulletin 5 API - Full / Mobile
    I am not currently available for vB Messenger Chats.


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