Converting from YaBB 2.2

Started by unpossible, January 03, 2008, 11:15:44 PM

Previous topic - Next topic

Gilrod

D'oh!!

Converting polls and poll choices (part 2)... Successful.
Converting poll votes... Unsuccessful!
This query:

    INSERT IGNORE INTO `tnmsv3`.smf_log_polls
    (ID_POLL, ID_MEMBER, ID_CHOICE, tempID)
    VALUES ('0', '1605', '0', '0'),
    ('0', '1464', '0', '0'),
    ('0', '1538', '0', '0'),
    ('0', '1589', '0', '0'),
    ('0', '996', '0', '0'),
    ('0', '0', '0', '0'),
    ('0', '301', '0', '0'),
    ('0', '787', '0', '0'),
    ('0', '0', '0', '0'),
    ('0', '1714', '0', '0'),
    ('0', '1087', '0', '0'),
    ('0', '686', '0', '0'),
    ('0', '1042', '0', '0'),
    ('0', '1109', '0', '0'),
    ('0', '1042', '0', '0'),
    ('0', '0', '0', '0'),
    ('0', '1109', '0', '0'),
    ('0', '533', '0', '0'),
    ('0', '301', '0', '0'),
    ('0', '988', '0', '0'),
    ('0', '1464', '0', '0'),
    ('0', '0', '0', '0'),
    ('0', '1632', '0', '0'),
    ('0', '1714', '0', '0'),
    ('0', '1802', '2', '0'),
    ('0', '1464', '0', '0'),
    ('0', '787', '0', '0'),
    ('0', '1589', '0', '0'),
    ('0', '1042', '0', '0'),
    ('0', '0', '0', '0'),
    ('0', '1109', '0', '0'),
    ('0', '1405', '0', '0'),
    ('0', '698', '0', '0'),
    ('0', '533', '0', '0'),
    ('0', '0', '0', '0'),
    ('0', '0', '1', '0'),
    ('0', '58', '1', '0'),
    ('0', '1048', '2', '0'),
    ('0', '1280', '2', '0'),
    ('0', '544', '0', '0'),
    ('0', '143', '0', '0'),
    ('0', '265', '1', '0'),
    ('0', '0', '3', '0'),
    ('0', '1072', '0', '0'),
    ('0', '1173', '5', '0'),
    ('0', '1176', '1', '0'),
    ('0', '1908', '1', '0'),
    ('0', '1351', '0', '0'),
    ('0', '1746', '0', '0'),
    ('0', '727', '1', '0'),
    ('0', '154', '4', '0'),
    ('0', '0', '0', '0'),
    ('0', '1782', '0', '0'),
    ('0', '160', '0', '0'),
    ('0', '1377', '2', '0'),
    ('0', '1270', '0', '0'),
    ('0', '1170', '0', '0'),
    ('0', '1171', '2', '0'),
    ('0', '0', '1', '0'),
    ('0', '0', '1', '0'),
    ('0', '1441', '2', '0'),
    ('0', '1779', '5', '0'),
    ('0', '447', '2', '0'),
    ('0', '0', '3', '0'),
    ('0', '1851', '1', '0'),
    ('0', '1650', '1', '0'),
    ('0', '0', '2', '0'),
    ('0', '509', '0', '0'),
    ('0', '1094', '4', '0'),
    ('0', '110', '2', '0'),
    ('0', '1753', '2', '0'),
    ('0', '850', '1', '0'),
    ('0', '1073', '1', '0'),
    ('0', '436', '0', '0'),
    ('0', '0', '0', '0'),
    ('0', '1042', '0', '0'),
    ('0', '116', '0', '0'),
    ('0', '301', '0', '0'),
    ('0', '1392', '0', '0'),
    ('0', '787', '0', '0'),
    ('0', '988', '0', '0'),
    ('0', '0', '0', '0'),
    ('0', '1834', '0', '0'),
    ('0', '1087', '0', '0'),
    ('0', '1464', '0', '0'),
    ('0', '1538', '0', '0'),
    ('0', '1195', '0', '0');

Caused the error:

    Unknown column 'tempID' in 'field list'

SleePy

* SleePy swears he replied to this topic..

Well, Go to the log_polls table and manually create that column. It can be anything that will hold a big value (an int of 10 or a varchar of 255 would do fine).

