Opened 17 years ago
Closed 17 years ago
#3094 closed defect (fixed)
error with sql schema update
Reported by: | Owned by: | Isaac Richards | |
---|---|---|---|
Priority: | minor | Milestone: | unknown |
Component: | mythtv | Version: | 0.20 |
Severity: | high | Keywords: | |
Cc: | Ticket locked: | no |
Description
Upgrading to schema version 1142 2007-02-16 15:38:06.803 DB Error (Performing database upgrade): Query was: CREATE TABLE IF NOT EXISTS customexample ( rulename VARCHAR(64) NOT NULL PRIMARY KEY, fromclause text NOT NULL DEFAULT , whereclause text NOT NULL DEFAULT ); Error was: Driver error was [2/1101]: QMYSQL3: Unable to execute query Database error was: BLOB/TEXT column 'fromclause' can't have a default value
Using: mythtv 2.0_12801 mysql 5.0.32 mysql has option strict enabled.
Note: See
TracTickets for help on using
tickets.
(In [12958]) Don't specify default values for the fromclause/whereclause text fields.
Early MySQL v5.x versions silently allowed this. Later MySQL versions give a warning in non-strict mode and error out when the server is in strict mode.
The code that uses this table always specifies both columns so there shouldn't be a need for the default value if it is going to cause some people to get errors trying to upgrade their DB.
Closes #3094.
References MySQL docs and bugs: