Re: [Koha-devel] SQL queries showing data that will cause software errors.

2018-10-19 Thread Barton Chittenden
Here's another data issue we run into sometimes -- the date from items.onloan does not match issues.date_due This is an actual bug; I have *no* idea what triggers it, but I know that I've seen it happen in the wild. SELECT biblionumber, itemnumber FROM items left join issues WHERE

Re: [Koha-devel] SQL queries showing data that will cause software errors.

2018-09-29 Thread Katrin Fischer
Hi Barton, I think holds on items without item types is a special case of "items without itemtypes". Generally items without itemtypes (with item-level_itype on items) will cause problems with Koha and should be avoided. I think the best option would be to make itemtype mandatory now that bug

[Koha-devel] SQL queries showing data that will cause software errors.

2018-09-28 Thread Barton Chittenden
When ByWater started upgrading our partners to 17.11 last spring, I noticed that we were getting a lot of errors of the form "can't call method * on an undefined value at ..." We're starting to see these errors because more and more of our code uses Koha objects, and these will fail if a method i