Uploaded image for project: 'Moodle'
  1. Moodle
  2. MDL-9722

Add an installation check for the MySQL strict mode

    XMLWordPrintable

    Details

    • Type: Improvement
    • Status: Closed
    • Priority: Minor
    • Resolution: Fixed
    • Affects Version/s: 1.8.1
    • Fix Version/s: 1.8.3, 1.9
    • 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.

        Attachments

          Issue Links

            Activity

              People

              Assignee:
              stronk7 Eloy Lafuente (stronk7)
              Reporter:
              samulik Samuli Karevaara
              Tester:
              Nobody
              Participants:
              Component watchers:
              Matteo Scaramuccia, Andrew Nicols, Dongsheng Cai, Huong Nguyen, Jun Pataleta, Michael Hawkins, Shamim Rezaie, Simey Lameze
              Votes:
              0 Vote for this issue
              Watchers:
              1 Start watching this issue

                Dates

                Created:
                Updated:
                Resolved:
                Fix Release Date:
                11/Oct/07