[Koha] Failing to edit MARC Frameworks in Koha 22.05.05.000

[Jonathan Druart]

What about this one?
SELECT frameworkcode, tagfield, tab, authorised_value FROM
marc_subfield_structure WHERE ( kohafield = "items.homebranch" OR
kohafield = "items.holdingbranch" ) AND ( authorised_value !=
"branches" OR tab != 10 );

Le mer. 2 août 2023 à 14:53, Antony Kujenga <akujenga at gmail.com> a écrit :
>
> Hi Jonathan,
>
> No, it does not return anything.
>
> Regards
>
>
> AK
>
>
> On Wed, 2 Aug 2023 at 13:56, Jonathan Druart <jonathan.druart at bugs.koha-community.org> wrote:
>>
>> Does this SQL query return something?
>>
>> SELECT frameworkcode, tagfield, tab, authorised_value FROM
>> marc_subfield_structure WHERE ( kohafield = "items.homebranch" OR
>> kohafield = "items.holdingbranch" ) AND authorised_value !=
>> "branches";
>>
>> Le mer. 2 août 2023 à 11:25, Antony Kujenga <akujenga at gmail.com> a écrit :
>> >
>> > Dear Community,
>> >
>> > I've been trying to edit some frameworks in our Koha 22.05.05.000 instance
>> > running on Ubuntu 22.04. Upon running the framework test, I'm getting this
>> > error report:
>> >
>> > homebranch NOT mapped the items.homebranch field MUST :
>> >
>> >    - be mapped to a MARC subfield,
>> >    - the corresponding subfield MUST have "Authorized value" set to
>> >    "branches"
>> >
>> > holdingbranch NOT mapped the items.holdingbranch field MUST :
>> >
>> >    - be mapped to a MARC subfield,
>> >    - the corresponding subfield MUST have "Authorized value" set to
>> >    "branches"
>> >
>> >
>> > I have tried changing the stated fields numerous times but the system will
>> > not effect the changes.
>> >
>> > I tried running
>> >
>> > $ sudo koha-shell -c '/usr/share/koha/bin/batchRebuildBiblioTables.pl -c'
>> > your_koha_name
>> >
>> > with our instance name but it hasn't helped.
>> >
>> > Any urgent help would be most appreciated.
>> >
>> > Regards
>> >
>> >
>> > AK
>> > _______________________________________________
>> >
>> > Koha mailing list  http://koha-community.org
>> > Koha at lists.katipo.co.nz
>> > Unsubscribe: https://lists.katipo.co.nz/mailman/listinfo/koha