PHPBB2 - problem with MySQL

[strangedesign]

I'm getting the following error converting from phpbb to smf. Anyone have any ideas of what might be causing this?

Recalculating forum statistics... Unsuccessful!
This query:
ALTER TABLE `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


Thanks!!!

[strangedesign]

Sorry! I found this thread from a google search. I downloaded the latest convert.php and sql file from the threads below, and it worked like a champ.

convert.php
http://www.simplemachines.org/community/index.php?topic=140741.0

phpbb2_to_smf.sql
http://www.simplemachines.org/community/index.php?topic=142124.0