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
[email protected]
https://lists.katipo.co.nz/mailman/listinfo/koha
_______________________________________________
Koha mailing list http://koha-community.org
[email protected]
https://lists.katipo.co.nz/mailman/listinfo/koha
