? Language Change PR-4.3-dev Success

User tests: Successful: Unsuccessful:

avatar obuisard
obuisard
22 Aug 2022
avatar obuisard obuisard - open - 22 Aug 2022
avatar obuisard obuisard - change - 22 Aug 2022
Status New Pending
avatar joomla-cms-bot
joomla-cms-bot - comment - 22 Aug 2022

Please add more information to your issue. Without test instructions and/or any description we will close this issue within 4 weeks. Thanks.
This is an automated message from the J!Tracker Application.

avatar joomla-cms-bot joomla-cms-bot - change - 22 Aug 2022
Category Administration com_admin SQL Postgresql com_joomlaupdate com_users Language & Strings
avatar richard67
richard67 - comment - 22 Aug 2022

Why is this PR deleting the update SQL scripts „4.2.0-2022-07-07.sql“?

avatar obuisard
obuisard - comment - 22 Aug 2022

Hi Richard, it was not meant to. I am just doing an up merge and I have not taken any action on this yet (setting up my local environment to deal with the conflicts).

The SQL scripts do not exist under 4.2-dev

avatar obuisard obuisard - change - 23 Aug 2022
Status Pending Fixed in Code Base
Closed_Date 0000-00-00 00:00:00 2022-08-23 01:05:19
Closed_By obuisard
Labels Added: ? Language Change PR-4.3-dev
avatar obuisard obuisard - close - 23 Aug 2022
avatar obuisard obuisard - merge - 23 Aug 2022
avatar richard67
richard67 - comment - 23 Aug 2022

@obuisard The 2 update SQL scripts have been deleted in the 4.2-dev branch when reverting PR #38244 . But that was maybe not right. I do not have the time today to check that deeper.

avatar obuisard
obuisard - comment - 23 Aug 2022

@obuisard The 2 update SQL scripts have been deleted in the 4.2-dev branch when reverting PR #38244 . But that was maybe not right. I do not have the time today to check that deeper.

@richard67 I will take a look today and see if I can lift the doubt on this deletion. Thank you Richard!

avatar obuisard
obuisard - comment - 23 Aug 2022

Apparently, as @richard67 posted in the CMS Maintenance team, the deleted files need to be added to script.php so they are removed on update.

avatar richard67
richard67 - comment - 23 Aug 2022

Apparently, as @richard67 posted in the CMS Maintenance team, the deleted files need to be added to script.php so they are removed on update.

Yes but that should have been done in the 4.2-dev branch. And it would have been better not to delete the files but just to comment out the content, and possibly it would even have been necessary to add new update SQL scripts which delete the records added by the deleted script on a 4.2.0. RC1.

@roland-d I would have expected to be contacted when such a thing happens, reverting a PR which has update SQL scripts.

avatar richard67
richard67 - comment - 23 Aug 2022

And when we remove them again on update, the database checker will complain about not matching schema version. As this will only happen when updating a 4.2.0 RC 1, I tend to ignore that for now, i.e. do nothing and leave things as they are.

avatar obuisard
obuisard - comment - 23 Aug 2022

Ok, I am taking note so that I remember that next time I run into such issue

avatar richard67
richard67 - comment - 23 Aug 2022

@obuisard Well it was @roland-d who ran into the issue. The upmerge here only has unmasked it. The golden rule for you: Whenever something has to do with update SQL scripts, ping me to have a look first.

Add a Comment

Login with GitHub to post a comment