[Building Sakai] Issue with sql script to upgrade msgcntr

[Sam Ottenhoff]

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>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****
>
> Cell: (919) 442-8337 ****
>
> E-mail: mike_jennings at unc.edu****
>
> ** **
>
> *From:* Stoufer,R M [mailto:kc4uf at ufl.edu]
> *Sent:* Thursday, August 18, 2011 3:09 PM
>
> *To:* Jennings, Michael; 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]
> *Sent:* Thursday, August 18, 2011 2:49 PM
> *To:* Stoufer,R M; 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****
>
> Cell: (919) 442-8337 ****
>
> E-mail: mike_jennings at unc.edu****
>
> ** **
>
> *From:* Stoufer,R M [mailto:kc4uf at ufl.edu]
> *Sent:* Thursday, August 18, 2011 2:47 PM
> *To:* Jennings, Michael; 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] *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****
>
> ** **
>
> _______________________________________________
> sakai-dev mailing list
> 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 with a subject of
> "unsubscribe"
>
-------------- next part --------------
An HTML attachment was scrubbed...
URL: http://collab.sakaiproject.org/pipermail/sakai-dev/attachments/20110818/ba743bca/attachment.html