How are you trying to update? Download manually or using CBs built in Install from Web? If manually are you trying to update from within Joomlas extensions page or from within CBs plugin install page?
I'm trying to update using CB's plugin install page. I tried both the install from web option and the install from local file option, and got the same result.
Running "Check Community Builder Plugins Database" returns the following:
Code:
CB plugin "CB Paid Subscriptions" database structure differences:
Table #__cbsubs_notifications Column receiver_id type is text instead of varchar(255)
Table #__cbsubs_notifications Column custom type is text instead of varchar(255)
Table #__cbsubs_notifications Column invoice type is text instead of varchar(255)
Table #__cbsubs_notifications Column memo type is text instead of varchar(255)
Table #__cbsubs_notifications Column option_name1 type is text instead of varchar(255)
Table #__cbsubs_notifications Column option_selection1 type is text instead of varchar(255)
Table #__cbsubs_notifications Column option_name2 type is text instead of varchar(255)
Table #__cbsubs_notifications Column option_selection2 type is text instead of varchar(255)
Table #__cbsubs_notifications Column auth_id type is text instead of varchar(255)
Table #__cbsubs_notifications Column auth_exp type is text instead of varchar(255)
Table #__cbsubs_notifications Column auth_amount type is text instead of varchar(255)
Table #__cbsubs_notifications Column auth_status type is text instead of varchar(255)
Table #__cbsubs_notifications Column num_cart_items type is text instead of varchar(255)
Table #__cbsubs_notifications Column payment_date type is text instead of varchar(255)
Table #__cbsubs_notifications Column reason_code type is text instead of varchar(255)
Table #__cbsubs_notifications Column remaining_settle type is text instead of varchar(255)
Table #__cbsubs_notifications Column transaction_entitiy type is text instead of varchar(255)
Table #__cbsubs_notifications Column mc_currency type is text instead of varchar(255)
Table #__cbsubs_notifications Column settle_currency type is text instead of varchar(255)
Table #__cbsubs_notifications Column auction_buyer_id type is text instead of varchar(255)
Table #__cbsubs_notifications Column auction_closing_date type is text instead of varchar(255)
Table #__cbsubs_notifications Column auction_multi_item type is text instead of varchar(255)
Table #__cbsubs_notifications Column for_auction type is text instead of varchar(255)
Table #__cbsubs_notifications Column subscr_date type is text instead of varchar(255)
Table #__cbsubs_notifications Column subscr_effective type is text instead of varchar(255)
Table #__cbsubs_notifications Column period1 type is text instead of varchar(255)
Table #__cbsubs_notifications Column period2 type is text instead of varchar(255)
Table #__cbsubs_notifications Column period3 type is text instead of varchar(255)
Table #__cbsubs_notifications Column username type is text instead of varchar(255)
Table #__cbsubs_notifications Column password type is text instead of varchar(255)
Table #__cbsubs_notifications Column subscr_id type is text instead of varchar(255)
Table #__cbsubs_notifications Column case_id type is text instead of varchar(255)
Table #__cbsubs_notifications Column case_type type is text instead of varchar(255)
Table #__cbsubs_notifications Column case_creation_date type is text instead of varchar(255)
Table #__cbsubs_payment_baskets Column payment_method type is text instead of varchar(255)
Table #__cbsubs_payment_baskets Column shared_secret type is text instead of varchar(255)
Table #__cbsubs_payment_baskets Column ip_addresses type is text instead of varchar(255)
Table #__cbsubs_payment_baskets Column charset type is text instead of varchar(255)
Table #__cbsubs_payment_baskets Column address_name type is text instead of varchar(255)
Table #__cbsubs_payment_baskets Column address_street type is text instead of varchar(255)
Table #__cbsubs_payment_baskets Column address_city type is text instead of varchar(255)
Table #__cbsubs_payment_baskets Column address_state type is text instead of varchar(255)
Table #__cbsubs_payment_baskets Column address_zip type is text instead of varchar(255)
Table #__cbsubs_payment_baskets Column address_country type is text instead of varchar(255)
Table #__cbsubs_payment_baskets Column address_country_code type is text instead of varchar(255)
Table #__cbsubs_payment_baskets Column address_status type is text instead of varchar(255)
Table #__cbsubs_payment_baskets Column first_name type is text instead of varchar(255)
Table #__cbsubs_payment_baskets Column last_name type is text instead of varchar(255)
Table #__cbsubs_payment_baskets Column payer_business_name type is text instead of varchar(255)
Table #__cbsubs_payment_baskets Column payer_email type is text instead of varchar(255)
Table #__cbsubs_payment_baskets Column payer_id type is text instead of varchar(255)
Table #__cbsubs_payment_baskets Column residence_country type is text instead of varchar(255)
Table #__cbsubs_payment_baskets Column business type is text instead of varchar(255)
Table #__cbsubs_payment_baskets Column item_name type is text instead of varchar(255)
Table #__cbsubs_payment_baskets Column item_number type is text instead of varchar(255)
Table #__cbsubs_payment_baskets Column receiver_id type is text instead of varchar(255)
Table #__cbsubs_payment_baskets Column custom type is text instead of varchar(255)
Table #__cbsubs_payment_baskets Column invoice type is text instead of varchar(255)
Table #__cbsubs_payment_baskets Column proformainvoice type is text instead of varchar(255)
Table #__cbsubs_payment_baskets Column memo type is text instead of varchar(255)
Table #__cbsubs_payment_baskets Column option_name1 type is text instead of varchar(255)
Table #__cbsubs_payment_baskets Column option_selection1 type is text instead of varchar(255)
Table #__cbsubs_payment_baskets Column option_name2 type is text instead of varchar(255)
Table #__cbsubs_payment_baskets Column option_selection2 type is text instead of varchar(255)
Table #__cbsubs_payment_baskets Column auth_id type is text instead of varchar(255)
Table #__cbsubs_payment_baskets Column auth_exp type is text instead of varchar(255)
Table #__cbsubs_payment_baskets Column auth_amount type is text instead of varchar(255)
Table #__cbsubs_payment_baskets Column auth_status type is text instead of varchar(255)
Table #__cbsubs_payment_baskets Column num_cart_items type is text instead of varchar(255)
Table #__cbsubs_payment_baskets Column payment_date type is text instead of varchar(255)
Table #__cbsubs_payment_baskets Column reason_code type is text instead of varchar(255)
Table #__cbsubs_payment_baskets Column remaining_settle type is text instead of varchar(255)
Table #__cbsubs_payment_baskets Column transaction_entitiy type is text instead of varchar(255)
Table #__cbsubs_payment_baskets Column mc_currency type is text instead of varchar(255)
Table #__cbsubs_payment_baskets Column settle_currency type is text instead of varchar(255)
Table #__cbsubs_payment_baskets Column auction_buyer_id type is text instead of varchar(255)
Table #__cbsubs_payment_baskets Column auction_closing_date type is text instead of varchar(255)
Table #__cbsubs_payment_baskets Column auction_multi_item type is text instead of varchar(255)
Table #__cbsubs_payment_baskets Column for_auction type is text instead of varchar(255)
Table #__cbsubs_payment_baskets Column subscr_date type is text instead of varchar(255)
Table #__cbsubs_payment_baskets Column subscr_effective type is text instead of varchar(255)
Table #__cbsubs_payment_baskets Column period1 type is text instead of varchar(255)
Table #__cbsubs_payment_baskets Column period2 type is text instead of varchar(255)
Table #__cbsubs_payment_baskets Column period3 type is text instead of varchar(255)
Table #__cbsubs_payment_baskets Column username type is text instead of varchar(255)
Table #__cbsubs_payment_baskets Column password type is text instead of varchar(255)
Table #__cbsubs_payment_baskets Column subscr_id type is text instead of varchar(255)
Table #__cbsubs_payment_baskets Column case_id type is text instead of varchar(255)
Table #__cbsubs_payment_baskets Column case_type type is text instead of varchar(255)
Table #__cbsubs_payment_baskets Column case_creation_date type is text instead of varchar(255)
Table #__cbsubs_payments Column payment_method type is text instead of varchar(255)
Table #__cbsubs_payments Column ip_addresses type is text instead of varchar(255)
Table #__cbsubs_payments Column notify_version type is text instead of varchar(255)
Table #__cbsubs_payments Column verify_sign type is text instead of varchar(255)
Table #__cbsubs_payments Column charset type is text instead of varchar(255)
Table #__cbsubs_payments Column address_name type is text instead of varchar(255)
Table #__cbsubs_payments Column address_street type is text instead of varchar(255)
Table #__cbsubs_payments Column address_city type is text instead of varchar(255)
Table #__cbsubs_payments Column address_state type is text instead of varchar(255)
Table #__cbsubs_payments Column address_zip type is text instead of varchar(255)
Table #__cbsubs_payments Column address_country type is text instead of varchar(255)
Table #__cbsubs_payments Column address_country_code type is text instead of varchar(255)
Table #__cbsubs_payments Column address_status type is text instead of varchar(255)
Table #__cbsubs_payments Column first_name type is text instead of varchar(255)
Table #__cbsubs_payments Column last_name type is text instead of varchar(255)
Table #__cbsubs_payments Column payer_business_name type is text instead of varchar(255)
Table #__cbsubs_payments Column payer_email type is text instead of varchar(255)
Table #__cbsubs_payments Column payer_id type is text instead of varchar(255)
Table #__cbsubs_payments Column residence_country type is text instead of varchar(255)
Table #__cbsubs_payments Column business type is text instead of varchar(255)
Table #__cbsubs_payments Column item_name type is text instead of varchar(255)
Table #__cbsubs_payments Column item_number type is text instead of varchar(255)
Table #__cbsubs_payments Column receiver_email type is text instead of varchar(255)
Table #__cbsubs_payments Column receiver_id type is text instead of varchar(255)
Table #__cbsubs_payments Column custom type is text instead of varchar(255)
Table #__cbsubs_payments Column invoice type is text instead of varchar(255)
Table #__cbsubs_payments Column memo type is text instead of varchar(255)
Table #__cbsubs_payments Column option_name1 type is text instead of varchar(255)
Table #__cbsubs_payments Column option_selection1 type is text instead of varchar(255)
Table #__cbsubs_payments Column option_name2 type is text instead of varchar(255)
Table #__cbsubs_payments Column option_selection2 type is text instead of varchar(255)
Table #__cbsubs_payments Column auth_id type is text instead of varchar(255)
Table #__cbsubs_payments Column auth_exp type is text instead of varchar(255)
Table #__cbsubs_payments Column auth_amount type is text instead of varchar(255)
Table #__cbsubs_payments Column auth_status type is text instead of varchar(255)
Table #__cbsubs_payments Column num_cart_items type is text instead of varchar(255)
Table #__cbsubs_payments Column payment_date type is text instead of varchar(255)
Table #__cbsubs_payments Column reason_code type is text instead of varchar(255)
Table #__cbsubs_payments Column remaining_settle type is text instead of varchar(255)
Table #__cbsubs_payments Column transaction_entitiy type is text instead of varchar(255)
Table #__cbsubs_payments Column mc_currency type is text instead of varchar(255)
Table #__cbsubs_payments Column settle_currency type is text instead of varchar(255)
Table #__cbsubs_payments Column auction_buyer_id type is text instead of varchar(255)
Table #__cbsubs_payments Column auction_closing_date type is text instead of varchar(255)
Table #__cbsubs_payments Column auction_multi_item type is text instead of varchar(255)
Table #__cbsubs_payments Column for_auction type is text instead of varchar(255)
Table #__cbsubs_payments Column subscr_date type is text instead of varchar(255)
Table #__cbsubs_payments Column subscr_effective type is text instead of varchar(255)
Table #__cbsubs_payments Column period1 type is text instead of varchar(255)
Table #__cbsubs_payments Column period2 type is text instead of varchar(255)
Table #__cbsubs_payments Column period3 type is text instead of varchar(255)
Table #__cbsubs_payments Column retry_at type is text instead of varchar(255)
Table #__cbsubs_payments Column username type is text instead of varchar(255)
Table #__cbsubs_payments Column password type is text instead of varchar(255)
Table #__cbsubs_payments Column subscr_id type is text instead of varchar(255)
Table #__cbsubs_payments Column case_id type is text instead of varchar(255)
Table #__cbsubs_payments Column case_type type is text instead of varchar(255)
Table #__cbsubs_payments Column case_creation_date type is text instead of varchar(255)
Table #__cbsubs_plans Column item_alias type is text instead of varchar(255)
Table #__cbsubs_plans Column hideregistrationfields type is varchar(512) instead of text
Table #__cbsubs_plans Column cond_1_basket_gatewayaccounts type is varchar(128) instead of text
Table #__cbsubs_plans Column cond_1_basket_payment_methods type is varchar(256) instead of text
Table #__cbsubs_plans Column cond_1_basket_payment_types type is varchar(256) instead of text
Table #__cbsubs_plans Column cond_2_basket_gatewayaccounts type is varchar(128) instead of text
Table #__cbsubs_plans Column cond_2_basket_payment_methods type is varchar(256) instead of text
Table #__cbsubs_plans Column cond_2_basket_payment_types type is varchar(256) instead of text
The CB plugin "CB Paid Subscriptions" database structure differences can be fixed (adjusted) by clicking here: Click here to fix (adjust) all CB plugin "CB Paid Subscriptions" database differences listed above (you can also Click here to preview fixing (adjusting) queries in a dry-run), but in all cases you need to backup database first as this adjustment is changing the database structure to match the needed structure for the installed version.
Hm. This reminds me that I'm using MariaDB (version listed below), rather than MySQL, which could be the cause of the problems above. I'm not sure what the right fix would be. I've fixed a similar issue before by converting varchar to text columns in the schema; I will look into whether that will solve this problem.
Code:
$ mysql --version
mysql Ver 15.1 Distrib 10.3.27-MariaDB, for Linux (x86_64) using readline 5.1
I see Joomla & Community Builder do not officially support MariaDB, according to
www.joomlapolis.com/forum/153-professional-member-support/242326-solved-cb-field-groups
. So if that means you can't provide further advice, I understand.
Kind regards,
Tim
krileon
