[Building Sakai] MySql configuration is throwing Erros

[Steve Swinsburg]

Shouldn't that be CREATE TABLE .... *ENGINE*=InnoDB ?

The ENGINE/ TYPE keyword was synonymous up until MySQL 5 or so - its been
dropped now though IIRC and we should be using ENGINE= syntax.

Also, MySQL 5.6 hasnt been tested on Sakai yet, you should be able to get
this up and running with 5.5.

cheers,
Steve


On Wed, Oct 23, 2013 at 7:17 AM, Pushyami Gundala <pushyami at umich.edu>wrote:

> Hi, I am trying to configure Mysql in my Local development, When try to
> start the tomcat i am running into some errors . I am able to connect to
> the database and some table are created not all. I see that the problems
> with creating the table for the "Grade Book" and "Assigments" modules. I
> have the full error list in the attachments. I tried to Drop the database
> and create it again, still saw the same issue.
>
>   2013-10-22 15:54:56,300  WARN localhost-startStop-1
> org.sakaiproject.springframework.orm.hibernate.AddableSessionFactoryBean -
> Unsuccessful schema statement: create table ASN_AP_ITEM_ACCESS_T (ID bigint
> not null auto_increment, ITEM_ACCESS varchar(255), ASN_AP_ITEM_ID bigint
> not null, primary key (ID), unique (ITEM_ACCESS, ASN_AP_ITEM_ID))
> type=InnoDB  com.mysql.jdbc.exceptions.jdbc4.MySQLSyntaxErrorException:
> 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 'type=InnoDB' at
> line 1        2013-10-22 15:54:56,302  WARN localhost-startStop-1
> org.sakaiproject.springframework.orm.hibernate.AddableSessionFactoryBean -
> Unsuccessful schema statement: create table ASN_AP_ITEM_T (ID bigint not
> null, ASSIGNMENT_ID varchar(255), TITLE varchar(255), TEXT longtext,
> RELEASE_DATE datetime, RETRACT_DATE datetime, HIDE bit, primary key (ID))
> type=InnoDB  com.mysql.jdbc.exceptions.jdbc4.MySQLSyntaxErrorException:
> 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 'type=InnoDB' at
> line 1        2013-10-22 15:54:56,303  WARN localhost-startStop-1
> org.sakaiproject.springframework.orm.hibernate.AddableSessionFactoryBean -
> Unsuccessful schema statement: create table ASN_MA_ITEM_T (ID bigint not
> null, ASSIGNMENT_ID varchar(255), TEXT longtext, SHOW_TO integer, primary
> key (ID)) type=InnoDB    com.mysql.jdbc.exceptions.jdbc4.MySQLSyntaxErrorException:
> 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 'type=InnoDB' at
> line 1        2013-10-22 15:54:56,304  WARN localhost-startStop-1
> org.sakaiproject.springframework.orm.hibernate.AddableSessionFactoryBean -
> Unsuccessful schema statement: create table ASN_NOTE_ITEM_T (ID bigint not
> null auto_increment, ASSIGNMENT_ID varchar(255), NOTE longtext, CREATOR_ID
> varchar(255), SHARE_WITH integer, primary key (ID)) type=InnoDB
>
>
>
>
>
>
>
>
>
>
>
>
>  Sakai version : Trunk
> MySql Version :5.6
>
>
>
>
>
>
>
>
>
>
>
>
>
>
>
>
>
>
> _______________________________________________
> 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/20131023/0f3fc2d1/attachment.html