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', '[email protected]', '', '', '', '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 Expand


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 Expand

                WHERE p.tempID = t.tempID

Replace:

Code Select Expand

                WHERE p.tempID = t.ID_TOPIC

[Conservationist]

I also got this error on one forum:

Code Select Expand


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 Expand

                WHERE p.tempID = t.tempID

Replace:

Code Select Expand

                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 Expand


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 Expand


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 Expand


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 :|