[Koha] Up-to-dateness of Koha database analysis by SchemaSpy

[Liz Rea]

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 at web.de
>> <mailto:katrin.fischer.83 at 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 at catalyst.net.nz <mailto:chrisc at 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 at gmail.com <mailto:david.nind at 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 at gmail.com
>>                 <mailto:david.nind at 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 at lists.katipo.co.nz <mailto:Koha at 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 at lists.katipo.co.nz <mailto:Koha at 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 at lists.katipo.co.nz <mailto:Koha at 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 at lists.katipo.co.nz <mailto:Koha at 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 at 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


-------------- next part --------------
A non-text attachment was scrubbed...
Name: signature.asc
Type: application/pgp-signature
Size: 490 bytes
Desc: OpenPGP digital signature
URL: <https://lists.katipo.co.nz/pipermail/koha/attachments/20161229/1d76385c/attachment.sig>