Closed Bug 1497042 Opened 7 years ago Closed 6 years ago

[MySQL] Update schema and queries to solve MySQL 8 compatibility issues

Categories

(Bugzilla :: Database, enhancement)

Product:
Bugzilla
Component:
Database
Type:
enhancement
Priority:
Not set
Severity:
normal

Tracking

()

Status:
RESOLVED FIXED

People

(Reporter: dereckson, Assigned: dereckson)

Details

The following issues occur when using MySQL 8: - groups is now a reserved keyword, as such the table must be protected: groups → `groups` - some fields can't have a default value anymore: BLOB, TEXT, GEOMETRY or JSON (that includes tinytext) The first is an installation blocker.
https://github.com/bugzilla/bugzilla/pull/71 addresses the first issue.
Assignee: database → dereckson
Status: UNCONFIRMED → RESOLVED
Closed: 6 years ago
Resolution: --- → FIXED

This will be in 5.0.6

You need to log in before you can comment on or make changes to this bug.