[Koha-devel] koha doku wiki, SQL report error

[Nelson Fredsell (nelsonf)]

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.