Time Nick Message 23:52 mtj i have a few existing files/dirs in my dev koha repo that are root too 23:49 mtj oops, thats not quite true - editing an existing file as root, does not change the perms 23:46 mtj ..when you edit/save a file in ktd, the file perms are set to root 23:46 mtj cait: hmm, the default user in ktd is 'root', so yeah, its probably causing the permission problem 23:33 cait mtj: ^any idea about this behavior? 23:32 cait it seems like a bit of a hassle 23:30 cait ... but should it do that? 23:30 cait davidnind: thx, that helps :) 23:29 cait aha! 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:25 mtj ah yep, understood 23:23 cait haven't had much chance to play :( but I always hope to find more time soon :) 23:22 mtj cait: how are you finding ktd, is it working ok for you? 23:19 mtj pass... lets call it fixed, unless it happens again 23:18 cait especially as it seemed quite random on the files 23:18 cait me neither :) 23:18 mtj i have no idea how the root:root perm happened 23:18 cait yep, thx for taking the time mtj 23:17 mtj cool, hopefully fixed :) 23:16 cait i've fixed hte permissions, hoping it stays that way 23:16 cait i have no idea how that happened if there was no automatism or so at work 23:15 cait -rw-rw-r-- 1 katrin katrin 131 Jan 6 13:36 MANIFEST.SKI 23:15 cait -rw-r--r-- 1 root root 68831 Jan 24 23:40 Makefile.PL 23:15 cait it looks like they are all mixed up 23:15 mtj $ chown -R katrin:katrin /home/katrin/git/koha 23:15 cait so what should I do to fix? 23:14 mtj its probably not caused/related to ktd/docker - but a coincidence 23:14 cait how would that happen? 23:14 mtj my 23:14 mtj ^ yeah,. that was mt 1st guess 23:13 cait I am not allowed to commit (permission error) 23:13 cait it's more a permission issue 23:13 cait but the repo looks odd... several files owned by root and not sure ho that would happen 23:13 mtj does 'git status' look ok? 23:12 cait my SYNC_REPO points to /home/katrin/git/koha 23:12 cait hm 23:11 mtj if so, then docker/ktd should not affect git's ability to commit a file 23:11 cait but things are still odd :) 23:11 cait yes 23:07 mtj ..thats mostly how i do it 23:07 mtj hi cait, are you using git on your repo, outside of docker? 22:20 cait this behaves so oddly ... my commits are not saved either and ugh. 21:45 cait or not... can't save... 21:43 cait ook, it works now... I think 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:28 bag the other must be from indrinal 21:27 cait 3 interesting 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 @karma Aloo 21:27 cait Aloo++ 21:26 cait :) 21:26 bag Aloo++ 21:26 cait and happy birthday to Aloo 21:26 bag hiya cait 21:26 cait garwhat do you mean with search in checkout? 21:26 * cait waves at bag 21:05 davidnind gary: you could try a reindex: koha-rebuild-zebra -f -v kohadev (where kohadev is your instance/library name) 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? 20:20 bag cold here fridolin - it was 0 this morning 20:19 bag will do :) 20:19 huginn caroline: I've exhausted my database of quotes 20:19 caroline @bag give Aloo a big birthday belly rub from me :) 20:17 fridolin its alwayts between 25°C and 30°C 20:17 fridolin but we managed to go to the beach on sunday morning 20:16 fridolin normal for this period 20:16 fridolin weather is havy rain, tropical rain 20:16 fridolin whouuuuffy birthday 20:15 bag what’s your weather like there fridolin ? 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:12 fridolin hello bag watsup ? 20:11 bag hiya fridolin 19:36 fridolin hi there 16:50 reiveune bye 16:03 oleonard Hi #koha 14:52 SVdP looking for anyone that has converted a "PrimaSoft Handy Library Manager" to KOHA 14:01 gary I need to pick up children so lets see if that works when I get back again 14:01 gary 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 13:55 gary and hope bywater respond ;-) 13:55 gary Back to the next school run for me and then mow the lawn a little to think and! 13:24 cait1 https://koha-community.org/manual/21.11/en/html/third_party_software.html#importing-excel-data-into-koha 13:24 cait1 hm not that one... but that one too maybe (helpful that is) 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/public/koha/2013-January/035302.html 13:21 gary thanks cait1 and joubu 13:21 cait1 gary: maybe this here is also helpful: http://blog.l2c2.co.in/index.php/2016/08/03/marcedit-quicktip-3-getting-your-952-items-holdings-data-field-in-place-for-import-into-koha/ 13:20 cait1 (back from meeting) 13:19 cait1 gary: ah I meant the koha manual 13:19 Joubu And the video is there: https://www.youtube.com/watch?v=Jjx7e7VoOs8 13:19 Joubu gary: https://web.archive.org/web/20161229102717/http://bywatersolutions.com/2012/01/18/using-marcedit-to-add-koha-items/ 13:14 gary I just emailed bywater, I guess America has awoken! 13:10 Joubu you can try the mailing list 13:09 gary is there a discord group or anywhere else I might make my cry for help? 13:01 gary the marcedit manual yes, maybe I have not come across it yet 12:59 cait1 next meeting here :( 12:59 cait1 (it happens quite often) 12:58 cait1 I am sure I saw a step by step somewhere for this problem 12:58 cait1 have you checked the manual? 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:47 marcelr i dont really know marc editor 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:43 marcelr ok sorry 12:43 gary Thats just one of the try this broken links outthere 12:43 marcelr bywater? 12:42 gary Ok really banging head on desk, links broken https://bywatersolutions.com/2012/01/18/using-marcedit-to-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:41 vfernandes it works... thanks Joubu... that's easier than using the method decode 12:39 vfernandes ok, let me try... i was using decode_uft8 method 12:37 Joubu vfernandes: add "use utf8;" at the top of the module 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:35 vfernandes hi #koha 12:32 marcelr o/ 12:29 gary I guess it all happens in marcedit 12:28 gary well on the spreadsheet, oh yes you are right 12:28 cait1 ok, was looking at your list, 260 stood out too 12:28 cait1 gary: not sure what you mean with column 12:28 gary 952 is the only one like that 12:28 cait1 260 is repeatable, not sure if it affects display to have them in separate 12:28 cait1 because 245 is marked as 'not repeatable' 12:27 cait1 like if you had 245 a b and c 12:27 cait1 yes, you shoudl actually do that with other fields doo I think 12:23 gary looking at the manual now 12:22 gary then do I write the values in the single column?? in the right order 12:21 gary so if I just put 952 $a $b $y $2 -- like that in one column? 12:21 cait1 i believe there are some hints on how to fix this with marcedit maybe in the manual 12:20 cait1 so that could be an issue for sure 12:20 gary oh 12:20 cait1 so one item is 952$a $b $.... 12:20 cait1 ok, it should only be one line per item 12:20 gary yes 12:20 cait1 are your 952 on mulitple lines? 12:20 cait1 oh 12:20 gary this is what I have 245$a 100$a 260$c 260$b 300$a 020$a 952$a 952$b 952$y 952$2 12:19 gary ok 12:19 cait1 you can just leave the subfields out, that's ok 12:19 gary Ok but can put them in blank? 12:19 cait1 just something that shoudl match too, when you do use them 12:19 cait1 are optional :) 12:19 cait1 you don't need them - location and collection 12:19 gary what are in those 12:19 gary no I don't 12:19 cait1 in the past Koha didn#t give a good error when these didn't match config, so just something to check maybe 12:18 cait1 do you import 952 c or 8? 12:18 cait1 ok, that's good 12:18 gary I have those 3 12:18 gary 952 a b 12:18 cait1 yes, things like that 12:17 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:17 gary by that you mean, hang on 952$y 12:17 cait1 about the FK constraint ... there could be some things, but there are some things to look out for 12:17 cait1 gary: you are also importing items? 12:17 gary that was the 5 12:16 gary 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: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:15 cait1 and then they shoudl show up 12:15 cait1 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:14 cait1 gary: sorry, was in meeting all morgning - after staging committing them to the catalog is a separate step 12:02 koha-jenkins Project Koha_Master_D12 build #67: FIXED in 41 min: https://jenkins.koha-community.org/job/Koha_Master_D12/67/ 12:02 koha-jenkins Yippee, build fixed! 11:58 gary Ah, I just tried another 3 and it worked fine, maybe I need to try 10 at a time 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:55 gary it pulled in three books and stopped 11:53 gary I am beginning to wonder how on earth I managed earlier this year, lockdown time I guess! 11:53 gary these are my home branch descriptions =952 \\$bCLIFTON =952 \\$yCLIFTON 11:50 gary Do I need to layout the csv exactly as here http://188.166.144.214:8080/cgi-bin/koha/admin/koha2marclinks.pl 11:48 paxed item homebranch does not exist in branches.branchcode 11:45 gary 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:45 gary Ok watch out for a big paste, something I am doing wrong I am sure --- 10:40 paxed and then very heavy reports wouldn't affect koha usage 10:40 paxed saved reports would be ideal for it, as it doesn't really matter if the db is few minutes behind the master 10:39 paxed yup 10:39 marcelr sql replication ? 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:28 gary will do that 09:52 mtj try and build a VM that is the same OS and koha version as your working system 09:50 gary must go for now 09:50 mtj compare OS and koba versions, etc 09:50 gary Not sat near the other one sadly 09:50 mtj alos, compare config files in /etc/koha and /etc/apache 09:49 gary the VM is for the school I teach at because I am afraid the other laptop will die 09:49 mtj try importing your marc files on both systems, and try to detect the differences 09:49 gary BRB have to pick up school children 09:49 gary Its a VM one causing me issues 09:48 gary I do 09:48 mtj gary: as i understand you have another woking koha, which is a good start 09:45 gary ok so what should I check now? 09:40 mtj yes, all those missing modules are not required for production 09:36 gary I see now I have done that the previous missing perl is now missing again 09:35 gary ok so renamed, and rebooting what next? 09:30 gary bit above my paygrade but will try 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:27 gary 30% of memory is what its sitting at 09:25 gary but maybe thats not enough 09:25 tuxayo And checking the RAM usage in the VM after you start the process could confirm that 09:25 gary yesterday I was trying 2 and am now up at 4 09:24 tuxayo with 8G for 2900 record that's unlikely 09:24 gary Yeah all the other records work in a machine at school that I have had running for at least 8 months 09:23 gary it was memory I thought 09:23 tuxayo mtj indeed, I wonder how often people are confused by that 09:22 tuxayo gary: So what was the issue when you said you found it? 09:22 mtj it should really be identified as such, to not cause confusion 09:21 mtj its a little misleading, but Test::DBIx::Class is only used by the testing scripts, and not needed for production 09:21 tuxayo gary: you where able to import all those record on another laptop? how long it was? 09:20 mtj gary: i think cpan installs to /usr/local/share/perl, so check in there to confirm :) 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:19 mtj ^ so, just make sure you dont cpan install those modules 09:18 mtj koha has a problem with newer versions of Mojolicious::Plugin::OpenAPI and Json::Validator 09:18 tuxayo gary: Sorry I don't know much about record import. But perhaps someone will. 09:18 gary 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:16 gary Well that's me! I tried to install only the ones it asked for..... 09:14 mtj hi gary: its possible to break your koha if you use cpan to install perl modules 09:05 gary can you point me at the CLI tools please, sorry to be a pain 09:03 tuxayo 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:03 tuxayo Because if it's one or two minutes long then you can't do that from the UI 09:02 tuxayo webserver timeout? 09:02 gary No its my fault found it now 09:02 tuxayo if it's the system that killed the process filling the ram then there should be something in the system logs `journalctl -r` 09:01 tuxayo Note that if the issue is memory usage it might not be report well depending how how the issue was "resolved" 09:00 tuxayo is /var/log/koha empty in the VM? 08:59 tuxayo oh, that's strang 08:59 gary let me try again 08:59 tuxayo http://irc.koha-community.org/koha/2022-01-21#i_2401166 08:59 tuxayo check in the logs for the same message: 08:59 gary I still can't find them, I thought that /var/log/koha 08:58 tuxayo gary: oops, kohadev is the name of my koha instance 08:55 gary I can't see that log file directory either 08:54 gary humm seems to have stopped again, I wonder if I should up the memory to 8gb 08:23 gary less than 10 minutes, I was not paying attention. 2900 going in now 08:18 tuxayo *it shouldn't 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:17 gary I think I may have been being impatient as the progress bar does not always work 08:17 gary Yeah, I made the machine a 4gb one this time and am using an ubuntu install 08:16 tuxayo that it didn't work on your previous attempts today now that you had enough ram. 08:16 tuxayo great! Right it's was about lack of RAM last time. It's odd 08:16 tuxayo > the records have gone in 08:16 tuxayo how big? 08:15 tuxayo and worker-output.log 08:15 tuxayo worker-error.log 08:15 gary Big batch now.... 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 thanks tuxayo, the records have gone in but I will save that handy hint 08:13 tuxayo tail -fn0 /var/log/koha/kohadev/* 08:13 tuxayo The command to see all the logfiles at once is: 08:13 tuxayo So you are the same person from the other day, I did recognize your nickname ^^ 08:11 tuxayo gary: As you have 100 records it shouldn't be long. So something is wrong. 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: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. 07:57 cait1 they only go into the catalog as the second step 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 alex_a Bonjour 07:54 gary I think I am wrong 07:52 gary cait Will the DB updates show up in logview as 1/24/2022 07:36 Gary Mortimer (51) Catalog Add Item 12 from Biblio 2 ?? 07:51 gary hello 07:50 matts hello ! 07:47 gary yes 07:47 cait you are importing bibliographic data? 07:46 gary Oh, how might I check the DB for dummies please 07:46 cait 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 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:45 gary thanks cait 07:45 gary Ah, ok I will wait and see then! 07:45 cait it doesn't mean that it isn't importing 07:45 cait gary: theprogess bar doesn't always work 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: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:20 marcelr hi #koha 06:59 reiveune hello 06:39 gary starting from scratch again 06:14 gary how do I reach the logs again? I foolishly did'nt note down the great advice the other day 06:12 tuxayo gary: You can also try to import your file in a demo with the same MARC flavor as your's : https://wiki.koha-community.org/wiki/Koha_Demo_Installations 06:12 tuxayo Anything in the log when you do the imports? 06:06 gary might just start again 06:06 gary look 06:06 gary I was hoping making sure all the packages would fix it, just sat back down again to loo 05:32 tuxayo gary: any leads with your record import issues? 05:30 tuxayo *though (<-I think ^^") 05:29 tuxayo Weird that cpan didn't do the trick tough. 05:29 tuxayo gary: not needed unless you want to run the automated tests. Like when working to developing & testing patches. 04:48 gary using sudo cpan worked for all the others missing 04:48 gary Hi all, struggling to install one missing perl module Test::DBIx::Class any tips?