You are viewing a plain text version of this content. The canonical link for it is here.
Posted to dev@ode.apache.org by "Piotr Kubowicz (JIRA)" <ji...@apache.org> on 2012/06/04 15:18:23 UTC

[jira] [Updated] (ODE-966) SQL scripts fail on newest MySQL

     [ https://issues.apache.org/jira/browse/ODE-966?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ]

Piotr Kubowicz updated ODE-966:
-------------------------------

    Description: 
ode-135-hib-mysql.sql causes errors on the newest versions of MySQL. The reason is that the script uses syntax like
  TYPE=InnoDB;

TYPE was replaced by ENGINE in MySQL and since MySQL 5.5 the old syntax is no longer supported. 

Please use
  ENGINE=InnoDB;
instead.

See OPENJPA-1530 for more details.

  was:
ode-135-hib-mysql.sql causes errors on the newest versions of MySQL. The reason is that the script uses syntax like
{noformat}
TYPE=InnoDB;
{noformat}
TYPE was replaced by ENGINE in MySQL and since MySQL 5.5 the old syntax is no longer supported. Please use
{noformat}
ENGINE=InnoDB;
{noformat}
instead.

See OPENJPA-1530 for more details.

    
> SQL scripts fail on newest MySQL
> --------------------------------
>
>                 Key: ODE-966
>                 URL: https://issues.apache.org/jira/browse/ODE-966
>             Project: ODE
>          Issue Type: Bug
>    Affects Versions: 1.3.5
>         Environment: mysql 5.5.20, ubuntu 14.14
>            Reporter: Piotr Kubowicz
>
> ode-135-hib-mysql.sql causes errors on the newest versions of MySQL. The reason is that the script uses syntax like
>   TYPE=InnoDB;
> TYPE was replaced by ENGINE in MySQL and since MySQL 5.5 the old syntax is no longer supported. 
> Please use
>   ENGINE=InnoDB;
> instead.
> See OPENJPA-1530 for more details.

--
This message is automatically generated by JIRA.
If you think it was sent incorrectly, please contact your JIRA administrators: https://issues.apache.org/jira/secure/ContactAdministrators!default.jspa
For more information on JIRA, see: http://www.atlassian.com/software/jira