Advertisement:

Author Topic: YaBB 1 Gold to SMF (Multiple primary keys error)  (Read 5363 times)

Offline djaizen

  • Newbie
  • *
  • Posts: 1
YaBB 1 Gold to SMF (Multiple primary keys error)
« 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!:)



Offline JayBachatero

  • SMF Friend
  • SMF Super Hero
  • *
  • Posts: 19,562
  • Gender: Male
    • @jaycreations on Twitter
    • JayBachatero.com
Re: YaBB 1 Gold to SMF (Multiple primary keys error)
« Reply #1 on: December 11, 2007, 11:54:42 PM »
My suggestion is that you upgrade to 2.1 and convert from there.
Follow me on Twitter

"HELP!!! I've fallen and I can't get up"
This moment has been brought to you by LifeAlert