[Koha-bugs] [Bug 34494] New: Table tmp_holdsqueue fails to be created for MySQL 8
bugzilla-daemon at bugs.koha-community.org
bugzilla-daemon at bugs.koha-community.org
Tue Aug 8 13:10:37 CEST 2023
https://bugs.koha-community.org/bugzilla3/show_bug.cgi?id=34494
Bug ID: 34494
Summary: Table tmp_holdsqueue fails to be created for MySQL 8
Change sponsored?: ---
Product: Koha
Version: master
Hardware: All
OS: All
Status: NEW
Severity: enhancement
Priority: P5 - low
Component: Architecture, internals, and plumbing
Assignee: koha-bugs at lists.koha-community.org
Reporter: kyle at bywatersolutions.com
QA Contact: testopia at bugs.koha-community.org
It appears that MySQL 8 rejects creating any table where the primary key is
nullable. The table tmp_holdsqueue has a nullable pk ( itemnumber ) but there
is no reason for this column to be nullable ( generating a holds queue entry
with no itemnumber is not possible ) so it make sense to just remove the
nullability for MySQL compatiability.
--
You are receiving this mail because:
You are watching all bug changes.
You are the assignee for the bug.
More information about the Koha-bugs
mailing list