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

Install error: MySQL says "BLOB/TEXT column 'sessdata' can't have a default value"

    XMLWordPrintable

    Details

    • Type: Bug
    • Status: Closed
    • Priority: Minor
    • Resolution: Duplicate
    • Affects Version/s: 1.9
    • Fix Version/s: None
    • Component/s: Database SQL/XMLDB
    • Labels:
      None
    • Environment:
      Apache 2.2.4, MySQL 5.1.17, PHP 5.2.1
    • Database:
      MySQL
    • Affected Branches:
      MOODLE_19_STABLE

      Description

      During fresh install (from CVS), MySQL says:

      1101: BLOB/TEXT column 'sessdata' can't have a default value

      ADOConnection._Execute(CREATE TABLE mdl_sessions2 (
      sesskey VARCHAR(64) NOT NULL DEFAULT '',
      expiry DATETIME NOT NULL,
      expireref VARCHAR(25..., false) % line 891, file: adodb.inc.php
      ADOConnection.Execute(CREATE TABLE mdl_sessions2 (
      sesskey VARCHAR(64) NOT NULL DEFAULT '',
      expiry DATETIME NOT NULL,
      expireref VARCHAR(25...) % line 89, file: dmllib.php
      execute_sql(CREATE TABLE mdl_sessions2 (
      sesskey VARCHAR(64) NOT NULL DEFAULT '',
      expiry DATETIME NOT NULL,
      expireref VARCHAR(25..., true) % line 1899, file: dmllib.php
      execute_sql_arr(Array[280]) % line 548, file: ddllib.php
      install_from_xmldb_file(D:\Moodle\moodle/lib/db/install.xml) % line 179, file: index.php

      This problem did not appeared on MySQL 5.0.33 and 5.0.22, and it seems to have a solution on http://moodle.org/mod/forum/discuss.php?d=58264#p267957

        Attachments

          Issue Links

            Activity

              People

              • Votes:
                0 Vote for this issue
                Watchers:
                0 Start watching this issue

                Dates

                • Created:
                  Updated:
                  Resolved: