[Tickets #15172] Re: mysql V 8.0.36: SQL QUERY FAILED: SQLSTATE[42000]: Syntax error or access violation: 1101 BLOB, TEXT, GEOMETRY or JSON column 'other_attributes' can't have a default value
noreply at bugs.horde.org
noreply at bugs.horde.org
Thu May 29 09:10:14 UTC 2025
BITTE NICHT AUF DIESE NACHRICHT ANTWORTEN. NACHRICHTEN AN DIESE
E-MAIL-ADRESSE WERDEN NICHT GELESEN.
Ticket-URL: https://spencer.horde.org/hordenext/horde/../whups/ticket/15172
------------------------------------------------------------------------------
Ticket | 15172
Aktualisiert Von | Ralf Lang <ralf.lang at ralf-lang.de>
Zusammenfassung | mysql V 8.0.36: SQL QUERY FAILED: SQLSTATE[42000]: Syntax
| error or access violation: 1101 BLOB,
| TEXT, GEOMETRY or JSON column
| 'other_attributes' can't have a
| default value
Warteschlange | Kronolith
Version | FRAMEWORK_6_0
Typ | Bug
Status | Assigned
Priorität | 2. Medium
Milestone |
Patch |
-Zuständige |
+Zuständige | Horde Developers, Ralf Lang
------------------------------------------------------------------------------
Ralf Lang <ralf.lang at ralf-lang.de> (2025-05-29 11:10) hat geschrieben:
> Confirmed.
> I don't have this in mariadb.
> There's a workaround in mysql 8.0.13 and later by using an
> expression rather than a literal as default for text and blob field.
> We will build a patch based on this.
Preliminary patch at library level
commit c2d525d02cb0a7c2f087e0c86f9728caf3e44816 (HEAD ->
FRAMEWORK_6_0, origin/HEAD, origin/FRAMEWORK_6_0)
Author: Ralf Lang <ralf.lang at ralf-lang.de>
Date: Thu May 29 11:08:19 2025 +0200
fix: #15172 Add a filter to support column defaults on mysql >=
8.0.13 for TEXT, BLOB and JSON format
Will test if this is sufficient for nag and kronolith on this version of mysql
More information about the bugs
mailing list