Bug 30805

Summary:	Missing default value on import_records.marxml_old
Product:	Koha	Reporter:	Katrin Fischer <katrin.fischer>
Component:	Architecture, internals, and plumbing	Assignee:	Bugs List <koha-bugs>
Status:	NEW ---	QA Contact:	Testopia <testopia>
Severity:	normal
Priority:	P5 - low	CC:	jonathan.druart
Version:	20.11
Hardware:	All
OS:	All
Change sponsored?:	---	Patch complexity:	---
Documentation contact:		Documentation submission:
Text to go in the release notes:		Version(s) released in:
Circulation function:
Bug Depends on:	20144
Bug Blocks:

Description Katrin Fischer 2022-05-19 07:55:05 UTC

We fixed a ton of missing default values on bug 20144, I believe this one might be another to fix:

import DBD::mysql::st execute failed: Field 'marcxml_old' doesn't have a default value [for Statement "INSERT INTO import_records (import_batch_id, record_sequence, marc, marcxml, 
                                                         record_type, encoding, z3950random)

We see this error in an older version after the latest Debian update with a new MariaDB version, but in master we still have:

`marcxml` longtext COLLATE utf8mb4_unicode_ci NOT NULL,

Comment 1 Jonathan Druart 2022-06-01 12:48:05 UTC

How do you recreate the failure?