网站是discuz,出现问题是插件,以前用的mysql5.5.49+PHP5.3.29,没有问题,正常使用
昨天换了服务器,mysql5.5.54+PHP5.3.29,就出现下面的问题了
请教高手,如何解决这个错误,小白很苦恼
Discuz! Database Error(1064) 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 '-20,20' at line 1
SELECT m.username,m.uid,v.level,v.czz,v.jointime,v.year_pay FROM dsu_vip v, common_member m WHERE m.uid=v.uid ORDER BY v.jointime DESC LIMIT -20,20
PHP DebugNo. File Line Code
1 vip.php 95 include(%s)
2 source/plugin/dsu_kkvip/module/new_vip.inc.php 9 vip->query(%s)
3 source/class/class_vip.php 74 db_driver_mysql->query(%s, %s)
4 source/class/db/db_driver_mysql.php 153 db_driver_mysql->halt(%s, %d, %s)
5 source/class/db/db_driver_mysql.php 224 break()
昨天换了服务器,mysql5.5.54+PHP5.3.29,就出现下面的问题了
请教高手,如何解决这个错误,小白很苦恼
Discuz! Database Error(1064) 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 '-20,20' at line 1
SELECT m.username,m.uid,v.level,v.czz,v.jointime,v.year_pay FROM dsu_vip v, common_member m WHERE m.uid=v.uid ORDER BY v.jointime DESC LIMIT -20,20
PHP DebugNo. File Line Code
1 vip.php 95 include(%s)
2 source/plugin/dsu_kkvip/module/new_vip.inc.php 9 vip->query(%s)
3 source/class/class_vip.php 74 db_driver_mysql->query(%s, %s)
4 source/class/db/db_driver_mysql.php 153 db_driver_mysql->halt(%s, %d, %s)
5 source/class/db/db_driver_mysql.php 224 break()
解决方案 »
- 主机断电mysql出现问题了
- delete data from tb的问题!
- mysql简单赋值错误
- c# sql语句条件里有汉字,选出来的结果为空
- 小弟在网上下了个blog程序,mysql建库时报错:Warning: Cannot modify header information - headers already sent by ....
- 如何将多个表中的数据汇总计算到另外一个表中
- 怎样在JDBC中忽略Duplicate column错误?
- 用access将Foxpro数据转换到mysql中的问题
- mysql max函数问题
- mysql如何让行显示星期
- 求mysql怎么查2周数据
- 导入mysql数据库时出现的问题
LIMIT 0,20
这个可能和sql_mode参数的设置有关系,如果你改不了sql,那就把sql_mode给改了吧。