http://bugs.koha.org/cgi-bin/bugzilla/show_bug.cgi?id=763 Summary: Location will not change Product: Koha Version: CVS Platform: PC OS/Version: Linux - Debian Status: NEW Severity: normal Priority: P2 Component: Circulation AssignedTo: chris@katipo.co.nz ReportedBy: jferraro@athenscounty.lib.oh.us QAContact: koha-bugs@lists.sourceforge.net This is a recent problem. Trying to change a location of a book to APL from NPL. No matter how many times it's scanned, it still says Location Nelsonville. (We checked the branch set--it was Athens.) Here is a snip from the log: ODUES at /usr/local/koha/intranet/cgi-bin/circ/circulation.pl line 406. DBD::mysql::db do failed: You have an error in your SQL syntax near 'holdingbran ch = 'GPL' WHERE items.itemnumber = '32048'' at line 1 at /usr/local/koha /intranet/modules/C4/Circulation/Circ2.pm line 479. DBD::mysql::db do failed: You have an error in your SQL syntax near 'holdingbran ch = 'ALB' WHERE items.itemnumber = '78528'' at line 1 at /usr/local/koha /intranet/modules/C4/Circulation/Circ2.pm line 479. DBD::mysql::db do failed: You have an error in your SQL syntax near 'holdingbran ch = 'ALB' WHERE items.itemnumber = '203123'' at line 1 at /usr/local/koh a/intranet/modules/C4/Circulation/Circ2.pm line 479. DBD::mysql::db do failed: You have an error in your SQL syntax near 'holdingbran ch = 'GPL' WHERE items.itemnumber = '260181'' at line 1 at /usr/local/koh a/intranet/modules/C4/Circulation/Circ2.pm line 479. DBD::mysql::db do failed: You have an error in your SQL syntax near 'holdingbran ch = 'GPL' WHERE items.itemnumber = '228586'' at line 1 at /usr/local/koh a/intranet/modules/C4/Circulation/Circ2.pm line 479. ------- You are receiving this mail because: ------- You are the QA contact for the bug, or are watching the QA contact.