Action email all users of a role(s)

I gave this a try today. It added the action in successfully but the action didn't seem to have a place to say which group to send it to - and when you try and create something that triggers the action you get an error:

"user warning: Unknown table 'users_roles' query: SELECT users_roles.*,users.mail as mail ,users.name,users.status from teamipxusers_roles LEFT JOIN users ON users_roles.uid=users.uid where users_roles.rid IN (2,3,4,6,7,8) and users.status=1; in /home//public_html/testsite/includes/database.mysql.inc on line 172."

FYI: This was my first attempt at testing a patch. I'm sure I patched it successfully, but it's possible I may be doing something else wrong. Also I haven't used actions and workflows much. The first thing I wanted it to do was send an email to some roles when a specific content type is created or updated. So i went looking for this patch.

Yeah Drupal 5.1. (Sorry for the late reply - yet to figure out how to get this to email me when my issues are updated).

I just submitted an alternate version of this but it also allows restricting to node types which may/may not be useful.

http://drupal.org/node/156705

how to do this for drupal 6?

This version of Actions is not supported anymore. The issue is closed for this reason.
Please upgrade to a supported version and feel free to reopen the issue on the new version if applicable.

This issue has been automagically closed by a script.