java多商户V1.5版本PC站点报sql异常错误,求解决!!!操作信息如下:
### Error querying database. Cause: com.mysql.jdbc.exceptions.jdbc4.MySQLSyntaxErrorException: 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 'DESC,sales DESC,ficti DESC,id DESC LIMIT 10' at line 5 ### The error may exist in com/zbkj/service/dao/ProductDao.java (best guess) ### The error may involve defaultParameterMap ### The error occurred while setting parameters ### SQL: SELECT id,mer_id,image,name,unit_name,price,sales,ficti,category_id,brand_id FROM eb_product WHERE (is_del = ? AND is_recycle = ? AND is_show = ? AND audit_status IN (?,?)) ORDER BY rank DESC,sales DESC,ficti DESC,id DESC LIMIT ? ### Cause: com.mysql.jdbc.exceptions.jdbc4.MySQLSyntaxErrorException: 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 'DESC,sales DESC,ficti DESC,id DESC LIMIT 10' at line 5 ; bad SQL grammar []; nested exception is com.mysql.jdbc.exceptions.jdbc4.MySQLSyntaxErrorException: 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 'DESC,sales DESC,ficti DESC,id DESC LIMIT 10' at line 5
{{item.user_info.nickname ? item.user_info.nickname : item.user_name}}
作者 管理员 企业
{{itemf.name}}
{{itemc.user_info.nickname}}
{{itemc.user_name}}
回复 {{itemc.comment_user_info.nickname}}
{{itemf.name}}