[Koha] #1005 - Can't create table `koha_library`.`aqbasket`

murphy murphyigbudu at gmail.com
Mon Feb 5 21:19:57 NZDT 2018

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:

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

More information about the Koha mailing list