Great! Thanks. & Thanks for the sql. Worked fine. - Tim On 6/27/2017 12:55 PM, Tomas Cohen Arazi wrote:
Tim, the authorised_values_branches table is not related.
The problem is that there are fields in your record(s) that are expected to contain a branchcode. And they don't. That's why Koha::Libraries->find() is returning an undefined value (undef in Perl).
When you removed the FK constraint, you did hide the basic problem of inconsistency.
I suggest that you find your only library's branchcode and make sure your items all have homebranch and holdingbranch set to that. Then reindex. You should do it like this:
# Enter to mysql $ sudo koha-mysql lib
UPDATE items SET homebranch='LIB', holdingbranch='LIB'; \q $ sudo koha-rebuild-zebra -f -a -b -v lib
Note: replace 'lib' for your instance name, and 'LIB' for your library's branchcode.
Regards.
El mar., 27 jun. 2017 a las 13:59, Tim Young (<Tim.Young@lightsys.org <mailto:Tim.Young@lightsys.org>>) escribió:
Awesome. Thanks. I may be able to figure it out (I am pretty good at poking and prodding, and finally figuring it out). I believe we only have one branch, so I should be able to simply replace everything in the sql to match the correct branch... (Yikes! Branchcode is used all over the place!)
BUT, I am a sysadmin, not a Koha admin. This looks like it might be easier to fix through the web interface... So excuse the dumb questions. :)
That particular error seems to stem from something be authorized by branches. My "authorised_values_branches" table is empty. Should I set up an authorized branch or something somewhere?
We do have a branch configured (I can see it in the branches table)...
The code seems to be looking at Koha::Libraries->find($value)->branchname;
and (I have "value" being undefined, or defined improperly. But I do not see a libraries table...)
But, at the same time: $tagslib->{$tag}->{$subfield}->{'authorised_value'} eq "branches". So I somewhere seem to be saying to authorize by branch, and I do not have any authorized branches (or the authorised_values_branches is empty)...
Is there a simple web area I should check out before I jump into the mysql and make changes that might not be supported?
- Tim
On 6/27/2017 9:26 AM, Tomas Cohen Arazi wrote: > You need to fix your data, so fields linked to branch codes actually > contain valid branchcodes. The band aid will work, but I think you > need to fix your data for good. > > Koha got stricter regarding the data quality/completeness. This > particular case could be saved by some tweak like the one you propose. > It is maybe worth filling a bug, because the previous behaviour worked > more gracefuly. >
_______________________________________________ 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
-- Tomás Cohen Arazi Theke Solutions (https://theke.io <http://theke.io/>) ✆ +54 9351 3513384 GPG: B2F3C15F