[Building Sakai] MySql configuration is throwing Erros

[Jez Cope]

Just wanted to follow up on this as I'd had the same problem this week and found that the solution for me was to set hibernate.dialect (in your sakai.properties or local.properties) to MySQL5InnoDBDialect instead of MySQLInnoDBDialect - then Hibernate just does the right thing.

All the best,
Jez

At Wed, 23 Oct 2013 10:24:41 +1100,
Steve Swinsburg wrote:
> 
> [1  <multipart/alternative (7bit)>]
> [1.1  <text/plain; ISO-8859-1 (7bit)>]
> 
> [1.2  <text/html; ISO-8859-1 (quoted-printable)>]
> 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"
> 
> 
> [2  <text/plain; us-ascii (7bit)>]
> _______________________________________________
> 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"