| Summary: | Running misc/batchRebuildBiblioTables.pl -c fails with error "Running Data too long for column 'lccn'" | ||
|---|---|---|---|
| Product: | Koha | Reporter: | David Nind <david> |
| Component: | Database | Assignee: | Bugs List <koha-bugs> |
| Status: | RESOLVED DUPLICATE | QA Contact: | Testopia <testopia> |
| Severity: | normal | ||
| Priority: | P5 - low | CC: | dcook, gmcharlt, jonathan.druart, m.de.rooy, nick, tomascohen |
| Version: | Main | ||
| Hardware: | All | ||
| OS: | All | ||
| See Also: |
https://bugs.koha-community.org/bugzilla3/show_bug.cgi?id=28328 https://bugs.koha-community.org/bugzilla3/show_bug.cgi?id=30739 |
||
| Change sponsored?: | --- | Patch complexity: | --- |
| Documentation contact: | Documentation submission: | ||
| Text to go in the release notes: | Version(s) released in: | ||
| Circulation function: | |||
|
Description
David Nind
2022-06-02 22:53:00 UTC
This might be some schema problem. I found this when running Biblio.t
# Failed test 'expected warnings when adding too long LCCN'
# at t/db_dependent/Biblio.t line 61.
# didn't find a warning
# expected to find warning: (?^u:Data too long for column 'lccn')
# expected to find warning: (?^u:Data too long for column 'lccn')
(In reply to David Nind from comment #0) > the sample data in koha-testing-data Should that be koha-testing-docker? Do you know which records were triggering the problem? (In reply to David Cook from comment #2) > (In reply to David Nind from comment #0) > > the sample data in koha-testing-data > > Should that be koha-testing-docker? It should! > > Do you know which records were triggering the problem? I tried to identify, but couldn't determine. I did a report that listed all the LCCN numbers and put into a spreadsheet, but none were longer than 25 characters - biblioitems table, lccn column = varchar(25). But I could have the wrong table. (In reply to Marcel de Rooy from comment #1) > This might be some schema problem. I found this when running Biblio.t > > # Failed test 'expected warnings when adding too long LCCN' > # at t/db_dependent/Biblio.t line 61. > # didn't find a warning > # expected to find warning: (?^u:Data too long for column 'lccn') > # expected to find warning: (?^u:Data too long for column 'lccn') Maybe I was a bit to quick here with changing the title ;) Record 72 has two 010 fields http://localhost:8081/cgi-bin/koha/catalogue/detail.pl?biblionumber=72 This makes the LCCN value too long It can cause errors, but I think is useful for testing error handling :-) 010 - Library of Congress Control Number is NR = not repeatable and seems to have a fixed structure (and possibly length): https://www.loc.gov/marc/bibliographic/bd010.html Does this make this a WONTFIX or should we handle things more gracefully? WONTFIX maybe, possibly a real edge case having the test data with two 010s. |