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

[Katrin Fischer]

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 at lists.katipo.co.nz
> https://lists.katipo.co.nz/mailman/listinfo/koha