IRC log for #koha, 2020-12-20

← Previous day | Today | Next day → | Search | Index

All times shown according to UTC.

Time 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 Logs do not look happy.  Can share if there is an expert around, but we are getting lots of lines like:
02:37 Unknown column 'me.exclude_from_local_holds_priority' in 'field list' at /usr/share/koha/lib/Koha/Objects.p
02:38 and
02:38 ==> plack-intranet-error.log <==
02:38 [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 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 do you have the logs from the upgrade?
08:50 I'd run updatedatebase from the command line and redirect stdout and sterr to file
08:50 also.. have you restarted plack and memcached.. those two can occasionally cause problems that present like this
08:52 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 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 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 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 Hello
16:46 wahanui hey, Bob
16:46 Bob Hi
16:47 I need some help on koha
16:47 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 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 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 Presuming elastic.. as that is what comes out of the box
17:46 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 (I think it's those)
18:38 An installation via package should have the indexer daemon running by default.
18:38 https://wiki.koha-community.or[…]ckagesIndexDaemon
18:38 Bob apparently is running, when I type  ps -def | grep zebra
18:40 I restated with "sudo service koha-common restart" but nothing changed
18:53 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 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 but read the text )
22:33 there shold only be one actually
22:35 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 Possibly a bug?
22:36 Yes, this is the GUI.
22:36 rangi dpk: that takes you to a different site
22:37 if i click home i end up at
22:37 https://catalogue.efdss.org/
22:37 so you might want to fix the opacbaseurl system preference too
22:37 so it points to the right site :)
22:37 dpk Thank you - Yes, that looks like an error on our test site.
22:37 We'll update that.
23:23 inlibro joined #koha

← Previous day | Today | Next day → | Search | Index

koha1