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 <katrin.fischer.83@web.de <mailto:katrin.fischer.83@web.de>> 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 <chrisc@catalyst.net.nz <mailto:chrisc@catalyst.net.nz>> 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 <david.nind@gmail.com <mailto:david.nind@gmail.com>> 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 | david.nind@gmail.com <mailto:david.nind@gmail.com> 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 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>
-- Sent from my Android device with K-9 Mail. Please excuse my brevity. _______________________________________________ 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>
_______________________________________________ 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 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