Looks like you are selecting from the wrong table here... borrowers should
be items
On Mon, May 16, 2011 at 1:30 AM, Chris Cormack <ch...@bigballofwax.co.nz>wrote:
> From: Srdjan Jankovic <srd...@catalyst.net.nz>
>
> This patch fixes rows in the issues table that have null borrower or item
> numbers
> And stops this being able to happen in the future
>
> Signed-off-by: Chris Cormack <ch...@bigballofwax.co.nz>
> ---
>
+ $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)");
_______________________________________________
Koha-patches mailing list
Koha-patches@lists.koha-community.org
http://lists.koha-community.org/cgi-bin/mailman/listinfo/koha-patches
website : http://www.koha-community.org/
git : http://git.koha-community.org/
bugs : http://bugs.koha-community.org/
