Error after J3>J4 Upgrade

Search
Other Bug Reports questions
Forum

Error after J3>J4 Upgrade

Marco Ciavolino's Avatar Marco Ciavolino
Error after J3>J4 Upgrade

We converted a site from J3 to J4. While test I upgraded the Regular Labs extensions and it three this error:

Library Install: Field 'extra_params' doesn't have a default value
Package Install: There was an error installing an extension: lib_regularlabs
Package Install: There was an error installing an extension: pkg_regularlabs

So uninstalled all the Regular Labs extensions (System > Manage > Uinstall).

When re-installing extensionmanager-v8.2.0.zip it throws this error:

Library Install: Field 'extra_params' doesn't have a default value
Package Install: There was an error installing an extension: lib_regularlabs
Package Install: There was an error installing an extension: pkg_regularlabs
Error installing package

Any ideas?
Peter van Westen's Avatar Peter van Westen ADMIN
No idea where this extra_params thing comes from.
Can you give me (super) admin and (s)ftp access so I can take a look?
You can use the 'Confidential information' button in the forum editor to hide sensitive information.
Please post a rating at the Joomla! Extensions Directory
Marco Ciavolino's Avatar Marco Ciavolino
Confidential information:
(hidden)
Peter van Westen's Avatar Peter van Westen ADMIN
Please check the Maintenance: Database page first:
/administrator/index.php?option=com_installer&view=database
Please post a rating at the Joomla! Extensions Directory
Marco Ciavolino's Avatar Marco Ciavolino
Confidential information:
(hidden)
Peter van Westen's Avatar Peter van Westen ADMIN
There are extra columns on the __extensions table in your database that shouldn't be there. Not sure why the database maintenance page doesn't correct this. Looks like your upgrade the J4 did not go 100% correctly.
Please post a rating at the Joomla! Extensions Directory
Marco Ciavolino's Avatar Marco Ciavolino
Confidential information:
(hidden)
Peter van Westen's Avatar Peter van Westen ADMIN
This is the database structure according to a fresh Joomla 4.2.3 installation:
CREATE TABLE IF NOT EXISTS `#__extensions` (
  `extension_id` int NOT NULL AUTO_INCREMENT,
  `package_id` int NOT NULL DEFAULT 0 COMMENT 'Parent package ID for extensions installed as a package.',
  `name` varchar(100) NOT NULL,
  `type` varchar(20) NOT NULL,
  `element` varchar(100) NOT NULL,
  `changelogurl` text,
  `folder` varchar(100) NOT NULL,
  `client_id` tinyint NOT NULL,
  `enabled` tinyint NOT NULL DEFAULT 0,
  `access` int unsigned NOT NULL DEFAULT 1,
  `protected` tinyint NOT NULL DEFAULT 0 COMMENT 'Flag to indicate if the extension is protected. Protected extensions cannot be disabled.',
  `locked` tinyint NOT NULL DEFAULT 0 COMMENT 'Flag to indicate if the extension is locked. Locked extensions cannot be uninstalled.',
  `manifest_cache` text NOT NULL,
  `params` text NOT NULL,
  `custom_data` text NOT NULL,
  `checked_out` int unsigned,
  `checked_out_time` datetime,
  `ordering` int DEFAULT 0,
  `state` int DEFAULT 0,
  `note` varchar(255),
  PRIMARY KEY (`extension_id`),
  KEY `element_clientid` (`element`,`client_id`),
  KEY `element_folder_clientid` (`element`,`folder`,`client_id`),
  KEY `extension` (`type`,`element`,`folder`,`client_id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 DEFAULT COLLATE=utf8mb4_unicode_ci;
File in zip:
/installation/sql/mysql/base.sql
Please post a rating at the Joomla! Extensions Directory
Marco Ciavolino's Avatar Marco Ciavolino
Perfect. Worked!
Peter van Westen's Avatar Peter van Westen ADMIN
Awesome!
Please post a rating at the Joomla! Extensions Directory
You can only post on this forum if you log in