Time Nick Message 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? 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:26 dpk Fixed it. MariaDB [koha_catalogue]> UPDATE systempreferences SET value=20.0500000 WHERE variable="Version"; 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 ^ 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? 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: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:31 Bob How can I do that ? 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.org/wiki/PackagesIndexDaemon 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....* 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: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.