添加广告后更新广告时出现数据库错误代码

xuezuo

本帖最后由 xuezuo 于 2013-5-21 14:58 编辑

4.0时添加广告后偶尔更新出现数据库代码错误，必须删除刚刚添加的广告再重建，有时就好了。
5.0的，删除后重建也不行，可能是哪个广告不行必须删除。[ol]

MySQL Query:SELECT * FROM [pre]ad WHERE pid=21 AND status=3 AND fromtime1369119394 AND areaid= ORDER BY fromtime DESC LIMIT 0,1

MySQL 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 'ORDER BY fromtime DESC LIMIT 0,1' at line 1 MySQL Errno:0

Message:MySQL Query Error[/ol]复制代码