IRC log for #koha, 2016-03-30

All times shown according to UTC.

Time S Nick Message
00:06 drab mmmh, got stuck on db upgrade. so got koha-cmmon, mysql and apache installed
00:06 drab I ported over the old crashed db into the new host and restored it, I can see koha_library in mysql
00:07 drab then I tried sudo koha-create --create-db library which fails, but it makes sense since the db exists already (the configuration doesn't tho since it's a new install, which I guess is the problem)
00:08 drab I tried koha-upgrade-schema library, but since there's no config I get an error unable to locate Koha configuration file koha-conf.xml at /usr/share/koha/lib/C4/ line 346
00:10 drab I guess I can move the db out, create the the instance again and then move it back
00:10 drab so that it gens the config
00:12 drab urm, there's a --use-db switch but that spits out "User library-koha already exists."
00:15 wizzyrea drab: i'd koha-remove the one you've created
00:15 wizzyrea then re-do it with the --use-db
00:16 drab wizzyrea: how do you mean? if I remove it does it not delete the mysql db?
00:17 wizzyrea yeah, you did it in a bit the wrong order :/ you'd koha-create, which would create the database
00:17 wizzyrea then import your stuff into it
00:17 wizzyrea and then upgrade the database
00:17 drab ok
00:17 wizzyrea if that makes sense?
00:17 drab fair enough
00:17 drab it does, thank you
00:17 wizzyrea if your db had a different name
00:17 wizzyrea (which there's not really a point)
00:18 wizzyrea then you could --use-db
00:18 wizzyrea (in reality there are lots of tricky ways around your problem)
00:21 drab ok,got through that but upgrader failed
00:22 drab DBD::mysql::st execute failed: Can't find file: './koha_library/systempreferences.frm' (errno: 13) <-- maybe bening as this didn't exist back then?
00:22 rangi nope that's always existed
00:23 rangi when you did your restore, did that file exist under /var/lib/mysql
00:24 rangi if not, your restore didn't work properly, id check the dump, there might be other tables missing too
00:25 drab nm, pebkac
00:25 drab messed up perms while restoring from the tar, upgrade is going, thanks
00:27 irma joined #koha
00:27 drab this is *pretty* sweet, painless db/schema upgrade is news to me, thanks all :)
00:31 drab got one error on issn
00:31 drab seems related to this: Upgrade to done (Bug 5377 - Biblioitems isbn and issn fields too small for multiple ISBN and ISSN)
00:31 huginn Bug[…]w_bug.cgi?id=5377 normal, P5 - low, ---, kyle, CLOSED FIXED, Database fields too small for multiple ISBN and ISSN
00:32 drab brb
00:42 wizzyrea fwiw as long as your koha is working and you can do what you need to do with it, that problem probably won't matter much.
01:07 rocio left #koha
01:30 drab fair enough, I'm cool with that
01:30 drab btw that was the only error, everything else completed successfully
02:05 wizzyrea \o/
02:18 mtompset_ joined #koha
02:33 Francesca joined #koha
03:05 Francesca joined #koha
03:19 rocio joined #koha
03:20 irma joined #koha
03:26 irma mtj hi there
03:26 irma Are you available?
03:35 Al_Sahem joined #koha
03:53 Oliver_Queen joined #koha
03:58 irma Hi Oliver_Queen
04:03 xarragon joined #koha
04:07 rocio left #koha
05:17 Francesca joined #koha
05:22 Francesca joined #koha
05:28 cait joined #koha
05:41 * magnuse waves
05:51 * cait waves back
06:01 laurence joined #koha
06:17 Joubu yop
06:19 cait morning Joubu!
06:19 cait bbiab
06:41 misilot_ joined #koha
06:45 sophie_m joined #koha
06:46 Joubu Does someone know if the AuthorisedValueImages pref is still used by some libraries?
06:51 reiveune joined #koha
06:55 alex_a joined #koha
06:56 alex_a bonjour
06:57 reiveune hello
06:59 magnuse Joubu: i have never heard of anyone using it, but who knows...
07:01 Joubu magnuse: it seems that it is not used by XSLT views (but lot of code is processed anyway...)
07:01 magnuse ah, sounds like something we might get rid of then, since non-xslt is deprecated
07:02 magnuse two of my customers have it set to 1, but i doubt they are using it
07:02 magnuse in hea there are 58 with AuthorisedValueImages = 1
07:03 Joubu yes, but it's the default value...
07:04 Joubu ha, StaffAuthorisedValueImages is set by default, but AuthorisedValueImages is not inserted for new installs (missing in sysprefs.sql)
07:05 Joubu whaou, good fun
07:06 cait joined #koha
07:08 * cait waves
07:09 alex_a_ joined #koha
07:09 magnuse yeah, lot of NULL values in hea
07:10 Francesca joined #koha
07:22 fridolin joined #koha
07:26 gaetan_B joined #koha
07:26 gaetan_B hello
07:27 fridolin hie all
07:27 fridolin I'm coming back to work in mai but i'm a little bit around today ;)
07:28 magnuse bonjour fridolin!
07:28 magnuse and congratulations on your family increase :-)
07:28 cait oooh a baby?
07:28 cait a Koha baby I missed?
07:29 fridolin magnuse: cait : thanks a lot
07:29 cait congratulations :)
07:30 fridolin in fact it is a child 3 years old from Madagascar
07:30 cait boy or girl?
07:32 fridolin girl
07:33 cait great news
07:33 fridolin everithing is fine with her, we are in heven :D
07:33 magnuse yay!
07:33 cait yay! :)
07:34 magnuse the pictures you posted on facebook looked rather fabulous
07:55 Francesca joined #koha
08:06 Francesca joined #koha
08:09 paul_p joined #koha
08:18 cait ah now i am missing out again without facebook :)
08:24 fridolin left #koha
08:25 fridolin joined #koha
08:25 fridolin see you soon , have a nice day
08:25 fridolin left #koha
08:25 cait @wunder Konstanz
08:25 huginn cait: The current temperature in Friedrichshafen, Germany is 12.0°C (10:20 AM CEST on March 30, 2016). Conditions: Clear. Humidity: 62%. Dew Point: 5.0°C. Pressure: 29.92 in 1013 hPa (Steady).
08:26 Francesca joined #koha
08:36 Francesca joined #koha
08:49 magnuse @wunder boo
08:49 huginn magnuse: The current temperature in Bodo, Norway is 6.0°C (10:20 AM CEST on March 30, 2016). Conditions: Scattered Clouds. Humidity: 57%. Dew Point: -2.0°C. Windchill: 1.0°C. Pressure: 29.36 in 994 hPa (Rising).
08:49 cdickinson_ joined #koha
09:03 Francesca joined #koha
09:09 cait bug 12446 is interesting, but has a long test plan
09:09 huginn Bug[…]_bug.cgi?id=12446 enhancement, P5 - low, ---, remi.mayrand-provencher, Needs Signoff , Enable an adult to have a guarantor
09:09 cait does more than the title says
09:20 cait mveron++
10:13 petter joined #koha
10:16 liw joined #koha
10:18 drab joined #koha
10:57 marcelr joined #koha
10:57 marcelr hi #koha
10:58 marcelr @later tell bag: what happened with CheckVersion in updatedatabase :)
10:58 huginn marcelr: The operation succeeded.
11:38 meliss joined #koha
12:23 drojf joined #koha
12:23 drojf hi #koha
12:24 marcelr hi drojf
12:32 Dyrcona joined #koha
12:34 francharb Morning #koha
12:42 marcelr hi francharb
12:42 NateC joined #koha
12:44 ericar joined #koha
12:50 bag morning all
12:50 cait morning bag
12:51 bag morning cait
12:54 nengard joined #koha
12:58 marcelr hi bag
12:58 bag hi marcelr
13:01 talljoy joined #koha
13:06 edveal joined #koha
13:09 magnuse bag: HI
13:09 bag hi there magnuse
13:10 tcohen joined #koha
13:11 tcohen bonjour
13:11 wahanui kia ora, tcohen
13:11 bag hola tcohen
13:11 bag tcohen is a homerun hitter :)
13:12 tcohen :-P
13:12 tcohen hola bag
13:16 JoshB joined #koha
13:17 mario joined #koha
13:18 alex_a_ joined #koha
13:27 cma joined #koha
13:28 tcohen bag: bug 14158 and bug 16160
13:28 huginn Bug[…]_bug.cgi?id=14158 normal, P5 - low, ---, jonathan.druart, Passed QA , t/db_dependent/www/search_utf8.t hangs if error is returned
13:28 huginn Bug[…]_bug.cgi?id=16160 major, P5 - low, ---, tomascohen, Passed QA , t/db_dependent/www/search_utf8.t fails due to layout change
13:28 tcohen they will help jenkins
13:32 bag :)
13:44 tcohen bag: thanks :-D
13:44 huginn New commit(s) kohagit: Bug 14158: www search tests - Cleanup at the end <[…]a20114b088b9bf555>
13:49 Joubu @later tell pianohacker could you have a look at 16166 and|or|vs 16140?
13:49 huginn Joubu: The operation succeeded.
13:49 Joubu ashimema: could you have a look at 16166 and|or|vs 16140?
13:53 amyk joined #koha
13:53 bag bug 16166
13:53 huginn Bug[…]_bug.cgi?id=16166 enhancement, P5 - low, ---, abl, Needs Signoff , Improve L1 cache performance
13:53 bag bug 16140
13:53 huginn Bug[…]_bug.cgi?id=16140 enhancement, P2, ---, jweaver, Needs Signoff , Only clear L1 cache when needed
13:54 huginn New commit(s) kohagit: Bug 16160: Fix t/../www/search_utf8.t for layout change <[…]1c5840cce7696d8e5>
14:15 kidclamp joined #koha
15:00 tcohen joined #koha
15:00 TGoat joined #koha
15:09 rocio joined #koha
15:13 pianohacker joined #koha
15:15 Joubu have a good evening/day #koha
15:16 kidclamp you too Joubu
15:18 Francesca joined #koha
15:32 rocio1 joined #koha
15:42 tcohen later Joubu !
15:51 tcohen cait: why aren't you the default assignee for QA contact?
16:18 laurence left #koha
16:30 reiveune bye
16:30 reiveune left #koha
16:40 kidclamp joined #koha
16:41 cait tcohen: oh please no :)
16:45 cait left #koha
16:55 mario joined #koha
17:00 gaetan_B bye
17:43 laurence joined #koha
17:43 laurence left #koha
17:43 cait joined #koha
18:07 cdickinson_ joined #koha
18:26 talljoy joined #koha
18:57 cdickinson_ joined #koha
19:03 ericar joined #koha
19:08 tcohen cait, you are the QA manager, you should be the default, and you should order us to QA stuff
19:08 cait if only it worked that way :)
19:08 tcohen have you tried?
19:08 cait I am trying to order people - but they all tell me they have no time! :)
19:09 cait for example, an opinion about performance on bug 11904 would be good
19:09 huginn Bug[…]_bug.cgi?id=11904 enhancement, P5 - low, ---, julian.maurice, Signed Off , Proposal for a uniform way to send messages to user interface
19:09 cait tcohen: ?
19:10 ibeardslee turn the Zen meditiation quote around .. You should QA for 20 minutes a day. Unless you're too busy, then you should QA for an hour.
19:14 cait sounds perfect :)
19:16 cait tcohen++
19:17 tcohen ?
19:18 cait fixing all the tests
19:20 tcohen ah, only some
19:25 bag some is greater than none  :)
19:26 tcohen later 3koha
19:26 tcohen #koha?
19:26 wahanui rumour has it #koha is all kinds of good drugs today
19:26 tcohen WTF?
19:28 rangi maybe we should have a section on the dashboard
19:28 rangi that has the names of people whose patches broke the build :) that might encourage them to fix it :)
19:42 * cait waves
19:42 cait hehe
19:47 talljoy joined #koha
20:36 wizzyrea so in regards to bug 13971 and 13216
20:36 huginn Bug[…]_bug.cgi?id=13971 minor, P5 - low, ---,, BLOCKED , Adjusted locations in koha-rebuild-zebra for gitified instance
20:37 wizzyrea if we were to change gitify to do "something" that would identify it as such to Koha (because I don't think that change would necessarily fit in Koha proper)
20:37 wizzyrea what kind of thing seems best?
20:37 rangi hmm?
20:37 wizzyrea We could make gitify write a file that indicates an instance is gitified somewhere in /etc/koha/sites/instance
20:37 rangi yeah thats what i'd do
20:37 wizzyrea we could add something to koha-conf
20:38 wizzyrea I had a patch that did something like that
20:38 wizzyrea it added an installation options type file
20:38 wizzyrea to Koha
20:38 rangi also you can tell
20:38 rangi from the apache conf
20:38 wizzyrea in apache yeah
20:38 rangi so you could just awk that file
20:38 rangi look for    Include /etc/koha/apache-shared-opac-git.conf
20:39 rangi without comment
20:39 wizzyrea *ponders*
20:39 rangi etc
20:39 wizzyrea ah yeah, I was creating an installation options file as part of bug 15088
20:39 huginn Bug[…]_bug.cgi?id=15088 enhancement, P5 - low, ---, gmcharlt, Needs Signoff , Notice when koha has been installed with --request-db instead of --create-db
20:40 wizzyrea in truth that might be a nice feature to have, an installation options file
20:40 wizzyrea or installation parameters
20:42 lkozloff joined #koha
20:43 lucio joined #koha
20:45 wizzyrea hm I feel like gitify should handle gitify's problems
20:45 lkozloff anyone around interested in a mysterious problem? Our Koha server recently started displaying "No Title" for all records in our public lists (but only our public lists, search and browse work like normal)
20:46 wizzyrea lkozloff: do you have a custom xslt?
20:46 lucio wizzyrea: \o
20:46 wizzyrea heya!
20:46 lucio %)
20:46 * cait waves
20:46 wizzyrea everybody, lucio. lucio, everybody
20:46 lkozloff no, no customizations
20:46 lucio Hi everybody
20:46 wahanui Hi, Doctor Nick!
20:46 cait hi lucio :)
20:47 wizzyrea oh we should introduce the bots
20:47 cait @wunder Konstanz
20:47 huginn cait: The current temperature in Friedrichshafen, Germany is 12.0°C (10:20 PM CEST on March 30, 2016). Conditions: Clear. Humidity: 67%. Dew Point: 6.0°C. Pressure: 29.89 in 1012 hPa (Steady).
20:47 wizzyrea wahanui knows things
20:47 wahanui wizzyrea: i'm not following you...
20:47 wizzyrea koha on debian?
20:47 wahanui[…]ki/Koha_on_Debian
20:47 cait packages?
20:47 wahanui well, packages is at
20:47 cait confetti?
20:47 wahanui somebody said confetti was[…]1qh8hleo1_400.gif
20:47 wizzyrea that's my favourite confetti
20:48 kathryn joined #koha
20:48 wizzyrea lkozloff: is there anything in your error log/
20:48 wizzyrea ?
20:50 lkozloff when I load the page, we do get an error: DBIx::Class::ResultSet::_construct_results(): Unable to properly collapse has_many results in iterator mode due to order criteria - performed an eager cursor slurp underneath. Consider using ->all() instead at /usr/share/koha/opac/cgi-bin/opac/ line 252
20:51 wizzyrea what version?
20:51 wahanui version is, like, always noted in a comment at the top of the view source in the OPAC
20:51 wizzyrea very helpful, wahanui.
20:51 wahanui wizzyrea: what?
20:53 lkozloff wizzyrea: version We also get a similarly worded error for the same script when viewing lists in the admin view.
20:53 wizzyrea same symptom?
20:54 lkozloff yes, in the staff view we don't get "No Title" though - it just doesn't display anything but the links for Holds | Edit record | Edit items
20:55 wizzyrea hm odd
20:55 wizzyrea oh
20:55 wizzyrea are you using a translation?
20:55 lkozloff no, no translations
20:56 wizzyrea hm I'm not seeing that problem on my test 3.22.05
20:57 wizzyrea I do get the error in the log though
20:57 wizzyrea so I don't think it's related
20:57 lkozloff i've got another installation that's not showing the problem
20:58 lkozloff so i'm really mystified
20:58 wizzyrea :)
20:58 wizzyrea if there was an xslt error, it would show up in your log
20:58 wizzyrea same for a missing dependency
20:58 wizzyrea so it's not that
20:59 wizzyrea you don't have a translation, so there's not a mismatch there
20:59 wizzyrea it could be a zebra problem
20:59 wizzyrea I think...
20:59 wizzyrea maybe as a very first step
20:59 wizzyrea try restarting zebra?
21:00 lkozloff that was my first thought. I tried rebuilding zebra, but not restarting it.
21:01 wizzyrea what's the history of this install? has it been upgraded many times from old-ish versions?
21:02 lkozloff it's a reasonably new server with a reasonably new install. I think when we turned it up koha was on 3.14ish
21:02 wizzyrea yeah I'd classify that as old-ish
21:02 wizzyrea (ish)
21:03 JoshB left #koha
21:03 lkozloff haha, our first Koha installation was 6 years ago - so it feels pretty new to me!
21:03 wizzyrea :)
21:05 rangi did we remove  AllowOnShelfHolds pref?
21:06 wizzyrea yes, it's in the circ matrix now
21:06 rangi ta
21:06 wizzyrea \o/
21:06 lkozloff now that i'm comparing the two installations, I see that it's not just the title information that missing.. it's basically everything that would normally display... except for the cover images. The links that are labled "No Ttile" do in fact work and take you to the correct place (where you can see the title..)
21:08 mtompset joined #koha
21:08 mtompset Greetings, #koha.
21:11 wizzyrea hm. If you create a new list
21:11 wizzyrea new public list
21:11 wizzyrea does it display correctly?
21:11 wizzyrea (I wonder if maybe a db update got missed or didn't complete correctly)
21:14 lkozloff same problem with a new list =(
21:14 cait hm
21:14 wizzyrea that's quite odd.
21:14 cait the result list draws from the index
21:15 cait the detail pages from the db i think
21:15 wizzyrea that's what I thought.
21:15 cait that would mean that's something wrong with the index
21:15 wizzyrea I wondered if maybe it was a grs1 vs dom
21:15 wizzyrea thing
21:15 cait does a title search work?
21:15 cait i am wondering unimarc/marc21
21:15 wizzyrea oh, also true
21:15 cait not a keyword, but specifically searching for the title
21:15 cait hm
21:16 wizzyrea though usually grs1 vs dom = no results
21:16 cait oh - check the about page, system information tab?
21:16 lkozloff title search works
21:16 cait ok
21:17 lkozloff sorry, in regards to the information on the about page? I wasn't clear what you were looking for there
21:20 wizzyrea in the staff interface, if you click the about button
21:20 wizzyrea from the home page
21:20 wizzyrea there's a tab on there, system information
21:20 wizzyrea sometimes it says helpful things
21:21 lkozloff "The <use_zebra_facets> entry is missing in your configuration file. Falling back to legacy facet calculation." seems interesting
21:22 cait hmm but shouldn't cause that problem
21:23 cait i think
21:23 lkozloff "You are missing the <log4perl_conf> entry in your koha-conf.xml file. Please add it, pointing to the log4perl.conf file for your Koha instance."?
21:23 lkozloff seems unrelated
21:23 lkozloff but that's all that's in there
21:31 wizzyrea hm no I've never seen that cause that problem.
21:33 wizzyrea is the catalogue public?
21:33 wizzyrea i.e. could we have a nosey?
21:33 lkozloff it's public, by all means take a look:
21:34 lkozloff whoops
21:34 lkozloff type
21:34 lkozloff *typo
21:34 wizzyrea (if you don't want the url in the log you can put [off] in front)
21:34 cait hm opac search seems ok?
21:34 cait oh
21:35 cait which language are you looking at?
21:35 lkozloff the problem only presents itself on the lists, as far as i can tell
21:35 cait hm interesting
21:35 wahanui well, interesting is sometimes good and sometimes bad
21:36 wizzyrea heh, here's another place we need to fix the amazon urls :P
21:36 lkozloff sorry? something I've done?
21:36 wizzyrea nope, something we haven't :)
21:38 wizzyrea Loading mixed (insecure) display content "[…]6.01.TZZZZZZZ.jpg" on a secure page[Learn More]
21:38 wizzyrea that's not your fault :)
21:38 wizzyrea that's our fault ^.^
21:39 cait hm lists view looksok on master
21:40 lkozloff ah, yes - I've had to deal with that in many of our internal projects
21:40 wizzyrea A+ for using ssl tho
21:40 wizzyrea or https
21:40 wizzyrea yeah, and they said that it was ok on another 3.22 install they had
21:41 cait we already checked the logs... didn't we
21:41 cait ?
21:41 wizzyrea DBIx::Class::ResultSet::_construct_results(): Unable to properly collapse has_many results in iterator mode due to order criteria - performed an eager cursor slurp underneath. Consider using ->all() instead at /home/liz/koha-src/koha/opac/ line 252, referer: http://opac.lizpc/cgi-bin/koha[…] only this
21:41 wizzyrea which happens on mine, even though the titles turn up ok
21:41 cait i wonder if it uses the biblio/biblioitems fields for buliding this
21:41 lkozloff the other install is 3.22, but the minor version is different.. it's
21:43 * wizzyrea is not sure
21:44 wizzyrea the new virtualshelves rewrite, I found it kinda baffling when I was looking at it earlier this week. That's just because I'm me though.
21:44 wizzyrea It's probably perfectly sensible.
21:45 cait i found the old code baffling... so still hopeful for th enew one :)
21:45 wizzyrea maybe it's just a baffling kin of thing
21:45 wizzyrea kind*
21:47 cait did you change the koha to marc mappings by chance?
21:47 cait it seems to draw from the database - looking at the template
21:47 lkozloff we haven't done any customizations to speak of
21:47 wizzyrea bug 16175 - lkozloff you helped us find a bug :)
21:47 huginn Bug[…]_bug.cgi?id=16175 enhancement, P5 - low, ---, gmcharlt, NEW , Amazon book covers should use https on public and private lists in the OPAC
21:48 lkozloff haha, yay! .. and one easy enough I might even be able to write the patch ;)
21:49 wizzyrea you totally should
21:49 wizzyrea version control using git?
21:49 wahanui version control using git is at[…]Control_Using_Git
21:49 wizzyrea ^
21:49 wizzyrea :)
21:50 bag :)
21:51 cbrannon joined #koha
21:51 lkozloff thanks for the link - I'll definitely look in to it!
21:51 cait if you look at your koha-2-marc-mappings for the title ...what is it mapped to?
21:52 lkozloff 245a
21:53 cait hmm
21:54 cait ok, no idea :(
21:55 Francesca joined #koha
21:55 wizzyrea the only thing I can think of
21:56 wizzyrea is that the conversion from the old lists code -> new lists code something went wrong
21:56 lkozloff well, at least it's a complicated enough problem my librarians won't be mad at me for taking awhile to figure it out ;)
21:58 cait i think the table structure didn't change, so not sure
21:58 cait it works on one installation with the same version you said?
21:58 cait super odd
21:59 wizzyrea not quite the same version
21:59 wizzyrea 3.22.2 vs 3.22.5
22:00 cait hm
22:00 wizzyrea .5 broken, .2 not
22:00 lkozloff let me upgrade the other version and see if it breaks ;)
22:00 wizzyrea O.O
22:00 cait hehe
22:00 wizzyrea pay close attention to the db update
22:01 cait well... there is a security fix... you can always claim that
22:01 wizzyrea ^
22:19 lkozloff joined #koha
22:19 kidclamp cait++
22:19 kidclamp cait++
22:20 lkozloff the upgraded installation works normally :|
22:25 cait hm so something in configuration
22:25 cait lkozloff: it's the same in staff? for the lists?
22:26 lkozloff on the broken installation? yes, it's the similar on staff and on the OPAC
22:26 lkozloff on staff it doesn't display "No Title" - it just doesn't display anything
22:28 cait what about the cart?
22:29 cait hm seems ok in the opac
22:30 cait time to sleep here
22:30 cait hope you can solve the riddle
22:30 cait night all
22:30 wahanui goodnight cait. You'll be back.
22:30 lkozloff thanks for the help! I appreciate your time!
22:30 cait left #koha
22:39 TGoat cbrannon you still here?
23:00 jamesb joined #koha
23:02 mario joined #koha
23:14 Francesca joined #koha
23:14 irma joined #koha

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