At admin -> node moderation I get the following two SQL errors at the top:

<code>user error: You have an error in your SQL syntax near 'ON nmuv.mid = v.mid JOIN node n ON nmuv.gid = n.nid AND nmuv.realm = 'node_nid' ' at line 1
query: SELECT COUNT(*) FROM nmoderation_uservotes nmuv JOIN nmoderation_votes v ON nmuv.mid = v.mid JOIN node n ON nmuv.gid = n.nid AND nmuv.realm = 'node_nid' JOIN users u ON nmuv.uid = u.uid WHERE n.status = 1  in /home/virtual/watchingchina.com/webroot/htdocs/includes/database.mysql.inc on line 125.

and

<code>user error: You have an error in your SQL syntax near 'ON nmuv.mid = v.mid JOIN node n ON nmuv.gid = n.nid AND nmuv.realm = 'node_nid' ' at line 1
query: SELECT v.vote, nmuv.value, nmuv.uvid, n.nid, n.title, nmuv.uid, u.name FROM nmoderation_uservotes nmuv JOIN nmoderation_votes v ON nmuv.mid = v.mid JOIN node n ON nmuv.gid = n.nid AND nmuv.realm = 'node_nid' JOIN users u ON nmuv.uid = u.uid WHERE n.status = 1 ORDER BY  title ASC LIMIT 0, 50 in /home/virtual/watchingchina.com/webroot/htdocs/includes/database.mysql.inc on line 125.

Comments

grohk’s picture

grohk commented

I am unable to reproduce this. Perhaps you could drop those tables and try to reinsert the nmoderation.mysql file?

Are you running Drupal 4.5? This module is not compatible with 4.4

grohk’s picture

grohk commented

I am unable to reproduce this. Perhaps you could drop those tables and try to reinsert the nmoderation.mysql file?

Are you running Drupal 4.5? This module is not compatible with 4.4

sillygwailo’s picture

sillygwailo
Location Toronto, ON
commented

I'm running a CVS checkout of 4.5, and I dropped the nmoderation tables and re-added the tables via the .mysql file, and same error.

gkrishna’s picture

gkrishna commented
Title: Two SQL Errors in node moderation admin screen » Add inner before join

Hi,

add the keyword 'INNER' (without quotes) before join (remember there should be space between the both.

The error will be removed.

Let me know if you still have errors

It is very to add INNER before join in the sql statement (if you find keywords like outer / left before join you need to change that sql statement)

gkrishna’s picture

gkrishna commented

Hi,

add the keyword 'INNER' (without quotes) before join (remember there should be space between the both.

The error will be removed.

Let me know if you still have errors

It is very to add INNER before join in the sql statement (if you find keywords like outer / left before join you need to change that sql statement)

gkrishna’s picture

gkrishna commented

Hi,

add the keyword 'INNER' (without quotes) before join (remember there should be space between the both.

The error will be removed.

Let me know if you still have errors

It is important to add INNER before join all related sql statement (if you find keywords like outer / left before join you need not change that sql statement)

gkrishna’s picture

gkrishna commented
Title: Add inner before join » Comments repeated

oops, please consider my latest suggestion

sillygwailo’s picture

sillygwailo
Location Toronto, ON
commented
Title: Comments repeated » Two SQL Errors in node moderation admin screen

Just changed the title of this bug report back to the original.

grohk’s picture

grohk commented

Did gkrishna's suggestion fix your problem?

grohk’s picture

grohk commented

http://drupal.org/node/11592