[SOLVED] CBSubs Mailer 500 Error After Updates

Joomla version: 2.5.9
CB version: 1.9
CBSubs version: 2.02

CB Tools were run and all are green.

Hi,

After updating CB to 1.9 and CBSubs to 2.02 I am now getting a 500 Error when running my Mailer Automation Settings. This was working before the updates.

JDatabaseMySQLi::query: 1064 - 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 'A 'R' ORDER BY m.`id` DESC' at line 5 SQL=SELECT * FROM `jml_cbsubs_subscriptions` AS m WHERE (m.`expiry_date` <= DATE_ADD( NOW(), INTERVAL 7 DAY )) AND (m.`expiry_date` >= DATE_SUB( NOW(), INTERVAL 7 DAY )) AND m.`plan_id` = 4 AND m.`status` A 'R' ORDER BY m.`id` DESC

Any help?

Thank you.

Sure!

You must have changed the conditions for the automailer too in addition of upgrading which triggered a bug which was there before CBSubs 2.0.2 most probably. , or turned joomla debug on which displayed that error message that was hidden before.

Looking at error message and understanding it: Your condition has status condition (in condition tab) of subscription as "Active" AND "Registered unpaid", leading to that error message (and if it would not bug, it wouldn't find any subscriptions to act upon). And the result when joomla debug is off and that error is not visible, is that it does what it should and doesn't find any subscriptions.

If you really need to send to all active and just subscribed without paying ones, please make 2 separate auto-mailers to work-around that bug.

That setting should be a drop-down single-select and not a multi-select:
#3913

THANK YOU!!!

This fixed it. I did just what you suggested and that will work fine for us.

Thank you so much for the quick response and fix.

Cindy