By the way, thanks for working and helping fix up these converters :)
Jeremy D ~ Site Team / SMF Developer ~ GitHub Profile ~ Join us on IRC @ Libera.chat/#smf ~ Support the SMF Support team!

Gilrod

No worries man, I just want away from YABB ASAFP, and this is the best way to go :-)

So purely Selfish reasons ;-)

Gilrod

Right seems there is a problem ...

http://***.com/convert.php?step=1&substep=56500&cstep=18&start=0

It stops there, however it does error out the browser simply reports "done"

QuoteConverting...
Converting poll votes... Successful.
Recalculating forum statistics...

Am thinking of giving you direct FTP access to my server so you can test on it directly, what do you think?

Stew

SleePy

Give it a little time, this is the finishing part. It should be refreshing soon.
If I remember right this is the part I hate to wait the longest on. Its because I couldn't tweak any part of that conversion since its built into the convert.php :| (Though I wonder if I can supply it settings).
Jeremy D ~ Site Team / SMF Developer ~ GitHub Profile ~ Join us on IRC @ Libera.chat/#smf ~ Support the SMF Support team!

Gilrod

hmmm just looked again and it has not moved on in the slightest... :-/

will leave it running overnight but I do think it's died.

SleePy

Is the server reporting any usage? Such as php, mysql and others taking up processes?
Jeremy D ~ Site Team / SMF Developer ~ GitHub Profile ~ Join us on IRC @ Libera.chat/#smf ~ Support the SMF Support team!

Gilrod

Checked again...

Definitely dead, oh and no resource usage... Typically.

SleePy

Well that stinks. It is the very last step :(

Does the forum work ok though? You might just need to run a few commands from the Admin panel in SMF to do most of the work it would of done.
Jeremy D ~ Site Team / SMF Developer ~ GitHub Profile ~ Join us on IRC @ Libera.chat/#smf ~ Support the SMF Support team!

Gilrod

Hmmmm

I think I might be looking at a total reinstall...

I've just entered the URL and for some inane reason my apache server is taking over 900MB of ram, scratch that 1.3GB of ram, then it drops to normal sizes and the browser reports "Done" nothing else...

:-/

Looking at the DB via Mysql5 admin it reports to being ok....

Am totally confused now.

Gilrod

Sleepy, where did we get to?!

SleePy

I believe you contacted me on msn and we worked into getting into the admin panel and where running the find and repair errors tools?

Jeremy D ~ Site Team / SMF Developer ~ GitHub Profile ~ Join us on IRC @ Libera.chat/#smf ~ Support the SMF Support team!

Gilrod

yeah that was it... Give me a shout on MSN next time you are on.

NemesisNG

Have used this convertor today for the first time.

I have used the file from the sticky topic, with the slight modification in this topic a few posts above to get it working.

Everything has gone through as planned, but I've lost the registered date for all members and I've lost the time stamp for all PM's.

Apart from that it's sweet!

Many, many thanks!

Nick

NemesisNG

Hoped there would have been some progress on this...

???

Nick


SleePy

I have rewrote the yabb 2.2 converter. So far both me and Gilrod have had successful results from the sounds of it (I went offline when he made the change for a minor bug and was running the converter again). We are both using the same yabb 2.2 data though so it doesn't help to much :P

If you want to try it, I will send you the file. I would highly recommend reinstalling SMF before you try this new converter as it operates in a new manner that the old converter did not, so this way it just will clean up anything that the old converter might of broke up.

I think I also got the pms outbox thing sorted. If I didn't I kept a second unused converter step that will dedicate to doing this properly :D
Jeremy D ~ Site Team / SMF Developer ~ GitHub Profile ~ Join us on IRC @ Libera.chat/#smf ~ Support the SMF Support team!

NemesisNG

Would be quite happy to test this new version out and report back.

I've got a full yabb backup I'm converting from so can do a fresh smf at the same time on the sandbox site.

Nick

SleePy

Sent a pm.

If all goes good for you as well, then I think I will post up the beta file for public testing :)
Jeremy D ~ Site Team / SMF Developer ~ GitHub Profile ~ Join us on IRC @ Libera.chat/#smf ~ Support the SMF Support team!

dontshoot

Could i get a copy. i finally got mysql for my forums and would like to move on from yabb.

SleePy

Jeremy D ~ Site Team / SMF Developer ~ GitHub Profile ~ Join us on IRC @ Libera.chat/#smf ~ Support the SMF Support team!

Advertisement: