新版本的 Spam Module

  • user warning: Unknown column 'u.signature_format' in 'field list' query: SELECT c.cid as cid, c.pid, c.nid, c.subject, c.comment, c.format, c.timestamp, c.name, c.mail, c.homepage, u.uid, u.name AS registered_name, u.signature, u.signature_format, u.picture, u.data, c.thread, c.status FROM comments c INNER JOIN users u ON c.uid = u.uid WHERE c.nid = 26 AND c.status = 0 ORDER BY SUBSTRING(c.thread, 1, (LENGTH(c.thread) - 1)) LIMIT 0, 30 in /home/mmx/supermmx.org/drupal-6.13/modules/comment/comment.module on line 992.
  • user warning: Table 'mmx_drupal.captcha_sessions' doesn't exist query: INSERT into captcha_sessions (uid, sid, ip_address, timestamp, form_id, solution, status, attempts) VALUES (0, '0207b3e5cfc37d504ca4c93d4d50acfd', '38.103.63.60', 1246594229, 'comment_form', 'undefined', 0, 0) in /home/mmx/supermmx.org/drupal-6.13/modules/captcha/captcha.inc on line 92.
  • user warning: Table 'mmx_drupal.captcha_sessions' doesn't exist query: SELECT status FROM captcha_sessions WHERE csid = 40960 in /home/mmx/supermmx.org/drupal-6.13/modules/captcha/captcha.inc on line 112.
  • user warning: Table 'mmx_drupal.captcha_sessions' doesn't exist query: SELECT status FROM captcha_sessions WHERE csid = 40960 in /home/mmx/supermmx.org/drupal-6.13/modules/captcha/captcha.inc on line 112.
  • user warning: Table 'mmx_drupal.captcha_sessions' doesn't exist query: UPDATE captcha_sessions SET timestamp=1246594229, solution='mukiq' WHERE csid=40960 in /home/mmx/supermmx.org/drupal-6.13/modules/captcha/captcha.inc on line 104.

突然想起来看看 [Drupal][Spam Module] 更新了没有, 一看果然更新了, 原来没有增加 4.7.x 的支持, 新版本 2.1.1 是针对 4.7.x 的, 就在 13 号发布的. 赶紧下来来装上, 几乎不用设定什么就可以用了. 上次尝试不能工作, 所以只好把匿名评论给关了, 害得上次一个哥们注册了一个帐号, 除了发评论没什么其他权限了. 现在用了新版本, 把匿名评论打开了, 这样方便大家评论. 呵呵. Trackback 仍然不开.

先开一段时间看看效果, 不过以前看到说效果还是不错的.

我现在跑的 Drupal 是 4.7.0 rc 版本的, 想顺便升级一下到 4.7 正式版, 看到都已经到 4.7.2 了, 没想到这一升级就遭大麻烦了, 反正没跑起来, 幸好升级前把数据库备份了一下, 又恢复到原来的版本. 但是使用了 spam module 以后, 提交评论把用户的 email 什么的都列出来了, 不知道是什么毛病. 所以试着把 Contact Information 给关掉了, 而且还出错: "user warning: Illegal mix of collations latin1_swedish_ci,IMPLICIT) and (utf8_general_ci,COERCIBLE) for operation '=' query: SELECT probability FROM spam_tokens WHERE token = 'header*匿名评论测试' in /home/mmx/supermmx.org/blog/drupal-old/includes/database.mysql.inc on line 120."
太诡异了.

Post new comment

The content of this field is kept private and will not be shown publicly.
  • Allowed HTML tags: <a> <em> <strong> <cite> <code> <ul> <ol> <li> <dl> <dt> <dd> <blockquote>
  • You can use BBCode tags in the text.
  • You can enable syntax highlighting of source code with the following tags: <code>, <blockcode>. Beside the tag style "<foo>" it is also possible to use "[foo]".
  • Web page addresses and e-mail addresses turn into links automatically.
  • Lines and paragraphs break automatically.

More information about formatting options