PR-6.1-dev Pending

User tests: Successful: Unsuccessful:

avatar richard67
richard67
14 Mar 2026

Pull Request for #47229 (comment) .

  • I read the Generative AI policy and my contribution is either not created with the help of AI or is compatible with the policy and GNU/GPL 2 or later.

Summary of Changes

This pull request (PR) renames the update SQL script which were added with PR #47229 so that they have a newer schema version in their name than the highest schema version of currently present update SQL scripts at the time of the merge of that PR.

In addition it modifies the insert statement for the tour record so it does not produce duplicates when running multiple times, e.g. after a failed previous update attempt. The same has been made for the 6.0.0 what's new tour, see #45967 .

Finally it makes some small code style change for better readability.

Testing Instructions

Code review should be sufficient, e.g. compare with #45967 , and in addition check the new file names.

Actual result BEFORE applying this Pull Request

The update SQL script "6.1.0-2026-02-25.sql" is not executed when updating a 6.1 nightly build from before last night to the latest 6.1 nightly build using the upload & update method because the schema version in the file name of that script is older than the current database schema version.

When executing the update SQL script more than one time, you have duplicate tour and tour step records.

Expected result AFTER applying this Pull Request

The update SQL script "6.1.0-2026-03-13.sql" is executed when updating a 6.1 nightly build from before last night to the latest 6.1 nightly build using the upload & update method because the schema version in the file name of that script is newer than the current database schema version.

When executing the update SQL script more than one time, you only have duplicate tour step records (which cannot be easily avoided) but no duplicate tour record.

Link to documentations

Please select:

  • Documentation link for guide.joomla.org:

  • No documentation changes for guide.joomla.org needed

  • Pull Request link for manual.joomla.org:

  • No documentation changes for manual.joomla.org needed

avatar richard67 richard67 - open - 14 Mar 2026
avatar richard67 richard67 - change - 14 Mar 2026
Status New Pending
avatar joomla-cms-bot joomla-cms-bot - change - 14 Mar 2026
Category SQL Administration com_admin Postgresql
avatar brianteeman
brianteeman - comment - 14 Mar 2026

Thanks @richard67 will it also need a change in the list of removed files?

avatar richard67
richard67 - comment - 14 Mar 2026

Thanks @richard67 will it also need a change in the list of removed files?

@brianteeman In this case here no, as the "6.1.0-2026-02-25.sql" haven't been released yet. If they had been in beta2, it would need that.

avatar brianteeman brianteeman - test_item - 14 Mar 2026 - Tested successfully
avatar brianteeman
brianteeman - comment - 14 Mar 2026

I have tested this item ✅ successfully on 4aa265d

tested mysql only


This comment was created with the J!Tracker Application at issues.joomla.org/tracker/joomla-cms/47389.

avatar tecpromotion
tecpromotion - comment - 14 Mar 2026

Thanks @brianteeman for testing

avatar tecpromotion tecpromotion - change - 14 Mar 2026
Status Pending Fixed in Code Base
Closed_Date 0000-00-00 00:00:00 2026-03-14 13:17:49
Closed_By tecpromotion
Labels Added: PR-6.1-dev
avatar tecpromotion tecpromotion - close - 14 Mar 2026
avatar tecpromotion tecpromotion - merge - 14 Mar 2026

Add a Comment

Login with GitHub to post a comment