Second this, terrifying as it is. Drop the database and reload the backup. It has to do with the way mysqldump exports the data, alphabetically and without regard to foreign key dependencies.
Cheers,
Liz
On 28/12/16 20:32, Katrin wrote:
>
> I have seen errors like this when trying to restore into a database
> where the web installer already created the tables for Koha. If that's
> the case, try to drop and create the database and then load your backup.
>
> Hope this helps,
>
> Katrin
>
> On 27.12.2016 08:39, Ahmad Nasser wrote:
>> i install koha using package installation and i when i restore backup
>> it give me this error ("Can't create table 'koha_library.aqbasket'
>> (errno: 150)")
>>
>> i install koha version 16.5 and my backup file for koha 3.16 so how
>> solve it.
>>
>> On Tue, Dec 27, 2016 at 8:43 AM, Katrin <[email protected]
>> <mailto:[email protected]>> wrote:
>>
>> Hi Ahmad,
>>
>> it's hard to tell for us where the problem is without the error
>> messages. Sometimes you will get warnings that can be safely
>> ignored. Can you send them with a new subject to the list?
>>
>> Katrin
>>
>>
>> On 26.12.2016 21:36, Ahmad Nasser wrote:
>>
>> i have old version for koha 3.16 and i want to upgrade so i
>> want to update
>> or upgrade schema-koha to avoid error because when i upgrade
>> to koha 3.22
>> or koha 3.20 it five me errors, please help me
>>
>> On Mon, Dec 26, 2016 at 9:57 PM, Chris Cormack
>> <[email protected] <mailto:[email protected]>>
>> wrote:
>>
>> Hi All
>>
>> I actually have most of that set up, eg
>> http://schema.koha-community.
>> org/master/
>>
>> And
>>
>> http://schema.koha-community.org/16_05/
>> <http://schema.koha-community.org/16_05/>
>>
>> Just needs to be finished off, I'll try to do that in the
>> next time few
>> days, we will need to submit some patches to Koha so we
>> link to the right
>> version from the reports page though.
>>
>> Chris
>>
>> On 27 December 2016 8:44:29 AM NZDT, David Nind
>> <[email protected] <mailto:[email protected]>>
>> wrote:
>>
>> Hi Michael.
>>
>> I will look into getting it up-to-date.
>>
>> It may take a few days though, as I work through what
>> is required.
>>
>> I will also work out whether we can display the schema
>> for different
>> versions of Koha.
>>
>> Regards.
>>
>> David Nind | [email protected]
>> <mailto:[email protected]>
>> PO Box 12367, Thorndon, Wellington, New Zealand 6144
>> m. +64 21 0537 847 | w. +64 4 8906 098
>> _______________________________________________
>> Koha mailing list http://koha-community.org
>> [email protected] <mailto:[email protected]>
>> https://lists.katipo.co.nz/mailman/listinfo/koha
>> <https://lists.katipo.co.nz/mailman/listinfo/koha>
>>
>> --
>> Sent from my Android device with K-9 Mail. Please excuse
>> my brevity.
>> _______________________________________________
>> Koha mailing list http://koha-community.org
>> [email protected] <mailto:[email protected]>
>> https://lists.katipo.co.nz/mailman/listinfo/koha
>> <https://lists.katipo.co.nz/mailman/listinfo/koha>
>>
>> _______________________________________________
>> Koha mailing list http://koha-community.org
>> [email protected] <mailto:[email protected]>
>> https://lists.katipo.co.nz/mailman/listinfo/koha
>> <https://lists.katipo.co.nz/mailman/listinfo/koha>
>>
>>
>> _______________________________________________
>> Koha mailing list http://koha-community.org
>> [email protected] <mailto:[email protected]>
>> https://lists.katipo.co.nz/mailman/listinfo/koha
>> <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
--
--
Liz Rea
Catalyst.Net Limited
Level 6, Catalyst House,
150 Willis Street, Wellington.
P.O Box 11053, Manners Street,
Wellington 6142
GPG: B149 A443 6B01 7386 C2C7 F481 B6c2 A49D 3726 38B7
signature.asc
Description: OpenPGP digital signature
_______________________________________________ Koha mailing list http://koha-community.org [email protected] https://lists.katipo.co.nz/mailman/listinfo/koha
