[Koha-bugs] [Bug 24387] Rename News tool

[bugzilla-daemon at bugs.koha-community.org]

https://bugs.koha-community.org/bugzilla3/show_bug.cgi?id=24387

--- Comment #67 from Caroline Cyr La Rose <caroline.cyr-la-rose at 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.