请在此详细描述你所遇到的问题
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
【产品名称】:JAVA版
【产品版本】:v1.5
【部署方式】:linux/mac宝塔面板
【部署环境】:线上环境
【php版本】:
【Mysql版本】5.7
【使用终端】:PC
{{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}}