Error: updating database schema. Error: failed to create missing joomla_power table. Invalid default value for 'id' #1128

New Issue

Closed

opened 2024-05-14 12:43:27 +00:00 by kommid · 0 comments

kommid commented

2024-05-14 12:43:27 +00:00

Member

What Happened?

after updating JCB 3.2.0 to 3.2.1, I get the error: "Error: updating database schema. Error: failed to create missing joomla_power table. Key column 'id' doesn't exist in table"

Steps to reproduce the Bug

update jcb from 3.2.0 to 3.2.1 by installing it over the older version

Which Joomla version are you compiling in?

3.10.12

Which PHP version are you compiling in?

8.0

Which Joomla versions are you targeting?

Which PHP version are you targeting?

8.0

Which Web server is JCB running on?

apache 2.4

Which Relational Database is JCB running on?

10.5.23-MariaDB-0+deb11u1

Which OS is JCB running on?

Debian 5.10.209-2 (2024-01-31) x86_64

Which JCB version are you using?

3.2.0

Where in JCB did this issue occur?

Other

On which browsers did you encounter the issue?

Firefox

Additional Comments

I then tried to add the table via phpmyadmin using the sql contained in the install.mysql.utf8.sql file and it was created with no errors (substituted #__ with my table prefix of course):

CREATE TABLE IF NOT EXISTS #__componentbuilder_joomla_power (
id INT(11) NOT NULL AUTO_INCREMENT,
asset_id INT(10) unsigned NOT NULL DEFAULT 0 COMMENT 'FK to the #__assets table.',
description TEXT NULL,
guid VARCHAR(36) NOT NULL DEFAULT '',
settings TEXT NOT NULL,
system_name VARCHAR(255) NOT NULL DEFAULT '',
params TEXT NULL,
published TINYINT(3) NOT NULL DEFAULT 1,
created_by INT(10) unsigned NOT NULL DEFAULT 0,
modified_by INT(10) unsigned NOT NULL DEFAULT 0,
created DATETIME NOT NULL DEFAULT '0000-00-00 00:00:00',
modified DATETIME NOT NULL DEFAULT '0000-00-00 00:00:00',
checked_out int(11) unsigned NOT NULL DEFAULT 0,
checked_out_time DATETIME NOT NULL DEFAULT '0000-00-00 00:00:00',
version INT(10) unsigned NOT NULL DEFAULT 1,
hits INT(10) unsigned NOT NULL DEFAULT 0,
access INT(10) unsigned NOT NULL DEFAULT 0,
ordering INT(11) NOT NULL DEFAULT 0,
PRIMARY KEY (id),
KEY idx_system_name (system_name),
KEY idx_guid (guid),
KEY idx_access (access),
KEY idx_checkout (checked_out),
KEY idx_createdby (created_by),
KEY idx_modifiedby (modified_by),
KEY idx_state (published)
) ENGINE=InnoDB AUTO_INCREMENT=0 DEFAULT CHARSET=utf8mb4 DEFAULT COLLATE=utf8mb4_unicode_ci ROW_FORMAT=DYNAMIC;

Any idea why the installer failed to create it?

### What Happened? after updating JCB 3.2.0 to 3.2.1, I get the error: "Error: updating database schema. Error: failed to create missing joomla_power table. Key column 'id' doesn't exist in table" ### Steps to reproduce the Bug update jcb from 3.2.0 to 3.2.1 by installing it over the older version ### Which Joomla version are you compiling in? 3.10.12 ### Which PHP version are you compiling in? 8.0 ### Which Joomla versions are you targeting? 3 ### Which PHP version are you targeting? 8.0 ### Which Web server is JCB running on? apache 2.4 ### Which Relational Database is JCB running on? 10.5.23-MariaDB-0+deb11u1 ### Which OS is JCB running on? Debian 5.10.209-2 (2024-01-31) x86_64 ### Which JCB version are you using? 3.2.0 ### Where in JCB did this issue occur? Other ### On which browsers did you encounter the issue? Firefox ### Additional Comments I then tried to add the table via phpmyadmin using the sql contained in the install.mysql.utf8.sql file and it was created with no errors (substituted #__ with my table prefix of course): CREATE TABLE IF NOT EXISTS `#__componentbuilder_joomla_power` ( `id` INT(11) NOT NULL AUTO_INCREMENT, `asset_id` INT(10) unsigned NOT NULL DEFAULT 0 COMMENT 'FK to the #__assets table.', `description` TEXT NULL, `guid` VARCHAR(36) NOT NULL DEFAULT '', `settings` TEXT NOT NULL, `system_name` VARCHAR(255) NOT NULL DEFAULT '', `params` TEXT NULL, `published` TINYINT(3) NOT NULL DEFAULT 1, `created_by` INT(10) unsigned NOT NULL DEFAULT 0, `modified_by` INT(10) unsigned NOT NULL DEFAULT 0, `created` DATETIME NOT NULL DEFAULT '0000-00-00 00:00:00', `modified` DATETIME NOT NULL DEFAULT '0000-00-00 00:00:00', `checked_out` int(11) unsigned NOT NULL DEFAULT 0, `checked_out_time` DATETIME NOT NULL DEFAULT '0000-00-00 00:00:00', `version` INT(10) unsigned NOT NULL DEFAULT 1, `hits` INT(10) unsigned NOT NULL DEFAULT 0, `access` INT(10) unsigned NOT NULL DEFAULT 0, `ordering` INT(11) NOT NULL DEFAULT 0, PRIMARY KEY (`id`), KEY `idx_system_name` (`system_name`), KEY `idx_guid` (`guid`), KEY `idx_access` (`access`), KEY `idx_checkout` (`checked_out`), KEY `idx_createdby` (`created_by`), KEY `idx_modifiedby` (`modified_by`), KEY `idx_state` (`published`) ) ENGINE=InnoDB AUTO_INCREMENT=0 DEFAULT CHARSET=utf8mb4 DEFAULT COLLATE=utf8mb4_unicode_ci ROW_FORMAT=DYNAMIC; Any idea why the installer failed to create it?