# 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;
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";
$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