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

6 Feb 2018

      Hi,

try to load your database dump into an empty database.

Katrin

-------- Forwarded Message --------
Subject: 	Re: [Koha] #1005 - Can't create table `koha_library`.`aqbasket`
Date: 	Tue, 6 Feb 2018 08:46:04 +0100
From: 	Igbudu Tersoo <murphyigbudu@gmail.com>
To: 	Katrin Fischer <katrin.fischer.83@web.de>

Hi Katrin
  in my case, the tables have been created by the web installer. 
remember i earlier said i just installed koha 17.11 which came with its 
database structure.  the data i am trying to import that this error is 
coming up was backed up from koha 3.18.
Please i am still waiting for a solution.
Thank you.

On Tue, Feb 6, 2018 at 7:32 AM, Katrin Fischer <katrin.fischer.83@web.de 
<mailto:katrin.fischer.83@web.de>> wrote:

    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
        <http://koha.1045719.n5.nabble.com/Koha-general-f3047918.html>
        _______________________________________________
        Koha mailing list http://koha-community.org
        Koha@lists.katipo.co.nz <mailto:Koha@lists.katipo.co.nz>
        https://lists.katipo.co.nz/mailman/listinfo/koha
        <https://lists.katipo.co.nz/mailman/listinfo/koha>

    _______________________________________________
    Koha mailing list http://koha-community.org
    Koha@lists.katipo.co.nz <mailto:Koha@lists.katipo.co.nz>
    https://lists.katipo.co.nz/mailman/listinfo/koha
    <https://lists.katipo.co.nz/mailman/listinfo/koha>