[#7098] onCPayUserStateChange only trigger from backend

I'm exporting donations to an external database, first I tried with SQL Action but nothing fires at all there, tested with simple queries to an external database and nothing.

So I turned to AutoAction and got it to work perfect, tested by addding the donation from backend on a user. But then when someone actually donated and payed using paypal it was not triggered anymore so I'm abit confused why.

onCPayUserStateChange
[var3] Equal to 3
[var2] Equal to A

I use this to fire a simple php script that fetch the donation amount from the last donation made by the user and insert it into the external database. Works perfect from the backend on any user I tried.

I'm exporting donations to an external database, first I tried with SQL Action but nothing fires at all there, tested with simple queries to an external database and nothing.

Should work perfectly fine for donations. There are no renewals for donation/merchandise plan so it should always fire the "Activation" state for integrations for donations/merchandise plans.

So I turned to AutoAction and got it to work perfect, tested by addding the donation from backend on a user. But then when someone actually donated and payed using paypal it was not triggered anymore so I'm abit confused why.

No idea, payment method should be irrelevant. You are only checking the activate state though. Is the payment pending at PayPal? Does it work fine from frontend using the dummy test gateway?

Well I tested SQL Action with a simple insert query with fake information that did work through phpmyadmin, the database information was correct and the query was on Activation, nothing. I only tried this adding a donation through the backend, never tested it from the frontend with a real donation, should make no difference?

SQL Action is published and using version 4.2.0+build.2018.03.16.15.25.02.efb5cc37c
CB Subs 4.2.0+build.2018.03.16.15.25.02.efb5cc37c
AutoAction 7.2.0+build.2018.03.15.18.56.12.5d366d3e0
CB Version 2.1.3
Joomla version 3.8.2

All donations from backend manually and frontend using paypal are showing up in the donation list as Active. Maybe there is an old bugg here and I just need to update, Im worried about updating though since my CB Subs has expired and Im not sure about compability if I update CB.

I have no dummy gateway setup, will look into this since it could be useful for testing. The payment is not pending on paypal, I get redirected back to the site and it changes to Active in the donation list. But the phpscript isnt fired or it isnt getting the userid from frontend maybe, Im lost.

Updatelogs from Paypal donation:
Donation record created By user
Donation paid and activated By system
Old value R new value A

Updatelogs from backend donation:
Donation record created By admin
Donation paid and activated By admin
Old value I new value A
On this one it also has old value parent_plan 0 and parent_subscription 0 and new value for those is nothing, this is the only difference I see when checking the logs.

Edit: Removed userid and amount fetch from the phpscript and tested with a fake query to see if the was atleast triggered and it was not. I guess next step is to update everything to the latest version. Just noticed my CBSubs hasnt expired yet so I could update.

Remove your "[var2] Equal to A" condition and retry as it maybe the state check that's causing an issue.

Removed the condition but it did not trigger.

However I have now decided to put my website offline and turn on error messaging and got this:
Fatal error: Class 'cbDatabase' not found in components/com_comprofiler/plugin/user/plug_cbpaidsubscriptions/plugin/cbsubssqlactions/cbsubs.sqlactions.php on line 89

I did not bother to check why the backend crashed everytime I added a donation, since the donation itself worked from the backend, and since it does not crash when donating from the frontend I did not see the connection but maybe this is the culprit.

I also wrote the wrong version of AutoAction, I have AutoAction 6.3.7+build.2017.08.01.23.45.46.6a2833787 but this does not matter if I can get sqlaction to work instead.

Edit: Disabled sqlaction and then the autoaction started to work, so this can be considered solved. Although would be glad to know whats wrong with my sqlaction, I updated it but that did not fix it.

Thank you for providing the error. Was exactly what I needed to track this down. Appears to be a bug in the SQL Actions integrations external database connection API. I've added a bug ticket and submitted a fix for review and merge for next CBSubs build.

#7098