发新话题
打印

请教一下macleo哥,关于for4.1的机器人问题

请教一下macleo哥,关于for4.1的机器人问题

运行机器人时经常出现以下错误,请问怎么解决??谢谢了~~~

fid NOT IN (16,18,13,20,21,22) and
Discuz! info: MySQL Query Error

User: XXXXXX
Time: 2006-8-24 10:04am
Script: /bbs/macher.php

SQL: INSERT INTO cdb_posts (fid, tid, author, authorid, dateline, message,useip, bbcodeoff)
VALUES ('24', '951', 'YYYYYY ', '26', '1156385087', ':'(:)','59.36.14.131', '0')
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 '(:)','59.36.14.131', '0')' at line 2
Errno.: 1064

Similar error report has beed dispatched to administrator before.

TOP

楼上的,我的也是出现你上述问题,以前我安装成功了,也用了很长一段时间,现在我换空间了,全新安装居然用不了,其他的 参数设置、发言内容、机器人名等等,都能够打开,就是到了 开启机器人 ,就出现你上面说的情况,郁闷!!希望版主能帮忙解决一下!

我的出现如下情况:

fid IN (12,1,,22) and
Discuz! info: MySQL Query Error

User: 管理员
Time: 2006-8-24 6:19pm
Script: /bbs/macher.php

SQL: SELECT fid, tid, subject, author, replies,dateline FROM cdb_threads WHERE dateline > UNIX_TIMESTAMP()- 0 and dateline < UNIX_TIMESTAMP() and fid IN (12,1,,22) and tid>0 ORDER BY rand() DESC LIMIT 1
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 '22) and tid>0 ORDER BY rand() DESC LIMIT 1' at line 1
Errno.: 1064

An error report has been dispatched to our administrator.

[ 本帖最后由 杨万里 于 2006-8-24 18:21 编辑 ]

TOP

请说明详细的使用环境!感谢!
可是我没有发现这样的错误啊?郁闷!
今天早上上班赶公共汽车,到站台的时候,汽车已经启动。于是我只好边追边喊:“师傅,等等我!师傅,等等我呀!”这时一乘客从车窗探出头来冲我说了一句:“悟空,你就别追了。”

TOP

发新话题