From 36bbe8a649162197c955740e4e2454c91f8bfad5 Mon Sep 17 00:00:00 2001 From: Paul Poulain Date: Fri, 22 Jun 2012 11:10:18 +0200 Subject: [PATCH] Bug 8289 Upgrading from 2.2 does not work anymore The updatedatabase22to30.pl script update the engine from MyISAM to InnoDB for most tables. However, the TYPE=InnoDB was deprecated, and is not removed. The correct syntax is now ENGINE=InnoDB Signed-off-by: Chris Cormack --- installer/data/mysql/update22to30.pl | 2 +- 1 file changed, 1 insertion(+), 1 deletion(-) diff --git a/installer/data/mysql/update22to30.pl b/installer/data/mysql/update22to30.pl index 76bb3c2..23d7a75 100755 --- a/installer/data/mysql/update22to30.pl +++ b/installer/data/mysql/update22to30.pl @@ -3022,7 +3022,7 @@ my $DBversion = "3.00.00.000"; next if $table->{Name} eq 'auth_subfield_table'; if ($table->{Engine} ne 'InnoDB') { print "moving $table->{Name} to InnoDB\n"; - $dbh->do("ALTER TABLE $table->{Name} TYPE = innodb"); + $dbh->do("ALTER TABLE $table->{Name} ENGINE = innodb"); } unless ($table->{Collation} =~ /^utf8/) { print "moving $table->{Name} to utf8\n"; -- 1.7.10