Advertisement:

Author Topic: YaBB 2.1 Converter stops working, but pretends to still be working  (Read 19438 times)

Offline pqx

  • Semi-Newbie
  • *
  • Posts: 12
**** Update ****

Please click here to download an updated converter that does not have this problem. (Same link as the file in post #11 below.)

There may still be one small problem: Polls may all seem to have the 'Maximum votes per user' set to 0. To fix this, use this SQL query in phpMyAdmin:



Code: [Select]
UPDATE smf_polls SET maxVotes = '1';

---------------------------------------------------------------------


Hi there,

I've been trying to convert my YaBB 2.1 forum into SMF 1.1.8 with the latest converters, but when it gets to the stage called:

"Converting polls and poll choices... Incomplete"

The database stops changing in size, and the converter runs forever, always showing the message above, refreshing after a while like it normally does.

Is there anything that can be done? I noticed this is one of the last stages, so maybe it won't be too hard to fix? I hope  :o

---------------------------------------------------------------------------------------------------------------

By the way, when I convert I also get three other errors, and they appear consistently on every attempt. But I have found ways to fix them. I'm just going to post the solutions here just as extra info:

"Duplicate entry '0-0' for key 1"

I fixed it by removing duplicate keys manually, adding incremental numbers starting from 1, in one of the key columns. (both columns have all-zeroes). The records involved are always around 15 or so.

UPDATE smf_log_topics set ID_TOPIC=1 where tempID=1181708943;
UPDATE smf_log_topics set ID_TOPIC=2 where tempID=1181706364;
etc...


"Unknown column 'temp_filename' in 'field list'" (#1)

Fixed by creating the missing column with alter table smf_messages ADD COLUMN temp_filename tinytext NOT NULL default ''


"Unknown column 'temp_filename' in 'field list'" (#2)

Error above will not go away with the previous solution, because it will re-delete the column and try to access it immediately, and it occurrs when converting attachments. Since I have never used the attachments feature, I simply blanked the variable uploaddir in Yabb's Paths.pl file. I don't know why it was even set, but it looked like a default value.


Any help will be EXTREMELY appreciated!! My host is ready to kick me out due to Yabb's high CPU usage...

« Last Edit: February 21, 2009, 08:56:42 PM by pqx »

ThorstenE

  • Guest
Re: YaBB 2.1 Converter stops working, but pretends to still be working
« Reply #1 on: February 13, 2009, 02:42:14 AM »
i'm not sure, but I think you are using the "old" style converter. Can you check this  post please:
http://www.simplemachines.org/community/index.php?topic=122338.msg1894646#msg1894646

Offline pqx

  • Semi-Newbie
  • *
  • Posts: 12
Re: YaBB 2.1 Converter stops working, but pretends to still be working
« Reply #2 on: February 16, 2009, 12:20:11 AM »
Thank you for pointing me to this converter. I tried with that one and here's what happened:

-None of the previous errors appeared, and it all appeared to run a whole lot faster. However, the conversion stopped at the following step:

"Converting polls and poll choices (part 2)... Incomplete."

And it was still pretending to be working, as it happened with the other converter. This time the substep number kept going higher and higher, (I stopped it at 2933000) but the size of the database had already stopped changing altogether when it got to the step above. The table smf_log_polls is empty, while smf_polls and smf_poll_choices contain thousands of records each.

The size of the database this time is significantly larger (164.4 MiB versus 133.0MiB). Though it did go one step further than the other converter.

What should I do now?
« Last Edit: February 16, 2009, 12:23:16 AM by pqx »

ThorstenE

  • Guest
Re: YaBB 2.1 Converter stops working, but pretends to still be working
« Reply #3 on: February 16, 2009, 02:08:13 AM »
have you re-installed SMF before using the "new" converter? the old converter drops some indexes from the database tables and this may be the problem during the polls conversion.

Offline pqx

  • Semi-Newbie
  • *
  • Posts: 12
Re: YaBB 2.1 Converter stops working, but pretends to still be working
« Reply #4 on: February 16, 2009, 02:23:32 AM »
yep, I always reinstall SMF on every conversion attempt, always using a new blank database for it. I am using SMF 1.1.8.

Offline JMB

  • Semi-Newbie
  • *
  • Posts: 50
  • Gender: Male
Re: YaBB 2.1 Converter stops working, but pretends to still be working
« Reply #5 on: February 16, 2009, 05:55:04 PM »
I have the exact same issue with the 'Converting polls and poll choices (part 2)...'.

It's currently at step=1&substep=617400&cstep=15&start=0.

The rest of the conversion took about 5 minutes, it's been stuck on the polls for over an hour!

Converting from YaBB2.1 to SMF 1.1.8, using the 'new style' converter and a clean SMF install...

ThorstenE

  • Guest
Re: YaBB 2.1 Converter stops working, but pretends to still be working
« Reply #6 on: February 17, 2009, 02:22:14 AM »
I'll check this later today and post a modified version from the converter..

ThorstenE

  • Guest
Re: YaBB 2.1 Converter stops working, but pretends to still be working
« Reply #7 on: February 17, 2009, 03:53:21 PM »
attached a modified version.. can you try this please?

Offline JMB

  • Semi-Newbie
  • *
  • Posts: 50
  • Gender: Male
Re: YaBB 2.1 Converter stops working, but pretends to still be working
« Reply #8 on: February 17, 2009, 04:28:31 PM »
Used the modified version. Completed conversion. No getting stuck this time.

Problem now is that no polls have been converted! The posts are there in the threads that had polls but the polls themselves are missing...

EDIT: Looking a phpMyAdmin, smf_polls has 9 records, smf_poll_choices has 106 records. The forum I was converting has about 250 polls and many thousands of votes...
« Last Edit: February 17, 2009, 04:33:33 PM by JMB »

Offline pqx

  • Semi-Newbie
  • *
  • Posts: 12
Re: YaBB 2.1 Converter stops working, but pretends to still be working
« Reply #9 on: February 18, 2009, 01:36:46 AM »
Here are my results:

-Conversion went smoothly and nicely with no errors or warnings.
-I cannot find any polls either, just the threads that had them. (I could see polls and poll results just fine with previous converter)
-Size of database: 164.6MiB (there have been posts since then, so essentially same size)
-smf_log_polls contains 3,342 records, smf_polls contains just 5, and smf_poll_choices contains just 36. (they contained thousands with previous converter)


Also, found the following when running the built-in maintenance scripts (only relevant text included):

Find and repair any errors:
The following errors are fouling up your forum:
A vote was cast by member #1 on a non-existent poll #0.


Optimize all tables to improve performance:
Optimizing smf_log_polls... 25.367188 kb optimized.

-----------

One thing that I forgot to mention in my original post (and which keeps happening) is that the moderators for each forum section all get clumped together into one forum section, making them all mods of only that section. This however is easily fixed through the control panel.

« Last Edit: February 19, 2009, 12:52:54 AM by pqx »

ThorstenE

  • Guest
Re: YaBB 2.1 Converter stops working, but pretends to still be working
« Reply #10 on: February 19, 2009, 04:29:18 PM »
ok, next version attached ..if this still doesn't work: can you zip the whole YaBB folder and PM me a link where I can download it?

Offline JMB

  • Semi-Newbie
  • *
  • Posts: 50
  • Gender: Male
Re: YaBB 2.1 Converter stops working, but pretends to still be working
« Reply #11 on: February 19, 2009, 05:35:34 PM »
That version worked great, all polls seem to be there! Thanks a lot for fixing that!  8)

One small issue with the polls is that they all seem to have the 'Maximum votes per user' set to 0, so you no one can vote!

ThorstenE

  • Guest
Re: YaBB 2.1 Converter stops working, but pretends to still be working
« Reply #12 on: February 19, 2009, 05:45:25 PM »
ok, I'll check this later ..
a quick and easy fix: use phpMyAdmin and set the maxVotes to 1 for all polls.

Code: [Select]
UPDATE smf_polls SET maxVotes = '1';

Offline JMB

  • Semi-Newbie
  • *
  • Posts: 50
  • Gender: Male
Re: YaBB 2.1 Converter stops working, but pretends to still be working
« Reply #13 on: February 19, 2009, 05:51:30 PM »
That fixed it, thank you!  :D

ThorstenE

  • Guest
Re: YaBB 2.1 Converter stops working, but pretends to still be working
« Reply #14 on: February 19, 2009, 05:57:56 PM »
That fixed it, thank you!  :D
Welcome to SMF.. :)

Offline pqx

  • Semi-Newbie
  • *
  • Posts: 12
Re: YaBB 2.1 Converter stops working, but pretends to still be working
« Reply #15 on: February 21, 2009, 11:30:29 PM »
Thank you so much Thorsten, you are a GOD!  :D