Bug 30805 - Missing default value on import_records.marxml_old
Summary: Missing default value on import_records.marxml_old
Status: NEW
Alias: None
Product: Koha
Classification: Unclassified
Component: Architecture, internals, and plumbing (show other bugs)
Version: 20.11
Hardware: All All
: P5 - low normal
Assignee: Bugs List
QA Contact: Testopia
URL:
Keywords:
Depends on: 20144
Blocks:
  Show dependency tree / graph
 
Reported: 2022-05-19 07:55 UTC by Katrin Fischer
Modified: 2022-06-01 12:48 UTC (History)
1 user (show)

See Also:
Change sponsored?: ---
Patch complexity: ---
Documentation contact:
Documentation submission:
Text to go in the release notes:
Version(s) released in:
Circulation function:

Attachments
Add an attachment (proposed patch, testcase, etc.)

Note You need to log in before you can comment on or make changes to this bug.
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?