Uploaded image for project: 'Moodle'
  1. Moodle
  2. MDL-17458 Install & upgrade 2.0 cleanup META
  3. MDL-8619

MySQL strict mode - Windows installation session2 table 1.7+ and 1.8 Beta

    XMLWordPrintable

Details

    • Sub-task
    • Status: Closed
    • Minor
    • Resolution: Fixed
    • 1.7.1
    • 2.0
    • Installation
    • None
    • Tested on Windows 2000, Windows 2003 servers, Mysql 5.0.2, Apache 2.2.4, PHP 5.x. Stand-alone generic package and extraction form XAMP package.
    • MySQL
    • MOODLE_17_STABLE
    • MOODLE_20_STABLE

    Description

      Each time I tried installing either version on a Windows system already configured with Apache, PHP, and MySQL, it errored trying to create the session2 table. This also caused an error creating the admin account if I continued the installation.
      The error was generated due to a DEFAULT value being applied to the sessdata column. I removed that from the create table section and it solved the problem completely.

      Attachments

        Activity

          People

            skodak Petr Skoda
            kcornish Ken Cornish
            Matteo Scaramuccia, David Woloszyn, Huong Nguyen, Jake Dallimore, Meirza, Michael Hawkins, Raquel Ortega, Safat Shahin, Stevani Andolo
            Votes:
            0 Vote for this issue
            Watchers:
            0 Start watching this issue

            Dates

              Created:
              Updated:
              Resolved:
              24/Nov/10