Skip to Content Skip to Menu

🎃 Happy Halloween! Treat yourself with an awesome discount on memberships! Get 20% off now with code SPOOKY-2024!

[SOLVED] CBSubs Mailer 500 Error After Updates

11 years 8 months ago - 11 years 8 months ago #221808 by cconner1000
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.
Last edit: 11 years 8 months ago by krileon.

Please Log in or Create an account to join the conversation.

  • beat
  • beat
  • ONLINE
  • Posts: 2169
  • Thanks: 463
  • Karma: 352
11 years 8 months ago - 11 years 8 months ago #221871 by beat
Replied by beat on topic CBSubs Mailer 500 Error After Updates
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

Beat - Community Builder Team Member

Before posting on forums: Read FAQ thoroughly -- Help us spend more time coding by helping others in this forum, many thanks :)
CB links: Our membership - CBSubs - Templates - Hosting - Forge - Send me a Private Message (PM) only for private/confidential info
Last edit: 11 years 8 months ago by beat. Reason: clarified

Please Log in or Create an account to join the conversation.

11 years 8 months ago #221896 by cconner1000
Replied by cconner1000 on topic CBSubs Mailer 500 Error After Updates
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
The following user(s) said Thank You: krileon

Please Log in or Create an account to join the conversation.

Moderators: beatnantkrileon
Powered by Kunena Forum