Opened 13 years ago

Closed 13 years ago

#1566 closed defect (fixed)

MySQL 5.5 no longer supports CREATE TABLE ... TYPE=InnoDB

Reported by: Nicklas Nordborg Owned by: everyone
Priority: major Milestone: BASE 2.17
Component: install Version:
Keywords: Cc:


According to the documentation at TYPE was deprecated in MySQL 4.0. It was removed in MySQL 5.5 and one should use ENGINGE=InnoDB instead.

Hibernate has fixed this some time ago, but it seems like we are still using the older MySQL dialect in the configuration file.

Change History (1)

comment:1 by Nicklas Nordborg, 13 years ago

Resolution: fixed
Status: newclosed

(In [5537]) Fixes #1566: MySQL 5.5 no longer supports CREATE TABLE ... TYPE=InnoDB

Changes the default dialect to org.hibernate.dialect.MySQL5InnoDBDialect. An additional problem was found in which incorrectly used type="string" length="65535" for a column declaration. We must use type="text" instead. Unfortunately this means that BASE will not install on MySQL 5.5 until 2.17 is released.

Note: See TracTickets for help on using tickets.