id,summary,reporter,owner,description,type,status,priority,milestone,component,version,severity,resolution,keywords,cc,mlocked 6811,Invalid default value for BLOB field in MySQL CREATE statement for mythweb_sessions table,Jonathan Martens ,Rob Smith,"Like issue #6802, there is also a invalid default value specified in the create statement of the mythweb_sessions table in the MythWeb plugin. 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. ",defect,closed,trivial,unknown,Plugin - MythWeb,head,low,fixed,,,0