[Building Sakai] Issue with sql script to upgrade msgcntr

[Jennings, Michael]

Sam,

Thanks so much for pointing me in that direction.  I guess the msgcntr scripts need to be updated.  This is working now....

Thanks again..

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

From: Sam Ottenhoff [mailto:ottenhoff at longsight.com]
Sent: Thursday, August 18, 2011 3:25 PM
To: Jennings, Michael
Cc: Stoufer,R M; sakai-dev at collab.sakaiproject.org
Subject: Re: [Building Sakai] Issue with sql script to upgrade msgcntr

Here is the central 2.7 - 2.8 upgrade script for MySQL:

https://source.sakaiproject.org/svn/reference/branches/sakai-2.8.x/docs/conversion/sakai_2_8_0_mysql_conversion.sql

The alters in that file are confirmed working.

--Sam
On Thu, Aug 18, 2011 at 3:12 PM, Jennings, Michael <mike_jennings at unc.edu<mailto:mike_jennings at unc.edu>> wrote:
Thanks for the suggestion, but that still did not work...

Oh how I hate bits...

Mike

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

Office: (919) 843-5013<tel:%28919%29%20843-5013>
Cell: (919) 442-8337<tel:%28919%29%20442-8337>
E-mail: mike_jennings at unc.edu<mailto:mike_jennings at unc.edu>

From: Stoufer,R M [mailto:kc4uf at ufl.edu<mailto:kc4uf at ufl.edu>]
Sent: Thursday, August 18, 2011 3:09 PM

To: Jennings, Michael; sakai-dev at collab.sakaiproject.org<mailto:sakai-dev at collab.sakaiproject.org>
Subject: RE: Issue with sql script to upgrade msgcntr

Should've known it wasn't that simple ;>)

I have seen that type of command coded using ((0)).  So your's would look like:

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

The Oracle version of the sql is setting a default of false so this may be on the right track.

Mike

From: Jennings, Michael [mailto:mike_jennings at unc.edu]<mailto:[mailto:mike_jennings at unc.edu]>
Sent: Thursday, August 18, 2011 2:49 PM
To: Stoufer,R M; sakai-dev at collab.sakaiproject.org<mailto:sakai-dev at collab.sakaiproject.org>
Subject: RE: Issue with sql script to upgrade msgcntr

Well that is actually two single quotes, and there is some kind of binary data in there by default, but I am not sure it should be there or what should be there...

https://source.sakaiproject.org/svn/msgcntr/branches/msgcntr-2.8.x/messageforums-hbm/src/sql/mysql/mfr_conversion_27x-28x.sql

you will see the query on line 6

Mike



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

Office: (919) 843-5013<tel:%28919%29%20843-5013>
Cell: (919) 442-8337<tel:%28919%29%20442-8337>
E-mail: mike_jennings at unc.edu<mailto:mike_jennings at unc.edu>

From: Stoufer,R M [mailto:kc4uf at ufl.edu]<mailto:[mailto:kc4uf at ufl.edu]>
Sent: Thursday, August 18, 2011 2:47 PM
To: Jennings, Michael; sakai-dev at collab.sakaiproject.org<mailto:sakai-dev at collab.sakaiproject.org>
Subject: RE: Issue with sql script to upgrade msgcntr

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> [mailto:sakai-dev-bounces at collab.sakaiproject.org]<mailto:[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<mailto: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<tel:%28919%29%20843-5013>
Cell: (919) 442-8337<tel:%28919%29%20442-8337>
E-mail: mike_jennings at unc.edu<mailto:mike_jennings at unc.edu>


_______________________________________________
sakai-dev mailing list
sakai-dev at collab.sakaiproject.org<mailto:sakai-dev at collab.sakaiproject.org>
http://collab.sakaiproject.org/mailman/listinfo/sakai-dev

TO UNSUBSCRIBE: send email to sakai-dev-unsubscribe at collab.sakaiproject.org<mailto:sakai-dev-unsubscribe at collab.sakaiproject.org> with a subject of "unsubscribe"

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