Advertisement:

Author Topic: Convert vBulletinn 3.8.7 to SMF 2.0.8 fails at posts  (Read 5544 times)

Offline Guy Verschuere

  • Jr. Member
  • **
  • Posts: 257
  • Gender: Male
    • guyverschuere on Facebook
    • Egregius on GitHub
    • guyverschuere on LinkedIn
    • @guyverschuere on Twitter
    • Egregius.be
Convert vBulletinn 3.8.7 to SMF 2.0.8 fails at posts
« on: June 21, 2014, 03:51:32 AM »
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]
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.

Offline margarett

  • SMF Friend
  • SMF Super Hero
  • *
  • Posts: 19,759
  • Gender: Male
Re: Convert vBulletinn 3.8.7 to SMF 2.0.8 fails at posts
« Reply #1 on: June 24, 2014, 05:16:35 AM »
Please check your vB database, table "editlog".

Looking at the code:

Code: [Select]
---* {$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

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

Offline Guy Verschuere

  • Jr. Member
  • **
  • Posts: 257
  • Gender: Male
    • guyverschuere on Facebook
    • Egregius on GitHub
    • guyverschuere on LinkedIn
    • @guyverschuere on Twitter
    • Egregius.be
Re: Convert vBulletinn 3.8.7 to SMF 2.0.8 fails at posts
« Reply #2 on: June 29, 2014, 03:18:25 AM »
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 :)