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
            Votes:
            0 Vote for this issue
            Watchers:
            0 Start watching this issue

            Dates

              Created:
              Updated:
              Resolved:
              24/Nov/10