Convert vBulletinn 3.8.7 to SMF 2.0.8 fails at posts

[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 http://download.simplemachines.org/?converters;software=vbulletin)

At http://smf.abforum.be/convert.php?step=1&substep=9&start=34200 the script stops with error:

Code Select Expand

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

[margarett]

Please check your vB database, table "editlog".

Looking at the code:

Code Select Expand

---* {$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...

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

abforum.be is on SMF and I'm verry happy with that