← Previous day | Today | Next day → | Search | Index
All times shown according to UTC.
| Time | Nick | Message |
|---|---|---|
| 00:29 | akilsdonk joined #koha | |
| 04:47 | gary joined #koha | |
| 04:48 | gary | Hi all, struggling to install one missing perl module Test::DBIx::Class any tips? |
| 04:48 | using sudo cpan worked for all the others missing | |
| 05:29 | tuxayo | gary: not needed unless you want to run the automated tests. Like when working to developing & testing patches. |
| 05:29 | Weird that cpan didn't do the trick tough. | |
| 05:30 | *though (<-I think ^^") | |
| 05:32 | gary: any leads with your record import issues? | |
| 06:06 | gary | I was hoping making sure all the packages would fix it, just sat back down again to loo |
| 06:06 | look | |
| 06:06 | might just start again | |
| 06:12 | tuxayo | Anything in the log when you do the imports? |
| 06:12 | gary: You can also try to import your file in a demo with the same MARC flavor as your's : https://wiki.koha-community.or[…]emo_Installations | |
| 06:13 | chriss joined #koha | |
| 06:14 | gary | how do I reach the logs again? I foolishly did'nt note down the great advice the other day |
| 06:39 | starting from scratch again | |
| 06:59 | reiveune joined #koha | |
| 06:59 | reiveune | hello |
| 07:01 | lmstrand joined #koha | |
| 07:18 | ngospodinov joined #koha | |
| 07:20 | marcelr joined #koha | |
| 07:20 | marcelr | hi #koha |
| 07:23 | ngospodinov | Hello, everyone. I am addressing you with the following problem: A user has received within one day the same email more than once. When he checks his account in the system, it shows that only one has been sent. How to proceed. Thanks in advance. |
| 07:33 | cait joined #koha | |
| 07:40 | cait1 joined #koha | |
| 07:43 | gary | Having blownup the instance and started again I am finding exactly the same issue, missing perl added first and still not showing any JOb progress importing converted MARC. I may be doing something very simple wrong! |
| 07:45 | cait | gary: theprogess bar doesn't always work |
| 07:45 | it doesn't mean that it isn't importing | |
| 07:45 | gary | Ah, ok I will wait and see then! |
| 07:45 | thanks cait | |
| 07:46 | cait | if you have a lot of data to load, there are also CLI tools for the staged import and a bulk import option |
| 07:46 | but yes, wait :) and maybe check on the import tables in the db if you are impatient to see if things are moving on | |
| 07:46 | gary | Oh, how might I check the DB for dummies please |
| 07:47 | cait | you are importing bibliographic data? |
| 07:47 | gary | yes |
| 07:47 | cait1 joined #koha | |
| 07:50 | matts | hello ! |
| 07:51 | gary | hello |
| 07:52 | cait Will the DB updates show up in logview as 1/24/2022 07:36Gary Mortimer (51)CatalogAddItem 12 from Biblio 2 ?? | |
| 07:54 | I think I am wrong | |
| 07:56 | alex_a joined #koha | |
| 07:57 | alex_a | Bonjour |
| 07:57 | cait1 | if you have the log turned on... but no I don't think so, because they go into 'staged' first, not into the catalog |
| 07:57 | they only go into the catalog as the second step | |
| 07:57 | lds joined #koha | |
| 07:59 | paul_p joined #koha | |
| 08:03 | marion joined #koha | |
| 08:03 | tuxayo | ngospodinov: hi, what type of email was it that was received twice? If it's those generated by misc/cronjobs/overdue_notices.pl or a similar script, then if for some reason the cron job is run twice (time changed on the server or something else weird) then duplicate email will ensue. |
| 08:07 | gary | Ok Cait, they are sat there staged and I will wait, will they start appearing one by one if I search? |
| 08:11 | tuxayo | gary: As you have 100 records it shouldn't be long. So something is wrong. |
| 08:13 | So you are the same person from the other day, I did recognize your nickname ^^ | |
| 08:13 | The command to see all the logfiles at once is: | |
| 08:13 | tail -fn0 /var/log/koha/kohadev/* | |
| 08:15 | gary | thanks tuxayo, the records have gone in but I will save that handy hint |
| 08:15 | tuxayo | plack-intranet-error.log is the main one but there are several others that can thus the blanket command. In this case especially |
| 08:15 | gary | Big batch now.... |
| 08:15 | tuxayo | worker-error.log |
| 08:15 | and worker-output.log | |
| 08:16 | how big? | |
| 08:16 | > the records have gone in | |
| 08:16 | great! Right it's was about lack of RAM last time. It's odd | |
| 08:16 | that it didn't work on your previous attempts today now that you had enough ram. | |
| 08:17 | gary | Yeah, I made the machine a 4gb one this time and am using an ubuntu install |
| 08:17 | I think I may have been being impatient as the progress bar does not always work | |
| 08:18 | tuxayo | For 100 record (and a comparable number of item) it should be that long. How long did it take when it worked? |
| 08:18 | *it shouldn't | |
| 08:23 | gary | less than 10 minutes, I was not paying attention. 2900 going in now |
| 08:54 | humm seems to have stopped again, I wonder if I should up the memory to 8gb | |
| 08:55 | I can't see that log file directory either | |
| 08:58 | tuxayo | gary: oops, kohadev is the name of my koha instance |
| 08:59 | gary | I still can't find them, I thought that /var/log/koha |
| 08:59 | tuxayo | check in the logs for the same message: |
| 08:59 | http://irc.koha-community.org/[…]2-01-21#i_2401166 | |
| 08:59 | gary | let me try again |
| 08:59 | tuxayo | oh, that's strang |
| 09:00 | is /var/log/koha empty in the VM? | |
| 09:01 | Note that if the issue is memory usage it might not be report well depending how how the issue was "resolved" | |
| 09:02 | if it's the system that killed the process filling the ram then there should be something in the system logs `journalctl -r` | |
| 09:02 | gary | No its my fault found it now |
| 09:02 | tuxayo | webserver timeout? |
| 09:03 | Because if it's one or two minutes long then you can't do that from the UI | |
| 09:03 | like cait said «if you have a lot of data to load, there are also CLI tools for the staged import and a bulk import option» | |
| 09:05 | gary | can you point me at the CLI tools please, sorry to be a pain |
| 09:14 | mtj | hi gary: its possible to break your koha if you use cpan to install perl modules |
| 09:16 | gary | Well that's me! I tried to install only the ones it asked for..... |
| 09:18 | I set this up on another laptop with zero issues so I am a little bewildered, perhaps blow it up again and go back to an older version | |
| 09:18 | tuxayo | gary: Sorry I don't know much about record import. But perhaps someone will. |
| 09:18 | mtj | koha has a problem with newer versions of Mojolicious::Plugin::OpenAPI and Json::Validator |
| 09:19 | ^ so, just make sure you dont cpan install those modules | |
| 09:19 | tuxayo | mtj: indeed, I'll try to remember that didn't shock when it was mentioned earlier. Anyways it's mostly the automated testing stuff I think. |
| 09:20 | mtj | gary: i think cpan installs to /usr/local/share/perl, so check in there to confirm :) |
| 09:21 | tuxayo | gary: you where able to import all those record on another laptop? how long it was? |
| 09:21 | mtj | its a little misleading, but Test::DBIx::Class is only used by the testing scripts, and not needed for production |
| 09:22 | it should really be identified as such, to not cause confusion | |
| 09:22 | tuxayo | gary: So what was the issue when you said you found it? |
| 09:23 | mtj indeed, I wonder how often people are confused by that | |
| 09:23 | gary | it was memory I thought |
| 09:24 | Yeah all the other records work in a machine at school that I have had running for at least 8 months | |
| 09:24 | tuxayo | with 8G for 2900 record that's unlikely |
| 09:25 | gary | yesterday I was trying 2 and am now up at 4 |
| 09:25 | tuxayo | And checking the RAM usage in the VM after you start the process could confirm that |
| 09:25 | gary | but maybe thats not enough |
| 09:27 | 30% of memory is what its sitting at | |
| 09:28 | mtj | gary: perhaps rename/move your /usr/local/share/perl dir, and restart koha (or reboot) - to make sure your cpan modules are not causing you problems |
| 09:30 | gary | bit above my paygrade but will try |
| 09:30 | alex_a joined #koha | |
| 09:35 | gary | ok so renamed, and rebooting what next? |
| 09:36 | I see now I have done that the previous missing perl is now missing again | |
| 09:40 | mtj | yes, all those missing modules are not required for production |
| 09:45 | gary | ok so what should I check now? |
| 09:48 | mtj | gary: as i understand you have another woking koha, which is a good start |
| 09:48 | gary | I do |
| 09:49 | Its a VM one causing me issues | |
| 09:49 | BRB have to pick up school children | |
| 09:49 | mtj | try importing your marc files on both systems, and try to detect the differences |
| 09:49 | gary | the VM is for the school I teach at because I am afraid the other laptop will die |
| 09:50 | mtj | alos, compare config files in /etc/koha and /etc/apache |
| 09:50 | gary | Not sat near the other one sadly |
| 09:50 | mtj | compare OS and koba versions, etc |
| 09:50 | gary | must go for now |
| 09:52 | mtj | try and build a VM that is the same OS and koha version as your working system |
| 10:28 | gary | will do that |
| 10:37 | paxed | hm. there's no way to make stuff like saved reports select from an alternative server? we've got two servers, and the slave one is sitting idle |
| 10:39 | marcelr | sql replication ? |
| 10:39 | paxed | yup |
| 10:40 | saved reports would be ideal for it, as it doesn't really matter if the db is few minutes behind the master | |
| 10:40 | and then very heavy reports wouldn't affect koha usage | |
| 11:45 | gary | Ok watch out for a big paste, something I am doing wrong I am sure --- |
| 11:45 | Cannot add or update a child row: a foreign key constraint fails (`koha_library`.`items`, CONSTRAINT `items_ibfk_2` FOREIGN KEY (`homebranch`) REFERENCES `branches` (`branchcode`) ON UPDATE CASCADE) [for Statement "INSERT INTO `items` ( `biblioitemnumber`, `biblionumber`, `cn_sort`, `cn_source`, `damaged_on`, `dateaccessioned`, `datelastborrowed`, `datelastseen`, `homebranch`, `itemlost_on`, `itype`, `more_subfields_xml`, `onloan`, `permanent_location`, `repl | |
| 11:48 | paxed | item homebranch does not exist in branches.branchcode |
| 11:48 | cait joined #koha | |
| 11:50 | gary | Do I need to layout the csv exactly as here http://188.166.144.214:8080/cg[…]koha2marclinks.pl |
| 11:53 | these are my home branch descriptions =952 \\$bCLIFTON =952 \\$yCLIFTON | |
| 11:53 | I am beginning to wonder how on earth I managed earlier this year, lockdown time I guess! | |
| 11:55 | it pulled in three books and stopped | |
| 11:57 | paxed | i don't know how you're importing those items in koha, but all the values used in item homebranch need to exist in koha as branches before the import |
| 11:58 | gary | Ah, I just tried another 3 and it worked fine, maybe I need to try 10 at a time |
| 12:02 | koha-jenkins | Yippee, build fixed! |
| 12:02 | Project Koha_Master_D12 build #67: FIXED in 41 min: https://jenkins.koha-community[…]ha_Master_D12/67/ | |
| 12:14 | marion joined #koha | |
| 12:14 | cait1 | gary: sorry, was in meeting all morgning - after staging committing them to the catalog is a separate step |
| 12:15 | gary: not sure someone told you already :) you first upload and match, when they are all staged and you are happy with matching against existing records, you commit them to the catalog (there is a button) | |
| 12:15 | and then they shoudl show up | |
| 12:16 | gary | Yes I upload, then match then I press the go and three went in, 10 did'nt I have just tried 5 and they did'nt and I will try another three now |
| 12:16 | Transaction aborted: Broken FK constraint. Rollback failed: DBIx::Class::Storage::txn_rollback(): Refusing to roll back without a started transaction at /usr/share/koha/intranet/cgi-bin/tools/manage-marc-import.pl line 253 at /usr/share/koha/intranet/cgi-bin/tools/manage-marc-import.pl line 253 | |
| 12:17 | that was the 5 | |
| 12:17 | cait1 | gary: you are also importing items? |
| 12:17 | about the FK constraint ... there could be some things, but there are some things to look out for | |
| 12:17 | gary | by that you mean, hang on 952$y |
| 12:18 | cait1 | you need $y to match an item type code exactly (case sensitive like you have it in koha) same for $a AND $b and the branchcode |
| 12:18 | yes, things like that | |
| 12:18 | gary | 952 a b |
| 12:18 | I have those 3 | |
| 12:18 | cait1 | ok, that's good |
| 12:18 | do you import 952 c or 8? | |
| 12:19 | in the past Koha didn#t give a good error when these didn't match config, so just something to check maybe | |
| 12:19 | gary | no I don't |
| 12:19 | what are in those | |
| 12:19 | cait1 | you don't need them - location and collection |
| 12:19 | are optional :) | |
| 12:19 | just something that shoudl match too, when you do use them | |
| 12:19 | gary | Ok but can put them in blank? |
| 12:19 | cait1 | you can just leave the subfields out, that's ok |
| 12:19 | gary | ok |
| 12:20 | this is what I have 245$a100$a260$c260$b300$a020$a952$a952$b952$y952$2 | |
| 12:20 | cait1 | oh |
| 12:20 | are your 952 on mulitple lines? | |
| 12:20 | gary | yes |
| 12:20 | cait1 | ok, it should only be one line per item |
| 12:20 | so one item is 952$a $b $.... | |
| 12:20 | gary | oh |
| 12:20 | cait1 | so that could be an issue for sure |
| 12:21 | i believe there are some hints on how to fix this with marcedit maybe in the manual | |
| 12:21 | gary | so if I just put 952 $a $b $y $2 -- like that in one column? |
| 12:22 | then do I write the values in the single column?? in the right order | |
| 12:23 | looking at the manual now | |
| 12:27 | cait1 | yes, you shoudl actually do that with other fields doo I think |
| 12:27 | like if you had 245 a b and c | |
| 12:28 | because 245 is marked as 'not repeatable' | |
| 12:28 | 260 is repeatable, not sure if it affects display to have them in separate | |
| 12:28 | gary | 952 is the only one like that |
| 12:28 | cait1 | gary: not sure what you mean with column |
| 12:28 | ok, was looking at your list, 260 stood out too | |
| 12:28 | gary | well on the spreadsheet, oh yes you are right |
| 12:29 | I guess it all happens in marcedit | |
| 12:32 | marcelr joined #koha | |
| 12:32 | marcelr | o/ |
| 12:34 | vfernandes joined #koha | |
| 12:35 | vfernandes | hi #koha |
| 12:37 | pmoura joined #koha | |
| 12:37 | vfernandes | I'm trying to create an OPAC plugin (opac_js method) with some special characteres (ã, é, í...) and i'm getting encoding problems |
| 12:37 | Joubu | vfernandes: add "use utf8;" at the top of the module |
| 12:39 | vfernandes | ok, let me try... i was using decode_uft8 method |
| 12:41 | it works... thanks Joubu... that's easier than using the method decode | |
| 12:42 | gary | Ok really banging head on desk, links broken https://bywatersolutions.com/2[…]o-add-koha-items/ is there anyone here that I could by a beer or several for to help me make this list of 2900 records importable! |
| 12:43 | marcelr | bywater? |
| 12:43 | gary | Thats just one of the try this broken links outthere |
| 12:43 | marcelr | ok sorry |
| 12:45 | gary | I don't understand how to merge the 952$ fields a b and y into one unit in MArc Editor its above my paygrade! |
| 12:47 | marcelr | i dont really know marc editor |
| 12:58 | gary | I will gladly buy beer for somebody that does! This is driving me nuts having one instance that works that I set up last year sometime and now one that does not. I cannot remember what I did before |
| 12:58 | cait1 | have you checked the manual? |
| 12:58 | I am sure I saw a step by step somewhere for this problem | |
| 12:59 | (it happens quite often) | |
| 12:59 | next meeting here :( | |
| 13:01 | gary | the marcedit manual yes, maybe I have not come across it yet |
| 13:09 | is there a discord group or anywhere else I might make my cry for help? | |
| 13:10 | Joubu | you can try the mailing list |
| 13:14 | gary | I just emailed bywater, I guess America has awoken! |
| 13:19 | Joubu | gary: https://web.archive.org/web/20[…]o-add-koha-items/ |
| 13:19 | And the video is there: https://www.youtube.com/watch?v=Jjx7e7VoOs8 | |
| 13:19 | cait1 | gary: ah I meant the koha manual |
| 13:20 | (back from meeting) | |
| 13:21 | gary: maybe this here is also helpful: http://blog.l2c2.co.in/index.p[…]import-into-koha/ | |
| 13:21 | gary | thanks cait1 and joubu |
| 13:24 | cait1 | I was thinking here, but it is not the tutorial I had in mind, still helpful maybe: https://lists.katipo.co.nz/pub[…]nuary/035302.html |
| 13:24 | hm not that one... but that one too maybe (helpful that is) | |
| 13:24 | https://koha-community.org/man[…]el-data-into-koha | |
| 13:31 | kidclamp joined #koha | |
| 13:51 | marion_ joined #koha | |
| 13:55 | gary | Back to the next school run for me and then mow the lawn a little to think and! |
| 13:55 | and hope bywater respond ;-) | |
| 14:01 | I just noticed at the end of the video the narrator added the .mrc ending to the import file, did'nt just hit save as I have been, 100 records with the $952 marc edit trick added | |
| 14:01 | I need to pick up children so lets see if that works when I get back again | |
| 14:03 | pmoura joined #koha | |
| 14:20 | pmoura joined #koha | |
| 14:50 | SVdP joined #koha | |
| 14:52 | SVdP | looking for anyone that has converted a "PrimaSoft Handy Library Manager" to KOHA |
| 15:37 | Dyrcona joined #koha | |
| 16:00 | bag joined #koha | |
| 16:02 | oleonard joined #koha | |
| 16:03 | oleonard | Hi #koha |
| 16:10 | PerplexedTheta joined #koha | |
| 16:50 | reiveune | bye |
| 16:50 | reiveune left #koha | |
| 17:25 | davidnind joined #koha | |
| 17:40 | cait joined #koha | |
| 17:53 | oleonard joined #koha | |
| 17:53 | bag joined #koha | |
| 17:53 | Dyrcona joined #koha | |
| 17:53 | kidclamp joined #koha | |
| 17:53 | vfernandes joined #koha | |
| 17:53 | akilsdonk joined #koha | |
| 17:53 | caroline joined #koha | |
| 17:53 | philor joined #koha | |
| 17:53 | pastebot joined #koha | |
| 17:53 | nugged joined #koha | |
| 17:53 | sam__ joined #koha | |
| 17:53 | khall joined #koha | |
| 17:53 | JBoyer joined #koha | |
| 17:53 | felicia joined #koha | |
| 17:53 | gooble_gobble joined #koha | |
| 17:53 | gmcharlt joined #koha | |
| 17:53 | huginn joined #koha | |
| 17:53 | raboof__ joined #koha | |
| 17:53 | phasefx joined #koha | |
| 17:53 | logbot joined #koha | |
| 17:53 | jeff joined #koha | |
| 17:53 | dpk joined #koha | |
| 17:53 | abneiman joined #koha | |
| 17:53 | sallyf joined #koha | |
| 17:53 | Guest130 joined #koha | |
| 17:53 | bshum joined #koha | |
| 19:35 | fridolin joined #koha | |
| 19:36 | fridolin | hi there |
| 19:43 | jzairo joined #koha | |
| 20:11 | bag | hiya fridolin |
| 20:12 | fridolin | hello bag watsup ? |
| 20:15 | bag | Today is the dogs birthday ;). he’s turning 11 yrs old - he’ll get some ice cream for a treat tonight :D |
| 20:15 | what’s your weather like there fridolin ? | |
| 20:16 | fridolin | whouuuuffy birthday |
| 20:16 | weather is havy rain, tropical rain | |
| 20:16 | normal for this period | |
| 20:17 | but we managed to go to the beach on sunday morning | |
| 20:17 | its alwayts between 25°C and 30°C | |
| 20:19 | caroline | @bag give Aloo a big birthday belly rub from me :) |
| 20:19 | huginn | caroline: I've exhausted my database of quotes |
| 20:19 | bag | will do :) |
| 20:20 | cold here fridolin - it was 0 this morning | |
| 20:47 | gary joined #koha | |
| 20:48 | lukeg joined #koha | |
| 20:48 | gary | Oh no, he's back! The 952 video worked books in, my next problem is that the word search in checkout is not picking them up. Do I have to refresh/index anything to make it better? |
| 21:05 | davidnind | gary: you could try a reindex: koha-rebuild-zebra -f -v kohadev (where kohadev is your instance/library name) |
| 21:11 | lukeg joined #koha | |
| 21:26 | * cait | waves at bag |
| 21:26 | cait | garwhat do you mean with search in checkout? |
| 21:26 | bag | hiya cait |
| 21:26 | cait | and happy birthday to Aloo |
| 21:26 | bag | Aloo++ |
| 21:26 | cait | :) |
| 21:27 | Aloo++ | |
| 21:27 | @karma Aloo | |
| 21:27 | huginn | cait: Karma for "Aloo" has been increased 3 times and decreased 0 times for a total karma of 3. |
| 21:27 | cait | 3 interesting |
| 21:28 | bag | the other must be from indrinal |
| 21:42 | cait | hm... is it onrmal i need to use sudo to edit my files when using ktd? *feels like I am doing something wrong* |
| 21:43 | ook, it works now... I think | |
| 21:45 | or not... can't save... | |
| 22:20 | this behaves so oddly ... my commits are not saved either and ugh. | |
| 23:07 | mtj | hi cait, are you using git on your repo, outside of docker? |
| 23:07 | ..thats mostly how i do it | |
| 23:11 | cait | yes |
| 23:11 | but things are still odd :) | |
| 23:11 | mtj | if so, then docker/ktd should not affect git's ability to commit a file |
| 23:12 | cait | hm |
| 23:12 | my SYNC_REPO points to /home/katrin/git/koha | |
| 23:13 | mtj | does 'git status' look ok? |
| 23:13 | cait | but the repo looks odd... several files owned by root and not sure ho that would happen |
| 23:13 | it's more a permission issue | |
| 23:13 | I am not allowed to commit (permission error) | |
| 23:14 | mtj | ^ yeah,. that was mt 1st guess |
| 23:14 | my | |
| 23:14 | cait | how would that happen? |
| 23:14 | mtj | its probably not caused/related to ktd/docker - but a coincidence |
| 23:15 | cait | so what should I do to fix? |
| 23:15 | mtj | $ chown -R katrin:katrin /home/katrin/git/koha |
| 23:15 | cait | it looks like they are all mixed up |
| 23:15 | -rw-r--r-- 1 root root 68831 Jan 24 23:40 Makefile.PL | |
| 23:15 | -rw-rw-r-- 1 katrin katrin 131 Jan 6 13:36 MANIFEST.SKI | |
| 23:16 | i have no idea how that happened if there was no automatism or so at work | |
| 23:16 | i've fixed hte permissions, hoping it stays that way | |
| 23:17 | mtj | cool, hopefully fixed :) |
| 23:18 | cait | yep, thx for taking the time mtj |
| 23:18 | mtj | i have no idea how the root:root perm happened |
| 23:18 | cait | me neither :) |
| 23:18 | especially as it seemed quite random on the files | |
| 23:19 | mtj | pass... lets call it fixed, unless it happens again |
| 23:22 | cait: how are you finding ktd, is it working ok for you? | |
| 23:23 | cait | haven't had much chance to play :( but I always hope to find more time soon :) |
| 23:25 | mtj | ah yep, understood |
| 23:26 | davidnind | I find when working on files from within KTD (after applying patches, etc) that the permissions get changed to root, so I do the chown from outside KTD reasonably often (normally after a pull or before I start KTD up) |
| 23:29 | cait | aha! |
| 23:30 | davidnind: thx, that helps :) | |
| 23:30 | ... but should it do that? | |
| 23:32 | it seems like a bit of a hassle | |
| 23:33 | mtj: ^any idea about this behavior? | |
| 23:46 | mtj | cait: hmm, the default user in ktd is 'root', so yeah, its probably causing the permission problem |
| 23:46 | ..when you edit/save a file in ktd, the file perms are set to root | |
| 23:49 | oops, thats not quite true - editing an existing file as root, does not change the perms | |
| 23:51 | davidnind joined #koha | |
| 23:52 | mtj | i have a few existing files/dirs in my dev koha repo that are root too |
← Previous day | Today | Next day → | Search | Index