I get the following error when a node is edited that triggers several different e-mails being sent (from separate workflows).

You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near ')' at line 1 query: SELECT DISTINCT u.mail FROM users u INNER JOIN users_roles r ON u.uid = r.uid WHERE r.rid IN () in /projects/harbor/dev/public_html/includes/database.mysql.inc on line 172.

If I apply the attached patch to workflow_ng_system.inc which changes the query to use the Drupal db_query replacement syntax the error goes away.

CommentFileSizeAuthor
workflow_ng_system.inc_.patch885 bytesmrf

Comments

fago’s picture

fago
Primary language German
Location Vienna
commented
Status: Active » Fixed

hm, that should not happen, is you shouldn't be able to select no role. anyway, your fix won't work if one selects multiple roles, so I've committed another fix.

Anonymous’s picture

Anonymous (not verified) commented
Status: Fixed » Closed (fixed)

Automatically closed -- issue fixed for two weeks with no activity.