User tests: Successful: Unsuccessful:
Pull Request for #47229 (comment) .
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.
Code review should be sufficient, e.g. compare with #45967 , and in addition check the new file names.
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.
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.
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
| Status | New | ⇒ | Pending |
| Category | ⇒ | SQL Administration com_admin Postgresql |
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.
I have tested this item ✅ successfully on 4aa265d
tested mysql only
Thanks @brianteeman for testing
| 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
|
||
Thanks @richard67 will it also need a change in the list of removed files?