Advertisement:

Author Topic: Trying to convert from YaBB 1.3.1 Gold to latest SMF  (Read 16660 times)

Offline doulos12

  • Newbie
  • *
  • Posts: 9
Trying to convert from YaBB 1.3.1 Gold to latest SMF
« on: April 30, 2008, 04:55:24 PM »
Installed. No prob.
Ran converter: couldn't convert membergroups.
Found http://www.simplemachines.org/community/index.php?topic=134431.msg870746#msg870746

membergroups successful, but:

Converting members... Unsuccessful!
This query:
ALTER TABLE `crossfe_oafc`.smf_members
ORDER BY ID_MEMBER = 0, dateRegistered;
Caused the error:
You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near '= 0, dateRegistered' at line 2



Offline doulos12

  • Newbie
  • *
  • Posts: 9
Re: Trying to convert from YaBB 1.3.1 Gold to latest SMF
« Reply #1 on: April 30, 2008, 05:23:48 PM »
I tried starting over and got this:

Converting membergroups... Successful.
Converting members... Unsuccessful!
This query:
ALTER TABLE `crossfe_oafc`.smf_members
DROP PRIMARY KEY,
CHANGE COLUMN ID_MEMBER ID_MEMBER mediumint(8) unsigned NOT NULL default 0;
Caused the error:
Can't DROP 'PRIMARY'; check that column/key exists


Offline SleePy

  • Site Team Lead
  • SMF Master
  • *
  • Posts: 30,341
  • Gender: Male
  • Thats his happy face.
    • jdarwood007 on GitHub
    • @jdarwood on Twitter
    • SleePy Code - My personal site
Re: Trying to convert from YaBB 1.3.1 Gold to latest SMF
« Reply #2 on: April 30, 2008, 09:56:08 PM »
I would recommend first upgrading to Yabb 2.1 before performing the conversion. The converters was targeted for Yabb 2.1
I edited the problem though out of the file. Since the conversion failed you will have to install SMF again.
Sadly for the converter to do its work, it needs to edit the tables in the SMF database to perform the conversion, since it failed it didn't make it to the step where it fixes them :(

Jeremy D — Site Team / SMF Developer
Support the SMF Support team!
Profiles:
GitHub

Offline doulos12

  • Newbie
  • *
  • Posts: 9
Re: Trying to convert from YaBB 1.3.1 Gold to latest SMF
« Reply #3 on: May 01, 2008, 09:51:38 AM »
Better:

Converting membergroups... Successful.
Converting members... Successful.
Converting settings... Successful.
Converting personal messages... Unsuccessful!
This query:
ALTER TABLE `crossfe_oafc`.smf_personal_messages
ORDER BY ID_PM = 0, msgtime;
Caused the error:
You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near '= 0, msgtime' at line 2

(And I can't upgrade YaBB, since I moved to a new server, and YaBB isn't working now--seemed like a good time to switch to SMF.)
If I have to reinstall again, does that mean delete the database as well as re-upload the php, or just delete & recreate the database? Sorry for the n00b question.

Offline SleePy

  • Site Team Lead
  • SMF Master
  • *
  • Posts: 30,341
  • Gender: Male
  • Thats his happy face.
    • jdarwood007 on GitHub
    • @jdarwood on Twitter
    • SleePy Code - My personal site
Re: Trying to convert from YaBB 1.3.1 Gold to latest SMF
« Reply #4 on: May 01, 2008, 11:49:25 AM »
Ok give this one a try. I found 3 others that had this weird code in it.
Jeremy D — Site Team / SMF Developer
Support the SMF Support team!
Profiles:
GitHub

Offline doulos12

  • Newbie
  • *
  • Posts: 9
Re: Trying to convert from YaBB 1.3.1 Gold to latest SMF
« Reply #5 on: May 01, 2008, 03:27:12 PM »
It gets a little farther each time:

