Moodle

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

Details

  • Type: Sub-task Sub-task
  • Status: Closed Closed
  • Priority: Minor Minor
  • Resolution: Fixed
  • Affects Version/s: 1.7.1
  • Fix Version/s: 2.0
  • Component/s: Installation
  • Labels:
    None
  • Environment:
    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.
  • Database:
    MySQL
  • Affected Branches:
    MOODLE_17_STABLE
  • Fixed Branches:
    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.

Activity

Ascending order - Click to sort in descending order
Hide
Permalink
Martin Dougiamas added a comment -

I've not ever run into this but perhaps Petr is already aware of something like this.

Show
Martin Dougiamas added a comment - I've not ever run into this but perhaps Petr is already aware of something like this.
Hide
Permalink
Petr Škoda (skodak) added a comment -

Did you enable strict mode in MySQL setup?

Moodle does not work with that yet

Show
Petr Škoda (skodak) added a comment - Did you enable strict mode in MySQL setup? Moodle does not work with that yet
Hide
Permalink
Ken Cornish added a comment -

Yes, I do have strict mode enabled. Are there run time issues with this mode? I got the install completed as I mentioned. Does this have an impact on self-registration?

Show
Ken Cornish added a comment - Yes, I do have strict mode enabled. Are there run time issues with this mode? I got the install completed as I mentioned. Does this have an impact on self-registration?
Hide
Permalink
Petr Škoda (skodak) added a comment -

please disable strict mode if you want to run Moodle with MySQL 5.x - http://docs.moodle.org/en/Installing_Moodle

Show
Petr Škoda (skodak) added a comment - please disable strict mode if you want to run Moodle with MySQL 5.x - http://docs.moodle.org/en/Installing_Moodle
Hide
Permalink
Eloy Lafuente (stronk7) added a comment -

I think I've installed Moodle in windows a lot of times since this was reported and seems to work ok now. Closing as fixed. Ciao

Show
Eloy Lafuente (stronk7) added a comment - I think I've installed Moodle in windows a lot of times since this was reported and seems to work ok now. Closing as fixed. Ciao

People

Vote (0)
Watch (0)

Dates

  • Created:
    Updated:
    Resolved:
Atlassian JIRA (v4.4.5#665-sha1:422aead) | Report a problem
Powered by a free Atlassian JIRA open source license for Moodle. Try JIRA - bug tracking software for your team.