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?
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?
Comment