Re: [Koha] Fwd: Unable to reindex after massive upgrade

2017-09-14 Thread Tim Young
I am revisiting an old topic here; we still have some inconsistencies in our data. Previously in this thread: We were getting an error to the likes of: *Can't call method "branchname" on an undefined value at /usr/share/koha/lib/C4/Biblio.pm line 1627* This was due to some bad data; our

Re: [Koha] Fwd: Unable to reindex after massive upgrade

2017-06-27 Thread Tim Young
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

Re: [Koha] Fwd: Unable to reindex after massive upgrade

2017-06-27 Thread Tomas Cohen Arazi
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

Re: [Koha] Fwd: Unable to reindex after massive upgrade

2017-06-27 Thread Tim Young
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

Re: [Koha] Fwd: Unable to reindex after massive upgrade

2017-06-27 Thread Tomas Cohen Arazi
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

Re: [Koha] Fwd: Unable to reindex after massive upgrade

2017-06-27 Thread Tim Young
Previously, I noted that I was not able to reindex. I tracked it down to the following. My biblio_metadata file wasempty, and therefore my reindex could not retrieve any biblio information. Now that I know what to look for, there was this error during the upgrade: [Thu Jun 22 22:29:11

Re: [Koha] Fwd: Unable to reindex after massive upgrade

2017-06-23 Thread Michael Kuhn
Hi Mary From my experience wrong permissions will often lead to an unindexed catalog. Given your instance is "xxx", the automatically created Koha user is named "xxx-koha" and the group is "xxx-koha" all the file in directory "/var/lib/koha/xxx" and its subdirectories have to belong to this

[Koha] Fwd: Unable to reindex after massive upgrade

2017-06-23 Thread Mary W. Maina
-- Forwarded message -- From: "Tim Young" Date: Jun 23, 2017 15:02 Subject: Unable to reindex after massive upgrade To: "Mary Maina" Cc: (Mary, could you send this on to the Koha email list?) We recently upgraded our old Koha install