[Koha] Barcode error

[Luis Moises Rojas]

Hello everybody,
Thanks to all, thanks katrin

are you using the AutoBarcode system preference to generate your barcodes?:

If you do, maybe there is a barcode in your db breaking things.
select max(barcode) from items

That was the problem: Two items (barcode) were breaking the rule.
We deleted  and everything is OK again


El dom., 21 de jul. de 2019 a la(s) 11:39, Luis Moises Rojas (
lmoisesrojas at gmail.com) escribió:

> Hello,
> Yes we are using it.
> Ok, we are going to check it.
> Let you know
>
> El dom., 21 de jul. de 2019 10:49 AM, Katrin Fischer <
> katrin.fischer.83 at web.de> escribió:
>
>> Hi,
>>
>> are you using the AutoBarcode system preference to generate your barcodes?
>>
>> If you do, maybe there is a barcode in your db breaking things.
>>
>> You can check for the currently biggest barcode using an SQL report:
>>
>> select max(barcode) from items
>>
>> That might help to find out what's going on.
>>
>> Katrin
>>
>> On 21.07.19 00:33, Luis Moises Rojas wrote:
>> > Did you tried to reindex your DB?: Yes
>> >
>> > Might it be something in cache? did you clear your browsers cache or
>> reset
>> > apache/memcache/plack?: Yes
>> >
>> > If you run a report that displays barcodes, what did you get?:
>> Everything OK
>> >
>> > El sáb., 20 de jul. de 2019 a la(s) 18:30, Luis Moises Rojas (
>> > lmoisesrojas at gmail.com) escribió:
>> >
>> >> Did you tried to reindex your DB?: Yes
>> >>
>> >> Might it be something in cache? did you clear your browsers cache or
>> reset
>> >> apache/memcache/plack?: Yes
>> >>
>> >> If you run a report that displays barcodes, what did you get?:
>> Everything
>> >> OK
>> >>
>> >> El sáb., 20 de jul. de 2019 a la(s) 13:20, Alvaro Cornejo (
>> >> cornejo.alvaro at gmail.com) escribió:
>> >>
>> >>> Hi Vikram,
>> >>>
>> >>> Did you tried to reindex your DB?
>> >>>
>> >>> Might it be something in cache? did you clear your browsers cache or
>> >>> reset apache/memcache/plack?
>> >>>
>> >>> If you run a report that displays barcodes, what did you get?
>> >>>
>> >>> Regards,
>> >>>
>> >>> Alvaro
>> >>>
>> >>>
>> |-----------------------------------------------------------------------------------------------------------------|
>> >>> Envíe y Reciba Datos y mensajes de Texto (SMS) hacia y desde cualquier
>> >>> celular y Nextel
>> >>> en el Perú, México y en mas de 180 paises. Use aplicaciones 2 vias via
>> >>> SMS y GPRS online
>> >>>                Visitenos en www.perusms.com
>> >>>
>> >>>
>> >>> Le sam. 20 juil. 2019 à 08:03, vikram zadgaonkar <
>> >>> vikramczadgaonkar at gmail.com> a écrit :
>> >>>
>> >>>> If possible share screenshot on any link .
>> >>>>
>> >>>> On Sat 20 Jul, 2019, 6:03 PM Luis Moises Rojas, <
>> lmoisesrojas at gmail.com>
>> >>>> wrote:
>> >>>>
>> >>>>> When we try to edit or create a new item, codebar is the same and
>> it is
>> >>>>> displayed in potential notation, i.e: 31344+16
>> >>>>>
>> >>>>> El vie., 19 de jul. de 2019 10:17 PM, vikram zadgaonkar <
>> >>>>> vikramczadgaonkar at gmail.com> escribió:
>> >>>>>
>> >>>>>> Hi,
>> >>>>>> What error you are getting?
>> >>>>>>
>> >>>>>> On Fri 19 Jul, 2019, 9:34 PM Luis Moises Rojas, <
>> >>>> lmoisesrojas at gmail.com>
>> >>>>>> wrote:
>> >>>>>>
>> >>>>>>> It is not from excel, it is from koha, when you try to add a new
>> >>>> item or
>> >>>>>>> edit one.
>> >>>>>>>
>> >>>>>>>
>> >>>>>>> El vie., 19 de jul. de 2019 a la(s) 11:43, Coehoorn, Joel (
>> >>>>>>> jcoehoorn at york.edu) escribió:
>> >>>>>>>
>> >>>>>>>> How are you viewing this? It looks a like Excel somehow got hold
>> of
>> >>>>>>> that
>> >>>>>>>> number.
>> >>>>>>>>
>> >>>>>>>>
>> >>>>>>>> Joel Coehoorn
>> >>>>>>>> Director of Information Technology
>> >>>>>>>> 402.363.5603
>> >>>>>>>> *jcoehoorn at york.edu <jcoehoorn at york.edu>*
>> >>>>>>>>
>> >>>>>>>> *Please contact helpdesk at york.edu <helpdesk at york.edu> for
>> >>>> technical
>> >>>>>>>> assistance.*
>> >>>>>>>>
>> >>>>>>>>
>> >>>>>>>> The mission of York College is to transform lives through
>> >>>>>>>> Christ-centered education and to equip students for lifelong
>> >>>> service to
>> >>>>>>>> God, family, and society
>> >>>>>>>>
>> >>>>>>>>
>> >>>>>>>> On Fri, Jul 19, 2019 at 7:51 AM Luis Moises Rojas <
>> >>>>>>> lmoisesrojas at gmail.com>
>> >>>>>>>> wrote:
>> >>>>>>>>
>> >>>>>>>>> Morning,
>> >>>>>>>>>
>> >>>>>>>>> We are using koha 18.05, Now when we try to add a new item, the
>> >>>>>>> BarCode
>> >>>>>>>>> is:
>> >>>>>>>>> 3.20141070118656e+16 for every new record or when we try to
>> edit.
>> >>>>>>>>>
>> >>>>>>>>>
>> >>>>>>>>> Any Help?
>> >>>>>>>>>
>> >>>>>>>>>
>> >>>>>>>>> --
>> >>>>>>>>> *Luis Moisés Rojas P.*
>> >>>>>>>>> _______________________________________________
>> >>>>>>>>> Koha mailing list  http://koha-community.org
>> >>>>>>>>> Koha at lists.katipo.co.nz
>> >>>>>>>>> https://lists.katipo.co.nz/mailman/listinfo/koha
>> >>>>>>>>>
>> >>>>>>> --
>> >>>>>>> *Luis Moisés Rojas P.*
>> >>>>>>> _______________________________________________
>> >>>>>>> Koha mailing list  http://koha-community.org
>> >>>>>>> Koha at lists.katipo.co.nz
>> >>>>>>> https://lists.katipo.co.nz/mailman/listinfo/koha
>> >>>>>>>
>> >>>> _______________________________________________
>> >>>> Koha mailing list  http://koha-community.org
>> >>>> Koha at lists.katipo.co.nz
>> >>>> https://lists.katipo.co.nz/mailman/listinfo/koha
>> >>>>
>> >> --
>> >> *Luis Moisés Rojas P.*
>> >>
>> >>
>> _______________________________________________
>> Koha mailing list  http://koha-community.org
>> Koha at lists.katipo.co.nz
>> https://lists.katipo.co.nz/mailman/listinfo/koha
>>
>

-- 
*Luis Moisés Rojas P.*