Opened 13 years ago

Closed 13 years ago

#3094 closed defect (fixed)

error with sql schema update

Reported by: johnjaylward@… 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.

Change History (1)

comment:1 Changed 13 years ago by cpinkham

Resolution: fixed
Status: newclosed

(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:

http://bugs.mysql.com/bug.php?id=19498 http://bugs.mysql.com/bug.php?id=26798 http://dev.mysql.com/doc/refman/5.0/en/blob.html

Note: See TracTickets for help on using tickets.