SMF Support > Install and Upgrade Help

Upgrade problems

(1/2) > >>

Sudesh:
Hello,

Our forum on Teamnse.Com was running on YabbSE 1.4.1 for a while and I just upgraded to 1.5.5 and now was trying to upgrade to Simple Machines. During the upgrade process, however, I recieve an error.  It reads:

Converting attachments, topics, and messages... Unsuccessful!
This query:
ALTER TABLE teamnse_topics
DROP PRIMARY KEY,
CHANGE COLUMN ID_TOPIC ID_TOPIC mediumint(8) unsigned NOT NULL auto_increment PRIMARY KEY,
CHANGE COLUMN ID_BOARD ID_BOARD smallint(5) unsigned NOT NULL default '0';
Caused the error:

Duplicate entry '16777215' for key 1


Any help you guys can offer will be greatly appreciated.

Oldiesmann:
Something probably got screwed up when you tried to convert from 1.41 to 1.55, because that's an awfully high topic ID, and you should never have two topics with the same ID number. Not sure what to tell you.

Sudesh:
I dunno whats wrong at all, the topic id's just jump into the millions for no reasons, i only have like 4,500 topics each of them have a unique number, but they suddenly take leaps and bounds into the millions. the 1.5.5 works great though, no problems at all.

 :'(

Oldiesmann:
Well, it's pretty tricky to re-number all the posts, so just edit upgrade.php and change that
--- Code: ---mediumint(8)
--- End code ---
thing to
--- Code: ---bigint(8)
--- End code ---
and that should fix it for now.

Sudesh:
are there any side effects of changing to bigint(8)?

Navigation

[0] Message Index

[#] Next page