[Tickets #15171] 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

[noreply at bugs.horde.org]

BITTE NICHT AUF DIESE NACHRICHT ANTWORTEN. NACHRICHTEN AN DIESE  
E-MAIL-ADRESSE WERDEN NICHT GELESEN.

Ticket-URL: https://bugs.horde.org/ticket/15171
------------------------------------------------------------------------------
  Ticket           | 15171
  Erstellt Von     | mrch at mailbox.org
  Zusammenfassung  | 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
  Warteschlange    | Nag
  Version          | FRAMEWORK_6_0
  Typ              | Bug
  Status           | Unconfirmed
  Priorität        | 2. Medium
  Milestone        |
  Patch            |
  Zuständige       |
------------------------------------------------------------------------------


mrch at mailbox.org (2024-09-26 07:08) hat geschrieben:

Fresh install according to:
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/