I am using subscriptions 5.x-1.x-dev with postgres

I tried it on standard mode and it sends too many mails so instead tried with cron however this still sends the same amount of mails. I'd prefer to keep this down as I don't want site mails blacklisted.

Is this a problem because I'm using postgres or is this how it's supposed to work?

If it's how it's supposed to work can I ask for a feature to allow just one mail per cron run informing a user of all the updates to nodes they are subscribed to.

If this is due to me using postgres then can this be changed to a bug request, I'm happy to help with testing on drupal as I have a test environment which will not impack my real sites.

Comments

salvis’s picture

salvis
he/his
commented
Version: 5.x-1.x-dev » 5.x-2.0-beta10
Status: Active » Fixed

Subscriptions 1.9 is buggy and unmaintained.

We're working on Subscriptions 2.0, currently in beta, and I'd be very interested in getting pgsql testing.

2.0 has a Digest mode as well as a configurable Send Interval, which can do what you want.

bfo’s picture

bfo commented

Cool I'll try the 2.0 beta version,

feel free to prod me if you want someone to test, Every so often i don't check the drupal site for a while but will still happily test.

bfo’s picture

bfo commented

using the 2.0 beta version I get the following error

* warning: pg_query() [function.pg-query]: Query failed: ERROR: duplicate key violates unique constraint "subscriptions_queue_pkey" in /mounts/max30/home/cath/1stsouth/www/includes/database.pgsql.inc on line 125.
* user warning: query: INSERT INTO subscriptions_queue (uid, name, mail, language, module, field, value, author_uid, send_interval, digest, last_sent, load_function, load_args, is_new) SELECT u.uid, u.name, u.mail, u.language, s.module, s.field, s.value, s.author_uid, s.send_interval, su.digest, su.last_sent, 'subscriptions_content_comment_load', '30', '1' FROM subscriptions s INNER JOIN subscriptions_user su ON s.recipient_uid = su.uid INNER JOIN users u USING(uid) WHERE s.module = 'node' AND s.field = 'nid' AND s.author_uid IN (4, -1) AND s.send_comments = 1 AND s.value = '12' in /mounts/max30/home/cath/1stsouth/www/includes/database.pgsql.inc on line 144.

when trying to reply to a comment in the forum.

If you need access to the site this can be provided.

bfo’s picture

bfo commented

I'll post this as a new issue

salvis’s picture

salvis
he/his
commented

feel free to prod me if you want someone to test, Every so often i don't check the drupal site for a while but will still happily test.

Great, thank you very much! Looks like pgsql testing is badly needed...

Anonymous’s picture

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

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