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

[Nicole Engard]

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 at 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.html
> Sent from the Koha - Dev mailing list archive at Nabble.com.
>
> _______________________________________________
> Koha-devel mailing list
> Koha-devel at lists.koha.org
> http://lists.koha.org/mailman/listinfo/koha-devel