duplicate threadid

Collapse
X
 
  • Time
  • Show
Clear All
new posts
  • Joe M.
    New Member
    • Apr 2004
    • 22

    duplicate threadid

    Doing install of 3.5.1 from 3.0.7 During Step 6 of Beta 1 upgrade get an error:

    Database error in vBulletin 3.0.10:

    Invalid SQL:
    ALTER TABLE thread CHANGE postusername postusername VARCHAR (100) NOT NULL DEFAULT '';

    MySQL Error : Duplicate entry '98825' for key 1
    Error Number : 1062
    Script : http://www.antsmarching.org/forum/in...0b1.php?step=6
    Referrer : http://www.antsmarching.org/forum/in...0b1.php?step=5

    I do infact somehow have two threadid's that are the same. What is the best action to take here? Delete one of the entires? Delelte both and all corresponding references to the threadid? Table repair?
  • Joe M.
    New Member
    • Apr 2004
    • 22

    #2
    2 hours later.....

    I went ahead and deleted the 2 thread rows. Couldn't find any other occurances of the threadid in the database. Hopefully that works out. I couldn't hold off the installation for many more hours.

    Comment

    widgetinstance 262 (Related Topics) skipped due to lack of content & hide_module_if_empty option.
    Working...
    😀
    😂
    🥰
    😘
    🤢
    😎
    😞
    😡
    👍
    👎