[Koha-bugs] [Bug 30571] Table z3950servers: Make host, syntax and encoding NOT NULL

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

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

--- Comment #24 from Marcel de Rooy <m.de.rooy at rijksmuseum.nl> ---
(In reply to Marcel de Rooy from comment #22)
> Created attachment 141361 [details] [review]
> Bug 30571: (follow-up) Additional check at upgrade
> 
> Bad data occurs. We are removing null hosts here and update
> empty syntax or encoding, informing the user.
> 
> Test plan:
> Remove the NOT NULL condition if needed.
> Copy db_revs/220600056.pl to atomicupdate and test dbrev.
> You might see something like:
>     Upgrade to 22.06.00.056  [11:48:22]: Bug 30571 - Table z3950servers:
> three cols NOT NULL
>         Found bad data in table z3950servers: removed 1 records with host
> undefined
>         Corrected empty syntax or encoding for the following hosts. Please
> check after upgrade.
>         Updated hosts: lx2.loc.gov,lx2.loc.gov
> 
> Signed-off-by: Marcel de Rooy <m.de.rooy at rijksmuseum.nl>

Forgot to add the second obvious step in testing: create some bad data..

-- 
You are receiving this mail because:
You are watching all bug changes.