| Summary | mysql V 8.0.36: SQL QUERY FAILED: SQLSTATE[42000]: Syntax error or access violation: 1101 BLOB, TEXT, GEOMETRY or JSON column 'task_other_attributes' can't have a d efault value |
| Queue | Nag |
| Queue Version | FRAMEWORK_6_0 |
| Type | Bug |
| State | Unconfirmed |
| Priority | 2. Medium |
| Owners | |
| Requester | mrch (at) mailbox (dot) org |
| Created | 09/26/2024 (392 days ago) |
| Due | |
| Updated | 06/01/2025 (144 days ago) |
| Assigned | |
| Resolved | |
| Github Issue Link | |
| Github Pull Request | |
| Milestone | |
| Patch | No |
https://bugs.horde.org/ticket/15172. Thank you!
State ⇒ Unconfirmed
Priority ⇒ 2. Medium
Type ⇒ Bug
Summary ⇒ mysql V 8.0.36: SQL QUERY FAILED: SQLSTATE[42000]: Syntax error or access violation: 1101 BLOB, TEXT, GEOMETRY or JSON column 'task_other_attributes' can't have a d efault value
Queue ⇒ Nag
Milestone ⇒
Patch ⇒ No
https://wiki.horde.org/Doc/Dev/H6/Installation/InstallBase?referrer=Doc%2FDev%2FH6%2FInstallation
The execution of
http://192.168.122.5/horde/admin/config/?app=nag&action=schema
throws the above error.
The schema remains without update.
IMHO the problem seems to be located in
/var/www/html/horde/vendor/horde/nag/migration/18_nag_upgrade_other_fields.php
line 29.
IMHO related to:
https://www.percona.com/blog/cant-we-assign-a-default-value-to-the-blob-text-geometry-and-json-data-types/