Advertisement:

Author Topic: Converting from YaBB 2.5 to SMF 1.1.14 result in errors...  (Read 17349 times)

Offline dnaeon

  • Newbie
  • *
  • Posts: 2
Converting from YaBB 2.5 to SMF 1.1.14 result in errors...
« on: February 24, 2013, 09:07:09 AM »
Hello,

We are in the process of converting our YaBB 2.5 forums to SMF and have been using the instructions found in this post:

* http://www.simplemachines.org/community/index.php?topic=457735.0

The converter that we've used is the one found from here:

* http://www.simplemachines.org/community/index.php?topic=344465.msg2778613#msg2778613

Please let me know if that is the correct one we should be using, as I was not able to find any reference to an official YaBB -> SMF converter.

After starting the conversion we have successfully converted all user account & PMs, but when the conversion of the posts started we hit an error and cannot proceed any further.

Code: [Select]
Converting topics (part 1)... Unsuccessful!
This query:
INSERT INTO `smf`.smf_topics
(ID_BOARD, isSticky, locked, numViews, ID_LAST_MSG, ID_FIRST_MSG)
VALUES ('1', '0', '1', '22', '1122197715', '1122197715');
Caused the error:
Duplicate entry '1122197715-1' for key 'lastMessage'

Could you please assist us in resolving this issue? Any hints to where/what should be fixed are much appreciated.

Thanks,

kat

  • Guest
Re: Converting from YaBB 2.5 to SMF 1.1.14 result in errors...
« Reply #1 on: February 24, 2013, 11:05:34 AM »
What about the one at the bottom of this list?

http://download.simplemachines.org/?converters;software=yabb

Offline dnaeon

  • Newbie
  • *
  • Posts: 2
Re: Converting from YaBB 2.5 to SMF 1.1.14 result in errors...
« Reply #2 on: February 25, 2013, 01:15:56 AM »
Hi,

Thanks for the feedback.

I have tried the Yabb to SMF 2-0 and also the Yabb 2 to SMF 2-0 converters, but they do not appear to work with YaBB 2.5.

I cannot find anything related to YaBB 2.5, or maybe I am overlooking.

Any help is appreciated. Thanks.


Online Westwegoman

  • Jr. Member
  • **
  • Posts: 189
  • Gender: Male
    • westwegoman on Facebook
    • Westwegoman on LinkedIn
    • Bayou State Fishing
Re: Converting from YaBB 2.5 to SMF 1.1.14 result in errors...
« Reply #3 on: February 26, 2013, 03:25:23 AM »
I followed the instructions at the following link:
www.simplemachines.org/community/index.php?topic=457735.0

I have converted a few 2.5AE boards with these instructions with no major problems. I can't remember exactly where I downloaded the converter but if you are still stuck, I can attach a copy when I get home in a few hours.

Good luck.

Offline Gaucho1962

  • Newbie
  • *
  • Posts: 3
Re: Converting from YaBB 2.5 to SMF 1.1.14 result in errors...
« Reply #4 on: June 24, 2013, 01:16:09 PM »
I am getting a similar error message, i.e.

(ID_BOARD, isSticky, locked, numViews, ID_LAST_MSG, ID_FIRST_MSG)
 VALUES ('2', '0', '0', '61', '1270203590', '1270203590');
 Caused the error:

Duplicate entry '1270203590-2' for key 'lastMessage'


And that is using the instructions in the afor mentioned post.

If I delete the message refered to, it just moves a little way and produces a similar error but with a different message ID.

Anyone any solutions for this?

Many thanks.

Offline emanuele

  • SMF Super Hero
  • *******
  • Posts: 14,156
  • Gender: Male
  • THERE'S JUST ME
Re: Converting from YaBB 2.5 to SMF 1.1.14 result in errors...
« Reply #5 on: June 27, 2013, 05:33:33 AM »
Just out of curiosity: did you do a maintenance (fix and repair all errors, etc.) before starting the upgrade? (If YABB has this tools of course, never used YABB so I don't know.)


Take a peek at what I'm doing! ;D



Hai bisogno di supporto in Italiano?

Aiutateci ad aiutarvi: spiegate bene il vostro problema: no, "non funziona" non รจ una spiegazione!!
1) Cosa fai,
2) cosa ti aspetti,
3) cosa ottieni.

Online Westwegoman

  • Jr. Member
  • **
  • Posts: 189
  • Gender: Male
    • westwegoman on Facebook
    • Westwegoman on LinkedIn
    • Bayou State Fishing
Re: Converting from YaBB 2.5 to SMF 1.1.14 result in errors...
« Reply #6 on: July 04, 2013, 03:03:44 AM »
Just thought I would chime back in.

YaBB does have maintenance tools which should be run before conversion is started. I ran those and then did my conversion and all went well using instructions from my above post. If I remember correctly, I removed mods that were installed on my YaBB forum before I started.

Wish you luck.