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