@@ -, +, @@
--> without this patch, there are associatedborrower and usercode errors
--> with patch, these two columns are not reported
---
installer/data/mysql/backfill_statistics.pl | 2 --
koha-tmpl/intranet-tmpl/prog/en/columns.def | 1 -
2 files changed, 3 deletions(-)
--- a/installer/data/mysql/backfill_statistics.pl
+++ a/installer/data/mysql/backfill_statistics.pl
@@ -24,9 +24,7 @@ sub get_counts() {
(SELECT count(*) FROM statistics WHERE branch="NO_LIBRARY" ) AS NO_LIBRARY,
(SELECT count(*) FROM statistics WHERE branch IS NULL) AS NULL_BRANCH,
(SELECT count(*) FROM statistics WHERE itemtype IS NULL AND itemnumber IS NOT NULL) AS NULL_ITEMTYPE,
- (SELECT count(*) FROM statistics WHERE usercode IS NULL) AS NULL_USERCODE,
(SELECT count(*) FROM statistics WHERE borrowernumber IS NULL) AS NULL_BORROWERNUMBER,
- (SELECT count(*) FROM statistics WHERE associatedborrower IS NULL) AS NULL_ASSOCIATEDBORROWER,
(SELECT count(*) FROM statistics ) AS Total
);
my $sth = $dbh->prepare($query);
--- a/koha-tmpl/intranet-tmpl/prog/en/columns.def
+++ a/koha-tmpl/intranet-tmpl/prog/en/columns.def
@@ -111,7 +111,6 @@
Value
Type
-User code
Item number
Itemtype
Borrower number
--