https://bugs.koha-community.org/bugzilla3/show_bug.cgi?id=26684
--- Comment #31 from Janusz Kaczmarek <[email protected]> --- (In reply to David Nind from comment #29) > A test plan would be ideal for the QA step, and a release note would be > great to explain what this fixes and why. It is hard to say about a strict test plan. One aspect of problems causing by this column can be illustrates by the following sequence of steps. 1. Take the provided test auth record (100 Baggins, Bilbo) with lots od 670 fields, of size 92771 B: still in the limits of ISO 2709, but significantly bigger than blob size (64 KB). 2. Try to import the record into ktd installation with: misc/migration_tools/bulkmarcimport.pl -a -d -file Baggins_Bilbo.mrc -fk You should see a series of warnings: DBIx::Class::Storage::DBI::_dbh_execute(): DBI Exception: DBD::mysql::st execute failed: Data too long for column 'marc' at row 1 at /kohadevbox/koha/Koha/Object.pm line 172 Use of uninitialized value $originalid in concatenation (.) or string at ./misc/migration_tools/bulkmarcimport.pl line 520, <GEN3> line 1. ERROR: Insert authority failed: DBIx::Class::Storage::DBI::_dbh_execute(): DBI Exception: DBD::mysql::st execute failed: Data too long for column 'marc' at row 1 at /kohadevbox/koha/Koha/Object.pm line 172 3. Control in ktd --dbshell with: select * from auth_header; You should see one row with no data in marc nor in marcxml. 4. Apply the patch ; updatedatabase. 5. Repeat p. 2 and p. 3. You should get no warnings and expected (huge) result from MySQL. Other aspects should be evaluated by code reviewers. The koha_header.marc column should not be used in the code anymore with this patch. -- You are receiving this mail because: You are watching all bug changes. You are the assignee for the bug. _______________________________________________ Koha-bugs mailing list [email protected] https://lists.koha-community.org/cgi-bin/mailman/listinfo/koha-bugs website : http://www.koha-community.org/ git : http://git.koha-community.org/ bugs : http://bugs.koha-community.org/
