VB 4.1.11 to SMF 2.0.2 converting posts error

[rollntider]

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)...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

I looked at the forum some topics there... some arent... help? thanks

[mr.Curiosity]

Can you Post a picture of that error on at line 203 ?

[mentalist]

Which MySQL version is that server? MySQL seems to have an issue with the SMF database layer (ORDER BY NULL will automatically be added if there's no ORDER defined).

let's try a "workaround", in vbulletin41_to_smf.sql find:

Code Select Expand

FROM {$from_prefix}post AS p
INNER JOIN {$from_prefix}thread AS t
ON t.threadid = p.threadid;

replace with:

Code Select Expand

FROM {$from_prefix}post AS p
INNER JOIN {$from_prefix}thread AS t
ON t.threadid = p.threadid
ORDER BY p.postid;

[nhocksiano]

I have a problem too, My SQL version is 5.5.25