I have this D6 site (with i18n, without comments) and I was getting a lot of warning like this (once per node or link) :
User warning: Table web.node_comment_statistics doesn't exist query: SELECT last_comment_timestamp, last_comment_name, comment_count FROM node_comment_statistics WHERE nid = 19 in _db_query() (line 169 of /..../drupal/includes/database.mysqli.inc).
User warning: Table web.comments doesn't exist query: SELECT COUNT(*) FROM comments c WHERE c.nid = 19 in _db_query() (line 169 of /..../drupal/includes/database.mysqli.inc).
User warning: Table web.comments doesn't exist 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 = 19 ORDER BY c.thread DESC LIMIT 0, 50 in _db_query() (line 169 of /..../drupal/includes/database.mysqli.inc).
Here's a patch against latest 6.x-dev that fixes it.
Comments
Comment #2
hass commentedThis patch is not correct. In D7 we are using hook_modules_disable(). In D6 we may use http://api.drupal.org/api/drupal/developer%21hooks%21install.php/function/hook_disable/6 and set the
linkchecker_scan_commentsvariable to 0. Seelinkchecker_modules_disabled()for details.Comment #3
hass commentedDamn, you are right. We also need to do this for blocks in D7.
Comment #4
hass commentedComment #5
hass commentedPatch for review
Comment #6
hass commentedComment #8
hass commented#5: linkchecker_1804842+Lots+of+warnings+when+comment_block+modules+are+not+installed.patch queued for re-testing.
Comment #10
hass commented#5: linkchecker_1804842+Lots+of+warnings+when+comment_block+modules+are+not+installed.patch queued for re-testing.
Comment #12
hass commentedCannot repro test failures locally.
Comment #14
hass commentedComment #15
hass commentedD7: http://drupalcode.org/project/linkchecker.git/commit/57c26ca && http://drupalcode.org/project/linkchecker.git/commit/7ee50f8
Comment #16
hass commentedD6 Patch attached
Comment #17
hass commentedD6: http://drupalcode.org/project/linkchecker.git/commit/8f46aef
Comment #18.0
(not verified) commentedAdding more error messages to better describe the issue