UC知道dedecms MYsqlError infos: You have an error in your SQL syntax;
来源：百度知道 编辑：UC知道 时间：2024/05/31 22:05:35
DedeCMS Error Warning!
Technical Support: http://bbs.dedecms.com
Error page: /index.php
Error infos: 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 ') And arc.arcrank > -1 order by arc.sortrank desc limit 0,60' at line 6
Error sql: Select arc.*,tp.typedir,tp.typename,tp.corank,tp.isdefault,tp.defaultname,tp.namerule, tp.namerule2,tp.ispart,tp.moresite,tp.siteurl,tp.sitepath from `lxh_archives` arc left join `lxh_arctype` tp on arc.typeid=tp.id where FIND_IN_SET('c', arc.flag)>0 And arc.typeid in () And arc.arcrank > -1 order by arc.sortrank desc limit 0,60
这是什么情况?
怎么处理? dedecms 安装好后很正常,我只是换了个模板,然后就出现这个错误
Technical Support: http://bbs.dedecms.com
Error page: /index.php
Error infos: 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 ') And arc.arcrank > -1 order by arc.sortrank desc limit 0,60' at line 6
Error sql: Select arc.*,tp.typedir,tp.typename,tp.corank,tp.isdefault,tp.defaultname,tp.namerule, tp.namerule2,tp.ispart,tp.moresite,tp.siteurl,tp.sitepath from `lxh_archives` arc left join `lxh_arctype` tp on arc.typeid=tp.id where FIND_IN_SET('c', arc.flag)>0 And arc.typeid in () And arc.arcrank > -1 order by arc.sortrank desc limit 0,60
这是什么情况?
怎么处理? dedecms 安装好后很正常,我只是换了个模板,然后就出现这个错误
在你的数据库语法错误！具体数据库操作语句为：And arc.arcrank>-1 order by arc.sortrank desc limit 0,60' at line 6
总之是你修改模板的时候不小心改变了或者删除了一些数据库查询要用到的参数导致的！