1 post in moderation

The only table that is examined is the {node} table. Maybe another module is using the 'moderate' column for something?

Try running a query like

print(db_result(db_query("SELECT COUNT(*) FROM {node} WHERE moderate > 0")));

unless you can provide more info, I don't think this is a bug with the module

Clearly, there are no nodes in moderation.

So, here's the relevant code, and maybe the problem is in the call to format_plural(). As you can see, I hard-coded the count to zero there, but maybe I only tested this with the locale module off. This message is only displayed when there are zero posts in moderation, so the bug is really at the display level, not anything deeper.

/**
 * Menu callback; displays the content moderation form.
 */
function modr8_page() {
  require_once drupal_get_path('module', 'modr8'). '/modr8_admin.inc';
  
  $count_sql = db_rewrite_sql('SELECT COUNT(*) FROM {node} n WHERE n.status = 1 AND n.moderate = 1');
  $page_sql = db_rewrite_sql('SELECT n.nid FROM {node} n WHERE n.status = 1 AND n.moderate = 1 ORDER BY n.changed DESC');
  $result = pager_query($page_sql, variable_get('modr8_nodes_per_page', 10), 0, $count_sql);
  
  $output = '<p>'. l(t('Show log of all actions on moderated content.'), 'admin/logs/modr8') .'</p>';
  if (db_num_rows($result)) {
    $output .= drupal_get_form('modr8_form', $result);
    $output .= theme('pager');
  }
  else {
    $output .= '<p>'. t('@items in moderation', array('@items' => format_plural(0, '1 post', '@count posts'))). '</p>';
  }
  return $output;
}

Hi,

I have the same thing. No node marked as moderate=1 on database, but module says I have one moderated node...

Thanks!

no patch, no clear indication of the bug