CBSubs VirtueMart - Unknown column 'perms'

CB 1.9.1, CBS 3.0.0, J 2.5.17, VM 2.0.26

We've been receiving this error message in the History logs: (USER WARNING: CBSubs VirtueMart - updateUser SQL Error: DB function failed with error number 1054 Unknown column 'perms' in 'field list' SQL=UPDATE `j25_virtuemart_userinfos`) ever since a November VM update (2.0.2x-something).

Since then, new member registrations have been getting assigned to the default shopper group in VirtueMart as well as other issues, including the md5(uniqid) userinfo_id problem. In reading through the forum I located fixes for most of the other issues, but have found nothing for the above permission error.

It's obvious that the cause of the error is because VM has moved the field for permissions (perms) from the virtuemart_userinfos table to the virtuemart_vmusers table in one of the recent updates. I've located the code that assigns the perms values, but I'm not sure how to make the proper changes to the cbsubs.virtuemart.php file.

I know this isn't caused by CBSubs, but our members are getting quite perturbed that they are not receiving members discounts in VM. Is there an update or patch to cbsubs.virtuemart.php or any advice on the code to change?

TIA

Delete lines 337-341 in the below file and see if your issue resolves. That's where perms is being set for VM2 usage. Probably needs to be removed for next release.

components/com_comprofiler/plugin/user/plug_cbpaidsubscriptions/plugin/cbsubsvirtuemart/cbsubs.virtuemart.php