Dear all, I've begun using the SQL report repository, and have run into an error on "previous month items created" (http://wiki.koha.org/doku.php?id=sql_library). Any clues?!
ERROR: Can't use an undefined value as an ARRAY reference at /usr/share/koha/lib/C4/Reports/Guided.pm line 412. Here's the SQL: SELECT count(items.itemnumber) as ItemsCreated FROM items WHERE items.dateaccessioned >= concat(date_format(LAST_DAY(now() - interval 1 month),'%Y-%m-'),'01') AND items.dateaccessioned ⇐ LAST_DAY(now() - interval 1 month) I did change the special character to "<=" and still received the error. Additional sys info -- Apache Server version: Apache/2.2.8 (Linux/SUSE) Server built: Nov 23 2008 23:32:28 Koha 3.00.01.005 Koha DB 3.0001005 MySQL mysql Ver 14.12 Distrib 5.0.51a, for suse-linux-gnu (i686) using readline 5.2 OS Linux li64-119 2.6.31.5-linode21 #1 SMP Mon Oct 26 18:17:01 UTC 2009 i686 Perl 5.010000 Many thanks, Nelson implementing a union catalogue in Cape Town, South Africa ----- Nelson Fredsell nelsonf on Koha IRC implementing a small, non-profit union catalogue in Cape Town, South Africa -- View this message in context: http://old.nabble.com/koha-doku-wiki%2C-SQL-report-error-tp26599870p26599870.html Sent from the Koha - Dev mailing list archive at Nabble.com. _______________________________________________ Koha-devel mailing list Koha-devel@lists.koha.org http://lists.koha.org/mailman/listinfo/koha-devel
