Converting from YaBB 2.2

[ThorstenE]

It was meant to be a delete

did you use the updated version from me? then you have to change the code as above explained. my version uses an UPDATE but SleePy meant a DELETE..

change

Code Select Expand

while ($row = mysql_fetch_assoc($result))
convert_query("
UPDATE {$to_prefix}log_topics
SET ID_TOPIC = $row[ID_TOPIC]");
mysql_free_result($result);

to

Code Select Expand

while ($row = mysql_fetch_assoc($result))
convert_query("
DELETE FROM {$to_prefix}log_topics
WHERE ID_TOPIC = $row[ID_TOPIC]");
mysql_free_result($result);


maybe, this is the reason for the stop?

[Gilrod]

Sleepy - FYI I used the version of the script in the stickied topic...

Converting topics (part 2)... Unsuccessful!
This query:

    DELETE `tnmsv3`.smf_log_topics
    WHERE ID_TOPIC = 1;

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 'WHERE ID_TOPIC = 1' at line 2

[SleePy]

Oops

Find:

Code Select Expand

   while ($row = mysql_fetch_assoc($result))
    convert_query("
     DELETE {$to_prefix}log_topics
     WHERE ID_TOPIC = $row[ID_TOPIC]");

Replace:

Code Select Expand


   while ($row = mysql_fetch_assoc($result))
    convert_query("
     DELETE FROM {$to_prefix}log_topics
     WHERE ID_TOPIC = $row[ID_TOPIC]");


Sorry for all the bugs. Its hard trying to guess the changes when they work fine for a small sized board (ie my test board). Its the bigger boards is where this correct testing goes into play.
I need to find time to write a flood script for Yabb to post thousands of posts so I can get a large sized board.

[Gilrod]

Interestingly, I've let it continue from the error mentioned previously...

However I've got the following url during "Posts (Part 2)"

http://tnmsv3.xxxxxxxxxxx.com/convert.php?step=1&substep=0&cstep=11&start=0

Should the substep be changing as with the other steps?

[SleePy]

Yes it should..

That stupid section has me in a fun loop here to try and figure it out..

Do you have a test board or something I can try this out on Gilrod?
I think that is going to be my best option to try and debug this out.. Its a troublesome section right there that is not wanting to work right.
On my small home tests it goes through that just fine though :|

[Gilrod]

Well the data I rar'd up for Jay is still available for download, but it's 100MB ;-)

[Gilrod]

hmmm getting this now ...

Converting...
Converting topics (part 1)... Successful.
Converting topics (part 2)... Unsuccessful!
This query:

    DELETE `tnmsv3`.smf_log_topics
    SET ID_TOPIC = 1
    WHERE tempID = 1025876070;

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 'SET ID_TOPIC = 1
    WHERE tempID = 1025876070' at line 2

[ThorstenE]

Gilrod, please attach your version of yabb22_to_smf.sql

[SleePy]

Do you mind if I get a link to that?
I won't be able to look at it until friday as I am backing up my data today on my laptop for the service I am taking it in for tomorrow.

[Gilrod]

Any luck Sleepy?

[SleePy]

I am sorry Gilrod,
time ran short suddenly and Oscon is in the works right now for me.

I am going to try and run some tests to see what I can't get fixed up today..

Though during my first test that only had a few messages the loop problem didn't occur. So I don't know if its just an issue with the amount of messages there are.

[Gilrod]

I take it you've not had any time Sleepy?

[ThorstenE]

from another post:

Currently I am in the middle of oscon (I am typing from the show room floor right now), so I don't got time at the moment to program something up that might work.

he is back soon i think

[Gilrod]

I have no idea what oscon is?!??

[SleePy]

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

[SleePy]

Gilrod,

Just so you dont think I forgot.

I found a bug bug in part two of the topics conversion which may have been part of these issues. It was trying to drop the tempid columns to early or never get to them.
I changed some code and it made it through.
Its currently working on posts.. Will let you know once it finishes (hope it finishes tonight otherwise I start over tomorrow).


Edit, also just found one in the second part of post conversion. Which is where I think we where currently having issues.

[Gilrod]

Cool :-)

Let me know how you get/got on.

I'll be on MSN if you sign in

[SleePy]

Do you want to try it again?

So far I have got it through topic and most of post. But there doesn't seem to be any errors occurring that I can see of so far. Its been running since a little after noon. Its just taking a while (Note for me its almost 7 pm).

[Gilrod]

Will give it a go...

[SleePy]

* SleePy crosses his fingers for good luck.