Joomla! Issue Tracker - CMS

Download
Launch
Feeling Lucky

[#26164] - [4.0] Download Key manager SQL errors

J4 Issue ?
avatar brianteeman
brianteeman
4 Sep 2019

@roland-d @wilsonge

Since the merge of PR #25553 when you do a clean install you will find that the database is reporting as out of date.

The problem is that there is a mismatch between the install sql and the update sql. The update sql file is for the #__update_sites table but the install sql is for the #__updates table

joomla-cms/administrator/components/com_admin/sql/updates/mysql/4.0.0-2019-08-03.sql

Lines 1 to 2 in 501dfad

ALTER TABLE `#__update_sites` ADD COLUMN `checked_out` int(10) unsigned NOT NULL DEFAULT 0;
ALTER TABLE `#__update_sites` ADD COLUMN `checked_out_time` datetime NULL DEFAULT NULL;

joomla-cms/installation/sql/mysql/joomla.sql

Lines 1936 to 1937 in 501dfad

`checked_out` int(10) unsigned NOT NULL DEFAULT 0,
`checked_out_time` datetime NULL DEFAULT NULL,

avatar brianteeman brianteeman - open - 4 Sep 2019
avatar joomla-cms-bot joomla-cms-bot - change - 4 Sep 2019
Labels Added: ?
avatar joomla-cms-bot joomla-cms-bot - labeled - 4 Sep 2019
avatar roland-d
roland-d - comment - 4 Sep 2019

@brianteeman Thank you for reporting this. I will submit a PR to fix this.

avatar brianteeman
brianteeman - comment - 4 Sep 2019

@roland-d I was going to but then I wasnt sure which was correct ;)

avatar roland-d
roland-d - comment - 4 Sep 2019

@brianteeman Feel free to post it, I can test it :)

The correct one is the #__update_sites because we moved the keys there. These columns are then used to be able to "lock" the rows.

avatar brianteeman
brianteeman - comment - 4 Sep 2019

ok - incoming

avatar brianteeman brianteeman - close - 4 Sep 2019
avatar brianteeman brianteeman - change - 4 Sep 2019
Status New ⇒ Closed
Closed_Date 0000-00-00 00:00:00 ⇒ 2019-09-04 19:19:22
Closed_By ⇒ brianteeman
avatar brianteeman brianteeman - change - 4 Sep 2019
Status Closed ⇒ New
Closed_Date 2019-09-04 19:19:22 ⇒
Closed_By brianteeman ⇒
avatar brianteeman brianteeman - reopen - 4 Sep 2019
avatar brianteeman brianteeman - change - 4 Sep 2019
Status New ⇒ Closed
Closed_Date 0000-00-00 00:00:00 ⇒ 2019-09-04 19:31:13
Closed_By ⇒ brianteeman
avatar brianteeman brianteeman - close - 4 Sep 2019
avatar franz-wohlkoenig franz-wohlkoenig - change - 5 Sep 2019
Labels Added: J4 Issue
avatar franz-wohlkoenig franz-wohlkoenig - labeled - 5 Sep 2019

Add a Comment

Login with GitHub to post a comment