Moodle

Installation problem prevents sessions being implemented via the database

Details

  • Type: Bug Bug
  • Status: Closed Closed
  • Priority: Major Major
  • Resolution: Fixed
  • Affects Version/s: 1.7.1
  • Fix Version/s: 1.7.4
  • Component/s: Installation
  • Labels:
    None
  • Environment:
    Windows 2000 / XP and Linux Ubuntu 6.1.0
  • Database:
    MySQL
  • Affected Branches:
    MOODLE_17_STABLE
  • Fixed Branches:
    MOODLE_17_STABLE

Description

During the install process the component responsible for installing the SQL scripts errors on the SESSIONS2 table.

The error message indicates that this is because the DEFAULT attribute is not allowed on TEXT/BLOB fields.

A local fix has been successful - this involved modifying /lib/db/install.xml and removing the DEFAULT="" statement from the node definition for the 'sessdata' field.

Activity

Hide
Petr Škoda (skodak) added a comment -

assigning to db guru

Show
Petr Škoda (skodak) added a comment - assigning to db guru
Hide
Eloy Lafuente (stronk7) added a comment -

This was fixed some time ago when destroying all the text->default clauses. Closing.

Show
Eloy Lafuente (stronk7) added a comment - This was fixed some time ago when destroying all the text->default clauses. Closing.

People

Dates

  • Created:
    Updated:
    Resolved: