I made the DDL change to #__cbsubs_subscriptions.next_event_params, and then changed all text fields to reflect the default database character set and collation.
Reinstalled CBSubs using the download package - same error:
Looks like cbsubs_history this time
I'll install a copy on a fresh J4 install and compare the tables...
System Information
Joomla: 4.4.10
Community Builder: 2.10.0
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_histo...', 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/components/com_comprofiler/plugin/user/plug_cbpackageinstaller/admin.packageinstaller.php(404): cbInstallerPlugin->install()
#8 /home/fdinkler/public_html/components/com_comprofiler/plugin/user/plug_cbpackageinstaller/admin.packageinstaller.php(158): packageinstallerInstall->installCBPlugin('004-002_cbplug_...', '/home/fdinkler/...')
#9 /home/fdinkler/public_html/components/com_comprofiler/plugin/user/plug_cbpackageinstaller/admin.packageinstaller.php(90): packageinstallerInstall->prepare()
#10 /home/fdinkler/public_html/components/com_comprofiler/plugin/user/plug_cbpackageinstaller/admin.packageinstaller.php(36): packageinstallerInstall->install()
#11 /home/fdinkler/public_html/administrator/components/com_comprofiler/controller/controller.plugin.php(279): cbpackageinstallerAdmin->editPluginView(Object(CB\Database\Table\PluginTable), 'com_comprofiler', 'editPlugin', 265, 'installpkg', Object(CBLib\Xml\SimpleXMLElement), 'editPlugin', Object(CBLib\Registry\Registry))
#12 /home/fdinkler/public_html/administrator/components/com_comprofiler/controller/controller.plugin.php(208): CBController_plugin->editPluginView(Object(CB\Database\Table\PluginTable), 'com_comprofiler', 'editPlugin', 265, 'installpkg', Object(CBLib\Xml\SimpleXMLElement), 'editPlugin', Object(CBLib\Registry\Registry))
#13 /home/fdinkler/public_html/administrator/components/com_comprofiler/admin.comprofiler.controller.php(296): CBController_plugin->editPlugin('com_comprofiler', 'editPlugin', 265)
#14 /home/fdinkler/public_html/administrator/components/com_comprofiler/comprofiler.php(14): require('/home/fdinkler/...')
#15 /home/fdinkler/public_html/libraries/src/Dispatcher/LegacyComponentDispatcher.php(71): require_once('/home/fdinkler/...')
#16 /home/fdinkler/public_html/libraries/src/Dispatcher/LegacyComponentDispatcher.php(73): Joomla\CMS\Dispatcher\LegacyComponentDispatcher::Joomla\CMS\Dispatcher\{closure}('/home/fdinkler/...')
#17 /home/fdinkler/public_html/libraries/src/Component/ComponentHelper.php(361): Joomla\CMS\Dispatcher\LegacyComponentDispatcher->dispatch()
#18 /home/fdinkler/public_html/libraries/src/Application/AdministratorApplication.php(143): Joomla\CMS\Component\ComponentHelper::renderComponent('com_comprofiler')
#19 /home/fdinkler/public_html/libraries/src/Application/AdministratorApplication.php(186): Joomla\CMS\Application\AdministratorApplication->dispatch()
#20 /home/fdinkler/public_html/libraries/src/Application/CMSApplication.php(293): Joomla\CMS\Application\AdministratorApplication->doExecute()
#21 /home/fdinkler/public_html/administrator/includes/app.php(61): Joomla\CMS\Application\CMSApplication->execute()
#22 /home/fdinkler/public_html/administrator/index.php(32): require_once('/home/fdinkler/...')
#23 {main}
krileon
