← Previous day | Today | Next day → | Search | Index
All times shown according to UTC.
Time | Nick | Message |
---|---|---|
00:16 | irma_ joined #koha | |
00:52 | inlibro joined #koha | |
01:44 | dpk_ joined #koha | |
01:52 | inlibro joined #koha | |
02:52 | inlibro joined #koha | |
03:26 | irma_ joined #koha | |
03:52 | inlibro joined #koha | |
04:51 | sophie_m joined #koha | |
04:53 | inlibro joined #koha | |
05:05 | chris joined #koha | |
05:14 | cait joined #koha | |
05:22 | clrh_ joined #koha | |
05:53 | inlibro joined #koha | |
06:36 | laurence joined #koha | |
06:47 | sophie_m1 joined #koha | |
06:51 | reiveune joined #koha | |
06:51 | cait joined #koha | |
06:51 | reiveune | hello |
06:53 | inlibro joined #koha | |
07:04 | alex_a joined #koha | |
07:04 | alex_a | bonjour |
07:04 | wahanui | hey, alex_a |
07:23 | fridolin joined #koha | |
07:23 | fridolin | hi |
07:23 | wahanui | hi, fridolin |
07:30 | greenjimll joined #koha | |
07:30 | liliputech_asu | hi :) |
07:34 | davidnind joined #koha | |
07:53 | Benoit joined #koha | |
07:53 | inlibro joined #koha | |
07:54 | Benoit | Hi Koha community ! Looking for help with an update from 17 to 19 and a "no result found" problem after restarting zebra etc... Anyone can help ? |
07:55 | reiveune left #koha | |
07:57 | cait | we can try if you give us a little bit more information |
07:57 | ther eis no koha 17 and 19 :) | |
07:58 | we do 2 big versions each year, so there are 17.05, 17.11 and 19.05 | |
07:58 | how did you update? waht kind of installation is it? (OS, packages?) | |
07:58 | Benoit | ok I'll check these number to be sure of what I say.. |
07:59 | So I moved from 17.05.08.001 to 19.05.02.000 | |
08:00 | reiveune joined #koha | |
08:00 | Benoit | Also changed OS from Debian 9.4 to Ubuntu 18.04 |
08:01 | magnuse | did you do a full reindex? |
08:01 | Benoit | yep |
08:01 | I did import all sql data and tmplates | |
08:01 | then reindex | |
08:02 | magnuse | and zebra is running? |
08:02 | Benoit | everything looks fine except search that doesn't give any result |
08:02 | yes it's running but just when i'm root logged | |
08:02 | if I try to start it as normal user I get an authorization error | |
08:03 | magnuse | sounds like you might have a problem with permissions, then |
08:03 | how did you install? | |
08:03 | Benoit | like changing ownership^on zebra-output.log not pernmitted |
08:03 | following the "official" way | |
08:03 | magnuse | meaning debian packages? |
08:04 | Benoit | yes I think |
08:04 | https://wiki.koha-community.or[…]ubuntu_-_packages | |
08:05 | magnuse | yup, that would be the debian packages |
08:05 | you shouldn't really have to worry about starting zebra then | |
08:05 | do you know the koha-* commands? like koha-zebra? | |
08:06 | Benoit | yes some of them |
08:06 | wahanui | some of them are probably available in yum |
08:06 | Benoit | followed that to move old koha to newer one :http://kohageek.blogspot.com/2[…]abase-to-new.html |
08:06 | magnuse | what does this give you? "sudo koha-zebra --status <your instance name>" |
08:07 | Benoit | with sudo it's OK |
08:07 | magnuse | yes, you can only run it with sudo |
08:07 | Benoit | ok was worried about the error without it.. |
08:08 | but still have this "no result" pb :( | |
08:08 | both zebra error and output logs are empty | |
08:10 | each time I make a search on the Opac I get a AH01215, uninitialized value in concatenation (.) error in C4/Auth.pm line 584 error | |
08:11 | magnuse | and you reindexed with "sudo koha-rebuild-zebra -f -v <instance>"? no errors? |
08:11 | what does line 584 look like? | |
08:14 | Benoit | the line : mylibraryfirst => ( C4::Context->preferences("SearchMyLibraryFirst") && C4::Context->userenv = ? C4::Context->userenv->{'branch'} : '', |
08:14 | I restart a reindex to check for errors | |
08:16 | magnuse | do you have a value for "SearchMyLibraryFirst"? try this: "SELECT * FROM systempreferences WHERE variable = 'SearchMyLibraryFirst'; |
08:17 | Benoit | ok waiting for reindex to end, got over 40k records.. |
08:17 | magnuse | yeah, that takes a little while |
08:19 | Benoit | got error retreiving record around the end but can't fully read, scrolling too fast :( |
08:21 | magnuse | there is one particular error to look out for, something to do with locking |
08:22 | the indexing should complete even if some records can't be retrieved | |
08:23 | Benoit | the searchmylibraryfirst is set to 0 in my library db |
08:24 | yep it does finish and I can even access to my notices in opac, just can't search them | |
08:26 | cait | where is the concatenation in this line? |
08:26 | could it be the wrong line? | |
08:26 | magnuse | the file should be /usr/share/koha/lib/C4/Auth.pm |
08:27 | cait | Benoit: have you tried a sudo koha-zebra --restart instance? |
08:28 | Benoit | yep |
08:28 | cait | looks ok? |
08:28 | Benoit | yep |
08:28 | cait | hm |
08:28 | anythin gin your plack-error.log? | |
08:29 | Benoit | where can i find this log ? |
08:30 | can't locate it | |
08:30 | magnuse | sudo tail -f /var/log/koha/<instance>/plack-error.log |
08:30 | i think | |
08:30 | if you are running under plack, that is | |
08:31 | Benoit | nope don't have this file |
08:32 | magnuse | ooh, you should run plack, much faster, but worry about that later |
08:32 | try this: | |
08:32 | sudo tail -f /var/log/koha/sksk/intranet-error.log | |
08:32 | or this: | |
08:32 | sudo tail -f /var/log/koha/sksk/opac-error.log | |
08:32 | depending on where you search | |
08:33 | run that, press enter a couple times to add newlines, run a search, then check what new errors you have after the newlines | |
08:34 | Benoit | ok hold on |
08:34 | magnuse | if that gives a lot of errors you can share them here: http://paste.koha-community.org/ |
08:35 | cait | yep but definitely need to activate plack and memcached in the end |
08:37 | Benoit | well still have these AH01215 concatenation errors but can't copy paste from VMWareConsole :( |
08:38 | can recopy if you've got 10minutes :p | |
08:43 | pastebot | "Benoit" at 127.0.0.1 pasted "Errors after a search in opac" (2 lines) at http://paste.koha-community.org/3765 |
08:45 | Benoit | also I've just found errors in indexer-output.log could that help ? |
08:46 | cait | hm those look just like warnings |
08:46 | what's in the indexer? | |
08:53 | Benoit | DBD::mysql::st execute failed: Table 'koha_cirdoc.zebraqueue' doesn't exist [for statement "SELECT COUNT(*) FROM zebraqueue WHERE done= 0;"] at /usr/share/koha/bin/migration_tools/rebuild_zebra.pl line 324 |
08:53 | and a second one : | |
08:53 | inlibro joined #koha | |
08:55 | Benoit | DBD::mysql::st fetchrow_arrayref failed fetch() without execute() [the same query as up here] at same path line 325 |
08:56 | question : does the fact that I changed the library name between old an new install can make this error happen ? | |
08:57 | cait | the instance name? |
08:57 | or the library in your koha admin config | |
08:58 | Benoit | nope the instance name like the koha_library name in the DB |
08:58 | cait | is cirdoc the old or the new one? |
08:58 | Benoit | new one |
08:58 | the old one was kohaclone | |
08:58 | cait | the error above is a 'not good' one |
08:58 | it tries to check for records to index and doesn't find the db table it's looking for | |
08:59 | so that's definitely something to look at | |
08:59 | Benoit | yep but I did the update schema process |
08:59 | cait | these tables haven't changed |
08:59 | between versions | |
09:00 | make sure your db name is really koha_cirdoc? | |
09:00 | Benoit | yes it is |
09:00 | cait | how did you migrate? |
09:00 | did you create the new isntallatoin + instance on a new server and then load the db? | |
09:00 | Benoit | yes |
09:00 | cait | did you mgirate any other files? |
09:01 | Benoit | yep some tmpl for opac |
09:02 | and if I check in the DB got this zebraqueue table | |
09:02 | it's empty but there | |
09:03 | in the old install the same table has over 23k rows | |
09:04 | cait | that's a bit much |
09:04 | Benoit | realizing also that old install on the Debian is using MariaDb, the new one on Ubuntu uses mysql, if it can help... ? |
09:05 | cait | usually you clean that out using a cronjog regularly |
09:05 | it should still be ok | |
09:05 | we are still using mysql too | |
09:05 | both work | |
09:05 | Benoit | ok |
09:05 | cait | I am not sure why the indexer woudl not find the table - maybe permissions? |
09:05 | vfernandes joined #koha | |
09:06 | cait | I am sorry, but running out of ideas :( |
09:06 | Benoit | :( |
09:06 | cait | if you try again a little later or post the error we found to the mailing list, someone else might be able to help from there |
09:06 | Benoit | it's ok don't worry, I'll finish to manage this damned search ! |
09:06 | ok cool, thanks !! | |
09:18 | magnuse | "Table 'koha_cirdoc.zebraqueue' doesn't exist" is definitely the thing to focus on |
09:19 | Benoit: if you do "sudo koha-mysql circdoc" and then "show tables" you are sure zebraqueue is there? | |
09:20 | sorry that should be "sudo koha-mysql cirdoc" | |
09:22 | you say you can see that zebraqueue is empty, are there things in other tables in that database? like tables systempreferences or biblio? | |
09:23 | if you created a db dump on an old machine and then restored it on the new machine, it will recreate a database with the old name on the new machine. did you edit the dump file to use the new db name? | |
09:45 | Benoit | sorry for answer delay : yes the koha-mysql works, everybody is there |
09:46 | yes for the dump | |
09:53 | inlibro joined #koha | |
10:02 | magnuse | Benoit: so if you do "sudo koha-mysql cirdoc" and "SELECT COUNT(*) FROM zebraqueue" + "SELECT COUNT(*) FROM biblo", the first gives 0 and the second gives the right number? |
10:03 | sorry, biblio, not biblo in the second query | |
10:03 | Benoit | that's it |
10:04 | got 0 on the first and 46764 on the second wich looks fine | |
10:04 | khall joined #koha | |
10:05 | magnuse | yeah, sounds good |
10:06 | so why on earth does rebuild_zebra.pl say it can't find the koha_cirdoc.zebraqueue table? | |
10:07 | hm, if there was just one error like that, maybe the cronjob to index the zebraqueue was run before the db was initialized | |
10:07 | is the log entry timestamped? | |
10:07 | or can you see if more errors like that are added? | |
10:08 | Benoit | nope that's the problem |
10:08 | magnuse | yeah, i think that is a red herring |
10:08 | Benoit | Could I try to clear it then retry the zebra rebuild ? |
10:08 | magnuse | the real problem is in the searching |
10:08 | clear what? | |
10:08 | Benoit | the indexer-outptut log |
10:09 | magnuse | you can watch it live with "tail -f" |
10:09 | if you can have two terminals at the same time | |
10:09 | Benoit | nope |
10:09 | magnuse | ok |
10:10 | but you can check if the indexing has been done, like this: https://wiki.koha-community.or[…]g_with_yaz-client | |
10:10 | $ yaz-client -c /etc/koha/zebradb/ccl.properties unix:/var/run/koha/cirdoc/bibliosocket | |
10:10 | then Z> base biblios | |
10:11 | and Z> f <something that should give results> | |
10:11 | Benoit | no result :( |
10:12 | magnuse | you get "Number of hits: 0, setno 1"? |
10:12 | Benoit | nope setno is 3 |
10:12 | but 0 hits indeed | |
10:13 | magnuse | and you searched for something that should give a result? |
10:13 | Benoit | sure |
10:13 | magnuse | then we know the indexing failed |
10:14 | and that zebra is running | |
10:17 | try to index just 10 records: "sudo koha-rebuild-zebra -f -v --length 10 cirdoc" | |
10:18 | Benoit | hmm looks like the --length 10 instructions is not taken into account |
10:18 | putting it after cirdoc ? | |
10:20 | cait | magnuse++ |
10:20 | magnuse | maybe "sudo koha-rebuild-zebra -f -v --length=10 cirdoc" |
10:21 | Benoit | yep |
10:21 | magnuse | the instance name should be last |
10:21 | Benoit | ok did it |
10:22 | magnuse | any errors or search results? |
10:22 | try searching for just "a" | |
10:22 | Benoit | just got a warn "record didn't contain match fields in (bib1, Local-number) |
10:22 | magnuse | 1 warn or 10? |
10:23 | cait | hmm |
10:23 | which marc flavour are you using? | |
10:23 | Benoit | unimarc |
10:23 | just one | |
10:23 | cait | did you create yoru instance to be unimarc? |
10:24 | marc21 is the default, so that could have been missed | |
10:24 | and the index configuration is very different | |
10:24 | Benoit | never been asked for that ? I'll find that in the conf file ? |
10:24 | cait | it wouldn't ask |
10:24 | i think | |
10:25 | magnuse: you set that in the conf file for creating an instance.. right? | |
10:25 | magnuse | yes, i'm pretty sure |
10:26 | check in /etc/koha/sites/cirdoc/koha-conf.xml | |
10:26 | it should say marc21 or unimarc in lots of places at the top of the file | |
10:26 | also check the MarcFlavor syspref | |
10:27 | Benoit | ok it says marc21 everywhere |
10:27 | magnuse | ah, that's the problem then |
10:27 | cait++ | |
10:27 | Benoit | so shall I just change marc21 to unimarc ? |
10:28 | magnuse | good question :-) |
10:29 | yeah, i think that should work, but there are some more files in /etc/koha/sites/cirdoc/ you need to edit too | |
10:32 | these four: zebra-authorities.cfg, zebra-authorities-dom.cfg, zebra-biblios.cfg, zebra-biblios-dom.cfg | |
10:32 | Benoit | ok i'll do that |
10:32 | magnuse | then restart zebra and probably the indexer? |
10:32 | and try reindexing | |
10:34 | Benoit | did it !!!! |
10:34 | sooooo happy ! | |
10:34 | cait | hah! |
10:34 | Benoit | thanks a lot guys ! |
10:34 | cait | team_work++ |
10:35 | magnuse++ | |
10:35 | Benoit | and also sorry for my stupid lookin like mistake ! |
10:35 | magnuse | team_work++ |
10:35 | it happens! | |
10:35 | for the record, you should have edited ZEBRA_MARC_FORMAT in /etc/koha/koha-sites.conf to avoid this | |
10:36 | Benoit | ok noticed ! |
10:36 | magnuse | guess it means you are probably set up with en for the zebra language too |
10:36 | Benoit | feel like it's the end of my 2 weeks headache ! |
10:37 | magnuse | you might want to look for "en" in the four files i mentioned and replace it with "fr", then restart and reindex again |
10:37 | cait | is fr still more complete n mappings? |
10:38 | I've created a sort file or us mixing them all together heh :) | |
10:38 | magnuse | dunno, but i would suspect there are some frenchisms :-) |
10:40 | cait | possibly :) |
10:45 | magnuse | guess koha-create could be made a bit more user friendly, e.g. by displaying the values from /etc/koha/koha-sites.conf and asking "does this look ok?" :-) |
10:51 | bug 23401 | |
10:51 | huginn` | Bug http://bugs.koha-community.org[…]_bug.cgi?id=23401 enhancement, P5 - low, ---, koha-bugs, NEW , Make koha-create more user friendly |
10:54 | inlibro joined #koha | |
11:02 | khall joined #koha | |
11:35 | oleonard joined #koha | |
11:36 | oleonard | Hi #koha |
11:37 | laurence left #koha | |
11:43 | kidclamp | hi oleonard |
11:43 | wahanui | hi oleopard |
11:49 | alex_a joined #koha | |
11:54 | inlibro joined #koha | |
12:33 | corilynn_ joined #koha | |
12:33 | oleonard | Hi corilynn |
12:36 | coriA__ joined #koha | |
12:37 | coriA__ joined #koha | |
12:46 | eythian | hi |
12:46 | oleonard | Hi eythian, what are you up to today? |
12:47 | eythian | just work. Nothing exciting. |
12:48 | oleonard | Straightening manhole covers, polishing traffic lights |
12:48 | eythian | pretty much, yes |
12:48 | oleonard | Yeah same |
12:50 | (eythian and I are the only ones who know we work across from each other in a secret spy facility) | |
12:50 | ...but like... the billing department. | |
12:50 | eythian | shh! |
12:51 | cait | lol |
12:51 | thx for that :) | |
12:54 | inlibro joined #koha | |
12:54 | oleonard | Oh no cait is here now we will have to... uh... silence her... |
12:54 | magnuse | i'm not here, btw |
12:58 | cait | oleonard: what does billing use for this.... paper clip chain? |
12:59 | * cait | wonders what eythian did to her booking account that she has to reset the password every single time she uses it |
12:59 | eythian | you're probably just a suspicious person |
12:59 | oleonard | You laugh now cait, but you won't be laughing after the paper cuts |
13:00 | magnuse | it's the secret "make life hell for my friends" setting |
13:00 | bug 23403 is fun | |
13:00 | huginn` | Bug http://bugs.koha-community.org[…]_bug.cgi?id=23403 major, P5 - low, ---, koha-bugs, NEW , SIP2 lends to wrong patron if cardnumber is missing |
13:00 | cait | ugh |
13:00 | oleonard: I am frightened | |
13:14 | khall joined #koha | |
13:14 | khall joined #koha | |
13:24 | caroline_catlady | hi everyone! |
13:25 | cait | hi caroline_catlady :) |
13:33 | wizzyrea joined #koha | |
13:46 | oleonard | Just like a good test plan can reveal problems with patches... preparing a screencast demo |
13:54 | inlibro joined #koha | |
13:58 | lukeG joined #koha | |
14:01 | oleonard | Working on Bug 23039: https://zivotdesign.com/p/view[…]?p=15645814910650 |
14:01 | huginn` | Bug http://bugs.koha-community.org[…]_bug.cgi?id=23039 enhancement, P5 - low, ---, koha-bugs, NEW , Hold found modal on checkin screen ( circulation.pl ) obscures Check in message info |
14:02 | oleonard | (look out everyone oleonard upgraded his image album software and now it supports video) |
14:03 | cait | oleonard: doesn't play for me :( |
14:03 | oleonard | Boo |
14:03 | cait | just shows the broken image icon |
14:04 | oleonard | ? https://zivotdesign.com/p/uplo[…]03b8e104d7a40.mp4 |
14:05 | cait | oh that works |
14:05 | i was trying tthe link above | |
14:05 | * oleonard | has no idea why the first link didn't work |
14:06 | cait | it's nice :) |
14:11 | oleonard | khall ^^ |
14:11 | * caroline_catlady | likes it |
14:12 | caroline_catlady | Is the see last message button new? |
14:12 | cait | yep |
14:12 | * caroline_catlady | likes that too |
14:18 | oleonard | If anyone would like to help this along, please test Bug 23399 :D |
14:18 | huginn` | Bug http://bugs.koha-community.org[…]_bug.cgi?id=23399 enhancement, P5 - low, ---, oleonard, Needs Signoff , Reindent returns.tt |
14:54 | inlibro joined #koha | |
15:05 | alex_a_ joined #koha | |
15:08 | cait | hm any reason why after a git fetch my system woudl still claim that v18.11.08 doesn't exist as a tag? |
15:10 | oleonard | I don't see it listed either |
15:10 | cait | huh |
15:10 | shows as tag for me here: http://git.koha-community.org/[…]oha.git;a=summary | |
15:10 | how did you look it up? | |
15:11 | reiveune | bye |
15:11 | reiveune left #koha | |
15:11 | oleonard | cait: git tag |
15:11 | cait | ah yeah |
15:11 | it#s not on the branch.... | |
15:11 | http://git.koha-community.org/[…]efs/heads/18.11.x | |
15:11 | not here | |
15:11 | hm | |
15:11 | lukeG: aroudn? | |
15:11 | around even :) | |
15:12 | khall: around? kidclamp: ? | |
15:15 | kidclamp | hm? |
15:15 | cait | lukeG: we are missing the v18.11.08 tag |
15:19 | fridolin left #koha | |
15:21 | lukeG | cait what should i do? add the tag now? |
15:22 | cait | i don't know actually |
15:22 | gmcharlt: maybe? | |
15:23 | gmcharlt | cait: lukeG: would be OK to add the tag now; just need to make sure that it is attached to the correct commit in 18.11.x |
15:24 | lisettelatah joined #koha | |
15:27 | lukeG left #koha | |
15:29 | cait | hm now we lost lukeG |
15:29 | gmcharlt++ thx | |
15:30 | lukeG joined #koha | |
15:30 | cait | wb |
15:31 | lukeG: did you see what gmcharlt said? | |
15:32 | git tag -a v1.2 commitid - says the manual | |
15:46 | lukeG | cait yes |
15:46 | i did that and pushed it out | |
15:48 | git tag -a v18.11.08 -m "Koha release 18.11.08" a71bd8c1952ddc7ae5e02be3b1cacddfe788af65 | |
15:49 | cait: does that seem right now? | |
15:49 | http://git.koha-community.org/[…]efs/heads/18.11.x | |
15:53 | cait | seems ok, on the phone sec |
15:55 | inlibro joined #koha | |
15:58 | cait | lukeG: the fetch looks good |
15:58 | and git kc too | |
15:58 | it's on the right tag | |
15:59 | that seems to have done it | |
15:59 | lukeG++ | |
15:59 | i always rebase our branches using the tags | |
15:59 | lukeG | oh good, sorry about that one. I won't make that mistake again! |
15:59 | cait | all good, fixed! :) |
15:59 | oleonard++ | |
15:59 | thx for helping figure it out | |
16:03 | Mandersoon joined #koha | |
16:03 | khall joined #koha | |
16:19 | lukeG1 joined #koha | |
16:33 | oleonard | lukeG1++ # Thanks for the signoff! |
16:34 | lukeG1 | oleonard++ |
16:34 | Thanks for the patch! | |
16:48 | Mandersoon_ joined #koha | |
16:55 | inlibro joined #koha | |
17:13 | oleonard | cait and wizzyrea: Should Bug 13420 be "in discussion" ? |
17:13 | huginn` | Bug http://bugs.koha-community.org[…]_bug.cgi?id=13420 major, P5 - low, ---, gmcharlt, Needs Signoff , Holdings table sorting on volume information incorrect |
17:34 | cait | oleonard-away: commented and changed status |
17:40 | cait left #koha | |
17:46 | oleonard | Thanks cait |
17:55 | inlibro joined #koha | |
18:15 | cait joined #koha | |
18:28 | caroline_catlady | are spaces important in yaml? (asking specifically for OpacHiddenItems.) |
18:29 | I seem to remember there had to be no space between the field and the colon, then a space and the bracket, e.g. itype: [], but I can't find that info anymore | |
18:34 | ok wikipedia answered my question :) | |
18:34 | "YAML requires the colon be followed by a space" | |
18:34 | https://en.wikipedia.org/wiki/YAML. | |
18:55 | inlibro joined #koha | |
19:00 | oleonard | See y'all later |
19:28 | cait | caroline_catlady++ |
19:32 | inlibro joined #koha | |
19:52 | lukeG joined #koha | |
19:55 | inlibro joined #koha | |
20:04 | kathryn joined #koha | |
20:13 | wizzyrea joined #koha | |
20:36 | Mandersoon | Does anyone tinker with the Digibib Koha docker container? I am trying to run it, but things go sideways because it seems to not set up the /koha symlink correctly or something. https://hub.docker.com/r/digibib/koha |
20:37 | Lots of this: unable to locate Koha configuration file koha-conf.xml at /koha/C4/Context.pm line 243. | |
20:37 | cait | I've not, sorry |
20:41 | alexbuckley joined #koha | |
20:55 | inlibro joined #koha | |
21:18 | davidnind left #koha | |
21:39 | lukeG joined #koha | |
21:40 | lukeG | anyone have any idea what is going on here: |
21:40 | https://bugs.koha-community.or[…]_bug.cgi?id=23408 | |
21:40 | huginn` | Bug 23408: normal, P5 - low, ---, koha-bugs, NEW , Relatives' checkout table columns are not configured properly |
21:56 | inlibro joined #koha | |
22:11 | janPasi_ joined #koha | |
22:56 | inlibro joined #koha | |
23:40 | papa joined #koha | |
23:48 | wizzyrea joined #koha | |
23:56 | inlibro joined #koha |
← Previous day | Today | Next day → | Search | Index