[Koha-bugs] [Bug 7298] export late orders, with # of claims and claim dates
bugzilla-daemon at bugs.koha-community.org
bugzilla-daemon at bugs.koha-community.org
Fri Mar 22 03:56:51 CET 2013
http://bugs.koha-community.org/bugzilla3/show_bug.cgi?id=7298
Jared Camins-Esakov <jcamins at cpbibliography.com> changed:
What |Removed |Added
----------------------------------------------------------------------------
Status|Passed QA |Failed QA
--- Comment #44 from Jared Camins-Esakov <jcamins at cpbibliography.com> ---
I get a nasty error from this:
DBD::mysql::st execute failed: You have an error in your SQL syntax; check the
manual that corresponds to your MariaDB server version for the right syntax to
use near 'o
ORDER BY title' at line 12 at /home/jcamins/kohaclone/C4/Serials.pm line 1906.
at /home/jcamins/kohaclone/serials/lateissues-export.pl line 134
The query that is generating is, sure enough, wrong:
SELECT
serialid, aqbooksellerid, name,
biblio.title, planneddate, serialseq,
serial.status, serial.subscriptionid, claimdate,
subscription.branchcode
FROM serial
LEFT JOIN subscription ON serial.subscriptionid=subscription.subscriptionid
LEFT JOIN biblio ON subscription.biblionumber=biblio.biblionumber
LEFT JOIN aqbooksellers ON subscription.aqbooksellerid = aqbooksellers.id
WHERE subscription.subscriptionid = serial.subscriptionid
AND (serial.STATUS = 4 OR ((planneddate < now() AND serial.STATUS =1) OR
serial.STATUS = 3 OR serial.STATUS = 7))
AND subscription.aqbooksellerid=
and serialid = on
ORDER BY title
Also, there needs to be a test plan.
--
You are receiving this mail because:
You are watching all bug changes.
More information about the Koha-bugs
mailing list