[Building Sakai] Issue with sql script to upgrade msgcntr

[Stoufer,R M]

Hi Mike,

Looks like you have a double quote (") at the end of the line which shouldn't be there.

Mike

R. Michael Stoufer
Academic Technology - ICS
University of Florida



From: sakai-dev-bounces at collab.sakaiproject.org [mailto:sakai-dev-bounces at collab.sakaiproject.org] On Behalf Of Jennings, Michael
Sent: Thursday, August 18, 2011 2:41 PM
To: sakai-dev at collab.sakaiproject.org
Subject: [Building Sakai] Issue with sql script to upgrade msgcntr

I am trying to run the script to upgrade the msgcntr from 2.7.x to 2.8.x and I get a error every time I run

alter table MFR_AREA_T modify (AVAILABILITY_RESTRICTED bit NOT NULL DEFAULT '');

It says that my syntax is wrong

ERROR 1064 (42000) at line 3: You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near '(AVAILABILITY_RESTRICTED bit NOT NULL DEFAULT '')' at line 1

I am running mysql 5.5 enterprise edition.....

Any suggestions?

Mike

==============================================================================
Mike Jennings
Teaching and Learning Developer
University of North Carolina at Chapel Hill

Office: (919) 843-5013
Cell: (919) 442-8337
E-mail: mike_jennings at unc.edu<mailto:mike_jennings at unc.edu>

-------------- next part --------------
An HTML attachment was scrubbed...
URL: http://collab.sakaiproject.org/pipermail/sakai-dev/attachments/20110818/6d1dd124/attachment.html