Nicolas Legrand <> changed:

           What    |Removed                     |Added
  Attachment #54810|0                           |1
        is obsolete|                            |

--- Comment #2 from Nicolas Legrand <> ---
Created attachment 56478
Bug 16935 - launch with deleted_barcodes param fails

When launching misc/ with this command line :

 misc/ --date=`date +%d/%m/%Y` --deleted_barcodes

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/ 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/ --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

Signed-off-by: Nicolas Legrand <>

You are receiving this mail because:
You are watching all bug changes.
Koha-bugs mailing list
website :
git :
bugs :

Reply via email to