Flachzange
Basic Pleskian
[SOLVED] Error during upgrading from 11.0.9 #54 to 11.5.29
Plesk offered me a upgrade which I just tried. But I get an error in early phases during upgrade and Google did not help at all:
Here you find the log (from web update, but also tried command line).
Any help is appreciated.
Plesk offered me a upgrade which I just tried. But I get an error in early phases during upgrade and Google did not help at all:
Code:
===> Upgrading database
Trying to start service mysql... /usr/sbin/mysqld (pid 7951) is running...
done
Trying to establish test connection... connected
done
Trying to find psa database... version is 011009
Trying to backup MySQL database... done
MySQL databases are dumped to /private-backup/mysql.preupgrade.11.0.9-11.5.29.20130614-182913.dump.gz
Trying to upgrade APS controller database...
===> Cumulative APS controller database (apsc) upgrade has been started.
Trying to backup MySQL database... done
MySQL databases are dumped to /private-backup/mysql.preupgrade.apsc.11.0.9-11.5.29.20130614-182918.dump.gz
ERROR 1005 (HY000) at line 9: Can't create table 'apsc.aps_resource_adjacency_list' (errno: 150)
InnoDB
Code:
LATEST FOREIGN KEY ERROR
------------------------
130614 18:29:18 Error in foreign key constraint of table apsc/aps_resource_adjacency_list:
FOREIGN KEY (`base_resource_id`) REFERENCES `aps_resource` (`id`) ON DELETE NO ACTION ON UPDATE NO ACTION,
CONSTRAINT `FK_aps_resource_adjacency_list_dependent` FOREIGN KEY (`dependent_resource_id`) REFERENCES `aps_resource` (`id`) ON DELETE NO ACTION ON UPDATE NO ACTION
) ENGINE=InnoDB DEFAULT CHARSET=utf8:
Cannot resolve table name close to:
(`id`) ON DELETE NO ACTION ON UPDATE NO ACTION,
CONSTRAINT `FK_aps_resource_adjacency_list_dependent` FOREIGN KEY (`dependent_resource_id`) REFERENCES `aps_resource` (`id`) ON DELETE NO ACTION ON UPDATE NO ACTION
) ENGINE=InnoDB DEFAULT CHARSET=utf8
Here you find the log (from web update, but also tried command line).
Any help is appreciated.
Last edited: