Time Nick Message
01:53 Arued Hi, i'm tring to migrate from Koha 17.11.02 to 22.11.12. I have dump the old database and restored. However when i run "koha-upgrade-schema instacename", i get the following error: {UNKNOWN}: DBI Exception: DBD::mysql::db do failed: Cannot change column 'type': used in a foreign key constraint 'koha_opacbts/account_offsets_ibfk_t' of table 'koha_opacbts/account_offsets' at /usr/share/perl5/DBIx/Class/Schema.pm line 1118. DBI
01:55 Arued the strange thing is that a few months ago I had done exactly the same procedure on the same server and with the same database and everything was successful...
01:57 Arued I then did a restore of the server while waiting for the definitive migration, I can't understand what may have changed in the meantime. Anyone have any suggestions? Thank you!
07:06 marcelr o/
07:22 Joubu dcook: around?
07:36 reiveune hello
09:45 paulderscheid[m] morning #koha
10:06 magnuse \o/
10:52 PedroAmorim[m] o/
11:12 magnuse i'm trying to get some more logging from the REST api. changed to "log4perl.logger.api = DEBUG, API" and "log4perl.logger.plack-api = DEBUG, PLACKAPI" in /etc/koha/sites/mykoha/log4perl.conf + restarted plack, but that does not seem to make a lot of difference. is there something else that needs to be done?
11:12 Joubu memcached
11:13 magnuse ah!
11:21 oleonard Hi #koha
11:25 Joubu @later tell marcelr some fun on 36102 comment 8
11:25 huginn` Joubu: The operation succeeded.
13:57 Joubu oleonard: great follow-ups, thanks!
13:58 oleonard :)
14:03 RamiKaram[m] hi
14:08 oleonard Hi RamiKaram[m]
14:09 RamiKaram[m] i am trying to understand how barcode works with koha, i found the field 952$p to insert barcode information
14:09 RamiKaram[m] but i only have fields up to 942
14:10 RamiKaram[m] anyone has an idea about it?
14:10 oleonard RamiKaram[m]: Do you mean you only see up to 942 in the MARC editor?
14:11 RamiKaram[m] in the cataloging page, new marc record
14:11 * RamiKaram[m] uploaded an image: (58KiB) < https://matrix.org/_matrix/media/v3/download/matrix.org/nAxrIPpJfAjDpsRezsigqNWZ/image.png >
14:12 oleonard When you fill out all the fields you want on that page, submit the form and you should be taken to the item entry form where you will fill out item-level information like barcode.
14:12 RamiKaram[m] i have a .mrc file containing information (title, author, publication,...) that i want to upload to koha database, and i want to assign barcode to each record so i can print it and label them
14:13 RamiKaram[m] how can i enter data to the field 952$p using import
14:14 RamiKaram[m] i am still new with koha and trying to understand how barcode works and how to assign them
14:15 caroline I'm not sure it's possible to insert a barcode in the import process in a batch.
14:16 caroline You'll have to import you .mrc, and then add the barcodes individually
14:16 caroline *your
14:16 oleonard Or add them one by one to the mrc file
14:21 oleonard Does that make sense RamiKaram[m] ?
14:28 RamiKaram[m] i see
14:29 RamiKaram[m] another question to better understand, when you try to search koha using barcode scan, it will search in which field for that number?
14:29 RamiKaram[m] 952$p?
14:29 RamiKaram[m] this is the only place that stores the barcode number?
14:30 RamiKaram[m] or is it possible to save a value in another field, and link it when doing search by barcode?
14:31 caroline if you use elasticsearch as the searchengine, you can view and modify the mappings in Administration > Search engine configuration
14:31 caroline out of the box, barcode search only searches in 952$p
14:31 RamiKaram[m] i see
14:32 oleonard RamiKaram[m]: I don't advise trying to work around using barcode in 952$p
14:32 RamiKaram[m] my problem is that i dont have that field
14:32 oleonard RamiKaram[m]: Is your barcode stored in another field?
14:32 caroline you should have it after you save the record
14:32 RamiKaram[m] i have records saved already, when ii edit them
14:32 RamiKaram[m] i still cannot find the field 952
14:33 RamiKaram[m] only up to 942
14:33 caroline it's not in the same screen
14:33 caroline if the record is already saved, you can click Add (or New) > Add new item
14:34 RamiKaram[m] ah i found it now
14:34 * RamiKaram[m] uploaded an image: (44KiB) < https://matrix.org/_matrix/media/v3/download/matrix.org/hQBXuydrYHVAOUZwdnUvRsRp/image.png >
14:34 caroline yes that is the screen for the items
14:34 RamiKaram[m] you mean here last item
14:35 RamiKaram[m] but this needs to be done manually for each record
14:35 RamiKaram[m] if i use import option
14:35 RamiKaram[m] it does not work right?
14:35 oleonard RamiKaram[m]: Does your mrc file have barcode stored in another place?
14:37 RamiKaram[m] i created this mrc file, it was an excel and i converted it using marcedit software
14:37 RamiKaram[m] so there is no barcode yet
14:37 RamiKaram[m] but i can add a field in excel having the barcode value...
14:38 RamiKaram[m] since i am generating the barcode now, they didnt exist before, i will create them, print them and label the books
14:39 caroline In that case, yes I think generating an incremental barcode in your excel file would be fine
14:39 caroline when you change the excel to mrc, map that column to 952$p
14:39 caroline Make sure to add 952$a and 952$b with your branchcode and 952$y with your itemtype too while you're there
14:39 caroline those are the mandatory fields for the items
14:39 RamiKaram[m] ah perfect
14:40 RamiKaram[m] thank you so much Caroline for the help
14:40 RamiKaram[m] i will try that and get back to you
14:40 RamiKaram[m] :)
14:40 caroline ok let us know if it works!
15:44 JasonGreene[m] It shows this in the log file... any ideas... (full message at <https://matrix.org/_matrix/media/v3/download/matrix.org/rRaesiDrHodWwaSvuGWnTyma>)
15:44 caroline ugh that is the most useless message, I hate it
15:45 caroline I usually go to the apache log when I see that
15:45 JasonGreene[m] ok. thanks, I'll look at that
15:46 oleonard-away JasonGreene[m]: Also, if you want, you can use https://paste.koha-community.org/ for longer messages like that
15:47 JasonGreene[m] tail /var/log/apache2/access.log is empty
15:47 caroline what about error.log?
15:50 JasonGreene[m] tail /var/log/apache2/error.log
15:50 JasonGreene[m] [Fri Feb 16 00:00:01.451619 2024] [mpm_prefork:notice] [pid 23932] AH00163: Apache/2.4.57 (Ubuntu) mpm-itk/2.4.7-04 configured -- resuming normal operations
15:50 JasonGreene[m] [Fri Feb 16 00:00:01.451658 2024] [core:notice] [pid 23932] AH00094: Command line: '/usr/sbin/apache2'
15:52 caroline no idea... if you redo the action does it add anything?
15:57 JasonGreene[m] I don't know if anything happened,
15:57 JasonGreene[m] however when I click on the "New Category" link it goes to a live page that works.... weird,
15:57 JasonGreene[m] sorry for the strange issue. and thanks for the help
15:58 caroline Someone must have looked at it with angry eyes and it decided to work ;) I have colleague that I called to come look at my computer issues with angry eyes and suddenly it works like a charm
15:58 reiveune bye
16:17 JasonGreene[m] no, I walked away and stopped yelling at it so then it could relax and start working.
16:21 caroline lol!
18:35 davidnind Jason Greene: The various log files for Koha are normally located under /var/log/koha/instancename (in a development environment anyway)
18:39 JasonGreene[m] looking for a link to Koha 23 import data.. I can only find older version and I can't find the "Stage MARC record Management" link , has it changed?
18:41 caroline JasonGreene[m], yes, it's now in the Cataloging module
18:46 JasonGreene[m] thanks