Welcome to WebmasterWorld Guest from

Forum Moderators: open

Message Too Old, No Replies

Database Error question


7:20 pm on Apr 27, 2010 (gmt 0)

Junior Member

5+ Year Member

joined:July 14, 2009
votes: 0


I tried to edit smileys and I got an error (everything seems to be OK so far)...In error log its written:

Database 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 '(code) DESC' at line 2
File: /homeX/my-user-name/public_html/forum/Sources/ManageSmileys.php
Line: 657

I use SMF 1.1.11 and in phpinfo.php its written that MySQL ver. No is: Client API version 5.1.41

Any ideas?
1:08 pm on Apr 29, 2010 (gmt 0)


WebmasterWorld Administrator coopster is a WebmasterWorld Top Contributor of All Time 10+ Year Member

joined:July 31, 2003
votes: 2

You need to dump that query out so you can see the syntax error in full. That looks like part of an ORDER BY clause. Why are there parentheses around the column name?

Join The Conversation

Moderators and Top Contributors

Hot Threads This Week

Featured Threads

Free SEO Tools

Hire Expert Members