https://bugs.koha-community.org/bugzilla3/show_bug.cgi?id=24387
--- Comment #67 from Caroline Cyr La Rose <caroline.cyr-la-r...@inlibro.com> --- I'm trying to figure out how to NOT have to do manual changes after the upgrade as we're about to upgrade ~60 installations from 21.05 to 22.05. I have an instance with 4 'OpacMainUserBlock' news, two in fr-CA and two in en. They each are the translation of the other (i.e. en #1 is the translation of fr-CA #1 and en #2 is the translation of fr-CA #2). Although It's not evident in the db and I don't think the dbrev can do anything about it. (And what's worse is that this particular library just copied the French text into the english news... but we won't take that into account.) select idnew, branchcode, title, lang, published_on, updated_on, expirationdate, number, borrowernumber from opac_news where lang like "%OpacMainUserBlock%"; +-------+------------+-------------------------+-------------------------+--------------+---------------------+----------------+--------+----------------+ | idnew | branchcode | title | lang | published_on | updated_on | expirationdate | number | borrowernumber | +-------+------------+-------------------------+-------------------------+--------------+---------------------+----------------+--------+----------------+ | 19 | NULL | OpacMainUserBlock_fr-CA | OpacMainUserBlock_fr-CA | 2021-02-01 | 2022-09-27 11:49:20 | NULL | 0 | NULL | | 20 | NULL | OpacMainUserBlock_en | OpacMainUserBlock_en | 2021-02-01 | 2022-09-27 11:49:20 | NULL | 0 | NULL | | 31 | NULL | Ouverture | OpacMainUserBlock_fr-CA | 2021-06-22 | 2022-08-10 10:08:52 | NULL | 1 | 1 | | 32 | NULL | Welcome | OpacMainUserBlock_en | 2021-06-22 | 2022-08-10 10:08:52 | NULL | 1 | 1 | +-------+------------+-------------------------+-------------------------+--------------+---------------------+----------------+--------+----------------+ 4 rows in set (0.000 sec) After the upgrade, I have six 'OpacMainUserBlock' contents, four defaults and two fr-CA. It seems like it doubled the fr-CA ones (one default and one fr-CA for each) and changed the en ones into default. select idnew, category, code, location, branchcode, title, lang, published_on, expirationdate, number, borrowernumber from additional_contents where location = 'OpacMainUserBlock' order by code; +-------+---------------------+---------+-------------------+------------+-------------------------+---------+--------------+----------------+--------+----------------+ | idnew | category | code | location | branchcode | title | lang | published_on | expirationdate | number | borrowernumber | +-------+---------------------+---------+-------------------+------------+-------------------------+---------+--------------+----------------+--------+----------------+ | 20 | html_customizations | News_20 | OpacMainUserBlock | NULL | OpacMainUserBlock_en | default | 2021-02-01 | NULL | 0 | NULL | | 32 | html_customizations | News_32 | OpacMainUserBlock | NULL | Welcome | default | 2021-06-22 | NULL | 1 | 1 | | 19 | html_customizations | News_49 | OpacMainUserBlock | NULL | OpacMainUserBlock_fr-CA | fr-CA | 2021-02-01 | NULL | 0 | NULL | | 49 | html_customizations | News_49 | OpacMainUserBlock | NULL | OpacMainUserBlock_fr-CA | default | 2021-02-01 | NULL | 0 | NULL | | 31 | html_customizations | News_55 | OpacMainUserBlock | NULL | Ouverture | fr-CA | 2021-06-22 | NULL | 1 | 1 | | 55 | html_customizations | News_55 | OpacMainUserBlock | NULL | Ouverture | default | 2021-06-22 | NULL | 1 | 1 | +-------+---------------------+---------+-------------------+------------+-------------------------+---------+--------------+----------------+--------+----------------+ 6 rows in set (0.000 sec) The contents are doubled everywhere in the OPAC, both in English and French. So I think default appears no matter which language were on? I'm wondering if it's necessary to create defaults? It was not possible to have that before with the news, it had to be in either language. So I don't think it makes sense to create a default in the course of the upgrade... (It's fine to use default after of course). -- You are receiving this mail because: You are watching all bug changes. _______________________________________________ Koha-bugs mailing list Koha-bugs@lists.koha-community.org https://lists.koha-community.org/cgi-bin/mailman/listinfo/koha-bugs website : http://www.koha-community.org/ git : http://git.koha-community.org/ bugs : http://bugs.koha-community.org/