Yabb2 to smf

Started by bowler1965, April 26, 2006, 04:45:47 PM

Previous topic - Next topic

bowler1965

SMF Version: SMF 1.1 RC2
I have a error by convert the forum.


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?

JayBachatero

Follow me on Twitter

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

bowler1965

#2
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:



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:


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. :-(

JayBachatero

Follow me on Twitter

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

phpchris

Hi, I am having problöems with the conversion:

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!

JayBachatero

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

phpchris

Quote from: Jay The Code Monkey on July 05, 2006, 12:26:37 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?

phpchris

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?

青山 素子

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

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


phpchris

Thanks for your reply chap but yabb2 is not a database-based forum.
It is file based...

青山 素子

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

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


phpchris

Yes, I tried to do so with phpBB but it didn't work neither...

phpchris

Please chaps, does really nobody have a working version???

JayBachatero

In the yabb2_to_smf.php file find

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


Replace

//$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

phpchris

Just trying it out, thank you so far!

phpchris

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...

phpchris

Thanks, I made it...

All there was needed was the comment:

QuoteIn 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!

phpchris

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?

Advertisement: