Opened 16 years ago
Closed 16 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)
by , 16 years ago
| Attachment: | mythplugins-mytharchive-mytharchive-dbcheck_cpp.patch added |
|---|
comment:1 by , 16 years ago
| Milestone: | 0.22 → unknown |
|---|---|
| Priority: | blocker → trivial |
| Severity: | medium → low |
comment:2 by , 16 years ago
| Owner: | changed from to |
|---|---|
| Status: | new → accepted |
comment:3 by , 16 years ago
| 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