A user can purchase multiple subscriptions (one for each campaign they create). I wrote the following SQL query and placed it in the activation field for the only plan I have available:

UPDATE `#__campaigns` SET `paid` = 1, `status` = 1 WHERE `id` = [cb_currentcampaign] AND `user_id`=[user_id]

cb_currentcampaign is a published cb field which contains the selected campaign (tested and it is getting set).

When I proceed with the purchase everything works fine. Upon return to the site I get the "Thank you for subscribing page" and a link to the invoice. But the query (above) never got called.

Any idea's?

Post edited by: krileon, at: 2010/11/16 18:42

I enabled debug mode and maximum error reporting in Joomla global configuration (I am getting the debug output at the bottom of the screen).

I also ensured that the SQL actions plugin is published and set to Public.

The debug output does not show the query I have in SQL actions for the plan (the only plan I have setup).

I am using PayPal as the payment gateway, so the site redirects to the secure paypal page and on success it redirects you back to the payment successful page. When is the SQL action plugin actually get called? On success of the payment?