Hi
I'm using drupal 5.3, plenty of other modules and Modr8,
I am also running ecommerce with EC Live Subproducts, my error may be a conflict with that.
I have a few roles including 'superadmin' with all access and 'poster' with resticted access.
when a 'poster' users submits a node of a content type that has been configured by default to go into moderation queue i get the error below.
I can work around the error by giving the user role 'poster' privialeges to administer the moderation queue, and then removing their privilages to access it (the modr8 queue page) through the menu and url using 'role menu', this is unsatisfactory but does work and might indicate what the issue is.
I do use this module in other installations on 5x and it works fine, so im looking for a clue as to what the problem might be.
Thank you, this is an essential mod for community driven sites.

user warning: Unknown column 'n.moderate' in 'where clause' query: SELECT td.*, sv.* , n.title, n.body AS attribute_description, n.format, a.* FROM term_data td INNER JOIN ec_ls_variation sv ON sv.tid = td.tid LEFT JOIN term_node tn ON tn.tid = td.tid LEFT JOIN node_revisions n ON n.nid = tn.nid LEFT JOIN ec_ls_attribute a ON a.nid = tn.nid INNER JOIN ec_ls_bpattribute ba ON ba.nid = a.nid INNER JOIN node_access na ON na.nid = n.nid WHERE (na.grant_view >= 1 AND ((na.gid = 0 AND na.realm = 'all') OR (na.gid = 2 AND na.realm = 'nodeaccess_rid') OR (na.gid = 4 AND na.realm = 'nodeaccess_rid') OR (na.gid = 38 AND na.realm = 'nodeaccess_uid') OR (na.gid = 38 AND na.realm = 'nodeaccess_author'))) AND ((n.moderate != 1 OR n.uid = 38)) AND ( td.vid = 2 AND ba.pnid = 500 ) ORDER BY td.weight, td.name ASC ,attr_weight , n.title in C:\xampp\htdocs\5store\includes\database.mysql.inc on line 172. 
The post has been submitted for moderation and won't be listed publicly until it has been approved. 

Comments

pwolanin’s picture

Looks like an improper use of db_rewrite_sql in that module - check the code.

pwolanin’s picture

Status: Active » Closed (fixed)