SMF Support > vBulletin

vBulletin 3.6.8 pl2 -> SMF Wrong value type sent to the database

(1/3) > >>

jlbooker:
Hi all,

I'm trying to convert from an old instance of vBulletin at version 3.6.8 patch level 2, to the latest version of SMF. I just downloaded the converter today and ran it on a fresh install of SMF.

I'm getting the error:
Converting members...
Successful.
Converting administrators... Successful.
Converting categories...Wrong value type sent to the database. Integer expected. (can_collapse)

Any ideas on how to fix this?

Oldiesmann:
You're using the "vBulletin 3.6 to SMF 2-0" converter from the downloads page, correct?

jlbooker:
That's correct. The files I had after un-taring were convert.php and vbulletin36_to_smf.sql.

Oldiesmann:
It appears there's a typo in the converter.

Make this change to the SQL file:

Find

--- Code: (Line 107) --- displayorder AS cat_order, '' AS can_collapse
--- End code ---

Replace

--- Code: --- displayorder AS cat_order, 0 AS can_collapse
--- End code ---

jlbooker:
Thanks! That fixed that error. Now I've run into this one:


--- Code: ---Converting topics...
Successful.
Converting posts (this may take some time)...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 'ORDER BY null' at line 203
--- End code ---

Navigation

[0] Message Index

[#] Next page