![https://matrix.org/_matrix/med[…]sigqNWZ/image.png](https://matrix.org/_matrix/media/v3/download/matrix.org/nAxrIPpJfAjDpsRezsigqNWZ/image.png){kind=link}
![https://matrix.org/_matrix/med[…]nUvRsRp/image.png](https://matrix.org/_matrix/media/v3/download/matrix.org/hQBXuydrYHVAOUZwdnUvRsRp/image.png){kind=link}
← Previous day | Today | Next day → | Search | Index
All times shown according to UTC.
| Time | Nick | Message |
|---|---|---|
| 01:50 | Arued joined #koha | |
| 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 | 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 | 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:05 | tcohen joined #koha | |
| 07:06 | marcelr joined #koha | |
| 07:06 | marcelr | o/ |
| 07:22 | Joubu | dcook: around? |
| 07:35 | reiveune joined #koha | |
| 07:36 | reiveune | hello |
| 08:05 | lds joined #koha | |
| 08:46 | fridolin joined #koha | |
| 08:52 | lmstrand joined #koha | |
| 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. |
| 12:47 | lds joined #koha | |
| 12:50 | magnuse_ joined #koha | |
| 13:08 | fridolin joined #koha | |
| 13:17 | magnuse__ joined #koha | |
| 13:57 | Dyrcona joined #koha | |
| 13:57 | Joubu | oleonard: great follow-ups, thanks! |
| 13:58 | oleonard | :) |
| 14:03 | RamiKaram[m] joined #koha | |
| 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 | but i only have fields up to 942 | |
| 14:10 | 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/med[…]sigqNWZ/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 | how can i enter data to the field 952$p using import | |
| 14:14 | 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 | lukeg joined #koha | |
| 14:16 | caroline | You'll have to import you .mrc, and then add the barcodes individually |
| 14:16 | *your | |
| 14:16 | oleonard | Or add them one by one to the mrc file |
| 14:21 | Does that make sense RamiKaram[m] ? | |
| 14:28 | RamiKaram[m] | i see |
| 14:29 | 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 | 952$p? | |
| 14:29 | this is the only place that stores the barcode number? | |
| 14:30 | 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 | 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 | i still cannot find the field 952 | |
| 14:33 | only up to 942 | |
| 14:33 | caroline | it's not in the same screen |
| 14:33 | 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/med[…]nUvRsRp/image.png > |
| 14:34 | caroline | yes that is the screen for the items |
| 14:34 | RamiKaram[m] | you mean here last item |
| 14:35 | but this needs to be done manually for each record | |
| 14:35 | if i use import option | |
| 14:35 | 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 | so there is no barcode yet | |
| 14:37 | but i can add a field in excel having the barcode value... | |
| 14:38 | 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 | when you change the excel to mrc, map that column to 952$p | |
| 14:39 | 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 | those are the mandatory fields for the items | |
| 14:39 | RamiKaram[m] | ah perfect |
| 14:40 | thank you so much Caroline for the help | |
| 14:40 | i will try that and get back to you | |
| 14:40 | :) | |
| 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/med[…]rHodWwaSvuGWnTyma>) |
| 15:44 | caroline | ugh that is the most useless message, I hate it |
| 15:45 | 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 | [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 | [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 | however when I click on the "New Category" link it goes to a live page that works.... weird, | |
| 15:57 | 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 |
| 15:58 | reiveune left #koha | |
| 16:00 | bag joined #koha | |
| 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 |
| 20:37 | bag joined #koha | |
| 21:43 | khall joined #koha | |
| 21:47 | khall_ joined #koha | |
| 21:48 | khall joined #koha | |
| 22:35 | dpk joined #koha |
← Previous day | Today | Next day → | Search | Index