The is the one simular to this one here http://drupal.org/node/11592
i get the same error only that fix wasnt specific enough, i added the INNER join infront of the inner on all sql quiries but it only included the inner in the error message

my error is

user error: You have an error in your SQL syntax near 'INNER JOIN nmoderation_uservotes nmuv ON n.nid = nmuv.gid AND nmuv.realm = 'node' at line 1
query: SELECT COUNT(*) FROM node n INNER JOIN users u ON n.uid = u.uid LEFT INNER JOIN nmoderation_uservotes nmuv ON n.nid = nmuv.gid AND nmuv.realm = 'node_nid' AND nmuv.uid = 1 WHERE n.type IN ('blog','book','daily-daily','daily-container','forum','page','poll','recipe','story') AND n.status = 1 AND ISNULL(nmuv.uvid) AND n.created > 1101516962 in /home/virtual/site247/fst/var/www/html/includes/database.mysql.inc on line 125.
user error: You have an error in your SQL syntax near 'INNER JOIN nmoderation_uservotes nmuv ON n.nid = nmuv.gid AND nmuv.realm = 'node' at line 1
query: SELECT DISTINCT(n.nid), n.created, u.name, n.title, n.uid FROM node n INNER JOIN users u ON n.uid = u.uid LEFT INNER JOIN nmoderation_uservotes nmuv ON n.nid = nmuv.gid AND nmuv.realm = 'node_nid' AND nmuv.uid = 1 WHERE n.type IN ('blog','book','daily-daily','daily-container','forum','page','poll','recipe','story') AND n.status = 1 AND ISNULL(nmuv.uvid) AND n.created > 1101516962 ORDER BY n.created DESC LIMIT 0, 50 in /home/virtual/site247/fst/var/www/html/includes/database.mysql.inc on line 125.

i did check out line 125 and it seemed there was a typo for inquiry... it was spelled /nquiry. i tryed changing it and the error got smaller but there was still an error

THE PAGE I GET IT IS - my unmoderated nodes http://allensworld.org/nmoderation

USERF 1 ONLY GETTS THIS ERROR ALSO, OTHER USERS SEEM TO TIME OUT COMPLETLY

Comments

allen’s picture

allen commented

OK, instead of just adding inner before join.

you have to replace LEFT with INNER - before the join

allen’s picture

allen commented

i dont get the sql error any longer but i still cant log in to the site as a admin with all rights when this module is combined with others

grohk’s picture

grohk commented
Title: nmoderation » nmoderation SQL problems.
Component: Code » Miscellaneous
Assigned: allen » grohk
Category: bug » support
Priority: Critical » Normal
allen’s picture

allen commented

some how i fixed it by seperating the permissions from users- example : before all users was checked in the admin >>user >> configure to be able to access the front page. i only checked one user for ever permision, then combined them when assigning permissions to a specific user in the admin> user settings.

it worked for that module but happened again when i installed the Feedback. mabee its in the core where my problem lies

grohk’s picture

grohk commented

Allen, I think your problems are being caused by a bad setup. I have this module and feedback co-existing nicely, so I think the problem lies elsewhere.

If we can, we should start over by dropping the nmoderation tables and using the latest versions for this module from CVS. I also want you to try to use my updated readme to setup this module and see if it helps you. You can find it here:

http://drupal.org/node/13994

grohk’s picture

grohk commented
Anonymous’s picture

(not verified) commented