Topic: Conversion Problems

[vmpre2]

Well, just like the rest of you I am trying to convert a YaBB 2.1 to SMF

YaBB 2.1
SMF 1.1.2
A few mods installed on YaBB but nothing crazy
Using the Converters posted here: http://www.simplemachines.org/download/?converters
52,000 posts
2500 Topics
900 Members

I get as far as converting the posts when I pretty consistantly encounter this:

Internal Server Error
The server encountered an internal error or misconfiguration and was unable to complete your request.

Please contact the server administrator and inform them of the time the error occurred, and anything you might have done that may have caused the error.

When I check the board just about everything is there expect the posts.

Any ideas?

Cheers

[vmpre2]

OK well

I think I got the posts to convert I think. Not sure what I did. Just kept trying. Also put YaBB into maintenance mode, so maybe that helped.

But (always a but) now I got an error converting polls.

Caused the error:
Duplicate entry '4-0-3' for key 1

Any thoughts on this one?

Polls are no big loss to me. Possible to ignore converting polls?

[vmpre2]

Man, this is frustrating.

Tried again, each time with a clean SMF.

Still getting the 500 error and still getting the Polls problem and now I am getting an attachments error

Converting attachments (if the mod is installed)... Unsuccessful!
This query:

    SELECT ID_MSG, temp_filename
    FROM `mysql_db`.yabbconvert_messages
    WHERE temp_filename != ''
    LIMIT 0, 100;

Caused the error:

    Unknown column 'temp_filename' in 'field list'

I have no idea on how to over come these issues.

Any one?

I am going to install 1.1 RC3 and use the converter from this topic and see if those jive better.

[SleePy]

Is this issue solved or do you still require assistance?
 
Did using an older converter on an Older version of SMF work? Did you make sure to upgrade to the latest version after that if it did work?

[Conservationist]

I'm on a Linux machine, converting a Yabb 2.1 board that was converted successfully from Yabb 1.4.

It looks like an array is being passed as a single value, causing confusion for the script:

Notice: Undefined variable: command_line in [path]/convert.php on line 1148
Converting members...
Notice: Undefined offset: 0 in [path]/yabb21_to_smf.php on line 1981

Warning: array_keys() [function.array-keys]: The first argument should be an array in [path]/yabb21_to_smf.php on line 1981

Warning: implode() [function.implode]: Invalid arguments passed in [path]/yabb21_to_smf.php on line 1981
Unsuccessful!
This query:

    INSERT INTO `database_name`.smf_members
    ()
    VALUES ('username', 'encrypted_pass', 'username', 'username@googlemail.com', '', '', '', '0', '0', '', '', '', '', '', 'I love YaBB 1G - SP1!', 'blank.gif', '', '', '', '1', '', '0', '0', '0', '', '', '', '', '', '', '', '', '', '', '', '', '', '');

Caused the error:

    Column count doesn't match value count at row 1

Any ideas as to what's gone wrong?

I replaced the following values:
username
encrypted pass
user email
path to installation

All help appreciated!

[SleePy]

Have you tried the Yabb 2.1 converter attached in the sticky at the top of this board?

[Conservationist]

Yes. The solution was to remove all 0-postcount accounts.

However, the next problem has arisen:

Code: [Select]

Notice: Undefined variable: command_line in [path]/convert.php on line 1148
Cleaning up (part 2)... Successful.
Converting polls and poll choices... Successful.
Converting polls and poll choices (part 2)... Unsuccessful!
This query:
SELECT p.ID_POLL, t.ID_TOPIC
FROM (`database_name`.smf_polls AS p, `metal_smf`.smf_topics AS t)
WHERE p.tempID = t.tempID
LIMIT 0, 200;
Caused the error:
Unknown column 't.tempID' in 'where clause'

No ideas what to do on this one.

[SleePy]

Did you do anything or try to resme in a different part of the script?

That column isn't dropped until the very last step :|

[Conservationist]

Nope, this is a straight run. In this attempt, it ran fine until it encountered this error.

[SleePy]

Odd,

This might work.

Find:

Code: [Select]

                WHERE p.tempID = t.tempID
Replace:

Code: [Select]

                WHERE p.tempID = t.ID_TOPIC

[Conservationist]

I also got this error on one forum:

Code: [Select]

Notice: Undefined variable: command_line in [path]/convert.php on line 1148
Converting attachments (if the mod is installed)... Unsuccessful!
This query:
SELECT ID_MSG, temp_filename
FROM `forum_smf`.smf_messages
WHERE temp_filename != ''
LIMIT 0, 100;
Caused the error:
Unknown column 'temp_filename' in 'field list'

Converting YaBB 2.2 converted a year ago from 1.4, now becoming SMF.

This one ran overnight -- most of us don't have the time to screw with this stuff for more than 24 hours.

[Conservationist]

Odd,

This might work.

Find:

Code: [Select]

                WHERE p.tempID = t.tempID
Replace:

Code: [Select]

                WHERE p.tempID = t.ID_TOPIC

Thank you; I will try this in a moment.

Right now the problem is "500 Internal Server Error"s, but I think this may be the webhost killing the process for being too big.

[Conservationist]

