Simple Machines Community Forum

SMF Support => Converting to SMF => YaBB/YaBB SE => Topic started by: raffael3d on March 10, 2008, 03:08:39 PM

Title: Yabb SE Conversion problem
Post by: raffael3d on March 10, 2008, 03:08:39 PM
I tried to convert,

I get this

Recalculating forum statistics... Unsuccessful!
This query:

    ALTER TABLE `a27sql`.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


what can I do??

thanks!
Title: Re: Yabb SE Conversion problem
Post by: raffael3d on March 10, 2008, 03:20:09 PM
I read the reply from here
http://docs.simplemachines.org/index.php?topic=1079.msg2548#msg2548

but

I have MySQL client version: 5.0.51a

so... anything else I can do? thanks
Title: Re: Yabb SE Conversion problem
Post by: Rumbaar on March 21, 2008, 04:06:10 AM
Did you actually try any of the suggestions in the doc entry?