Up-to-dateness of Koha database analysis by SchemaSpy
Hi It seems to me that http://schema.koha-community.org/ is not up to date (it shows the date of Mon Jan 11 08:19 NZDT 2016). For example Koha 16.11 has 70 fields in table "borrowers" but SchemaSpy still only shows 67 of them (like in Koha 16.05), missing the new fields "checkprevcheckout", "updated_on" and "lastseen". * http://schema.koha-community.org/tables/borrowers.html Would someone with the needed privileges please update this database description? Also in Koha menu "Tools > Import patrons" the help text "Field list" does miss some fields: the three mentioned above and also "privacy_guarantor_checkouts" (introduced in Koha 16.05 I guess). This leads me to another question: Is there any database description of older Koha versions (e. g. Koha 3.20, Koha 3.18) or will the database analysis by SchemaSpy always just overwrite and thus destroy all older status? Best wishes: Michael -- Geschäftsführer · Diplombibliothekar BBS, Informatiker eidg. Fachausweis Admin Kuhn GmbH · Pappelstrasse 20 · 4123 Allschwil · Schweiz T 0041 (0)61 261 55 61 · E mik@adminkuhn.ch · W www.adminkuhn.ch
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 PO Box 12367, Thorndon, Wellington, New Zealand 6144 m. +64 21 0537 847 | w. +64 4 8906 098
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/ 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> 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 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 https://lists.katipo.co.nz/mailman/listinfo/koha
-- Sent from my Android device with K-9 Mail. Please excuse my brevity.
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> 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/
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> 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 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 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 https://lists.katipo.co.nz/mailman/listinfo/koha
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> 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/
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> 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 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 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 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
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> 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> 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/
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> 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 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 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 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
_______________________________________________ Koha mailing list http://koha-community.org Koha@lists.katipo.co.nz https://lists.katipo.co.nz/mailman/listinfo/koha
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>
hi my friends i have success to upgrade from koha 3.18 to koha 3.22.5 stable version so every things is ok but the problem in patrons (borrowers) when i finishing upgrade and login using user name and passwords it give me invalid user so i login with koha admin and when searching in patrons modules it not give me any thing and i check phpmyadmin to see borrowers table i found all borrowers data complete, so how solving patron i install using koha package Koha Version- 3.22.5 (Stable) Operating System- Ubuntu 12.04.5- 64 bit. On Wed, Dec 28, 2016 at 9:32 AM, Katrin <katrin.fischer.83@web.de> 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> 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>chrisc@catalyst.net.nz> wrote:
Hi All
I actually have most of that set up, eg <http://schema.koha-community> http://schema.koha-community. org/master/
And
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>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 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 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 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
_______________________________________________ Koha mailing list http://koha-community.org Koha@lists.katipo.co.nz https://lists.katipo.co.nz/mailman/listinfo/koha
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
On 27/12/16 12:29, David Nind wrote:
Thanks Chris!
David Nind
Here we go, all up to date and linked from http://schema.koha-community.org/ I'll run the schema for 16.11 tonight. But master, 16.05 and 3.22 are all up to date there We can add a patch to koha so that each version links directly to the right schema, but for now I think the landing page will do. Chris
Hi Chris
Here we go, all up to date and linked from
I don't see no links there... it is not clear to me the tables of what version this page shows because I can't see the version number anwhere (though I guess it's the master resp. current development version).
I'll run the schema for 16.11 tonight.
But master, 16.05 and 3.22 are all up to date there
I see everything is there now, even back to Koha 3.18! * http://schema.koha-community.org/3_18/ * http://schema.koha-community.org/3_20/ * http://schema.koha-community.org/3_22/ * http://schema.koha-community.org/16_05/ * http://schema.koha-community.org/16_11/ * http://schema.koha-community.org/master (I guess this is the current development version)
We can add a patch to koha so that each version links directly to the right schema, but for now I think the landing page will do.
Yes, this is a good idea! Or link it directly from https://koha-community.org/documentation/ Many thanks & best wishes: Michael -- Geschäftsführer · Diplombibliothekar BBS, Informatiker eidg. Fachausweis Admin Kuhn GmbH · Pappelstrasse 20 · 4123 Allschwil · Schweiz T 0041 (0)61 261 55 61 · E mik@adminkuhn.ch · W www.adminkuhn.ch
If you see no links on that first page you might want to try a force reload to bust your browsers cache. It's just an index.html of links now Chris On 28 December 2016 7:08:05 AM NZDT, Michael Kuhn <mik@adminkuhn.ch> wrote:
Hi Chris
Here we go, all up to date and linked from
I don't see no links there... it is not clear to me the tables of what version this page shows because I can't see the version number anwhere (though I guess it's the master resp. current development version).
I'll run the schema for 16.11 tonight.
But master, 16.05 and 3.22 are all up to date there
I see everything is there now, even back to Koha 3.18!
* http://schema.koha-community.org/3_18/ * http://schema.koha-community.org/3_20/ * http://schema.koha-community.org/3_22/ * http://schema.koha-community.org/16_05/ * http://schema.koha-community.org/16_11/ * http://schema.koha-community.org/master (I guess this is the current development version)
We can add a patch to koha so that each version links directly to the right schema, but for now I think the landing page will do.
Yes, this is a good idea! Or link it directly from https://koha-community.org/documentation/
Many thanks & best wishes: Michael -- Geschäftsführer · Diplombibliothekar BBS, Informatiker eidg. Fachausweis Admin Kuhn GmbH · Pappelstrasse 20 · 4123 Allschwil · Schweiz T 0041 (0)61 261 55 61 · E mik@adminkuhn.ch · W www.adminkuhn.ch _______________________________________________ Koha mailing list http://koha-community.org Koha@lists.katipo.co.nz https://lists.katipo.co.nz/mailman/listinfo/koha
-- Sent from my Android device with K-9 Mail. Please excuse my brevity.
participants (6)
-
Ahmad Nasser -
Chris Cormack -
David Nind -
Katrin -
Liz Rea -
Michael Kuhn