[Koha] Warning about patron relationship problems?

[Renvoize, Martin]

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 at 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 at ptfs-europe.com



On Wed, 11 Dec 2019 at 10:43, Renvoize, Martin <
martin.renvoize at 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*
>
> <https://www.ptfs-europe.com>
>
> Development Team Manager
>
>
>
>
>
> *Phone:* +44 (0) 1483 378728
>
> *Mobile:* +44 (0) 7725 985 636
>
> *Email:* martin.renvoize at 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 at ptfs-europe.com
>
>
>
> On Wed, 4 Dec 2019 at 16:40, Cindy Murdock Ames <cmurdock at 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 at lists.katipo.co.nz
>> https://lists.katipo.co.nz/mailman/listinfo/koha
>>
>