Attachment 10446 Details for Bug 8289 – Bug 8289 Upgrading from 2.2 does not work anymore

[patch] Bug 8289 Upgrading from 2.2 does not work anymore

Bug-8289-Upgrading-from-22-does-not-work-anymore.patch (text/plain), 1.22 KB, created by Chris Cormack on 2012-06-24 07:05:50 UTC

(hide)

Description:

Filename:

MIME Type:

Creator: Chris Cormack

Created: 2012-06-24 07:05:50 UTC

Size: 1.22 KB

patch

obsolete

>From 36bbe8a649162197c955740e4e2454c91f8bfad5 Mon Sep 17 00:00:00 2001
>From: Paul Poulain <paul.poulain@biblibre.com>
>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 <chris@bigballofwax.co.nz>
>---
> 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

Actions: View | Diff | Splinter Review

Attachments on bug 8289: 10425 | 10446