Skip to:

  1. Skip to Jira Navigation
  2. Skip to Side Navigation
  3. Skip to Main Content

sakai_2_7_0_mysql_conversion.sql: line to add isCollab columnto table osp_presentation has error

Description

The statement on line 23:

ALTER TABLE osp_presentation ADD isCollab bit DEFAULT '0';

causes an error:

Invalid default value for 'isCollab'

this works better:

ALTER TABLE osp_presentation ADD isCollab bit DEFAULT 0;

Activity

Anthony Whyte August 10, 2010 at 5:11 PM
Edited

Trunk, r81037, 2.7.x, r81038, 2.7.1, r81039.

Fixed

Details

Priority

Affects versions

Fix versions

Components

Assignee

Reporter

Conversion Script Required

Yes

Created July 28, 2010 at 4:19 PM
Updated August 10, 2010 at 7:10 PM
Resolved August 10, 2010 at 5:11 PM

Flag notifications