News:

Wondering if this will always be free?  See why free is better.

Main Menu

Problems with conversion

Started by NCDiesel, June 02, 2016, 02:08:36 PM

Previous topic - Next topic

NCDiesel

Hey - new user here.   I would like to switch to Simple Machine from vBulletin; which I have grown more increasingly frustrated with.  However, in doing the conversion - which is a requirement for switching - I am having trouble.  First the details:


MySQL client API 5.5.8
php 5.3.5
vBulletin 4.2.0
Latest download and clean install of SMF
What I believe are the latest convert script and SQL file


When I first run it, it barfs right away parsing the SQL file:

Converting members...You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near '}members' at line 2

I had to change this on line 20

20c20
< ---{$to_prefix}members
---
> ---* {$to_prefix}members

After that it runs to completion with many warnings, but no errors(except the statistics, which I don't care about).   Unfortunately, nothing happens.   All I do is lose my one single user record for SMF.   Nothing from vBulletin is added.  Here is the output.

PS:   Where is this error log mentioned in the output?    I could not find anything and nothing is logged to the errors table.

Thanks in advance!

Converting...
Converting members...
Notice: Undefined variable: row in /www/docs/antique-tractor/forum/convert.php(1101) : eval()'d code on line 10
Successful.
Converting administrators... Successful.
Converting categories...
Warning: get_resource_type() expects parameter 1 to be resource, boolean given in /www/docs/antique-tractor/forum/convert.php on line 2750

Warning: mysql_fetch_assoc() expects parameter 1 to be resource, boolean given in /www/docs/antique-tractor/forum/convert.php on line 2754

Warning: get_resource_type() expects parameter 1 to be resource, boolean given in /www/docs/antique-tractor/forum/convert.php on line 2792

Warning: mysql_num_rows() expects parameter 1 to be resource, boolean given in /www/docs/antique-tractor/forum/convert.php on line 2796

Warning: get_resource_type() expects parameter 1 to be resource, boolean given in /www/docs/antique-tractor/forum/convert.php on line 2750

Warning: mysql_fetch_assoc() expects parameter 1 to be resource, boolean given in /www/docs/antique-tractor/forum/convert.php on line 2754

Warning: get_resource_type() expects parameter 1 to be resource, boolean given in /www/docs/antique-tractor/forum/convert.php on line 2792

Warning: mysql_num_rows() expects parameter 1 to be resource, boolean given in /www/docs/antique-tractor/forum/convert.php on line 2796
Successful.
Converting boards...
Warning: get_resource_type() expects parameter 1 to be resource, boolean given in /www/docs/antique-tractor/forum/convert.php on line 2750

Warning: mysql_fetch_assoc() expects parameter 1 to be resource, boolean given in /www/docs/antique-tractor/forum/convert.php on line 2754

Warning: get_resource_type() expects parameter 1 to be resource, boolean given in /www/docs/antique-tractor/forum/convert.php on line 2792

Warning: mysql_num_rows() expects parameter 1 to be resource, boolean given in /www/docs/antique-tractor/forum/convert.php on line 2796

Warning: get_resource_type() expects parameter 1 to be resource, boolean given in /www/docs/antique-tractor/forum/convert.php on line 2750

Warning: mysql_fetch_assoc() expects parameter 1 to be resource, boolean given in /www/docs/antique-tractor/forum/convert.php on line 2754

Warning: get_resource_type() expects parameter 1 to be resource, boolean given in /www/docs/antique-tractor/forum/convert.php on line 2792

Warning: mysql_num_rows() expects parameter 1 to be resource, boolean given in /www/docs/antique-tractor/forum/convert.php on line 2796

Warning: get_resource_type() expects parameter 1 to be resource, boolean given in /www/docs/antique-tractor/forum/convert.php on line 2750

Warning: mysql_fetch_assoc() expects parameter 1 to be resource, boolean given in /www/docs/antique-tractor/forum/convert.php on line 2754

Warning: get_resource_type() expects parameter 1 to be resource, boolean given in /www/docs/antique-tractor/forum/convert.php on line 2792

Warning: mysql_num_rows() expects parameter 1 to be resource, boolean given in /www/docs/antique-tractor/forum/convert.php on line 2796
Successful.
Assigning boards to categories... Successful.
Converting topics...
Warning: get_resource_type() expects parameter 1 to be resource, boolean given in /www/docs/antique-tractor/forum/convert.php on line 2750

Warning: mysql_fetch_assoc() expects parameter 1 to be resource, boolean given in /www/docs/antique-tractor/forum/convert.php on line 2754

Warning: get_resource_type() expects parameter 1 to be resource, boolean given in /www/docs/antique-tractor/forum/convert.php on line 2792

Warning: mysql_num_rows() expects parameter 1 to be resource, boolean given in /www/docs/antique-tractor/forum/convert.php on line 2796

Warning: get_resource_type() expects parameter 1 to be resource, boolean given in /www/docs/antique-tractor/forum/convert.php on line 2750

Warning: mysql_fetch_assoc() expects parameter 1 to be resource, boolean given in /www/docs/antique-tractor/forum/convert.php on line 2754

Warning: get_resource_type() expects parameter 1 to be resource, boolean given in /www/docs/antique-tractor/forum/convert.php on line 2792

Warning: mysql_num_rows() expects parameter 1 to be resource, boolean given in /www/docs/antique-tractor/forum/convert.php on line 2796

Warning: get_resource_type() expects parameter 1 to be resource, boolean given in /www/docs/antique-tractor/forum/convert.php on line 2750

Warning: mysql_fetch_assoc() expects parameter 1 to be resource, boolean given in /www/docs/antique-tractor/forum/convert.php on line 2754

Warning: get_resource_type() expects parameter 1 to be resource, boolean given in /www/docs/antique-tractor/forum/convert.php on line 2792

Warning: mysql_num_rows() expects parameter 1 to be resource, boolean given in /www/docs/antique-tractor/forum/convert.php on line 2796

Warning: get_resource_type() expects parameter 1 to be resource, boolean given in /www/docs/antique-tractor/forum/convert.php on line 2750

Warning: mysql_fetch_assoc() expects parameter 1 to be resource, boolean given in /www/docs/antique-tractor/forum/convert.php on line 2754

Warning: get_resource_type() expects parameter 1 to be resource, boolean given in /www/docs/antique-tractor/forum/convert.php on line 2792

Warning: mysql_num_rows() expects parameter 1 to be resource, boolean given in /www/docs/antique-tractor/forum/convert.php on line 2796
Successful.
Converting posts (this may take some time)...
Warning: get_resource_type() expects parameter 1 to be resource, boolean given in /www/docs/antique-tractor/forum/convert.php on line 2750

Warning: mysql_fetch_assoc() expects parameter 1 to be resource, boolean given in /www/docs/antique-tractor/forum/convert.php on line 2754

Warning: get_resource_type() expects parameter 1 to be resource, boolean given in /www/docs/antique-tractor/forum/convert.php on line 2792

Warning: mysql_num_rows() expects parameter 1 to be resource, boolean given in /www/docs/antique-tractor/forum/convert.php on line 2796

Warning: get_resource_type() expects parameter 1 to be resource, boolean given in /www/docs/antique-tractor/forum/convert.php on line 2750

Warning: mysql_fetch_assoc() expects parameter 1 to be resource, boolean given in /www/docs/antique-tractor/forum/convert.php on line 2754

Warning: get_resource_type() expects parameter 1 to be resource, boolean given in /www/docs/antique-tractor/forum/convert.php on line 2792

Warning: mysql_num_rows() expects parameter 1 to be resource, boolean given in /www/docs/antique-tractor/forum/convert.php on line 2796
Successful.
Converting polls...
Warning: get_resource_type() expects parameter 1 to be resource, boolean given in /www/docs/antique-tractor/forum/convert.php on line 2750

Warning: mysql_fetch_assoc() expects parameter 1 to be resource, boolean given in /www/docs/antique-tractor/forum/convert.php on line 2754

Warning: get_resource_type() expects parameter 1 to be resource, boolean given in /www/docs/antique-tractor/forum/convert.php on line 2792

Warning: mysql_num_rows() expects parameter 1 to be resource, boolean given in /www/docs/antique-tractor/forum/convert.php on line 2796

Warning: get_resource_type() expects parameter 1 to be resource, boolean given in /www/docs/antique-tractor/forum/convert.php on line 2750

Warning: mysql_fetch_assoc() expects parameter 1 to be resource, boolean given in /www/docs/antique-tractor/forum/convert.php on line 2754

Warning: get_resource_type() expects parameter 1 to be resource, boolean given in /www/docs/antique-tractor/forum/convert.php on line 2792

Warning: mysql_num_rows() expects parameter 1 to be resource, boolean given in /www/docs/antique-tractor/forum/convert.php on line 2796

Warning: get_resource_type() expects parameter 1 to be resource, boolean given in /www/docs/antique-tractor/forum/convert.php on line 2750

Warning: mysql_fetch_assoc() expects parameter 1 to be resource, boolean given in /www/docs/antique-tractor/forum/convert.php on line 2754

Warning: get_resource_type() expects parameter 1 to be resource, boolean given in /www/docs/antique-tractor/forum/convert.php on line 2792

Warning: mysql_num_rows() expects parameter 1 to be resource, boolean given in /www/docs/antique-tractor/forum/convert.php on line 2796
Successful.
Converting poll options... Successful.
Converting poll votes... Successful.
Converting personal messages (step 1)...
Warning: get_resource_type() expects parameter 1 to be resource, boolean given in /www/docs/antique-tractor/forum/convert.php on line 2750

Warning: mysql_fetch_assoc() expects parameter 1 to be resource, boolean given in /www/docs/antique-tractor/forum/convert.php on line 2754

Warning: get_resource_type() expects parameter 1 to be resource, boolean given in /www/docs/antique-tractor/forum/convert.php on line 2792

Warning: mysql_num_rows() expects parameter 1 to be resource, boolean given in /www/docs/antique-tractor/forum/convert.php on line 2796
Successful.
Converting personal messages (step 2)...
Warning: get_resource_type() expects parameter 1 to be resource, boolean given in /www/docs/antique-tractor/forum/convert.php on line 2750

Warning: mysql_fetch_assoc() expects parameter 1 to be resource, boolean given in /www/docs/antique-tractor/forum/convert.php on line 2754

Warning: get_resource_type() expects parameter 1 to be resource, boolean given in /www/docs/antique-tractor/forum/convert.php on line 2792

Warning: mysql_num_rows() expects parameter 1 to be resource, boolean given in /www/docs/antique-tractor/forum/convert.php on line 2796
Successful.
Converting topic notifications...
Warning: get_resource_type() expects parameter 1 to be resource, boolean given in /www/docs/antique-tractor/forum/convert.php on line 2750

Warning: mysql_fetch_assoc() expects parameter 1 to be resource, boolean given in /www/docs/antique-tractor/forum/convert.php on line 2754

Warning: get_resource_type() expects parameter 1 to be resource, boolean given in /www/docs/antique-tractor/forum/convert.php on line 2792

Warning: mysql_num_rows() expects parameter 1 to be resource, boolean given in /www/docs/antique-tractor/forum/convert.php on line 2796
Successful.
Converting board notifications... Successful.
Converting smileys...
Warning: get_resource_type() expects parameter 1 to be resource, boolean given in /www/docs/antique-tractor/forum/convert.php on line 2750

Warning: mysql_fetch_assoc() expects parameter 1 to be resource, boolean given in /www/docs/antique-tractor/forum/convert.php on line 2754

Warning: get_resource_type() expects parameter 1 to be resource, boolean given in /www/docs/antique-tractor/forum/convert.php on line 2792

Warning: mysql_num_rows() expects parameter 1 to be resource, boolean given in /www/docs/antique-tractor/forum/convert.php on line 2796
Successful.
Converting attachments...
Notice: Undefined variable: id_attach in /www/docs/antique-tractor/forum/convert.php(1101) : eval()'d code on line 25

Notice: Undefined variable: id_attach in /www/docs/antique-tractor/forum/convert.php(1101) : eval()'d code on line 26
Successful.
Converting avatars...
Notice: Undefined variable: id_attach in /www/docs/antique-tractor/forum/convert.php(1101) : eval()'d code on line 18

Notice: Undefined variable: id_attach in /www/docs/antique-tractor/forum/convert.php(1101) : eval()'d code on line 19
Successful.
Recalculating forum statistics...
Notice: Undefined index: latest_member in /www/docs/antique-tractor/forum/convert.php on line 1571

Notice: Undefined index: latest_real_name in /www/docs/antique-tractor/forum/convert.php on line 1572
The database value you're trying to insert does not exist: value


NCDiesel

Sorry to reply to my own message, but I found my problem.    The attachments for the scripts embedded within the messages in this forum *even if they are dated after the Sticky post* are older than the scripts in the sticky note.   There were still a few typos to correct but after that all is well.


Thanks!

Advertisement: