Details
-
Type:
Improvement
-
Status:
Closed
-
Priority:
Minor
-
Resolution: Fixed
-
Affects Version/s: 1.8.1
-
Component/s: Installation
-
Labels:None
-
Database:MySQL
-
Affected Branches:MOODLE_18_STABLE
-
Fixed Branches:MOODLE_18_STABLE, MOODLE_19_STABLE
Description
Installation checks for unicode et cetera, it could detect the MySQL strict mode too. Recent versions of MySQL have this on by default, and it prevents installation of Moodle anyway, so catching it before the nasty errors (see MDL-6218) would be a bonus. Maybe some short info text about how to disable the strict mode?
The SQL mode can be queried and checked, a bit like the character set, see http://dev.mysql.com/doc/refman/5.0/en/server-sql-mode.html.
Issue Links
| This issue will be resolved by: | ||||
| MDL-6218 | MySQL - TEXT and BLOB columns can't have a default value |
|
|
|
Activity
- All
- Comments
- History
- Activity
- Source
- Test Sessions
Hide
Eloy Lafuente (stronk7)
added a comment -
Show
Eloy Lafuente (stronk7)
added a comment - Hi,
as MDL-6218 have been fixed, there aren't TEXT + DEFAULT fields anymore since Moodle 1.8. Also, for old sites, the DEFAULT will be dropped as part of the upgrade to 1.9.
So, perhaps, once MDL-6218 will be closed, this won't need further action...
Ciao 
Hide
Eloy Lafuente (stronk7)
added a comment -
With the deletion of all those DEFAULTS in TEXT columns, both install and upgrade to 1.8 works perfectly under mysql's strict mode.
So, closing this now. Ciao
Show
Eloy Lafuente (stronk7)
added a comment - With the deletion of all those DEFAULTS in TEXT columns, both install and upgrade to 1.8 works perfectly under mysql's strict mode.
So, closing this now. Ciao
If
MDL-6218is resolved, then this feature request is void. That is, if there are no other issues preventing installing Moodle with the SQL strict mode on.MDL-6218is resolved, then this feature request is void. That is, if there are no other issues preventing installing Moodle with the SQL strict mode on.