Opened 15 years ago
Closed 14 years ago
#6820 closed defect (fixed)
Invalid default values specified for some fields in MythArchive dbcheck.cpp
Reported by: | Owned by: | Rob Smith | |
---|---|---|---|
Priority: | trivial | Milestone: | unknown |
Component: | Plugin - MythArchive | Version: | head |
Severity: | low | Keywords: | |
Cc: | Ticket locked: | no |
Description
Like issue #6802 there are also invalid default values specified in the create statement of the mytharchive dbcheck.cpp file. This prevents the upgrade of the tables from running to the latest version as MySQL errors out on the query.
According to http://dev.mysql.com/doc/refman/5.1/en/blob.html:
"In most respects, you can regard a BLOB column as a VARBINARY column that can be as large as you like. Similarly, you can regard a TEXT column as a VARCHAR column. BLOB and TEXT differ from VARBINARY and VARCHAR in the following ways:
- For indexes on BLOB and TEXT columns, you must specify an index prefix length. For CHAR and VARCHAR, a prefix length is optional. See Section 7.4.2, “Column Indexes”.
- BLOB and TEXT columns cannot have DEFAULT values."
Please find attached a patch to fix this.
Attachments (1)
Change History (4)
Changed 15 years ago by
Attachment: | mythplugins-mytharchive-mytharchive-dbcheck_cpp.patch added |
---|
comment:1 Changed 15 years ago by
Milestone: | 0.22 → unknown |
---|---|
Priority: | blocker → trivial |
Severity: | medium → low |
comment:2 Changed 15 years ago by
Owner: | changed from paulh to Rob Smith |
---|---|
Status: | new → accepted |
comment:3 Changed 14 years ago by
Resolution: | → fixed |
---|---|
Status: | accepted → closed |
Note: See
TracTickets for help on using
tickets.
(In [22384]) Fixes #6802, Fixes #6820, this allows the database schema updates to run on mysql database running in strict modes