Skip to Content Skip to Menu

CB Paid Subscriptions = update error

  • fdinkler
  • fdinkler
  • ONLINE
  • Posts: 224
  • Thanks: 27
  • Karma: 0
3 hours 52 minutes ago - 3 hours 47 minutes ago #340210 by fdinkler
CB Paid Subscriptions = update error was created by fdinkler
Attempting to update CB using Install Plugins from Web, 
the latest CB Paid Subscriptions failed install...
However, the Community Builder: Plugin Management page shows 4.8.0+build.2025.02.03.17.52.54.76d74952e as installed

Details:
System Information
Joomla: 4.4.10
Community Builder: 2.9.3
PHP: 8.3.16
Database: mysql 8.0.41

Package
File: 004-002_cbplug_CBSubs_MAIN-4.8.0+build.2025.02.03.17.52.54.76d74952e.zip
Log:
Code:
Invalid use of NULL value
Last edit: 3 hours 47 minutes ago by fdinkler. Reason: Additional info

Please Log in or Create an account to join the conversation.

  • krileon
  • krileon
  • ONLINE
  • Posts: 48768
  • Thanks: 8328
  • Karma: 1448
3 hours 23 minutes ago #340212 by krileon
Replied by krileon on topic CB Paid Subscriptions = update error
Strange, seams to install ok in my tests. Do you recall what version you were updating from? We've also released CB 2.10.0 and recommend installing it then trying again as that might help. If still erroring please enable debug mode and maximum error reporting in Joomla global configuration then retry and see if the install error exposes anything further as to where the error is coming from exactly.

Kyle (Krileon)
Community Builder Team Member
Before posting on forums: Read FAQ thoroughly + Read our Documentation + Search the forums
CB links: Documentation - Localization - CB Quickstart - CB Paid Subscriptions - Add-Ons - Forge
--
If you are a Professional, Developer, or CB Paid Subscriptions subscriber and have a support issue please always post in your respective support forums for best results!
--
If I've missed your support post with a delay of 3 days or greater and are a Professional, Developer, or CBSubs subscriber please send me a private message with your thread and will reply when possible!
--
Please note I am available Monday - Friday from 8:00 AM CST to 4:00 PM CST. I am away on weekends (Saturday and Sunday) and if I've missed your post on or before a weekend after business hours please wait for the next following business day (Monday) and will get to your issue as soon as possible, thank you.
--
My role here is to provide guidance and assistance. I cannot provide custom code for each custom requirement. Please do not inquire me about custom development.

Please Log in or Create an account to join the conversation.

  • fdinkler
  • fdinkler
  • ONLINE
  • Posts: 224
  • Thanks: 27
  • Karma: 0
3 hours 8 minutes ago #340214 by fdinkler
Replied by fdinkler on topic CB Paid Subscriptions = update error
Downloaded the install pkg, same result.
Debug listing below.
Looks like a possible database error - is there a field update that's NULL that can't be according MySQL STRICT rules?

System Information
Joomla: 4.4.10
PHP: 8.3.16
Database: mysql 8.0.41

Package
File: 004-002_cbplug_CBSubs_MAIN-4.8.0+build.2025.02.03.17.52.54.76d74952e.zip
Log:
Code:
Invalid use of NULL value #0 /home/fdinkler/public_html/libraries/vendor/joomla/database/src/DatabaseDriver.php(675): Joomla\Database\Mysqli\MysqliStatement->execute() #1 /home/fdinkler/public_html/libraries/CBLib/CBLib/Database/Driver/CmsDatabaseDriver.php(326): Joomla\Database\DatabaseDriver->execute() #2 /home/fdinkler/public_html/libraries/CBLib/CBLib/Database/DatabaseUpgrade.php(1980): CBLib\Database\Driver\CmsDatabaseDriver->query() #3 /home/fdinkler/public_html/libraries/CBLib/CBLib/Database/DatabaseUpgrade.php(1246): CBLib\Database\DatabaseUpgrade->doQuery('ALTER TABLE `#_...') #4 /home/fdinkler/public_html/libraries/CBLib/CBLib/Database/DatabaseUpgrade.php(324): CBLib\Database\DatabaseUpgrade->changeColumn('#__cbsubs_subsc...', Array, Object(CBLib\Xml\SimpleXMLElement), 'cbpaidsubscript...', Object(CBLib\Xml\SimpleXMLElement)) #5 /home/fdinkler/public_html/libraries/CBLib/CBLib/Database/DatabaseUpgrade.php(254): CBLib\Database\DatabaseUpgrade->checkXmlTableDescription(Object(CBLib\Xml\SimpleXMLElement), 'cbpaidsubscript...', true, true, NULL, NULL) #6 /home/fdinkler/public_html/libraries/CBLib/CB/Legacy/cbInstallerPlugin.php(376): CBLib\Database\DatabaseUpgrade->checkXmlDatabaseDescription(Object(CBLib\Xml\SimpleXMLElement), 'cbpaidsubscript...', true) #7 /home/fdinkler/public_html/administrator/components/com_packageinstaller/admin.packageinstaller.php(404): cbInstallerPlugin->install() #8 /home/fdinkler/public_html/administrator/components/com_packageinstaller/admin.packageinstaller.php(158): packageinstallerInstall->installCBPlugin('004-002_cbplug_...', '/home/fdinkler/...') #9 /home/fdinkler/public_html/administrator/components/com_packageinstaller/admin.packageinstaller.php(90): packageinstallerInstall->prepare() #10 /home/fdinkler/public_html/administrator/components/com_packageinstaller/packageinstaller.php(14): packageinstallerInstall->install() #11 /home/fdinkler/public_html/libraries/src/Dispatcher/LegacyComponentDispatcher.php(71): require_once('/home/fdinkler/...') #12 /home/fdinkler/public_html/libraries/src/Dispatcher/LegacyComponentDispatcher.php(73): Joomla\CMS\Dispatcher\LegacyComponentDispatcher::Joomla\CMS\Dispatcher\{closure}('/home/fdinkler/...') #13 /home/fdinkler/public_html/libraries/src/Component/ComponentHelper.php(361): Joomla\CMS\Dispatcher\LegacyComponentDispatcher->dispatch() #14 /home/fdinkler/public_html/libraries/src/Application/AdministratorApplication.php(143): Joomla\CMS\Component\ComponentHelper::renderComponent('com_packageinst...') #15 /home/fdinkler/public_html/libraries/src/Application/AdministratorApplication.php(186): Joomla\CMS\Application\AdministratorApplication->dispatch() #16 /home/fdinkler/public_html/libraries/src/Application/CMSApplication.php(293): Joomla\CMS\Application\AdministratorApplication->doExecute() #17 /home/fdinkler/public_html/administrator/includes/app.php(61): Joomla\CMS\Application\CMSApplication->execute() #18 /home/fdinkler/public_html/administrator/index.php(32): require_once('/home/fdinkler/...') #19 {main}

