vbulletin 3.8.1 to smf

[Am']

Hi

why pack i use for converting vbulletin 3.8.1 to smf 2rc3?

http://download.simplemachines.org/?converters;software=vbulletin

thx

[Norv]

Please use http://download.simplemachines.org/index.php?thanks;filename=smf_2-0-rc3_vbulletin37_converter.zip

[ngoclanbaby86]

convert from VBB3.8.4 to SMF 2.0RC3I used this one and sucssessful.
download files attack

[Am']

ok

i choose vbulletin 3.7 ?

[Norv]

Yes, please. It was confirmed to work with vbulletin 3.8.

[Am']

Hi

the script converts well members, admins, forums but he jammed with the post table

the page will load almost 45 minutes (size of vbulletin table post : 150mo), after i have this :

Converting members... Successful.
Converting administrators... Successful.
Converting categories... Successful.
Converting boards... Successful.
Assigning boards to categories... Successful.
Converting topics...

and url :

http://localhost:82/smf2rc3/convert.php?step=1

why this problem? ie I did the conversion locally, if I'm online it goes fast? any idea please ? it's so important   

[Norv]

It depends how fast your server is, but typically if you're online it goes slower.

Is there anything else on the page? A screenshot may help.

[Am']

It depends how fast your server is, but typically if you're online it goes slower.

Is there anything else on the page? A screenshot may help.

no anything, juste this message :

Converting members... Successful.
Converting administrators... Successful.
Converting categories... Successful.
Converting boards... Successful.
Assigning boards to categories... Successful.
Converting topics...

[Norv]

Can you please tell what file(s) have you used, can you please make sure it's these: http://download.simplemachines.org/index.php?thanks;filename=smf_2-0-rc3_vbulletin37_converter.zip

[Am']

Can you please tell what file(s) have you used, can you please make sure it's these: http://download.simplemachines.org/index.php?thanks;filename=smf_2-0-rc3_vbulletin37_converter.zip

yes 

[Norv]

Please try this :(keep a backup copy of your original file, and restore it after working on the conversion)
(Subs-Db-mysql.php)

Code (find) Select Expand


// Here's where the variables are injected to the query.
$insertRows = array();
foreach ($data as $dataRow)
$insertRows[] = smf_db_quote($insertData, array_combine($indexed_columns, $dataRow), $connection);


Code (replace) Select Expand


// Here's where the variables are injected to the query.
echo "indexed_columns:<br>";
var_dump($indexed_columns);
echo "<br>";
$insertRows = array();
foreach ($data as $dataRow) {
echo "dataRow: <br>";
var_dump($dataRow);
echo "<br>";
$insertRows[] = smf_db_quote($insertData, array_combine($indexed_columns, $dataRow), $connection);
}


Then, run the conversion again. Please post the entire messages on the page (copy paste, or attach a screenshot, or both).

[Am']

ok, i will try

postindex/postparsed (90mo) is important in the convertion ? i can truncate before convertion?

Please try this :(keep a backup copy of your original file, and restore it after working on the conversion)
(Subs-Db-mysql.php)

Code (find) Select Expand


// Here's where the variables are injected to the query.
$insertRows = array();
foreach ($data as $dataRow)
$insertRows[] = smf_db_quote($insertData, array_combine($indexed_columns, $dataRow), $connection);


Code (replace) Select Expand


// Here's where the variables are injected to the query.
echo "indexed_columns:<br>";
var_dump($indexed_columns);
echo "<br>";
$insertRows = array();
foreach ($data as $dataRow) {
echo "dataRow: <br>";
var_dump($dataRow);
echo "<br>";
$insertRows[] = smf_db_quote($insertData, array_combine($indexed_columns, $dataRow), $connection);
}


Then, run the conversion again. Please post the entire messages on the page (copy paste, or attach a screenshot, or both).

[Am']

now i have this

Converting members... Successful.
Converting administrators... Successful.
Converting categories... Successful.
Converting boards... Successful.
Assigning boards to categories... Successful.
Converting topics... Successful.
Converting posts (this may take some time)...Got a packet bigger than 'max_allowed_packet' bytes

i am in this host : http://www.allo-heberge.com/ (and i can custom php.ini)

in phpmyadmin > variables i have this value :

max allowed packet     1 048 576

infos of my mysql :

Code Select Expand

    * Apache/2.2.15 (Unix)
    * Version du client MySQL: 5.0.90
    * Extension PHP: mysqli


please help   

[Norv]

Please try:
(vbulletin37_to_smf.sql)

Code (find) Select Expand


---* {$to_prefix}messages 200


Code (replace) Select Expand


---* {$to_prefix}messages 100


[Am']

now i have  this :

first screen

Converting members... Successful.
Converting administrators... Successful.
Converting categories... Successful.
Converting boards... Successful.
Assigning boards to categories... Successful.
Converting topics... Successful.
Converting posts (this may take some time)... Incomplete.

Not quite done yet!
This conversion has paused to avoid overloading your server, and hence not working properly.
Don't worry though, nothing's wrong - simply click the continue button below to start the converter from where it left off.

after, second screen

Converting posts (this may take some time)...
Got a packet bigger than 'max_allowed_packet' bytes

i tested ---* {$to_prefix}messages 50 but the same problem

url is :

convert.php?step=1&substep=9&start=34650

[Norv]

If you can (if you have access to your server's installation mysql), you could perhaps make higher the max allowed packet value.
Or, make the chunk even lower.

What happens as far as I can see, is that: your MySQL only accepts a maximum amount of data to process at a time, which is smaller than what the converter sends it. The converter sends it 50 posts at a time, if you set 50 on that line...
You *could* make it as low as you want, but conversion would take much longer then.

If you're on localhost still, you can access your mysql installation, and change the value of the variable which seems to be causing trouble right now:
http://forums.mysql.com/read.php?35,54533,56470#msg-56470

[Am']

it works

but after I get this error:

Converting polls... Successful.
Converting poll options... Successful.
Converting poll votes...Wrong value type sent to the database. Integer expected. (id_member)

what to do? It s one opportunity not to repeat from the beginning? the conversion of the table post took me 1 hour ... 

thank you

[Norv]

You could remove the sections about topics and posts, (and members), from vbulletin37_to_smf sql file, but I must say it's untested.
If you want to try, you would need to delete from the file, everything from

Code Select Expand


--- Converting members...

(including this line),
to

Code Select Expand


--- Converting polls...

(excluding this line)
Please keep a copy of the file on your computer, just in case.

Then, about the error:
please try modifying (in the same file)

Code (find) Select Expand


SELECT pollid AS id_poll, userid AS id_member, voteoption AS id_choice
FROM {$from_prefix}pollvote;


Code (replace) Select Expand


SELECT pollid AS id_poll, IFNULL(userid, 0) AS id_member, voteoption AS id_choice
FROM {$from_prefix}pollvote;


[Am']

thx 

but he not convert avatar ?

[Norv]

It should have converted avatars too, afaik. Didn't it?
Were there other errors/warnings?
Were the avatars moved in your SMF folder/attachments directory? (that's where they are supposed to be)