[Building Sakai] MySql configuration is throwing Erros
Neal Caidin
neal.caidin at apereo.org
Thu Jan 9 10:22:24 PST 2014
Thanks for the follow up Jez!
Cheers,
Neal
Apereo Foundation
Sakai Community Coordinator
> Jez Cope <mailto:j.cope at bath.ac.uk>
> January 9, 2014 at 9:45 AM
> 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,
> _______________________________________________
> 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"
> Steve Swinsburg <mailto:steve.swinsburg at gmail.com>
> October 22, 2013 at 7:24 PM
> 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
>
>
>
> _______________________________________________
> 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"
> Pushyami Gundala <mailto:pushyami at umich.edu>
> October 22, 2013 at 4:17 PM
> 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"
--
Neal Caidin
Sakai Community Coordinator
Apereo Foundation
neal.caidin at apereo.org
Skype me! (but let me know in advance for the first interaction) - nealkdin
-------------- next part --------------
An HTML attachment was scrubbed...
URL: http://collab.sakaiproject.org/pipermail/sakai-dev/attachments/20140109/c281757b/attachment.html
-------------- next part --------------
A non-text attachment was scrubbed...
Name: postbox-contact.jpg
Type: image/jpeg
Size: 1177 bytes
Desc: not available
Url : http://collab.sakaiproject.org/pipermail/sakai-dev/attachments/20140109/c281757b/attachment.jpg
-------------- next part --------------
A non-text attachment was scrubbed...
Name: postbox-contact.jpg
Type: image/jpeg
Size: 1251 bytes
Desc: not available
Url : http://collab.sakaiproject.org/pipermail/sakai-dev/attachments/20140109/c281757b/attachment-0001.jpg
-------------- next part --------------
A non-text attachment was scrubbed...
Name: compose-unknown-contact.jpg
Type: image/jpeg
Size: 770 bytes
Desc: not available
Url : http://collab.sakaiproject.org/pipermail/sakai-dev/attachments/20140109/c281757b/attachment-0002.jpg
More information about the sakai-dev
mailing list