Warning about patron relationship problems?
Hi all, I have a test instance of Koha with my libraries' data, originally 19.05 but I upgraded it to 19.11 yesterday, so I don't know if this message was there before as I just noticed the warnings of potential problems on the About page under the System Information tab (nice btw!), and I have the following notice there: The following values have been used for guarantee/guarantor relationships, but do not exist in the 'borrowerRelationship' system preference: ARRAY(0x55f2846812d0) What does that ARRAY warning mean? Here's my original values in borrower_relationships.relationship: +--------------------+ | relationship | +--------------------+ | parent/guardian | | grandparent | | tss | +--------------------+ And here's the values in the relationship field in borrowers: MariaDB [Koha]> select relationship, count(*) from borrowers group by relationship; +--------------------+----------+ | relationship | count(*) | +--------------------+----------+ | NULL | 34031 | | grandparent | 161 | | parent/guardian | 5552 | | tss | 11 | +--------------------+----------+ With the exception of NULL, those are the values in the borrowerRelationship syspref, separated by pipes (|). I thought maybe the slash in "parent/guardian" was the issue, so I tried changing it to "parent or guardian" but the ARRAY(0x55f2846812d0) warning is still there. What on earth is it? I googled and looked in the bug list but didn't find anything pertinent. Thanks all! And thanks for 19.11! Cindy ----------------------------------------------------------- Cindy Murdock Ames IT Services Director Meadville Public Library | CCFLS https://meadvillelibrary.org | https://ccfls.org Please report tech support issues in Mantis: https://mantis.ccfls.org
This looks like a bug to me, you should not see ARRAY but rather see a relationship name that exists in your database table but does not yet exist in the system preference. I'll take a look and file a bug for it. *Martin Renvoize* <https://www.ptfs-europe.com> Development Team Manager *Phone:* +44 (0) 1483 378728 *Mobile:* +44 (0) 7725 985 636 *Email:* martin.renvoize@ptfs-europe.com *Fax:* +44 (0) 800 756 6384 www.ptfs-europe.com Registered in the United Kingdom No. 06416372 VAT Reg No. 925 7211 30 The information contained in this email message may be privileged, confidential and protected from disclosure. If you are not the intended recipient, any dissemination, distribution or copying is strictly prohibited. If you think that you have received this email message in error, please email the sender at info@ptfs-europe.com On Wed, 4 Dec 2019 at 16:40, Cindy Murdock Ames <cmurdock@ccfls.org> wrote:
Hi all,
I have a test instance of Koha with my libraries' data, originally 19.05 but I upgraded it to 19.11 yesterday, so I don't know if this message was there before as I just noticed the warnings of potential problems on the About page under the System Information tab (nice btw!), and I have the following notice there:
The following values have been used for guarantee/guarantor relationships, but do not exist in the 'borrowerRelationship' system preference:
ARRAY(0x55f2846812d0)
What does that ARRAY warning mean? Here's my original values in borrower_relationships.relationship:
+--------------------+ | relationship | +--------------------+ | parent/guardian | | grandparent | | tss | +--------------------+
And here's the values in the relationship field in borrowers: MariaDB [Koha]> select relationship, count(*) from borrowers group by relationship; +--------------------+----------+ | relationship | count(*) | +--------------------+----------+ | NULL | 34031 | | grandparent | 161 | | parent/guardian | 5552 | | tss | 11 | +--------------------+----------+
With the exception of NULL, those are the values in the borrowerRelationship syspref, separated by pipes (|). I thought maybe the slash in "parent/guardian" was the issue, so I tried changing it to "parent or guardian" but the ARRAY(0x55f2846812d0) warning is still there. What on earth is it? I googled and looked in the bug list but didn't find anything pertinent.
Thanks all! And thanks for 19.11!
Cindy
----------------------------------------------------------- Cindy Murdock Ames IT Services Director Meadville Public Library | CCFLS https://meadvillelibrary.org | https://ccfls.org
Please report tech support issues in Mantis: https://mantis.ccfls.org _______________________________________________ Koha mailing list http://koha-community.org Koha@lists.katipo.co.nz https://lists.katipo.co.nz/mailman/listinfo/koha
I've added a bug (and patch): https://bugs.koha-community.org/bugzilla3/show_bug.cgi?id=24215. *Martin Renvoize* <https://www.ptfs-europe.com> Development Team Manager *Phone:* +44 (0) 1483 378728 *Mobile:* +44 (0) 7725 985 636 *Email:* martin.renvoize@ptfs-europe.com *Fax:* +44 (0) 800 756 6384 www.ptfs-europe.com Registered in the United Kingdom No. 06416372 VAT Reg No. 925 7211 30 The information contained in this email message may be privileged, confidential and protected from disclosure. If you are not the intended recipient, any dissemination, distribution or copying is strictly prohibited. If you think that you have received this email message in error, please email the sender at info@ptfs-europe.com On Wed, 11 Dec 2019 at 10:43, Renvoize, Martin < martin.renvoize@ptfs-europe.com> wrote:
This looks like a bug to me, you should not see ARRAY but rather see a relationship name that exists in your database table but does not yet exist in the system preference.
I'll take a look and file a bug for it.
*Martin Renvoize*
Development Team Manager
*Phone:* +44 (0) 1483 378728
*Mobile:* +44 (0) 7725 985 636
*Email:* martin.renvoize@ptfs-europe.com
*Fax:* +44 (0) 800 756 6384
www.ptfs-europe.com
Registered in the United Kingdom No. 06416372 VAT Reg No. 925 7211 30
The information contained in this email message may be privileged, confidential and protected from disclosure. If you are not the intended recipient, any dissemination, distribution or copying is strictly prohibited. If you think that you have received this email message in error, please email the sender at info@ptfs-europe.com
On Wed, 4 Dec 2019 at 16:40, Cindy Murdock Ames <cmurdock@ccfls.org> wrote:
Hi all,
I have a test instance of Koha with my libraries' data, originally 19.05 but I upgraded it to 19.11 yesterday, so I don't know if this message was there before as I just noticed the warnings of potential problems on the About page under the System Information tab (nice btw!), and I have the following notice there:
The following values have been used for guarantee/guarantor relationships, but do not exist in the 'borrowerRelationship' system preference:
ARRAY(0x55f2846812d0)
What does that ARRAY warning mean? Here's my original values in borrower_relationships.relationship:
+--------------------+ | relationship | +--------------------+ | parent/guardian | | grandparent | | tss | +--------------------+
And here's the values in the relationship field in borrowers: MariaDB [Koha]> select relationship, count(*) from borrowers group by relationship; +--------------------+----------+ | relationship | count(*) | +--------------------+----------+ | NULL | 34031 | | grandparent | 161 | | parent/guardian | 5552 | | tss | 11 | +--------------------+----------+
With the exception of NULL, those are the values in the borrowerRelationship syspref, separated by pipes (|). I thought maybe the slash in "parent/guardian" was the issue, so I tried changing it to "parent or guardian" but the ARRAY(0x55f2846812d0) warning is still there. What on earth is it? I googled and looked in the bug list but didn't find anything pertinent.
Thanks all! And thanks for 19.11!
Cindy
----------------------------------------------------------- Cindy Murdock Ames IT Services Director Meadville Public Library | CCFLS https://meadvillelibrary.org | https://ccfls.org
Please report tech support issues in Mantis: https://mantis.ccfls.org _______________________________________________ Koha mailing list http://koha-community.org Koha@lists.katipo.co.nz https://lists.katipo.co.nz/mailman/listinfo/koha
Hi Martin, I have the same problem ad I saw that the patch was pushed to 19.11.02 When does it will be available? Or can I apply the patch without breaking apt-get update/upgrade? Regards, Alvaro |-----------------------------------------------------------------------------------------------------------------| Envíe y Reciba Datos y mensajes de Texto (SMS) hacia y desde cualquier celular y Nextel en el Perú, México y en mas de 180 paises. Use aplicaciones 2 vias via SMS y GPRS online Visitenos en www.perusms.com Le mer. 11 déc. 2019 à 06:39, Renvoize, Martin < martin.renvoize@ptfs-europe.com> a écrit :
I've added a bug (and patch): https://bugs.koha-community.org/bugzilla3/show_bug.cgi?id=24215.
*Martin Renvoize*
Development Team Manager
*Phone:* +44 (0) 1483 378728
*Mobile:* +44 (0) 7725 985 636
*Email:* martin.renvoize@ptfs-europe.com
*Fax:* +44 (0) 800 756 6384
www.ptfs-europe.com
Registered in the United Kingdom No. 06416372 VAT Reg No. 925 7211 30
The information contained in this email message may be privileged, confidential and protected from disclosure. If you are not the intended recipient, any dissemination, distribution or copying is strictly prohibited. If you think that you have received this email message in error, please email the sender at info@ptfs-europe.com
On Wed, 11 Dec 2019 at 10:43, Renvoize, Martin < martin.renvoize@ptfs-europe.com> wrote:
This looks like a bug to me, you should not see ARRAY but rather see a relationship name that exists in your database table but does not yet exist in the system preference.
I'll take a look and file a bug for it.
*Martin Renvoize*
Development Team Manager
*Phone:* +44 (0) 1483 378728
*Mobile:* +44 (0) 7725 985 636
*Email:* martin.renvoize@ptfs-europe.com
*Fax:* +44 (0) 800 756 6384
www.ptfs-europe.com
Registered in the United Kingdom No. 06416372 VAT Reg No. 925 7211 30
The information contained in this email message may be privileged, confidential and protected from disclosure. If you are not the intended recipient, any dissemination, distribution or copying is strictly prohibited. If you think that you have received this email message in error, please email the sender at info@ptfs-europe.com
On Wed, 4 Dec 2019 at 16:40, Cindy Murdock Ames <cmurdock@ccfls.org> wrote:
Hi all,
I have a test instance of Koha with my libraries' data, originally 19.05 but I upgraded it to 19.11 yesterday, so I don't know if this message was there before as I just noticed the warnings of potential problems on the About page under the System Information tab (nice btw!), and I have the following notice there:
The following values have been used for guarantee/guarantor relationships, but do not exist in the 'borrowerRelationship' system preference:
ARRAY(0x55f2846812d0)
What does that ARRAY warning mean? Here's my original values in borrower_relationships.relationship:
+--------------------+ | relationship | +--------------------+ | parent/guardian | | grandparent | | tss | +--------------------+
And here's the values in the relationship field in borrowers: MariaDB [Koha]> select relationship, count(*) from borrowers group by relationship; +--------------------+----------+ | relationship | count(*) | +--------------------+----------+ | NULL | 34031 | | grandparent | 161 | | parent/guardian | 5552 | | tss | 11 | +--------------------+----------+
With the exception of NULL, those are the values in the borrowerRelationship syspref, separated by pipes (|). I thought maybe the slash in "parent/guardian" was the issue, so I tried changing it to "parent or guardian" but the ARRAY(0x55f2846812d0) warning is still there. What on earth is it? I googled and looked in the bug list but didn't find anything pertinent.
Thanks all! And thanks for 19.11!
Cindy
----------------------------------------------------------- Cindy Murdock Ames IT Services Director Meadville Public Library | CCFLS https://meadvillelibrary.org | https://ccfls.org
Please report tech support issues in Mantis: https://mantis.ccfls.org _______________________________________________ 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
Hi Alvaro, Someone please correct me if I'm wrong, but I think you can apply the patch without affecting package updates (I think it would just overwrite about.pl with the new version when you upgrade). I just applied it manually on my test server (since there were few changes I just made the changes in a text editor) and it seems to have worked. It's probably safe because you're only changing one file, and you can save a copy of the original if you want in case it breaks the package update, and put it back in place before doing the upgrade to 19.11.02. Thanks all for the fix! Cindy ----------------------------------------------------------- Cindy Murdock Ames IT Services Director Meadville Public Library | CCFLS https://meadvillelibrary.org | https://ccfls.org Please report tech support issues in Mantis: https://mantis.ccfls.org On Wed, Jan 8, 2020 at 8:54 PM Alvaro Cornejo <cornejo.alvaro@gmail.com> wrote:
Hi Martin,
I have the same problem ad I saw that the patch was pushed to 19.11.02
When does it will be available? Or can I apply the patch without breaking apt-get update/upgrade?
Regards,
Alvaro
|-----------------------------------------------------------------------------------------------------------------| Envíe y Reciba Datos y mensajes de Texto (SMS) hacia y desde cualquier celular y Nextel en el Perú, México y en mas de 180 paises. Use aplicaciones 2 vias via SMS y GPRS online Visitenos en www.perusms.com
Le mer. 11 déc. 2019 à 06:39, Renvoize, Martin < martin.renvoize@ptfs-europe.com> a écrit :
I've added a bug (and patch): https://bugs.koha-community.org/bugzilla3/show_bug.cgi?id=24215.
*Martin Renvoize*
Development Team Manager
*Phone:* +44 (0) 1483 378728
*Mobile:* +44 (0) 7725 985 636
*Email:* martin.renvoize@ptfs-europe.com
*Fax:* +44 (0) 800 756 6384
www.ptfs-europe.com
Registered in the United Kingdom No. 06416372 VAT Reg No. 925 7211 30
The information contained in this email message may be privileged, confidential and protected from disclosure. If you are not the intended recipient, any dissemination, distribution or copying is strictly prohibited. If you think that you have received this email message in error, please email the sender at info@ptfs-europe.com
On Wed, 11 Dec 2019 at 10:43, Renvoize, Martin < martin.renvoize@ptfs-europe.com> wrote:
This looks like a bug to me, you should not see ARRAY but rather see a relationship name that exists in your database table but does not yet exist in the system preference.
I'll take a look and file a bug for it.
*Martin Renvoize*
Development Team Manager
*Phone:* +44 (0) 1483 378728
*Mobile:* +44 (0) 7725 985 636
*Email:* martin.renvoize@ptfs-europe.com
*Fax:* +44 (0) 800 756 6384
www.ptfs-europe.com
Registered in the United Kingdom No. 06416372 VAT Reg No. 925 7211 30
The information contained in this email message may be privileged, confidential and protected from disclosure. If you are not the intended recipient, any dissemination, distribution or copying is strictly prohibited. If you think that you have received this email message in error, please email the sender at info@ptfs-europe.com
On Wed, 4 Dec 2019 at 16:40, Cindy Murdock Ames <cmurdock@ccfls.org> wrote:
Hi all,
I have a test instance of Koha with my libraries' data, originally 19.05 but I upgraded it to 19.11 yesterday, so I don't know if this message was there before as I just noticed the warnings of potential problems on the About page under the System Information tab (nice btw!), and I have the following notice there:
The following values have been used for guarantee/guarantor relationships, but do not exist in the 'borrowerRelationship' system preference:
ARRAY(0x55f2846812d0)
What does that ARRAY warning mean? Here's my original values in borrower_relationships.relationship:
+--------------------+ | relationship | +--------------------+ | parent/guardian | | grandparent | | tss | +--------------------+
And here's the values in the relationship field in borrowers: MariaDB [Koha]> select relationship, count(*) from borrowers group by relationship; +--------------------+----------+ | relationship | count(*) | +--------------------+----------+ | NULL | 34031 | | grandparent | 161 | | parent/guardian | 5552 | | tss | 11 | +--------------------+----------+
With the exception of NULL, those are the values in the borrowerRelationship syspref, separated by pipes (|). I thought maybe the slash in "parent/guardian" was the issue, so I tried changing it to "parent or guardian" but the ARRAY(0x55f2846812d0) warning is still there. What on earth is it? I googled and looked in the bug list but didn't find anything pertinent.
Thanks all! And thanks for 19.11!
Cindy
----------------------------------------------------------- Cindy Murdock Ames IT Services Director Meadville Public Library | CCFLS https://meadvillelibrary.org | https://ccfls.org
Please report tech support issues in Mantis: https://mantis.ccfls.org _______________________________________________ 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
Thanks Martin! Let me know if there's anything I can do to help. ----------------------------------------------------------- Cindy Murdock Ames IT Services Director Meadville Public Library | CCFLS https://meadvillelibrary.org | https://ccfls.org Please report tech support issues in Mantis: https://mantis.ccfls.org On Wed, Dec 11, 2019 at 5:43 AM Renvoize, Martin < martin.renvoize@ptfs-europe.com> wrote:
This looks like a bug to me, you should not see ARRAY but rather see a relationship name that exists in your database table but does not yet exist in the system preference.
I'll take a look and file a bug for it.
*Martin Renvoize*
Development Team Manager
*Phone:* +44 (0) 1483 378728
*Mobile:* +44 (0) 7725 985 636
*Email:* martin.renvoize@ptfs-europe.com
*Fax:* +44 (0) 800 756 6384
www.ptfs-europe.com
Registered in the United Kingdom No. 06416372 VAT Reg No. 925 7211 30
The information contained in this email message may be privileged, confidential and protected from disclosure. If you are not the intended recipient, any dissemination, distribution or copying is strictly prohibited. If you think that you have received this email message in error, please email the sender at info@ptfs-europe.com
On Wed, 4 Dec 2019 at 16:40, Cindy Murdock Ames <cmurdock@ccfls.org> wrote:
Hi all,
I have a test instance of Koha with my libraries' data, originally 19.05 but I upgraded it to 19.11 yesterday, so I don't know if this message was there before as I just noticed the warnings of potential problems on the About page under the System Information tab (nice btw!), and I have the following notice there:
The following values have been used for guarantee/guarantor relationships, but do not exist in the 'borrowerRelationship' system preference:
ARRAY(0x55f2846812d0)
What does that ARRAY warning mean? Here's my original values in borrower_relationships.relationship:
+--------------------+ | relationship | +--------------------+ | parent/guardian | | grandparent | | tss | +--------------------+
And here's the values in the relationship field in borrowers: MariaDB [Koha]> select relationship, count(*) from borrowers group by relationship; +--------------------+----------+ | relationship | count(*) | +--------------------+----------+ | NULL | 34031 | | grandparent | 161 | | parent/guardian | 5552 | | tss | 11 | +--------------------+----------+
With the exception of NULL, those are the values in the borrowerRelationship syspref, separated by pipes (|). I thought maybe the slash in "parent/guardian" was the issue, so I tried changing it to "parent or guardian" but the ARRAY(0x55f2846812d0) warning is still there. What on earth is it? I googled and looked in the bug list but didn't find anything pertinent.
Thanks all! And thanks for 19.11!
Cindy
----------------------------------------------------------- Cindy Murdock Ames IT Services Director Meadville Public Library | CCFLS https://meadvillelibrary.org | https://ccfls.org
Please report tech support issues in Mantis: https://mantis.ccfls.org _______________________________________________ Koha mailing list http://koha-community.org Koha@lists.katipo.co.nz https://lists.katipo.co.nz/mailman/listinfo/koha
participants (3)
-
Alvaro Cornejo -
Cindy Murdock Ames -
Renvoize, Martin