I would like users of a particular role to to automatically be notified by email of new postings of a content type, without the need to subscribe.
Any thoughts??
Most helpful answers
All roles but anonymous have an associated email. Create a rules that sends an email to all user of that role when a new instance of the particular content type is created.
Comments
All roles but anonymous have an associated email. Create a rules that sends an email to all user of that role when a new instance of the particular content type is created.
Yes...that was the first thing I tried, but it fails (in two separate installations) with error
PDOException: SQLSTATE[42S22]: Column not found: 1054 Unknown column 'r.rid' in 'where clause': SELECT DISTINCT u.mail FROM {users} u INNER JOIN {users_roles} r ON u.uid = r.uid WHERE r.rid IN (owner); Array ( ) in rules_action_mail_to_users_of_role() (line 111 of /var/www/html/modules/rules/modules/system.eval.inc).
Have you filed an issue in the queue for that error? Looks like the module is still looking for a role ID in the database, but that's now a role name instead.
The issue in contrib module Rules has now been reported and addressed at https://github.com/backdrop-contrib/rules/issues/26 and a new release of Rules (v2.0.2) includes the fix.
There is also a port of the Notify module that may meet the need, but it needs more testing.
Have you filed an issue in the queue for that error? Looks like the module is still looking for a role ID in the database, but that's now a role name instead.