---- Reported by email@example.com 2010-03-24 11:00:49 ----
There is some leak in reports that doesn't count items that have no barcode.
---- Additional Comments From firstname.lastname@example.org 2010-04-16 11:18:29 ----
Patch pushed. Please test and close.
--- Bug imported by email@example.com 2010-05-21 01:26 UTC ---
This bug was previously known as _bug_ 4339 at http://bugs.koha.org/cgi-bin/bugzilla3/show_bug.cgi?id=4339
Actual time not defined. Setting to 0.0
Setting qa contact to the default for this product.
This bug either had no qa contact or an invalid one.
It would be good to know the steps to reproduce this problem since the report is so vague. Can anyone confirm whether this is now fixed?
Want a challenge? Test me, I'm kinda vague and misunderstood, but you just might be the one person who can understand me.
Owen, the interesting lines are :
- $strsth .= "select distinctrow $linefield from biblioitems left join items on (items.biblioitemnumber = biblioitems.biblioitemnumber) where barcode $not LIKE ? AND $line is not null ";
+ my $strsth = "SELECT DISTINCTROW $linefield FROM biblioitems
+ INNER JOIN items USING (biblioitemnumber)
+ WHERE $line IS NOT NULL ";
see the distinction between INNER JOIN and LEFT JOIN : http://www.w3schools.com/sql/sql_join_left.asp and http://www.w3schools.com/sql/sql_join_inner.asp
(the rest of the patch is just changing lc to UC for SQL terms)
it's in master though, so marking it resolved