|
|
|
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 » |
made changes - 21/Aug/06 04:21 PM
| Field |
Original Value |
New Value |
|
Assignee
|
Eloy Lafuente
[ eloylafuente
]
|
Eloy Lafuente
[ stronk7
]
|
made changes - 06/May/07 06:43 PM
|
Link
|
|
This issue is duplicated by MDL-9530
[ MDL-9530
]
|
made changes - 06/May/07 06:44 PM
|
Link
|
|
This issue is duplicated by MDL-7994
[ MDL-7994
]
|
made changes - 06/May/07 06:51 PM
|
Link
|
|
This issue will help resolve MDL-9722
[ MDL-9722
]
|
made changes - 09/Dec/07 01:18 AM
|
Link
|
|
This issue is duplicated by MDL-8372
[ MDL-8372
]
|
made changes - 09/Dec/07 01:19 AM
|
Fix Version/s
|
|
1.9
[ 10190
]
|
|
Resolution
|
|
Fixed
[ 1
]
|
|
Status
|
In Progress
[ 3
]
|
Closed
[ 6
]
|
|
Fix Version/s
|
|
1.8.3
[ 10230
]
|
|
Bug
Closed
