[Koha-bugs] [Bug 4002] Issues with borrowernumber set as NULL
bugzilla-daemon at bugs.koha-community.org
bugzilla-daemon at bugs.koha-community.org
Mon May 16 19:12:15 CEST 2011
http://bugs.koha-community.org/bugzilla3/show_bug.cgi?id=4002
Chris Cormack <chris at bigballofwax.co.nz> changed:
What |Removed |Added
----------------------------------------------------------------------------
Patch Status|Signed Off |Failed QA
--- Comment #5 from Chris Cormack <chris at bigballofwax.co.nz> 2011-05-16 17:12:15 UTC ---
+ $dbh->do("INSERT INTO old_issues (borrowernumber, itemnumber, date_due,
branchcode, issuingbranch, returndate, lastreneweddate, `return`, renewals,
timestamp, issuedate)
+ SELECT borrowernumber, itemnumber, date_due, branchcode,
issuingbranch, returndate, lastreneweddate, `return`, renewals, timestamp,
issuedate FROM issues WHERE NOT EXISTS (SELECT * FROM borrowers WHERE
itemnumber = issues.itemnumber)");
+ $dbh->do("DELETE FROM issues WHERE NOT EXISTS (SELECT * FROM items WHERE
itemnumber = issues.itemnumber)");
--
Configure bugmail: http://bugs.koha-community.org/bugzilla3/userprefs.cgi?tab=email
------- You are receiving this mail because: -------
You are the QA Contact for the bug.
More information about the Koha-bugs
mailing list