Advertisement:

Author Topic: Converting from YaBB 2.2  (Read 152355 times)

Offline Gilrod

  • Semi-Newbie
  • *
  • Posts: 81
Re: Converting from YaBB 2.2
« Reply #140 on: August 02, 2008, 05:12:03 PM »
D'oh!!

Code: [Select]
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'

Offline SleePy

  • Let there be light!
  • Site Team Lead
  • SMF Master
  • *
  • Posts: 30,639
  • Gender: Male
  • Thats his happy face.
    • jdarwood007 on GitHub
    • @jdarwood on Twitter
    • SleePy Code - My personal site
Re: Converting from YaBB 2.2
« Reply #141 on: August 05, 2008, 04:34:30 PM »
* 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
Support the SMF Support team!
Profiles:
GitHub

Offline Gilrod

  • Semi-Newbie
  • *
  • Posts: 81
Re: Converting from YaBB 2.2
« Reply #142 on: August 06, 2008, 09:40:30 AM »
No worries man, I just want away from YABB ASAFP, and this is the best way to go :-)

So purely Selfish reasons ;-)

Offline Gilrod

  • Semi-Newbie
  • *
  • Posts: 81
Re: Converting from YaBB 2.2
« Reply #143 on: August 11, 2008, 04:27:41 PM »
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"

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

Offline SleePy

  • Let there be light!
  • Site Team Lead
  • SMF Master
  • *
  • Posts: 30,639
  • Gender: Male
  • Thats his happy face.
    • jdarwood007 on GitHub
    • @jdarwood on Twitter
    • SleePy Code - My personal site
Re: Converting from YaBB 2.2
« Reply #144 on: August 11, 2008, 07:33:20 PM »
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
Support the SMF Support team!
Profiles:
GitHub

Offline Gilrod

  • Semi-Newbie
  • *
  • Posts: 81
Re: Converting from YaBB 2.2
« Reply #145 on: August 11, 2008, 08:11:01 PM »
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.

Offline SleePy

  • Let there be light!
  • Site Team Lead
  • SMF Master
  • *
  • Posts: 30,639
  • Gender: Male
  • Thats his happy face.
    • jdarwood007 on GitHub
    • @jdarwood on Twitter
    • SleePy Code - My personal site
Re: Converting from YaBB 2.2
« Reply #146 on: August 11, 2008, 10:47:11 PM »
Is the server reporting any usage? Such as php, mysql and others taking up processes?
Jeremy D — Site Team / SMF Developer
Support the SMF Support team!
Profiles:
GitHub

Offline Gilrod

  • Semi-Newbie
  • *
  • Posts: 81
Re: Converting from YaBB 2.2
« Reply #147 on: August 12, 2008, 02:40:32 AM »
Checked again...

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

Offline SleePy

  • Let there be light!
  • Site Team Lead
  • SMF Master
  • *
  • Posts: 30,639
  • Gender: Male
  • Thats his happy face.
    • jdarwood007 on GitHub
    • @jdarwood on Twitter
    • SleePy Code - My personal site
Re: Converting from YaBB 2.2
« Reply #148 on: August 12, 2008, 01:16:31 PM »
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
Support the SMF Support team!
Profiles:
GitHub

Offline Gilrod

  • Semi-Newbie
  • *
  • Posts: 81
Re: Converting from YaBB 2.2
« Reply #149 on: August 13, 2008, 04:24:24 PM »
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.

Offline Gilrod

  • Semi-Newbie
  • *
  • Posts: 81
Re: Converting from YaBB 2.2
« Reply #150 on: August 17, 2008, 03:19:26 PM »
Sleepy, where did we get to?!

Offline SleePy

  • Let there be light!
  • Site Team Lead
  • SMF Master
  • *
  • Posts: 30,639
  • Gender: Male
  • Thats his happy face.
    • jdarwood007 on GitHub
    • @jdarwood on Twitter
    • SleePy Code - My personal site
Re: Converting from YaBB 2.2
« Reply #151 on: August 18, 2008, 12:31:12 AM »
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
Support the SMF Support team!
Profiles:
GitHub

Offline Gilrod

  • Semi-Newbie
  • *
  • Posts: 81
Re: Converting from YaBB 2.2
« Reply #152 on: August 18, 2008, 03:41:59 PM »
yeah that was it... Give me a shout on MSN next time you are on.

Offline NemesisNG

  • Newbie
  • *
  • Posts: 3
Re: Converting from YaBB 2.2
« Reply #153 on: August 25, 2008, 12:14:35 PM »
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

Offline NemesisNG

  • Newbie
  • *
  • Posts: 3
Re: Converting from YaBB 2.2
« Reply #154 on: September 14, 2008, 07:33:51 PM »
Hoped there would have been some progress on this...

 ???

Nick


Offline SleePy

  • Let there be light!
  • Site Team Lead
  • SMF Master
  • *
  • Posts: 30,639
  • Gender: Male
  • Thats his happy face.
    • jdarwood007 on GitHub
    • @jdarwood on Twitter
    • SleePy Code - My personal site
Re: Converting from YaBB 2.2
« Reply #155 on: September 15, 2008, 01:06:09 AM »
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
Support the SMF Support team!
Profiles:
GitHub

Offline NemesisNG

  • Newbie
  • *
  • Posts: 3
Re: Converting from YaBB 2.2
« Reply #156 on: September 16, 2008, 07:43:28 AM »
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

Offline SleePy

  • Let there be light!
  • Site Team Lead
  • SMF Master
  • *
  • Posts: 30,639
  • Gender: Male
  • Thats his happy face.
    • jdarwood007 on GitHub
    • @jdarwood on Twitter
    • SleePy Code - My personal site
Re: Converting from YaBB 2.2
« Reply #157 on: September 16, 2008, 05:01:38 PM »
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
Support the SMF Support team!
Profiles:
GitHub

Offline dontshoot

  • Newbie
  • *
  • Posts: 4
Re: Converting from YaBB 2.2
« Reply #158 on: September 16, 2008, 05:44:14 PM »
Could i get a copy. i finally got mysql for my forums and would like to move on from yabb.

Offline SleePy

  • Let there be light!
  • Site Team Lead
  • SMF Master
  • *
  • Posts: 30,639
  • Gender: Male
  • Thats his happy face.
    • jdarwood007 on GitHub
    • @jdarwood on Twitter
    • SleePy Code - My personal site
Re: Converting from YaBB 2.2
« Reply #159 on: September 16, 2008, 06:24:53 PM »
sent you a pm.
Jeremy D — Site Team / SMF Developer
Support the SMF Support team!
Profiles:
GitHub