Simple Machines Community Forum

SMF Support => Converting to SMF => YaBB/YaBB SE => Topic started by: djaizen on December 11, 2007, 11:53:32 PM

Title: YaBB 1 Gold to SMF (Multiple primary keys error)
Post by: djaizen on December 11, 2007, 11:53:32 PM
I tried Boris's modified converter file on a small test forum and managed to get the conversion done successfully (The original one from SMF's download page doesn't work). However, running the converter on my actual forum results in a "Multiple primary keys" error.

This is the error message I get:

Converting posts (part 2)... Unsuccessful!
This query:
ALTER TABLE `jez_forum`.jez_messages
CHANGE COLUMN ID_MSG ID_MSG int(10) unsigned NOT NULL auto_increment PRIMARY KEY;
Caused the error:

Multiple primary key defined

What is the cause of this problem? Duplicate fields?
Please help!
Thanks in advance!:)


Title: Re: YaBB 1 Gold to SMF (Multiple primary keys error)
Post by: JayBachatero on December 11, 2007, 11:54:42 PM
My suggestion is that you upgrade to 2.1 and convert from there.