I don't get any errors with that query - but I also don't get any results - since my system doesn't have anything added last month :) Anyone else able to use this query as it is? Nicole On Tue, Dec 1, 2009 at 5:06 PM, Nelson Fredsell (nelsonf) <nfredsell@gmail.com> wrote:
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... 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