Bug 40491

Summary: 19.12.00.082 crashes if zh-Hant-TW is installed
Product: Koha Reporter: Jonathan Druart <jonathan.druart>
Component: Installation and upgrade (command-line installer)Assignee: Bugs List <koha-bugs>
Status: NEW --- QA Contact: Testopia <testopia>
Severity: normal    
Priority: P5 - low CC: dcook, tomascohen
Version: unspecified   
Hardware: All   
OS: All   
GIT URL: Initiative type: ---
Sponsorship status: --- Comma delimited list of Sponsors:
Crowdfunding goal: 0 Patch complexity: ---
Documentation contact: Documentation submission:
Text to go in the release notes:
Version(s) released in:
Circulation function:
Bug Depends on: 23794    
Bug Blocks:    

Description Jonathan Druart 2025-07-24 11:04:14 UTC
If zh-Hant-TW is installed the upgrade will fail on 19.12.00.082 because opac_news.lang is varchar(25) and we try to insert OpacMainUserBlock_$lang
Comment 1 Jonathan Druart 2025-07-24 11:09:49 UTC
{UNKNOWN}: DBI Exception: DBD::mysql::db do failed: Data too long for column 'lang' at row 1  at /usr/share/perl5/DBIx/Class/Schema.pm line 1118.
Comment 2 David Cook 2026-01-12 05:55:36 UTC
That's an interesting one. Shall we update updatedatabase.pl for 19.12.00.082? 

It looks like it was extended in 20.06.00.014.
Comment 3 Jonathan Druart 2026-01-12 13:46:35 UTC
Yes, we should, but nobody complained...
Comment 4 David Cook 2026-01-12 22:14:25 UTC
(In reply to Jonathan Druart from comment #3)
> Yes, we should, but nobody complained...

Right? I was thinking how 19.11/20.05 hasn't been supported for a while, but then I suppose it's always good to have a healthy upgrade path. I don't know.