|
|
|
Environment:
|
All
|
|
Issue Links:
|
Dependency
|
|
This issue will help resolve:
|
|
MDL-9722
Add an installation check for the MySQL strict mode
|
|
|
|
|
|
Duplicate
|
|
|
|
This issue is duplicated by:
|
|
MDL-7994
Upgrade Errors: MySQL Error 1101: BLOB/TEXT columns cannot have a DEFAULT value
|
|
|
|
 |
MDL-9530
Install error: MySQL says "BLOB/TEXT column 'sessdata' can't have a default value"
|
|
|
|
|
MDL-8372
Drop all TEXT defaults across Moodle
|
|
|
|
|
|
|
This is a follow up to MDL-6206 (adding a quiz fails on some MySQL 5 setups because it relies on using a default value for a TEXT column)
According to the MySQL documentation TEXT and BLOB aren't allowed to use default values - http://dev.mysql.com/doc/refman/5.0/en/blob.html - but a quick search of the .sql files in moodle using a regexp like
/ text[^rn,]+default/i
finds several places where text columns are setup with a default value - obviously it would require much more in depth checking to find out if any of these default values are required anytime a row is created.
As noted in the previous bug MySQL only seems to enforce it's no default values for TEXT or BLOB rule with certain values of the sql_mode server variable (I think the default value of sql_mode in MySQL 5.0.22 includes the STRICT_TRANS_TABLES option which causes any query trying to use a default value to fail)
|
|
Description
|
This is a follow up to MDL-6206 (adding a quiz fails on some MySQL 5 setups because it relies on using a default value for a TEXT column)
According to the MySQL documentation TEXT and BLOB aren't allowed to use default values - http://dev.mysql.com/doc/refman/5.0/en/blob.html - but a quick search of the .sql files in moodle using a regexp like
/ text[^rn,]+default/i
finds several places where text columns are setup with a default value - obviously it would require much more in depth checking to find out if any of these default values are required anytime a row is created.
As noted in the previous bug MySQL only seems to enforce it's no default values for TEXT or BLOB rule with certain values of the sql_mode server variable (I think the default value of sql_mode in MySQL 5.0.22 includes the STRICT_TRANS_TABLES option which causes any query trying to use a default value to fail) |
Show » |
committed 1 file to 'Moodle CVS' on branch 'MOODLE_18_STABLE' - 24/Jul/07 07:26 AM
Anihilate the last TEXT column having a default clause. With thin, Moodle > 1.8
builds under strict (mysql) and those defaults won't be there anymore. As part
of the upgrade to 1.9 one check is going to be performed to see if it's needed
to drop such default. MDL-6218
|
|
|
committed 2 files to 'Moodle CVS' - 24/Jul/07 07:28 AM
Drop the latest TEXT default existing since XMLDB debut. MDL-6218
|
|
|
committed 1 file to 'Moodle CVS' - 03/Jul/09 09:12 AM
MDL-6218 TEXT/BINARY columns and default clauses - forbidden since ages, warn and autofix them if found
|
|
|
|
Bug
Closed
