Release Blocker ? Pending

User tests: Successful: Unsuccessful:

avatar richard67
richard67
31 Dec 2021

Pull Request for Issue # .

Summary of Changes

Fix the sequence number next value for the assets table in base.sql for PostgreSQL after the last upmerge from 4.0-dev.

Testing Instructions

Either code review by someone who knows what a sequence means in PostgreSQL, or:

  1. Make a new Joomla installation using a PostgreSQL database with the 4.1-dev branch as it is right now, i.e. since after the upmerge from 4.0-dev a few hours ago.
  2. Try to install blog sample data.

Actual result BEFORE applying this Pull Request

Creating anything which requires assets fails, and so does e.g. installing Blog Sample Data.

In the log file of the database server:

ERROR:  duplicate key value violates unique constraint "j4ux0_assets_pkey"
DETAIL:  Key (id)=(90) already exists.
STATEMENT:  INSERT INTO "j4ux0_assets"
	("name","title","rules","parent_id","level","lft","rgt") VALUES 
	('com_content.fieldgroup.1','The Author','{}',8,2,38,39)
	RETURNING id
ERROR:  current transaction is aborted, commands ignored until end of transaction block
STATEMENT:  SELECT 1
ERROR:  current transaction is aborted, commands ignored until end of transaction block
STATEMENT:  DEALLOCATE pdo_stmt_00000196

Expected result AFTER applying this Pull Request

No such problem.

Documentation Changes Required

None.

avatar richard67 richard67 - open - 31 Dec 2021
avatar richard67 richard67 - change - 31 Dec 2021
Status New Pending
avatar joomla-cms-bot joomla-cms-bot - change - 31 Dec 2021
Category Postgresql SQL Installation
avatar bembelimen bembelimen - close - 31 Dec 2021
avatar bembelimen bembelimen - merge - 31 Dec 2021
avatar bembelimen bembelimen - change - 31 Dec 2021
Status Pending Fixed in Code Base
Closed_Date 0000-00-00 00:00:00 2021-12-31 17:18:09
Closed_By bembelimen
Labels Added: Release Blocker ?
avatar bembelimen
bembelimen - comment - 31 Dec 2021

Thx

Add a Comment

Login with GitHub to post a comment