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) <nfreds...@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@lists.koha.org > http://lists.koha.org/mailman/listinfo/koha-devel _______________________________________________ Koha-devel mailing list Koha-devel@lists.koha.org http://lists.koha.org/mailman/listinfo/koha-devel
