[Koha-bugs] [Bug 16935] launch export_records.pl with deleted_barcodes param fails
bugzilla-daemon at bugs.koha-community.org
bugzilla-daemon at bugs.koha-community.org
Wed Aug 24 12:27:01 CEST 2016
https://bugs.koha-community.org/bugzilla3/show_bug.cgi?id=16935
--- Comment #1 from Fridolin SOMERS <fridolin.somers at biblibre.com> ---
Created attachment 54810
-->
https://bugs.koha-community.org/bugzilla3/attachment.cgi?id=54810&action=edit
Bug 16935 - launch export_records.pl with deleted_barcodes param fails
When launching misc/export_records.pl with this command line :
misc/export_records.pl --date=`date +%d/%m/%Y` --deleted_barcodes
--filename=/tmp/koha.mrc
You get this error message :
DBD::mysql::db selectall_arrayref 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 '' at line 4 [for Statement " (
SELECT DISTINCT barcode
FROM deleteditems
WHERE deleteditems.biblionumber = ?
"] at misc/export_records.pl line 189.
This is because of a '(' after 'q|', looks like a typo.
Also, this patch removes useless var $q.
Test plan :
- Delete an item with barcode
- Without patch, run : misc/export_records.pl --date=`date +%d/%m/%Y`
--deleted_barcodes --filename=/tmp/koha.mrc
=> You get dirty MySQL
- Without patch, run the same command
=> No error and the file is generated
--
You are receiving this mail because:
You are watching all bug changes.
More information about the Koha-bugs
mailing list