homepage Welcome to WebmasterWorld Guest from
register, free tools, login, search, pro membership, help, library, announcements, recent posts, open posts,
Pubcon Gold Sponsor 2015!
Home / Forums Index / Code, Content, and Presentation / Databases
Forum Library, Charter, Moderator: open

Databases Forum

Database Error question

5+ Year Member

Msg#: 4123115 posted 7:20 pm on Apr 27, 2010 (gmt 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?



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

Msg#: 4123115 posted 1:08 pm on Apr 29, 2010 (gmt 0)

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?

Global Options:
 top home search open messages active posts  

Home / Forums Index / Code, Content, and Presentation / Databases
rss feed

All trademarks and copyrights held by respective owners. Member comments are owned by the poster.
Home ¦ Free Tools ¦ Terms of Service ¦ Privacy Policy ¦ Report Problem ¦ About ¦ Library ¦ Newsletter
WebmasterWorld is a Developer Shed Community owned by Jim Boykin.
© Webmaster World 1996-2014 all rights reserved