Advertisement:

Author Topic: Yabb2 to smf  (Read 15352 times)

Offline bowler1965

  • Newbie
  • *
  • Posts: 2
Yabb2 to smf
« on: April 26, 2006, 04:45:47 PM »
SMF Version: SMF 1.1 RC2
I have a error by convert the forum.

Code: [Select]
Converting settings... Successful.
Converting personal messages... Successful.
Converting boards and categories... Unsuccessful!
This query:

    ALTER TABLE `DB169034`.smf_boards
    ADD tempID tinytext,
    ADD tempCatID tinytext;

Caused the error:

    Duplicate column name 'tempID'


can you me help?

Offline JayBachatero

  • SMF Friend
  • SMF Super Hero
  • *
  • Posts: 19,562
  • Gender: Male
    • @jaycreations on Twitter
    • JayBachatero.com
Re: Yabb2 to smf
« Reply #1 on: April 26, 2006, 08:58:58 PM »
Which convert.php file are you using?  Try the one here.
http://www.simplemachines.org/community/index.php?topic=65677.0
Follow me on Twitter

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

Offline bowler1965

  • Newbie
  • *
  • Posts: 2
Re: Yabb2 to smf
« Reply #2 on: April 29, 2006, 07:51:48 AM »
I now use the converter from this post http://www.simplemachines.org/community/index.php?topic=65677.0.

I have many errors during the conversion of the members and the boards and categories.
Here an example:

Code: [Select]

Notice: Undefined index: webtitle in /mnt/am1/06/957/00000017/htdocs/joomla/forum/yabb2_to_smf.php on line 264

Notice: Undefined index: weburl in /mnt/am1/06/957/00000017/htdocs/joomla/forum/yabb2_to_smf.php on line 265

Notice: Undefined index: signature in /mnt/am1/06/957/00000017/htdocs/joomla/forum/yabb2_to_smf.php on line 266

Notice: Undefined index: position in /mnt/am1/06/957/00000017/htdocs/joomla/forum/yabb2_to_smf.php on line 268

Notice: Undefined index: icq in /mnt/am1/06/957/00000017/htdocs/joomla/forum/yabb2_to_smf.php on line 269

Notice: Undefined index: aim in /mnt/am1/06/957/00000017/htdocs/joomla/forum/yabb2_to_smf.php on line 270

Notice: Undefined index: yim in /mnt/am1/06/957/00000017/htdocs/joomla/forum/yabb2_to_smf.php on line 271

Notice: Undefined index: msn in /mnt/am1/06/957/00000017/htdocs/joomla/forum/yabb2_to_smf.php on line 272

Notice: Undefined index: gender in /mnt/am1/06/957/00000017/htdocs/joomla/forum/yabb2_to_smf.php on line 273

Notice: Undefined index: gender in /mnt/am1/06/957/00000017/htdocs/joomla/forum/yabb2_to_smf.php on line 273

Notice: Undefined index: location in /mnt/am1/06/957/00000017/htdocs/joomla/forum/yabb2_to_smf.php on line 277

Notice: Undefined index: bday in /mnt/am1/06/957/00000017/htdocs/joomla/forum/yabb2_to_smf.php on line 278

Notice: Undefined index: bday in /mnt/am1/06/957/00000017/htdocs/joomla/forum/yabb2_to_smf.php on line 287
Successful.
Converting settings... Successful.
Converting personal messages... Successful.
Converting boards and categories...
Notice: Undefined index: HausAllg in /mnt/am1/06/957/00000017/htdocs/joomla/forum/yabb2_to_smf.php on line 620

Notice: Undefined index: Hausliga in /mnt/am1/06/957/00000017/htdocs/joomla/forum/yabb2_to_smf.php on line 624

Notice: Undefined index: VereinAusschr in /mnt/am1/06/957/00000017/htdocs/joomla/forum/yabb2_to_smf.php on line 620

Notice: Undefined index: Verein in /mnt/am1/06/957/00000017/htdocs/joomla/forum/yabb2_to_smf.php on line 624


The conversion ends then with:

