Bug #8901
closedJoomla 4.1 and MariaDB 3.10: Clean install errors with "Field 'description' doesn't have a default value"
Description
Details:
System Information
Joomla: 4.1.0
PHP: 7.4.14
Database: mysql 10.3.31-MariaDB-0+deb10u1
Package
File: 999_plug_cbquickstart_1.0.0+build.2021.10.11.16.00.23.8f78a3960.zip
Log:
[code]
Field 'description' doesn't have a default value
#0 libraries/vendor/joomla/database/src/DatabaseDriver.php(675): Joomla\Database\Mysqli\MysqliStatement->execute()
#1 libraries/vendor/joomla/database/src/Mysqli/MysqliDriver.php(776): Joomla\Database\DatabaseDriver->execute()
#2 libraries/CBLib/CBLib/Database/Driver/CmsDatabaseDriver.php(531): Joomla\Database\Mysqli\MysqliDriver->insertObject('#__comprofiler_...', Object(CB\Database\Table\FieldTable), 'fieldid')
#3 libraries/CBLib/CBLib/Database/Table/Table.php(161): CBLib\Database\Driver\CmsDatabaseDriver->insertObject('#__comprofiler_...', Object(CB\Database\Table\FieldTable), 'fieldid')
#4 libraries/CBLib/CBLib/Database/Table/OrderedTable.php(69): CBLib\Database\Table\Table->store(false)
#5 libraries/CBLib/CB/Database/Table/FieldTable.php(320): CBLib\Database\Table\OrderedTable->store(false)
#6 components/com_comprofiler/plugin/user/plug_cbquickstart/library/Installer.php(934): CB\Database\Table\FieldTable->store()
#7 components/com_comprofiler/plugin/user/plug_cbquickstart/install.cbquickstart.php(24): CB\Plugin\Quickstart\Installer::install()
#8 libraries/CBLib/CB/Legacy/cbInstallerPlugin.php(638): plug_cbquickstart_install(Object(cbInstallerPlugin), Object(CB\Database\Table\PluginTable), false, '1.0.0+build.202...')
#9 administrator/components/com_packageinstaller/admin.packageinstaller.php(362): cbInstallerPlugin->install()
#10 administrator/components/com_packageinstaller/admin.packageinstaller.php(127): packageinstallerInstall->installCBPlugin('999_plug_cbquic...', '/var/www/h75644...')
#11 administrator/components/com_packageinstaller/admin.packageinstaller.php(62): packageinstallerInstall->prepare()
#12 administrator/components/com_packageinstaller/packageinstaller.php(16): packageinstallerInstall->install()
#13 libraries/src/Dispatcher/LegacyComponentDispatcher.php(69): require_once('/var/www/h75644...')
#14 libraries/src/Dispatcher/LegacyComponentDispatcher.php(71): Joomla\CMS\Dispatcher\LegacyComponentDispatcher::Joomla\CMS\Dispatcher\{closure}('/var/www/h75644...')
#15 libraries/src/Component/ComponentHelper.php(389): Joomla\CMS\Dispatcher\LegacyComponentDispatcher->dispatch()
#16 libraries/src/Application/AdministratorApplication.php(143): Joomla\CMS\Component\ComponentHelper::renderComponent('com_packageinst...')
#17 libraries/src/Application/AdministratorApplication.php(186): Joomla\CMS\Application\AdministratorApplication->dispatch()
#18 libraries/src/Application/CMSApplication.php(278): Joomla\CMS\Application\AdministratorApplication->doExecute()
#19 administrator/includes/app.php(63): Joomla\CMS\Application\CMSApplication->execute()
#20 administrator/index.php(32): require_once('/var/www/h75644...')
#21 {main}
[/code]
On second installation, no errors, but menus and parametrization of CB is not done.
When clicking "Reinstall" button in CB Plugin management, error is outputed:
Field 'description' doesn't have a default value
<br >
#0 libraries/vendor/joomla/database/src/DatabaseDriver.php(675): Joomla\Database\Mysqli\MysqliStatement->execute()
#1 libraries/vendor/joomla/database/src/Mysqli/MysqliDriver.php(776): Joomla\Database\DatabaseDriver->execute()
#2 libraries/CBLib/CBLib/Database/Driver/CmsDatabaseDriver.php(531): Joomla\Database\Mysqli\MysqliDriver->insertObject('#__comprofiler_...', Object(CB\Database\Table\FieldTable), 'fieldid')
#3 libraries/CBLib/CBLib/Database/Table/Table.php(161): CBLib\Database\Driver\CmsDatabaseDriver->insertObject('#__comprofiler_...', Object(CB\Database\Table\FieldTable), 'fieldid')
#4 libraries/CBLib/CBLib/Database/Table/OrderedTable.php(69): CBLib\Database\Table\Table->store(false)
#5 libraries/CBLib/CB/Database/Table/FieldTable.php(320): CBLib\Database\Table\OrderedTable->store(false)
#6 components/com_comprofiler/plugin/user/plug_cbquickstart/library/Installer.php(934): CB\Database\Table\FieldTable->store()
#7 components/com_comprofiler/plugin/user/plug_cbquickstart/library/Installer.php(2635): CB\Plugin\Quickstart\Installer::install()
#8 libraries/CBLib/CBLib/AhaWow/View/RegistryEditView.php(4948): CB\Plugin\Quickstart\Installer::reinstall(NULL, Object(CBLib\Registry\Registry), '', Object(CBLib\Xml\SimpleXMLElement), NULL, '', true, Object(CBLib\Registry\Registry), NULL, NULL)
#9 [internal function]: CBLib\AhaWow\View\RegistryEditView->_form_private('', NULL, Object(CBLib\Xml\SimpleXMLElement), NULL)
#10 libraries/CBLib/CBLib/AhaWow/View/RegistryEditView.php(3635): call_user_func(Array, '', NULL, Object(CBLib\Xml\SimpleXMLElement), NULL)
#11 libraries/CBLib/CBLib/AhaWow/View/RegistryEditView.php(1539): CBLib\AhaWow\View\RegistryEditView->renderParam(Object(CBLib\Xml\SimpleXMLElement), NULL, true, 'none')
#12 libraries/CBLib/CBLib/AhaWow/View/RegistryEditView.php(1285): CBLib\AhaWow\View\RegistryEditView->renderOneParamAndChildren(Object(CBLib\Xml\SimpleXMLElement), NULL, Object(cbTabs), 'view', 'none')
#13 libraries/CBLib/CBLib/AhaWow/View/RegistryEditView.php(451): CBLib\AhaWow\View\RegistryEditView->renderAllParams(Object(CBLib\Xml\SimpleXMLElement), NULL, Object(cbTabs), 'view', 'none')
#14 libraries/CBLib/CBLib/AhaWow/Controller/RegistryEditController.php(317): CBLib\AhaWow\View\RegistryEditView->renderEditRowView(Object(CBLib\Xml\SimpleXMLElement), Object(CBLib\Registry\Registry), Object(CBLib\AhaWow\Controller\DrawController), Array, 'view', 'none')
#15 libraries/CBLib/CBLib/AhaWow/View/ActionViewAdmin.php(133): CBLib\AhaWow\Controller\RegistryEditController->draw(NULL, NULL, NULL, NULL, NULL, NULL, false, 'view', 'none')
#16 libraries/CBLib/CBLib/AhaWow/Controller/ActionController.php(542): CBLib\AhaWow\View\ActionViewAdmin::editPluginView(Array, Array, Object(CBLib\Xml\SimpleXMLElement), NULL, Object(CBLib\AhaWow\Controller\RegistryEditController), Object(CB\Database\Table\PluginTable), 'view', 'b3B0aW9uPWNvbV9...', true)
#17 libraries/CBLib/CBLib/AhaWow/Controller/ActionController.php(170): CBLib\AhaWow\Controller\ActionController->drawView('com_comprofiler', 'editPlugin', Object(CBLib\Xml\SimpleXMLElement), 'edit')
#18 libraries/CBLib/CBLib/AhaWow/Controller/Controller.php(131): CBLib\AhaWow\Controller\ActionController->handleAction(Array)
#19 libraries/CBLib/CBLib/AhaWow/Controller/Controller.php(111): CBLib\AhaWow\Controller\Controller->execute(Array, Object(CBLib\Output\Output))
#20 libraries/CBLib/CBLib/Controller/Controller.php(101): CBLib\AhaWow\Controller\Controller->dispatchRoute(Array)
#21 libraries/CBLib/CBLib/Controller/Controller.php(78): CBLib\Controller\Controller->execute('editPluginTask')
#22 libraries/CBLib/CBLib/Controller/Dispatcher.php(86): CBLib\Controller\Controller->dispatch('editPluginTask')
#23 libraries/CBLib/CBLib/Application/Application.php(165): CBLib\Controller\Dispatcher->dispatch()
#24 libraries/CBLib/CBLib/Core/CBLib.php(186): CBLib\Application\Application->dispatch()
#25 administrator/components/com_comprofiler/admin.comprofiler.controller.php(202): CBLib\Core\CBLib::execute()
#26 administrator/components/com_comprofiler/comprofiler.php(14): require('/var/www/h75644...')
#27 libraries/src/Dispatcher/LegacyComponentDispatcher.php(69): require_once('/var/www/h75644...')
#28 libraries/src/Dispatcher/LegacyComponentDispatcher.php(71): Joomla\CMS\Dispatcher\LegacyComponentDispatcher::Joomla\CMS\Dispatcher\{closure}('/var/www/h75644...')
#29 libraries/src/Component/ComponentHelper.php(389): Joomla\CMS\Dispatcher\LegacyComponentDispatcher->dispatch()
#30 libraries/src/Application/AdministratorApplication.php(143): Joomla\CMS\Component\ComponentHelper::renderComponent('com_comprofiler')
#31 libraries/src/Application/AdministratorApplication.php(186): Joomla\CMS\Application\AdministratorApplication->dispatch()
#32 libraries/src/Application/CMSApplication.php(278): Joomla\CMS\Application\AdministratorApplication->doExecute()
#33 administrator/includes/app.php(63): Joomla\CMS\Application\CMSApplication->execute()
#34 administrator/index.php(32): require_once('/var/www/h75644...')
#35 {main}
Reference: Support Ticket #594087
Updated by beat over 2 years ago
Complement:
Saw also this, might be unrelated:
CB core and fields database checks are ok.
Tools check CB Plugins database gives all green except in black:
CB plugin "CB Core Fields Ajax": no database or no database description.
CB plugin "CB GroupJive Forums": no database or no database description.
CB plugin "CB Quickstart": no database or no database description.
Updated by krileon over 2 years ago
- % Done changed from 0 to 50
Core CB bug with field description column not being nullabe. Fixed in MR !1793
Also fixing in CB Quickstart for older CB installs.
Updated by krileon over 2 years ago
- Status changed from New to Resolved
- % Done changed from 50 to 100