Issue Details (XML | Word | Printable)

Key: MDL-9722
Type: Improvement Improvement
Status: Resolved Resolved
Resolution: Fixed
Priority: Minor Minor
Assignee: Eloy Lafuente (stronk7)
Reporter: Samuli Karevaara
Votes: 0
Watchers: 1
Operations

Add/Edit UI Mockup to this issue
If you were logged in you would be able to see more operations.
Moodle

Add an installation check for the MySQL strict mode

Created: 06/May/07 06:49 PM   Updated: 09/Dec/07 01:23 AM
Return to search
Component/s: Installation
Affects Version/s: 1.8.1
Fix Version/s: 1.8.3, 1.9

Issue Links:
Dependency
 

Database: MySQL
Participants: Eloy Lafuente (stronk7) and Samuli Karevaara
Security Level: None
Resolved date: 09/Dec/07
Affected Branches: MOODLE_18_STABLE
Fixed Branches: MOODLE_18_STABLE, MOODLE_19_STABLE


 Description  « Hide
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.

 All   Comments   Change History   Version Control      Sort Order: Ascending order - Click to sort in descending order
Samuli Karevaara added a comment - 06/May/07 06:51 PM
If MDL-6218 is resolved, then this feature request is void. That is, if there are no other issues preventing installing Moodle with the SQL strict mode on.

Eloy Lafuente (stronk7) added a comment - 24/Jul/07 07:41 AM
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


Eloy Lafuente (stronk7) added a comment - 09/Dec/07 01:23 AM
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