News:

Wondering if this will always be free?  See why free is better.

Main Menu

Problem converting vBulletin 3.6.5 to SMF 1.1.2

Started by Suicide Man 2oo7, April 25, 2007, 11:18:50 AM

Previous topic - Next topic

Suicide Man 2oo7

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 :(

Oldiesmann

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
Christian Metal Fans

dyrer


ixian

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.

ixian

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.

Advertisement: