Advertisement:

Author Topic: Problem converting vBulletin 3.6.5 to SMF 1.1.2  (Read 5795 times)

Offline Suicide Man 2oo7

  • Newbie
  • *
  • Posts: 2
Problem converting vBulletin 3.6.5 to SMF 1.1.2
« on: April 25, 2007, 11:18:50 AM »
This is what I get:
Converting...
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)... Successful.
Converting polls... Successful.
Converting poll options... Successful.
Converting poll votes... Successful.
Converting personal messages (step 1)... Successful.
Converting personal messages (step 2)... Successful.
Converting topic notifications... Successful.
Converting board notifications... Successful.
Converting smileys... Unsuccessful!
This query:

    ALTER TABLE `kp_439146_forum`.smf_smileys

    ORDER BY LENGTH(code) DESC;

Caused the error:

    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 'LENGTH(code) DESC' at line 2

Anyone know how to fix this? Ive got custom smilies in my vb...should I delete them?

EDIT: I deleted them but STILL this problem :(
« Last Edit: April 25, 2007, 11:23:43 AM by Suicide Man 2oo7 »

Offline Oldiesmann

  • SMF Friend
  • SMF Super Hero
  • *
  • Posts: 24,866
  • Gender: Male
  • Ask me about the function DB :)
    • oldiesmann on Facebook
    • Oldiesmann on GitHub
    • https://www.linkedin.com/in/michaeleshom on LinkedIn
    • @oldiesmann on Twitter
    • Archie Comics Fan Forum
Re: Problem converting vBulletin 3.6.5 to SMF 1.1.2
« Reply #1 on: April 26, 2007, 10:48:19 AM »
I'm not sure what the problem is. I just tried that query on my forum and it worked fine. What version of MySQL are you using?
Michael Eshom
Cincy Space - now open!

Offline dyrer

  • Semi-Newbie
  • *
  • Posts: 83
  • Gender: Male
    • Windows 7 Forums
Re: Problem converting vBulletin 3.6.5 to SMF 1.1.2
« Reply #2 on: May 10, 2007, 11:56:44 AM »
I have same problem too

Offline ixian

  • Newbie
  • *
  • Posts: 2
Re: Problem converting vBulletin 3.6.5 to SMF 1.1.2
« Reply #3 on: May 10, 2007, 03:17:09 PM »
This was never corrected? I have the exact same problem, mySQL 5.0.37. No custom smilieys or anything, in fact a pretty stock vbulletin 3.6.2 install.

Offline ixian

  • Newbie
  • *
  • Posts: 2
Re: Problem converting vBulletin 3.6.5 to SMF 1.1.2
« Reply #4 on: May 10, 2007, 03:29:39 PM »
It's corrected now, anyway:) Here's the fix I figured out for anyone else running in to this:

In your SMF folder:

Edit Sources/ManageSmileys.php

Change Line 654:
ORDER BY LENGTH(code) DESC", __FILE__, __LINE__);
To:
ORDER BY code DESC", __FILE__, __LINE__);

Change Line 990:
ORDER BY LENGTH(code) DESC", __FILE__, __LINE__);
To:
ORDER BY code DESC", __FILE__, __LINE__);

Edit the vbulletin36_to_smf.sql file

Change Line 397:

ORDER BY LENGTH(code) DESC;
To:
ORDER BY code DESC;

Edit the Convert.php file

Change Line 1371:

ORDER BY LENGTH(code) DESC");
To:
ORDER BY code DESC");

It's a syntax error that apparently newer versions of mySQL 5 don't like.