Converting personal messages... Successful.
Converting boards and categories... Successful.
Converting mark read data... Unsuccessful!
This query:
INSERT INTO `crossfe_oafc`.smf_log_boards
(ID_MEMBER, ID_BOARD)
VALUES ('91', '2'),
('91', '6'),
('', '2'),
('76', '2'),
('76', '6'),
('76', '3'),
('', '2'),
('', '1'),
('', '2'),
('', '2'),
('', '2'),
('', '2'),
('', '2'),
('', '2'),
('', '6'),
('', '2'),
('', '3'),
('', '5'),
('', '1'),
('', '4');
Caused the error:
Duplicate entry '0-2' for key 1


Offline SleePy

  • Site Team Lead
  • SMF Master
  • *
  • Posts: 30,341
  • Gender: Male
  • Thats his happy face.
    • jdarwood007 on GitHub
    • @jdarwood on Twitter
    • SleePy Code - My personal site
Re: Trying to convert from YaBB 1.3.1 Gold to latest SMF
« Reply #6 on: May 01, 2008, 11:04:10 PM »
Hopefully this one makes it :)
I added it to ignore the errors from those
Jeremy D — Site Team / SMF Developer
Support the SMF Support team!
Profiles:
GitHub

Offline doulos12

  • Newbie
  • *
  • Posts: 9
Re: Trying to convert from YaBB 1.3.1 Gold to latest SMF
« Reply #7 on: May 05, 2008, 10:14:07 AM »
Looking pretty good now, but one more, looks like:

Recalculating forum statistics... Unsuccessful!
This query:
ALTER TABLE `crossfe_oafc`.smf_smileys
ORDER BY LENGTH(code) DESC;
Caused the error:
You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near 'LENGTH(code) DESC' at line 2


Forum stats aren't all that important to me, so is that the last thing?

And BTW, I really appreciate your help here.

Offline SleePy

  • Site Team Lead
  • SMF Master
  • *
  • Posts: 30,341
  • Gender: Male
  • Thats his happy face.
    • jdarwood007 on GitHub
    • @jdarwood on Twitter
    • SleePy Code - My personal site
Re: Trying to convert from YaBB 1.3.1 Gold to latest SMF
« Reply #8 on: May 05, 2008, 11:45:36 AM »
Common conversion errors.

I am hoping with the SMF 2.0 converter I am working on shouldn't have this error, but for now its a simple edit of the file :)
Jeremy D — Site Team / SMF Developer
Support the SMF Support team!
Profiles:
GitHub

Offline karel.mokry

  • Newbie
  • *
  • Posts: 1
Re: Trying to convert from YaBB 1.3.1 Gold to latest SMF
« Reply #9 on: July 30, 2008, 10:58:24 AM »
Hi, I have similar problem (need to upgrade from 1.3). I used latest converter from this thread and received following error:

Converting personal messages... Unsuccessful!
This query:

    INSERT INTO `smf`.smf_pm_recipients
    (ID_PM, ID_MEMBER, labels)
    SELECT pm.ID_PM, mem.ID_MEMBER, '-1' AS labels
    FROM (`smf`.smf_personal_messages AS pm, `smf`.smf_members AS mem)
    WHERE mem.memberName = pm.temp_toName
    AND pm.temp_toName != '';

Caused the error:

    Duplicate entry '0-46' for key 1

Any idea what to modify? Thanks for your support.

ThorstenE

  • Guest
Re: Trying to convert from YaBB 1.3.1 Gold to latest SMF
« Reply #10 on: July 30, 2008, 01:37:00 PM »
slow server performance is sometimes a reason for duplicate entry.. try conversion again from the beginning.. if you receive the same error there must be a duplicate in the pm_recipients..

then edit the yabb_to_smf.php

search for
Code: [Select]
INSERT INTO {$to_prefix}pm_recipientsreplace with
Code: [Select]
INSERT IGNORE INTO {$to_prefix}pm_recipientsand restart conversion.

Hope it works ..