User:Victor Grousset - tuxayo/Community work/Reports/2020-11

Release maintenance of 19.05 branch

Backport list

• Bug 26604 - "Generate next" button gives error on serials-collection.pl
• Bug 26589 - t/db_dependent/OAI/Sets.t unit test fails due to OAI-PMH:AutoUpdateSets syspref
• Bug 26496 - Budget plan save button doesn't save plans
• Bug 26569 - Use gender-neutral pronouns in systempreference explanation field in DB
• Bug 26612 - Error during web install for it-IT translation
• Bug 26613 - In the unimarc_framework.sql file in the it-IT translation there are wrong value fields for 995 r record
• Bug 26601 - Add utf8 output to text output of overdue_notices.pl
• Bug 18050 - Missing constraint on aqbudgets.budget_period_id in aqbudgets
• Bug 26606 - Correctly URI-encode query string in URL loaded after deleting an authority record
• Bug 18051 - Advanced Editor - Rancor - encoding issues with some sources
• Bug 26639 - Turn auto_savepoint ON
• Bug 26904 - OPAC password recovery allows regexp in email

Minor stuff

10 patchsets skipped after quick analysis

Due one of the following

• missing dependencies
• severity too low considering this is the oldoldstable branch of Koha
• not enough benefits compared to the risks of regression

Investigated patches for backporting and backport attempts

Some time needed to determine whether it impacts 19.05 or the feasibility of the backport. And also attempts to backport not possible due to code conflicts.

• Bug 25242 - Accessibility: The 'Holdings' table partially obscures navigation links at 200% zoom

QA

Note: an attempt results in feedback provided on the bug. To ask if I correctly followed the test plan due to results that I couldn't interpret. Or if there is indeed an issue.

Partial QA

I'm not yet in the QA team and doesn't know all the basics but I can still do the testing part, like a signoff. And also run the qa-test-tools.

Bug 18267 - Update price and tax fields in EDI to reflect DB changes

Ran the QA script and reported missed errors.

Signoffs (testing submitted patches so they can move on to be integrated)

Note: an attempt results in feedback provided on the bug. To ask if I correctly followed the test plan due to results that I couldn't interpret. Or if there is indeed an issue.

Attempt: Add a new switch to run Koha as a Mojo app

https://gitlab.com/koha-community/koha-testing-docker/-/issues/228 https://gitlab.com/koha-community/koha-testing-docker/-/merge_requests/162

Maybe found issue with: Add a new switch to run Koha as a Mojo app

https://gitlab.com/koha-community/koha-testing-docker/-/issues/228 https://gitlab.com/koha-community/koha-testing-docker/-/merge_requests/162

Issue #176 - Use KOHA_ELASTICSEARCH when the container is created

Found what was wrong in my attempt and tested successfully.

Misc tasks and work on tickets: Analysis or implementation

Large amount of work on Bug 23732 - Hold rules checker: show matched rules and syspref values to help understand why a hold is possible or not

• Tough rebase to make it work it the current code after more than a years for changes
• Various bugfixes
• Enhancement that required to refactor sensitive code

Significant amount of work on Bug 27055 - Update Firefox version used in Selenium GUI tests

Fix multiple issues across all the GUI tests. Patch submitted.

Bug 14242 - Use ISBN-field to fill out purchase suggestions (using an Ajax-request)

Personal data analysis: found issues and proposed some solutions.

Bug 23653 - Plack fails when http://swagger.io/v2/schema.json is unavailable and schema cache missing

Found Debian package that already provides the schema files in order for the Perl library that we depend on to use then. Thus fixing the root cause.

Bug 20885 - Transferring an item on hold results in bypassing restrictions, actually doing the transfer and can be piled up if repeated

Tried to reproduce and found different potential issues this time.

Bug 17258 - [OMNIBUS] MySQL 5.7

Research about MariaDB and MySQL version compatibility.

Continuation of analysis of SQL comment formats and which should be adopted

https://wiki.koha-community.org/wiki/User:Victor_Grousset_-_tuxayo/Coding_Guidelines-SQL11-changes

Bug 26031 - www/search_utf8.t is failing randomly and must be removed/replaced

Some analysis to try to find an alternative solution.

Documentation

Some updates to who had access to which community infrastructure parts

https://wiki.koha-community.org/wiki/Website_Administration

Translation guideline draft about an important point to not loose translation work

Discussions after feedback on it.

https://wiki.koha-community.org/wiki/User:Victor_Grousset_-_tuxayo:Translation#Translation_process

Minor security release process improvements + asked for feedback

https://wiki.koha-community.org/wiki/Release_maintenance

Release maintenance: add section about backporting a patch with a new Perl dependency

https://wiki.koha-community.org/wiki/Release_maintenance#Backporting_a_patch_with_a_new_perl_dependency

SIP: add example about how to use the emulator

https://wiki.koha-community.org/wiki/Koha_SIP2_server_setup#Example

New tickets opened

i.e. Found something wrong and documented how to reproduce it. Or suggest an enhancement (usually for dev tools)

KohaDevBox: koha-common outdated

https://gitlab.com/koha-community/kohadevbox/-/issues/309

QA tools: Crash in certain cases

https://gitlab.com/koha-community/qa-test-tools/-/issues/45

koha-testing-docker: Add libio-prompt-tiny-perl, dependency of the release tools

https://gitlab.com/koha-community/koha-testing-docker/-/issues/235

docker-selenium: quit() hangs while Firefox is at 100% CPU

https://github.com/SeleniumHQ/docker-selenium/issues/1146