Convert vBulletinn 3.8.7 to SMF 2.0.8 fails at posts

Started by Guy Verschuere, June 21, 2014, 03:51:32 AM

Previous topic - Next topic

Guy Verschuere

Hi all,

I recently adopted a vbulletin forum, but since I'm a great SMF fan I'd like to convert it to SMF.
Because I don't want the forum to be down I'm testing in a subdomain.
Steps that I did:
- Imported everything from vbulletin into a new database (with mysqldump and mysql in SSH)
- uploaded and installed SMF 2.0.8 in that database.
- SMF 2.0.8 was up and running (ofcourse :) )
- Running convert.php from Vbulletin 3.7 to SMF 2-0 (from;software=vbulletin)

At the script stops with error:
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

Quit strange that 38200 posts are converted (around 70000 posts in vbulletin).

Any idea's how to fix this? I really want to run that forum also on SMF instead of the $&§ vbulletin.


Please check your vB database, table "editlog".

Looking at the code:

---* {$to_prefix}messages (update id_msg)
SELECT postid AS id_msg, username AS modified_name, dateline AS modified_time
FROM {$from_prefix}editlog
ORDER BY dateline;

It seems that you have a NULL value in column "dateline", maybe?

Can you please remove that code momentarily and try the converter again? Just to be sure...
Se forem conduzir, não bebam. Se forem beber... CHAMEM-ME!!!! :D

QuoteOver 90% of all computer problems can be traced back to the interface between the keyboard and the chair

Guy Verschuere

Thanks for your reply!
Can't verify anymore do, I got thru it skipping some posts by altering the start= in the url.
Found in the DB that those posts were at least 5 years old, so not that important anymore. is on SMF and I'm verry happy with that :)