Please Log in or Create an account to join the conversation.

  • krileon
  • krileon
  • ONLINE
  • Posts: 48768
  • Thanks: 8328
  • Karma: 1448
2 hours 44 minutes ago #340215 by krileon
Replied by krileon on topic CB Paid Subscriptions = update error
Ok, looks like a table structure change on the _cbsubs_subscriptions table is failing. I'm not sure what column is doing it exactly though as the alter table query is cut off too early in the debug log. If you've access to phpmyadmin please be sure your _cbsubs_subscriptions table has the below structure.

 

My best guess as to what's going on is since your install has been around so long there's a database structure change we're not taking into account. Did this only happen with this most recent update? If you can recall what version you were previously using I can compare the two and see what table structure change happened between the two versions.

Kyle (Krileon)
Community Builder Team Member
Before posting on forums: Read FAQ thoroughly + Read our Documentation + Search the forums
CB links: Documentation - Localization - CB Quickstart - CB Paid Subscriptions - Add-Ons - Forge
--
If you are a Professional, Developer, or CB Paid Subscriptions subscriber and have a support issue please always post in your respective support forums for best results!
--
If I've missed your support post with a delay of 3 days or greater and are a Professional, Developer, or CBSubs subscriber please send me a private message with your thread and will reply when possible!
--
Please note I am available Monday - Friday from 8:00 AM CST to 4:00 PM CST. I am away on weekends (Saturday and Sunday) and if I've missed your post on or before a weekend after business hours please wait for the next following business day (Monday) and will get to your issue as soon as possible, thank you.
--
My role here is to provide guidance and assistance. I cannot provide custom code for each custom requirement. Please do not inquire me about custom development.

Please Log in or Create an account to join the conversation.

  • fdinkler
  • fdinkler
  • ONLINE
  • Posts: 224
  • Thanks: 27
  • Karma: 0
2 hours 19 minutes ago #340216 by fdinkler
Replied by fdinkler on topic CB Paid Subscriptions = update error
Kyle - 
I update CB plugins every month, so the prior release would have been one of more recent versions.
I'll check the db table...

Note: I've had to modify the DDL on more than a few extension tables due to MySQL STRICT mode, mostly due to NULL datetime fields.

Thanks,
Fred

Please Log in or Create an account to join the conversation.

  • krileon
  • krileon
  • ONLINE
  • Posts: 48768
  • Thanks: 8328
  • Karma: 1448
2 hours 9 minutes ago #340217 by krileon
Replied by krileon on topic CB Paid Subscriptions = update error
Strict shouldn't have mattered as Joomla clears that before performing a query. Did CBSubs install fine after correcting the structure manually?

Kyle (Krileon)
Community Builder Team Member
Before posting on forums: Read FAQ thoroughly + Read our Documentation + Search the forums
CB links: Documentation - Localization - CB Quickstart - CB Paid Subscriptions - Add-Ons - Forge
--
If you are a Professional, Developer, or CB Paid Subscriptions subscriber and have a support issue please always post in your respective support forums for best results!
--
If I've missed your support post with a delay of 3 days or greater and are a Professional, Developer, or CBSubs subscriber please send me a private message with your thread and will reply when possible!
--
Please note I am available Monday - Friday from 8:00 AM CST to 4:00 PM CST. I am away on weekends (Saturday and Sunday) and if I've missed your post on or before a weekend after business hours please wait for the next following business day (Monday) and will get to your issue as soon as possible, thank you.
--
My role here is to provide guidance and assistance. I cannot provide custom code for each custom requirement. Please do not inquire me about custom development.

Please Log in or Create an account to join the conversation.

Moderators: beat, nant, krileon
Powered by Kunena Forum