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] [Created] (ODE-966) SQL scripts fail on newest MySQL

Piotr Kubowicz created ODE-966:
----------------------------------

             Summary: 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
{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.

--
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

        

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

Posted by "Piotr Kubowicz (JIRA)" <ji...@apache.org>.
     [ 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 and mysql.sql cause errors on the newest versions of MySQL. The reason is that the scripts use 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
  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.

    
> 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 and mysql.sql cause errors on the newest versions of MySQL. The reason is that the scripts use 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

        

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

Posted by "Tammo van Lessen (JIRA)" <ji...@apache.org>.
    [ https://issues.apache.org/jira/browse/ODE-966?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=13497625#comment-13497625 ] 

Tammo van Lessen commented on ODE-966:
--------------------------------------

Confirmed, thanks for reporting this. Unfortunately there is not stable release from openJPA's 1.3.x branch, so we cannot use it in a bugfix release. We try to address this for the next major release (1.4)
                
> 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 12.04
>            Reporter: Piotr Kubowicz
>             Fix For: 1.4
>
>
> ode-135-hib-mysql.sql and mysql.sql cause errors on the newest versions of MySQL. The reason is that the scripts use 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
For more information on JIRA, see: http://www.atlassian.com/software/jira

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

Posted by "Piotr Kubowicz (JIRA)" <ji...@apache.org>.
     [ 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

        

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

Posted by "Piotr Kubowicz (JIRA)" <ji...@apache.org>.
     [ https://issues.apache.org/jira/browse/ODE-966?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ]

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

    Environment: mysql 5.5.20, ubuntu 12.04  (was: mysql 5.5.20, ubuntu 14.14)
    
> 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 12.04
>            Reporter: Piotr Kubowicz
>
> ode-135-hib-mysql.sql and mysql.sql cause errors on the newest versions of MySQL. The reason is that the scripts use 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

        

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

Posted by "Tammo van Lessen (JIRA)" <ji...@apache.org>.
     [ https://issues.apache.org/jira/browse/ODE-966?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ]

Tammo van Lessen updated ODE-966:
---------------------------------

    Fix Version/s: 1.4
    
> 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 12.04
>            Reporter: Piotr Kubowicz
>             Fix For: 1.4
>
>
> ode-135-hib-mysql.sql and mysql.sql cause errors on the newest versions of MySQL. The reason is that the scripts use 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
For more information on JIRA, see: http://www.atlassian.com/software/jira