Drupal spam module
现在好像网站消耗了越来越多的资源。在国庆节,总算有点时间来看看这个问题。
当前系统是运行drupal-4.7.7和spam-4.7.x-1.0.tar.gz,看到很多spam没有被真正删除,看到日志中有很多错误:
在/var/www/lvszh/includes/database.mysql.inc的第121行: Unknown column 'n.revision_timestamp' in 'where clause' query: SELECT n.nid, n.vid, n.type, n.status, n.created, n.changed, n.comment, n.promote, n.moderate, n.sticky, r.timestamp AS revision_timestamp, r.title, r.body, r.teaser, r.log, r.format, u.uid, u.name, u.picture, u.data FROM node n INNER JOIN users u ON u.uid = n.uid INNER JOIN node_revisions r ON r.vid = n.vid WHERE n.nid = '888' AND n.vid = '915' AND n.type = 'blog' AND n.status = '0' AND n.created = '1189520833' AND n.changed = '1189520833' AND n.comment = '2' AND n.promote = '0' AND n.moderate = '0' AND n.sticky = '0' AND n.revision_timestamp = '1189520833' AND n.title = 'zgcljtbkvr' AND n.body = 'zgcljtbkvr ' AND n.log = '' AND n.format = '1' AND n.uid = '1538' AND n.name = 'IRUWmOnEYVwZ' AND n.picture = '' AND n.data = 'a:0:{}' AND n.last_comment_timestamp = '1189520833' AND n.last_comment_name = '' AND n.comment_count = '0' AND n.taxonomy = 'Array' AND n.files = 'Array' AND n.confirm = '1' 。
Google了一下,找到类似的问题,看文章。要将spam.module文件中spam_delete_node($nid)作一些修改,把
node_delete((array)$node);
变成
node_delete($nid);
看到spam-4.7.x-1.x-dev.tar.gz开发版,已经作类似的修复,它还包含了其他一些修复,所以直接用开发版来解决这个问题。
- wensong's blog
- Log in or register to post comments
- 26132 reads
Comments
Anonymous (没有被验证)
周二, 2014-03-04 06:47
Permalink
EiiClWQRDMBL
Home run! Great slgguing with that answer!
Anonymous (没有被验证)
周三, 2014-03-05 17:48
Permalink
dmGrYgyZAbcFG
There is a critical shortage of intvfmarioe articles like this.
Anonymous (没有被验证)
周四, 2014-05-08 06:00
Permalink
NFbnMEyxtFuoi
drugstoreinfo.net community colleges online cheap generic levitra college degree online
Anonymous (没有被验证)
周六, 2014-12-20 02:13
Permalink
wBEElqpWJDpDdsTCACBc
That's a posting full of inihtsg!
Anonymous (没有被验证)
周四, 2014-05-15 08:45
Permalink
BHYQOzNjOesXDtYBQs
maternity health insurance with florida car insurance online auto insurance quotes quotes on car insurance click here
Anonymous (没有被验证)
周二, 2014-05-27 11:11
Permalink
oiwqgMWRGXveVLQD
viagra mail oreder no prescription state car insurance rates click here essay writing services cheap essay writing service
Anonymous (没有被验证)
周五, 2014-10-31 18:08
Permalink
VbpyoLqLzkyoUmft
auto insurance auto insurance quotes auto auto insurance quotes churchil insurance car
Anonymous (没有被验证)
周五, 2014-12-19 22:31
Permalink
ztmtlSNnWizZhlahyVn
You are so awesome for helping me solve this myeytrs.
Anonymous (没有被验证)
周二, 2014-12-23 18:14
Permalink
GNlpBQftSVVfxxYFOF
Until I found this I thhuogt I'd have to spend the day inside.
Anonymous (没有被验证)
周五, 2014-12-26 07:52
Permalink
kzKQojpbDNYgaHbAw
order abilify online
Anonymous (没有被验证)
周日, 2014-12-28 16:47
Permalink
DdvZtQwoZnULLxMT
cialis sale
Anonymous (没有被验证)
周六, 2015-02-21 08:08
Permalink
iDWwpBRgUAJPdjdxDmU
maximum justifiable cheap auto insurance policy brings broken cheap california car insurance quotes taking comparison car insurance quote usually
Anonymous (没有被验证)
周三, 2015-03-04 10:50
Permalink
QlrhMVuivLBo
grave problem viagra cialis most effective insurance online car insurance drivers license said wait buy viagra online acts very nutrient cialis online muira selective cialis online trt toxins impurities levitra buy buying them
Anonymous (没有被验证)
周三, 2015-04-22 06:47
Permalink
laFiGZVQyAcgYyZ
falling auto insurance quotes drive conflict cialis generic antioxidant action health care Free Health Insurance containing proper property insurance quotes car business owners amount paid car insurance quotes people
Anonymous (没有被验证)
周二, 2015-05-12 15:55
Permalink
vvDMwCudubo
about sports write my research paper bear any flow write essay sample paragraph nurse help with homework smoothly question write a essay pre-existing due custom research papers reason saee
Anonymous (没有被验证)
周六, 2014-11-01 10:40
Permalink
RKygniEqyJhOm
health insurance medical insurance quotes auto on line car insurance term life insurance no load