IRC log for #koha, 2020-12-20

All times shown according to UTC.

Time S Nick Message
00:13 Oak joined #koha
00:19 inlibro joined #koha
00:29 deb-CSPL joined #koha
01:19 inlibro joined #koha
01:29 cait1 joined #koha
02:19 inlibro joined #koha
02:36 dpk Doug here supporting EFDSS in London.  Just got a report from users post upgrade to 20.11.00 (via debian packages) that displaying results of some searches is giving "Internal Server Error".
02:37 dpk Logs do not look happy.  Can share if there is an expert around, but we are getting lots of lines like:
02:37 dpk Unknown column 'me.exclude_from_local_holds_priority' in 'field list' at /usr/share/koha/lib/Koha/Objects.p
02:38 dpk and
02:38 dpk ==> plack-intranet-error.log <==
02:38 dpk [2020/12/20 02:26:58] [WARN] DBD::mysql::st execute failed: Unknown column 'me.exclude_from_local_holds_priority' in 'field list' [for Statement "SELECT ...
02:39 dpk Any ideas?
03:19 inlibro joined #koha
04:19 inlibro joined #koha
05:19 inlibro joined #koha
06:07 dpk It looks like some of the schema updates from updatedatabase.pl did not run or apply.  How can I force it ro run again from the DB version as of 20.05.00.000?  I would prefer not to have to restore the database to do this.
06:20 inlibro joined #koha
06:26 dpk Fixed it.  MariaDB [koha_catalogue]> UPDATE systempreferences SET value=20.0500000 WHERE variable="Version";
07:20 inlibro joined #koha
08:20 inlibro joined #koha
08:49 ashimema If they failed the first time they may well fail again
08:49 ashimema do you have the logs from the upgrade?
08:50 ashimema I'd run updatedatebase from the command line and redirect stdout and sterr to file
08:50 ashimema also.. have you restarted plack and memcached.. those two can occasionally cause problems that present like this
08:52 ashimema EFDSS, that's Cecil Sharp House isn't it.. when the current fun and games is over I should really get myself to a Ceilidh again
08:52 ashimema dpk ^
08:57 MarkHofstetter joined #koha
09:20 inlibro joined #koha
10:20 inlibro joined #koha
10:26 cait joined #koha
10:56 did joined #koha
11:20 inlibro joined #koha
11:22 cait dpk: still around?
11:22 cait one thing to check: in your marc frameworks, make sure that the tag/subfield for biblionumber (usually 999c) are set to visible in the opac
11:23 cait not sure about the missing field... but did you restart all the things after schema update?
12:17 MarkHofstetter joined #koha
12:21 inlibro joined #koha
13:00 khall joined #koha
13:21 inlibro joined #koha
14:19 paul_p joined #koha
14:20 MarkHofstetter joined #koha
14:21 inlibro joined #koha
15:21 inlibro joined #koha
16:08 Oak joined #koha
16:21 inlibro joined #koha
16:46 Bob joined #koha
16:46 Bob Bonjour
16:46 Bob Hello
16:46 wahanui hey, Bob
16:46 Bob Hi
16:47 Bob I need some help on koha
16:47 Bob is it the right place ?
17:05 dpk Yes, its fixed now.  I followed resetting the version in System Preferences by restarting the caching daemons and re-running updatedatabase.pl.
17:06 dpk This may not have been necessary, and possibly just restarting Memcache and Plack might have resolved this in retrospect.  This really should be part of the debian install process.
17:21 inlibro joined #koha
17:34 ashimema I believe the restarts are part of the Debian process.. but they don't always work as expected
17:35 ashimema We do our best ;)
17:41 Bob Hi, I installed koha, set adm pass and add a few books, but when I try to consult the calalog without login, the query rsult is empty... any suggestion ?
17:45 ashimema Are you using zebra or elastic?
17:46 ashimema Presuming elastic.. as that is what comes out of the box
17:46 ashimema You need to make sure both zebrasrv and the indexing Daemon are running
18:22 inlibro joined #koha
18:31 Bob How can I do that ?
18:36 MarkHofstetter1 joined #koha
18:36 tuxayo Bob: can you check if processes with indexer or rebuild_zebra in the name are running?
18:36 tuxayo (I think it's those)
18:38 tuxayo An installation via package should have the indexer daemon running by default.
18:38 tuxayo https://wiki.koha-community.or[…]ckagesIndexDaemon
18:38 Bob apparently is running, when I type  ps -def | grep zebra
18:40 Bob I restated with "sudo service koha-common restart" but nothing changed
18:53 Bob even from admin the catalog is empty when i do a search... mayby I didn't enter de books properly ? I used Z39.50....*
19:12 MarkHofstetter joined #koha
19:22 inlibro joined #koha
20:01 paul_p joined #koha
20:22 inlibro joined #koha
21:17 paul_p joined #koha
21:22 inlibro joined #koha
22:11 dpk Is there a way to limit OPAC access to only logged in users?
22:15 cait yes
22:15 cait look for the opac public system preference
22:22 inlibro joined #koha
22:31 dpk cait: so there are several - which one forces logins to be required.
22:33 cait i can't look it up right now
22:33 cait but read the text )
22:33 cait there shold only be one actually
22:35 cait you are looking in the GUI, right?
22:35 dpk So OpacPublic is set to Disable.  Going to koha.randomnotes.org (our test system) gives a login page (so far so good), but if you then click on "Home" in the upper left corner, you get a search page.  Enter some text, and *Poof*, you get results.
22:36 dpk Possibly a bug?
22:36 dpk Yes, this is the GUI.
22:36 rangi dpk: that takes you to a different site
22:37 rangi if i click home i end up at
22:37 rangi https://catalogue.efdss.org/
22:37 rangi so you might want to fix the opacbaseurl system preference too
22:37 rangi so it points to the right site :)
22:37 dpk Thank you - Yes, that looks like an error on our test site.
22:37 dpk We'll update that.
23:23 inlibro joined #koha

| Channels | #koha index | Today | | Search | Google Search | Plain-Text | plain, newest first | summary