[Koha-bugs] [Bug 20206] Inventory: barcodes without or with extra leading zeroes are reported not found

bugzilla-daemon at bugs.koha-community.org bugzilla-daemon at bugs.koha-community.org
Tue Jun 22 18:04:50 CEST 2021


https://bugs.koha-community.org/bugzilla3/show_bug.cgi?id=20206

Hakam Almotlak <hakam.almotlak at inLibro.com> changed:

           What    |Removed                     |Added
----------------------------------------------------------------------------
                 CC|                            |hakam.almotlak at inLibro.com

--- Comment #15 from Hakam Almotlak <hakam.almotlak at inLibro.com> ---
Hey i applied the patch and created an item with 0123456 then another item with
00123456 and i tried to check in with the code 123456 and it says no item with
this code.
i checked the database and the code 0123456 and 00123456 exist in the database,
but i can`t find it when i check in it does not exclude the zeros at the
begging of the code.
that is the database output:

MariaDB [koha_master_dev_inlibro]> select barcode from items;
+----------+
| barcode  |
+----------+
| NULL     |
| 00123456 |
| 0123456  |
| 111      |
| 77777    |
| 88888    |
| 99999    |
+----------+
7 rows in set (0.001 sec)

-- 
You are receiving this mail because:
You are watching all bug changes.


More information about the Koha-bugs mailing list