[#3833] Error when deleting Cbsubs users from backend

Hello

I noticed a strange thing. Sometime when I delete some users from backend, I get this error:

Fatal error: Call to undefined method stdClass::store() in <span>/</span>home<span>/</span>mysite/domains/test.mysite.com/public_html/components/com_comprofiler/plugin/user/plug_cbpaidsubscriptions/plugin/cbsubssqlactions/cbsubs.sqlactions.php on line 113

If I go back to CB User Management area and I make a page refresh, the subscription plan who was assigned to users who needed to be deleted disappear. Then I can without problem delete desired users.

The error seem to be related with plugin SQL Action and that right, I have some SQL queries set in my CBsubs Plans. However I don't know why I get this error. Maybe because I'm supposed to terminate/deactivate their plan before delete users ?

any suggestion ?

thank

I believe this was a bug in CB or perhaps just the SQL Actions plugin that has been fixed already. Please try upgrading to CB 1.9 and see if issue persists. If it does ensure the CBSubs SQL Actions installed is 2.0.2.

I installed CB 1.9 and checked if SQL plugin is well the version 2.0.2 but the issue persist...

Is not a big deal but it seem something is wrong somewhere...

Was able to confirm your issue and have created a bug ticket for further investigation. For now please remove the subscription before deleting the user.

#3833

Was able to determine this is a bug in CB and not in CBSubs. I've proposed a patch to fix the issue, please see the below bug ticket.

forge.joomlapolis.com/issues/3833

I made many test these last weeks and I created a bunch of fake users. I would like quickly remove these users and I seen you have published a patch. I downloaded the file and looked inside and I see some sql query who are probably supposed to fix the bug. However I have no idea how I must use this file. It is something who can be uploaded in database management tools such Virtualmin ?. Or I can copy his contain and run this as query ?