Code: [Select]
Converting mark read data... Unsuccessful!
This query:

    INSERT INTO `DB169034`.smf2_log_mark_read
    (logTime, ID_MEMBER, ID_BOARD)
    VALUES ('1143656084', '1', '4'),
    ('1143656084', '1', '11'),
    ('1143656084', '1', '3'),
    ('1143656084', '1', '2'),
    ('1143656084', '1', '16'),
    ('1143656084', '1', '17'),
    ('1143656084', '1', '7'),
    ('1143656084', '1', '12'),
    ('1143656084', '1', '1'),
    ('1143656084', '1', '15'),
    ('1143656084', '1', '8'),
    ('1143656084', '1', '9'),
    ('1143656084', '1', '13'),
    ('1143656084', '1', '10'),
    ('1143656084', '1', '5'),
    ('1143656084', '1', '14');

Caused the error:

    Unknown column 'logTime' in 'field list'

Can you me help?

Sorry my bad English.

Heiko

The search does not function unfortunately. :-(
« Last Edit: April 29, 2006, 07:54:28 AM by bowler1965 »

Offline JayBachatero

  • SMF Friend
  • SMF Super Hero
  • *
  • Posts: 19,562
  • Gender: Male
    • @jaycreations on Twitter
    • JayBachatero.com
Re: Yabb2 to smf
« Reply #3 on: April 29, 2006, 03:58:23 PM »
Follow me on Twitter

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

Offline phpchris

  • Semi-Newbie
  • *
  • Posts: 30
Re: Yabb2 to smf
« Reply #4 on: July 04, 2006, 07:37:39 AM »
Hi, I am having problöems with the conversion:

Code: [Select]
INSERT INTO `smf`.smf_log_boards
(logTime, ID_MEMBER, ID_BOARD)
VALUES ('1143365234', '533', '8'),

[..........]

Caused the error:

    Unknown column 'logTime' in 'field list'

I have tried and did some alter tables but it didn't seem to work.
Anyone has any ideas?
I got it so far that it starts with step 2 but looks like it gets in a neverending loop!

Offline JayBachatero

  • SMF Friend
  • SMF Super Hero
  • *
  • Posts: 19,562
  • Gender: Male
    • @jaycreations on Twitter
    • JayBachatero.com
Re: Yabb2 to smf
« Reply #5 on: July 05, 2006, 12:26:37 AM »
In the convert file remove logTime from the log_boards query.
Follow me on Twitter

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

Offline phpchris

  • Semi-Newbie
  • *
  • Posts: 30
Re: Yabb2 to smf
« Reply #6 on: July 06, 2006, 12:14:24 AM »
In the convert file remove logTime from the log_boards query.

That's not working. I tried it and I still get almost each query resulting in an error, either "Duplicate column name" or other errors concerning queries.
How is the function called where they insert the data to the database?

Offline phpchris

  • Semi-Newbie
  • *
  • Posts: 30
Re: Yabb2 to smf
« Reply #7 on: July 09, 2006, 03:30:35 AM »
Nobody? Please I have to migrate a yabb2 within 2 weeks or they will close the forums and they are well visited. It seems to me as if when I comment out a query which causes an error, the next query causes an error...
Has anyone got a working version of this?

Offline 青山 素子

  • Server Team
  • SMF Super Hero
  • *
  • Posts: 17,029
  • 戦場ヶ原、蕩れ!
    • srvrguy on GitHub
    • @motokochan on Twitter
    • Nekomusume Moe
Re: Yabb2 to smf
« Reply #8 on: July 09, 2006, 04:15:10 AM »
If you send me a dump of the database I might be able to get a quick converter set up. I don't know the structure off-hand, so I can't promise anything for sure.
Motoko-chan
Director, Simple Machines

Just because it's pouring down doesn't mean we're gonna drown. There's a time when all you can say is let it rain - Mat Kearney (Let It Rain)

Note: Unless otherwise stated, my posts are not representative of any official position or opinion of Simple Machines.


Offline phpchris

  • Semi-Newbie
  • *
  • Posts: 30
Re: Yabb2 to smf
« Reply #9 on: July 09, 2006, 04:37:31 AM »
Thanks for your reply chap but yabb2 is not a database-based forum.
It is file based...

Offline 青山 素子

  • Server Team
  • SMF Super Hero
  • *
  • Posts: 17,029
  • 戦場ヶ原、蕩れ!
    • srvrguy on GitHub
    • @motokochan on Twitter
    • Nekomusume Moe
Re: Yabb2 to smf
« Reply #10 on: July 09, 2006, 04:48:09 AM »
File-based. Ick.

Well, one other option would be to use another board software as an intermediary step. Find a board that is well-supported by the converters here that can convert from YaBB2 and try using it as a middle step in conversion. A pain, but it might work.
Motoko-chan
Director, Simple Machines

Just because it's pouring down doesn't mean we're gonna drown. There's a time when all you can say is let it rain - Mat Kearney (Let It Rain)

Note: Unless otherwise stated, my posts are not representative of any official position or opinion of Simple Machines.


Offline phpchris

  • Semi-Newbie
  • *
  • Posts: 30
Re: Yabb2 to smf
« Reply #11 on: July 09, 2006, 04:58:11 AM »
Yes, I tried to do so with phpBB but it didn't work neither...

Offline phpchris

  • Semi-Newbie
  • *
  • Posts: 30
Re: Yabb2 to smf
« Reply #12 on: July 11, 2006, 02:36:58 AM »
Please chaps, does really nobody have a working version???

Offline JayBachatero

  • SMF Friend
  • SMF Super Hero
  • *
  • Posts: 19,562
  • Gender: Male
    • @jaycreations on Twitter
    • JayBachatero.com
Re: Yabb2 to smf
« Reply #13 on: July 11, 2006, 12:30:10 PM »
In the yabb2_to_smf.php file find
Code: [Select]
$row['logTime'] = $parts[1] != '' ? (int) $parts[1] : (int) trim($parts[2]);

Replace
Code: [Select]
//$row['logTime'] = $parts[1] != '' ? (int) $parts[1] : (int) trim($parts[2]);
  That will comment out that line and should work.
Follow me on Twitter

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

Offline phpchris

  • Semi-Newbie
  • *
  • Posts: 30
Re: Yabb2 to smf
« Reply #14 on: July 12, 2006, 02:27:21 AM »
Just trying it out, thank you so far!

Offline phpchris

  • Semi-Newbie
  • *
  • Posts: 30
Re: Yabb2 to smf
« Reply #15 on: July 12, 2006, 02:29:03 AM »
Ok, this got me much farer...
Most of the steps have been successfull but still the topics and stuff are not converted.
Here is the output:

Successful.
Converting settings... Successful.
Converting personal messages... Successful.
Converting boards and categories... Successful.
Converting mark read data... Successful.
Converting topics (part 1)... Successful.
Converting topics (part 2)... Successful.
Converting notifications... Successful.
Converting posts (part 1 - this may take some time)... Successful.
Converting posts (part 2)... Successful.
Converting posts (part 3)... Successful.
Converting attachments (if the mod is installed)... Successful.
Cleaning up (part 1)... Successful.
Cleaning up (part 2)... Successful.
Recalculating forum statistics... Unsuccessful!
This query:

    UPDATE `smf`.smf_boards
    SET ID_LAST_MSG = 4163, lastUpdated = 1151528794
    WHERE ID_BOARD = 1
    LIMIT 1;

Caused the error:

    Unknown column 'lastUpdated' in 'field list'



I will try and comment this query out...

Offline phpchris

  • Semi-Newbie
  • *
  • Posts: 30
Re: Yabb2 to smf
« Reply #16 on: July 12, 2006, 02:41:38 AM »
Thanks, I made it...

All there was needed was the comment:

Quote
In the yabb2_to_smf.php file find
Code:

$row['logTime'] = $parts[1] != '' ? (int) $parts[1] : (int) trim($parts[2]);


Replace
Code:

//$row['logTime'] = $parts[1] != '' ? (int) $parts[1] : (int) trim($parts[2]);

  That will comment out that line and should work.
.

Oh and I had to add a table field called "lastUpdated" (tinytext) to the smf_boards-table.
Then it worked like a charm, thanks again!

Offline phpchris

  • Semi-Newbie
  • *
  • Posts: 30
Re: Yabb2 to smf
« Reply #17 on: July 21, 2006, 08:55:34 AM »
Now I got another problem :D
There were greek chars in the forums, now there are only signs like therse here shown [ch692].
Any ideas?