Simple Machines Community Forum

I am trying to upgrade all the files have gone through but got a query.Im very new to this sort of thing so please tyr and keep it simple.

query is

This query:

    ALTER TABLE 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

Quote from: Gavcox on April 05, 2008, 11:55:25 AM
I am trying to upgrade all the files have gone through but got a query.Im very new to this sort of thing so please tyr and keep it simple.

query is

This query:

    ALTER TABLE 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

Have a look at the below link.

http://docs.simplemachines.org/index.php?topic=1079.msg2548#msg2548

I done a fresh install and works fine thanks..but what i have now is

Performance Warning
The cache directory is not writable - this will adversely affect the performance of your forum.

I have changed the permissions for the cache so it is writable but still getting this message

Quote from: babjusi on April 05, 2008, 12:51:15 PM

Quote from: Gavcox on April 05, 2008, 11:55:25 AM
I am trying to upgrade all the files have gone through but got a query.Im very new to this sort of thing so please tyr and keep it simple.

query is

This query:

    ALTER TABLE 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

Have a look at the below link.

http://docs.simplemachines.org/index.php?topic=1079.msg2548#msg2548

Thank you for your post !
I had same problem and I just applied with success what was in the post you suggested.

You are welcome brygida :)

Quote from: Gavcox on April 05, 2008, 01:41:43 PM
I done a fresh install and works fine thanks..but what i have now is

Performance Warning
The cache directory is not writable - this will adversely affect the performance of your forum.

I have changed the permissions for the cache so it is writable but still getting this message

are you sure the change was successful?  proper folder ownership on the folder as well?  If its not writable by the webserver it will throw that error.  Alternatively you may be able to disable caching in admin > server settings.  But you won't be able to take advantage of file-based caching then

http://docs.simplemachines.org/index.php?topic=1079.msg2548#msg2548

i see that erro i try here and she work 100% done

Gavcox: Did you CHMOD that cache folder to 777?

joomlamz, did you code change fix the error you have?