Hi Murphy, have you loaded your database dump into an empty database or had the tables already been created by the web installer? Hope this helps, Katrin On 05.02.2018 09:19, murphy wrote:
Hi, we were using koha 3.18 running on ubuntu 14.04 since 2015. 2 weeks back the server refused to respond. i now backed up the data using mysql dump and re-installed koha 17.11 running on ubuntu 16.04 and mariadb database. i am now trying to import the backup of our former server using phpmyadmin, it starts to import then, the following error pops up. what to do. below is the error:
Error SQL query:
CREATE TABLE `aqbasket` ( `basketno` int(11) NOT NULL AUTO_INCREMENT, `basketname` varchar(50) DEFAULT NULL, `note` mediumtext, `booksellernote` mediumtext, `contractnumber` int(11) DEFAULT NULL, `creationdate` date DEFAULT NULL, `closedate` date DEFAULT NULL, `booksellerid` int(11) NOT NULL DEFAULT '1', `authorisedby` varchar(10) DEFAULT NULL, `booksellerinvoicenumber` mediumtext, `basketgroupid` int(11) DEFAULT NULL, `deliveryplace` varchar(10) DEFAULT NULL, `billingplace` varchar(10) DEFAULT NULL, `branch` varchar(10) DEFAULT NULL, PRIMARY KEY (`basketno`), KEY `booksellerid` (`booksellerid`), KEY `basketgroupid` (`basketgroupid`), KEY `contractnumber` (`contractnumber`), KEY `aqbasket_ibfk_4` (`branch`), CONSTRAINT `aqbasket_ibfk_1` FOREIGN KEY (`booksellerid`) REFERENCES `aqbooksellers` (`id`) ON UPDATE CASCADE, CONSTRAINT `aqbasket_ibfk_2` FOREIGN KEY (`contractnumber`) REFERENCES `aqcontract` (`contractnumber`), CONSTRAINT `aqbasket_ib[...] MySQL said: Inline image 1
#1005 - Can't create table `koha_library`.`aqbasket` (errno: 150 "Foreign key constraint is incorrectly formed") (Details…)
Thank you.
-- Sent from: http://koha.1045719.n5.nabble.com/Koha-general-f3047918.html _______________________________________________ Koha mailing list http://koha-community.org Koha@lists.katipo.co.nz https://lists.katipo.co.nz/mailman/listinfo/koha