[Koha] Warning about patron relationship problems?

[Cindy Murdock Ames]

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 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
>>
>