X-Git-Url: http://git.rot13.org/?a=blobdiff_plain;f=installer%2Fdata%2Fmysql%2Fupdate22to30.pl;h=d38f080bcccc389b30e41419ac992b0536c2c538;hb=13faff1250ed3ede712c405821f3ad9187e892b6;hp=76bb3c2053f80eec3f81ae11b03581704c5a2acf;hpb=5278aa0ca4bb5110741b792b527725280a3ee902;p=koha.git diff --git a/installer/data/mysql/update22to30.pl b/installer/data/mysql/update22to30.pl index 76bb3c2053..d38f080bcc 100755 --- a/installer/data/mysql/update22to30.pl +++ b/installer/data/mysql/update22to30.pl @@ -12,7 +12,6 @@ # NOTE: If you do something more than once in here, make it table driven. use strict; -#use warnings; FIXME - Bug 2505 # CPAN modules use DBI; @@ -3022,7 +3021,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"; @@ -3443,7 +3442,7 @@ my $DBversion = "3.00.00.000"; $dbh->do($sql); if ($dbh->err) { print "==================== - An error occured during : + An error occurred during : \t$sql It probably means there is something wrong in your DB : a row ($table.$row->{key}) refers to a value in $row->{foreigntable}.$row->{foreignkey} that does not exist. solve the problem and run updater again (or just the previous SQL statement). You can find those values with select