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