https://bugs.koha-community.org/bugzilla3/show_bug.cgi?id=41460
Bug ID: 41460
Summary: On Mysql on upgrade from 25.05 to 25.11 I got the
error TEXT column 'value' can't have a default value
Initiative type: ---
Sponsorship ---
status:
Product: Koha
Version: 25.11
Hardware: All
OS: All
Status: NEW
Severity: blocker
Priority: P5 - low
Component: Database
Assignee: [email protected]
Reporter: [email protected]
QA Contact: [email protected]
Mysql does not allow blob or text type columns to have a default. The
systempreferences.value column is the only occurrence of this I found in the
kohastructure.sql file. It seems Mysql will ignore the default null as long as
the column allows null, so that's not an issue.
Bug 40405 sets systempreferences.value to NOT NULL, but tries to also add a
DEFAULT '', which causes Mysql to throw the above error.
Proposed solution is to remove the DEFAULT '' part of the clause from the
db_rev file.
--
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/
