Download & Extend

Identify When the table comments exits.

Project:abuse
Version:6.x-1.1-alpha1
Component:Code
Category:feature request
Priority:normal
Assigned:Unassigned
Status:active
Issue tags:abuse, cron, cron warning, display warnings, PHP 5.3 compatibility

Issue Summary

If some one (like me) has installed Node Comments (http://drupal.org/project/nodecomment) it remplace the table comments and include the comments into the table "node".

The problem is when the cron is running it cause a warning because this line in abuse_cron

<?php
db_query
("DELETE FROM {abuse_status} WHERE type='comment' AND oid NOT IN (SELECT cid FROM {comments})");
?>

is broken.

For example, in the abuse_cron() I add this lines:

<?php
 
if (db_query('SHOW TABLES LIKE {comments}')) {
   
db_query("DELETE FROM {abuse_status} WHERE type='comment' AND oid NOT IN (SELECT cid FROM {comments})");
  }
?>

Comments

#1

a patch

AttachmentSize
abuse-1309594-1-D6-1.x.patch 716 bytes
nobody click here