Unfortunately, it did not work:

Code: [Select]

Notice: Undefined variable: command_line in [path]/convert.php on line 1148
Converting polls and poll choices (part 2)... Unsuccessful!
This query:
SELECT p.ID_POLL, t.ID_TOPIC
FROM (`database_smf`.smf_polls AS p, `database_smf`.smf_topics AS t)
WHERE p.tempID = t.ID_TOPIC
LIMIT 0, 200;
Caused the error:
Unknown column 'p.tempID' in 'where clause'

Hmm. Not sure what to try at this point.

[SleePy]

Odd,
Did you have it skip any steps?

It looks like a step that was performed a while ago was skipped and it doesn't have the temp file column.

[SleePy]

what.. That is saying that none of the temp columns that where created during the topic and post conversion where done

If you go into the smf database and look at the polls and topics table do you see columns starting with temp?

[Conservationist]

If you go into the smf database and look at the polls and topics table do you see columns starting with temp?

Nope, I sure don't.

This is what I see for smf_topics:

Code: [Select]

ID_TOPIC mediumint(8) UNSIGNED No auto_increment
  isSticky tinyint(4) No 0
  ID_BOARD smallint(5) UNSIGNED No 0
  ID_FIRST_MSG int(10) UNSIGNED No 0
  ID_LAST_MSG int(10) UNSIGNED No 0
  ID_MEMBER_STARTED mediumint(8) UNSIGNED No 0
  ID_MEMBER_UPDATED mediumint(8) UNSIGNED No 0
  ID_POLL mediumint(8) UNSIGNED No 0
  numReplies int(10) UNSIGNED No 0
  numViews int(10) UNSIGNED No 0
  locked tinyint(4) No 0

This is what I see for smf_polls

Code: [Select]

ID_POLL mediumint(8) UNSIGNED No auto_increment
  question tinytext utf8_general_ci No
  votingLocked tinyint(1) No 0
  maxVotes tinyint(3) UNSIGNED No 1
  expireTime int(10) UNSIGNED No 0
  hideResults tinyint(3) UNSIGNED No 0
  changeVote tinyint(3) UNSIGNED No 0
  ID_MEMBER mediumint(8) UNSIGNED No 0
  posterName tinytext utf8_general_ci No


[Conservationist]

Odd,
Did you have it skip any steps?

It looks like a step that was performed a while ago was skipped and it doesn't have the temp file column.

I did not instruct it to skip any steps; one continuing problem we've had is the webhost killing large processes, but that would give me an error, wouldn't it?

[SleePy]

It might be if they are killing the processes it needs to do to make the changes.

Have you thought about trying maybe doing the conversion locally?
You would just need a local copy of all the stuff and make sure it all works before you do the conversion.

Then once it is done you just dump your smf database and import it onto your live site.

[Conservationist]

It might be if they are killing the processes it needs to do to make the changes.

Have you thought about trying maybe doing the conversion locally?
You would just need a local copy of all the stuff and make sure it all works before you do the conversion.

Then once it is done you just dump your smf database and import it onto your live site.

I'm going to have to do it on another machine.

I'm getting "Connection dropped by server" or similar errors through the browser.

I don't have a Linux machine handy, so I'm seeking options right now.

Thanks for all your help -- I'm not sure this is "the only problem," but it needs a different approach.

[SleePy]

Well you could make the block sizes for how many inserts it is doing at once.
Though if your host is killing them not sure what will stop them from killing it again :|

[Conservationist]

Well you could make the block sizes for how many inserts it is doing at once.
Though if your host is killing them not sure what will stop them from killing it again :|

They're killing what are actually very small processes, and for some reason, I'm not getting warnings, but it looks consistent when I scan over my notes.

The machine we're on is incredibly slow. Based on past use of Linuxen, I'd guess it's a PIII or early PIV but nothing with real power. They've also put quite a few users on it.

We're locked into a years contract and then will reconsider the situation if nothing has changed. I am saddened by it, because this host used to be quite good and painless, where now they have an attitude of indifference toward how long web sites are down, and their solution to everything is "buy dedicated hosting," even for those of us who don't yet have stats meriting that.

[SleePy]

To long past any guarantees I guess?

[Conservationist]

To long past any guarantees I guess?

Well... using a host, you get to know some of the people.

And you end up liking them... even if they may be (in my view) making poor decisions.

So then I'd have to prove to them that their service was basically a failure.

I hold out hope -- they're not dumb or mean people -- I think they just oversold in an effort to make a bit more money. I think I understand. They may fix it (?) in the future.

It has been disappointing, however. The whole thing reeks of a lack of planning, and seeing something good like a webhost go down the path to ruin is never a happy thing.

But, me and this webhost did have some happy years together, so I can't say things are bad. Just quite possibly changing

[SleePy]

Any luck on this Conservationist?

[Conservationist]

Yes and no. We switched hosting. The original host had just radically oversold their shared hosting, and those of us who started out paying a higher price back in the "good old days" got a bit of a shock when decrease in the service crept up on us. I was able to convert the forum itself with a far simpler hack: take old Pentium IV PC, install Linux, run conversion there while using our new ISP's SQL. Thank you all for your help.