Time Nick Message 05:14 saa i am trying to upgrade koha from 16.11 to 17.11 and this is run on a test server now to check everything is fine but when i run koha-upgrade-koha library command it throws lot of errors here are last few lines 05:14 saa DBD::mysql::st execute failed: Table 'koha_library.systempreferences' doesn't exist [for Statement "SELECT `me`.`variable`, `me`.`value`, `me`.`options`, `me`.`explanation`, `me`.`type` FROM `systempreferences` `me` WHERE ( `me`.`variable` = ? )" with ParamValues: 0='version'] at /usr/share/perl5/DBIx/Class/Storage/DBI.pm line 1834. DBD::mysql::st execute failed: Table 'koha_library.systempreferences' doesn't exist [for Statement "SELECT `me`.`variable`, `me`. 05:14 saa can someone help to knw what is going wrong 05:52 marcelr hi #koha 06:02 calire hi marcelr 06:03 marcelr :) 06:04 saa i am trying to upgrade koha from 16.11 to 17.11 and this is run on a test server now to check everything is fine but when i run koha-upgrade-koha library command it throws lot of errors here are last few lines [03:43] <saa> DBD::mysql::st execute failed: Table 'koha_library.systempreferences' doesn't exist [for Statement "SELECT `me`.`variable`, `me`.`value`, `me`.`options`, `me`.`explanation`, `me`.`type` FROM `systempreferences` `me` WHERE ( `me`.`variable` 06:41 ashimema is 'library' the name of your koha instance? 06:41 ashimema `koha-upgrade-koha whatever` where whatever is the name of your koha instance 06:57 alex_a bonjour 07:02 marcelr hi alex_a 07:03 alex_a hello marcelr 07:22 magnuse \o/ 07:23 marcelr o/ 07:43 cait hi marcelr! 07:45 marcelr hi cait 08:09 ashimema morning #koha 08:09 ashimema morning cait 08:09 ashimema morning marcelr 08:49 saa_ DBD::mysql::st execute failed: Table 'koha_library.systempreferences' doesn't exist [for Statement "SELECT `me`.`variable`, `me`.`value`, `me`.`options`, `me`.`explanation`, `me`.`type` FROM `systempreferences` `me` WHERE ( `me`.`variable` = ? )" with ParamValues: 0='version'] at /usr/share/perl5/DBIx/Class/Storage/DBI.pm line 1834. Use of uninitialized value in numeric lt (<) at /usr/share/koha/intranet/cgi-bin/installer/data/mysql/updatedatabase.pl line 553 08:49 saa_ hw to sort out this error 08:59 * andreashm waves 09:01 ashimema saa_ 09:01 ashimema is 'library' the name of your koha instance? 09:01 ashimema `koha-upgrade-koha whatever` where whatever is the name of your koha instance 09:01 wahanui i already had it that way, ashimema. 09:01 ashimema think you missed that earlier 09:02 saa_ yes for migration i created 09:02 saa_ library as instance 09:02 ashimema so there's definitely a koha_library database in your mysql/mariadb server 09:02 saa_ yes 09:03 ashimema hmm.. pass then :( 09:12 eythian well, it's missing a table. First step is to see if any tables are there at all. if not, figure out why not. If so, why is that one missing? 09:29 paxed hm. bug 18639 added replacement price to eg. the receivedt table in acquisitions, but didn't seem to add an aoColumns def to the table 09:29 huginn` Bug http://bugs.koha-community.org/bugzilla3/show_bug.cgi?id=18639 enhancement, P5 - low, ---, nick, RESOLVED FIXED, Separate replacement cost and retail price fields in acquisitions 09:31 paxed who do i slap with a rotten trout? i just spent an hour looking for a bug in my own code. 09:32 ashimema cait and I :( 09:32 * paxed slaps ashimema with a rotten trout 09:32 ashimema or it may have got lost in a rebase somewhere between our signoff and qa cycle :( 09:33 ashimema sorry 09:33 ashimema hate it when that happens.. well found 09:33 paxed it's also very fun to debug when the only indication is " 09:33 paxed whoops 09:34 paxed ... when the only indication is an error in the (minimized) jquery lib 09:34 paxed coffee break ----> 09:34 ashimema oh, nasty 09:47 cait dos someone know if kyle is around these days? 09:48 cait it might haveoverlapped or so, sorry 09:49 ashimema I can reach kyle if you want cait.. he's generally just very busy 09:49 cait i had sent him an email to hispersonal address about using a photo 09:50 cait i might catch him in person - hope he is coming? 09:50 ashimema I've left him a poke on slack 09:50 cait thx :) 09:54 andreashm ashimema: maybe ask him to rebase bug 19469 while you are at it? =) 09:54 huginn` Bug http://bugs.koha-community.org/bugzilla3/show_bug.cgi?id=19469 enhancement, P5 - low, ---, kyle, Patch doesn't apply , Add ability to split view of holds view on record by pickup library and/or itemtype 09:55 * andreashm wonders if he should have asked if the presentations should be 4:3 och 16:9 before making 20+ slides? 09:56 * ashimema wonders if there are any plans to stream kohacon presentations? 09:57 andreashm same here, colleagues have asked 10:01 paxed ashimema: do you want me to add a comment to 18639? 10:02 ashimema probably create a new bug that depends on it saying what the issue is 10:02 ashimema then we can fix it (or you can post a fix and it'll get a fast SO and QA) 10:06 paxed ashimema: bug 21324 10:06 huginn` Bug http://bugs.koha-community.org/bugzilla3/show_bug.cgi?id=21324 minor, P5 - low, ---, koha-bugs, NEW , Missing aoColumns definition in acqui/parcel receivedt table 10:07 ashimema cheers 10:54 khall mornin all! 10:56 ashimema khall is here :) 10:57 ashimema hello 10:57 wahanui que tal, ashimema 11:20 magnuse bag around? he might know about the streaming 11:28 oleonard Hi #koha 11:29 ashimema do people really use distinct cover image providers for opac vs staff client? 11:31 * ashimema is looking at bug 18421 and wondering why we'd want distinct system preferences.. Syndetics, OpenLibrary, Google and Baker and Taylor covers stuff all just have the one pref that covers both staff and opac as far as I can see.. it's only Amazon that has them distinct. 11:31 huginn` Bug http://bugs.koha-community.org/bugzilla3/show_bug.cgi?id=18421 enhancement, P5 - low, ---, charles.farmer, Signed Off , Make Coce cover images available for staff search 11:32 oleonard ashimema: Are you sure all of those affect the staff client? 11:33 ashimema Hmm, perhaps not 11:36 ashimema still seems odd that you'd want to be able to choose your provider differently per interface to me 11:39 oleonard I think it's more about being able to turn them off in one place or the other? 11:39 ashimema paxed, care to signoff on kidclamp patch for bug 19469? 11:39 huginn` Bug http://bugs.koha-community.org/bugzilla3/show_bug.cgi?id=19469 enhancement, P5 - low, ---, kyle, Passed QA , Add ability to split view of holds view on record by pickup library and/or itemtype 11:39 oleonard Also, it's just more consistent to have separate controls. 11:39 ashimema fair enough 11:39 kidclamp brb 11:39 ashimema thanks oleonard 11:39 oleonard @quote get 123 11:39 huginn` oleonard: Quote #123: "rangi: #thingsihavelearnt if there is a mad scheme a library somewhere will be doing it ... except madder" (added by wizzyrea at 09:20 PM, March 30, 2011) 11:39 wahanui i already had it that way, huginn`. 11:49 kidclamp ashimema: did you mean bug 21234 11:49 huginn` Bug http://bugs.koha-community.org/bugzilla3/show_bug.cgi?id=21234 minor, P5 - low, ---, oleonard, RESOLVED FIXED, Remove our .clearfix class in favor of Bootstrap's 11:49 kidclamp ashimema: did you mean bug 21324 11:49 huginn` Bug http://bugs.koha-community.org/bugzilla3/show_bug.cgi?id=21324 minor, P5 - low, ---, nick, Needs Signoff , Missing aoColumns definition in acqui/parcel receivedt table 11:50 ashimema sorry.. yes I did 11:50 ashimema brain today.. too many tabs open 11:55 kidclamp bbiab 11:59 oleonard ashimema: I remember reaching out to LibraryThing people a long time ago and got the same non-response. 12:00 ashimema Interesting 12:01 ashimema I reached out to them on twitter a few months ago when they basically slated the koha opac.. I asked nicely what was wrong with it and go completely blanked then too 12:01 ashimema Oh well 12:02 ashimema I'm happy we can nuke that services throttle now anyways 😉 12:02 oleonard Oh yeah that's right, I think I've heard them bad-mouthing Koha too. 12:02 ashimema Done my due diligence and all that 12:28 * cait leaves - suitcase to pack :) 12:30 tuxayo caturday ? 12:31 tuxayo ho, AnnaBoten isn't funny here :( 12:42 oleonard tuxayo: ? 12:48 caroline_ hello everyone! 13:31 oleonard All packed, cait? 13:32 magnuse whaaat, an ils-di request for /cgi-bin/koha/ilsdi.pl?service=GetRecords&id=1+2 includes the borrowernumber and cardnumber of the borrower, if an item is on loan? 13:40 cait oleonard: hm about half packed 13:40 cait oleonard: when do you leave? 13:42 oleonard I have to leave my house tomorrow morning at 4:30AM to drive to the airport 13:43 oleonard Columbus -> Huston -> San Francisco -> Portland. :| 13:44 oleonard I think if my flight has that many stops I should be ending up in another country to make it worth my trouble. 13:44 caroline_ oleonard: you're going all around the US! was it that much cheaper? 13:48 oleonard caroline_: It must have seemed so at the time :) 13:49 cait oleonard: same actually :) just i feel my tomorrow ill be sooner probably? 14:55 fridolin hi tehre 14:55 * fridolin from Porland 14:56 oleonard How was your trip fridolin? 14:56 fridolin oleonard: super thanks 14:57 fridolin no problem at all 14:57 fridolin some jetlag in our head but we are cool ;) 14:57 fridolin hotel and city are very nice 14:57 oleonard Are you staying at the University Place Hotel? 14:57 fridolin yes, Paul and Matthias and me 14:58 fridolin we have been by foot in the center its cool 14:58 fridolin already found a bar with many craft beers ;) 14:59 oleonard By the time the rest of us get there you'll be the experts 15:12 bag nice!!! 15:12 bag ashimema: there is streaming 15:12 bag we’re using zoom 15:12 bag https://kohacon2018.bywatersolutions.com/schedule.html 15:13 bag @later tell ashimema https://kohacon2018.bywatersolutions.com/schedule.html you can find the links for streaming in there 15:13 huginn` bag: The operation succeeded. 15:16 ashimema awesome! 15:16 ashimema thanks bag 15:16 bag you bet 15:17 ashimema couldn't see any mention of streaming when I last looked 15:17 ashimema aha.. it's well hidden. ;) 15:18 * ashimema subscribes to the google calendar now 15:36 caroline_ @wunder Montreal, Canada 15:36 huginn` caroline_: Montreal, Quebec :: Clear :: 65F/18C | Friday: A good deal of sunshine. High 73F. Winds light and variable. Friday Night: A clear sky. Low 49F. Winds NNW at 5 to 10 mph. 15:37 oleonard @wunder Portland, OR 15:37 huginn` oleonard: Portland, OR :: Clear :: 57F/14C | Friday: A good deal of sunshine. High 81F. Winds WSW at 5 to 10 mph. Friday Night: Partly cloudy skies this evening will give way to occasional showers overnight. Low 57F. Winds SW at 5 to 10 mph. Chance of rain 40%. 16:04 huginn` News from kohagit: Bug 21235: DBRev 18.06.00.027 <http://git.koha-community.org/gitweb/?p=koha.git;a=commitdiff;h=c66a2894e1857b403a52d8392d46c343be7d0ed8> 16:04 huginn` News from kohagit: Bug 21235: (QA follow-up) Remove table services_throttle <http://git.koha-community.org/gitweb/?p=koha.git;a=commitdiff;h=96a095f4e1d14721ace2198fb369670ce848c9ef> 16:04 huginn` News from kohagit: Bug 19550: (QA follow-up) Add missing [% USE %] <http://git.koha-community.org/gitweb/?p=koha.git;a=commitdiff;h=a9e859942c8cf8c4de8e872fb3ed79b5f80fa19a> 16:04 huginn` News from kohagit: Bug 17530: DBRev 18.06.00.025 <http://git.koha-community.org/gitweb/?p=koha.git;a=commitdiff;h=80e8c857e31cf14bb760731715a2f854d7c72441> 16:04 huginn` News from kohagit: Bug 19817: DBRev 18.06.00.025 <http://git.koha-community.org/gitweb/?p=koha.git;a=commitdiff;h=4cd57521c43f4e8c5e37ec61e1112ff2b74453ad> 16:04 huginn` News from kohagit: Bug 17530: (QA follow-up) Fix caching error <http://git.koha-community.org/gitweb/?p=koha.git;a=commitdiff;h=dfadaa45aa8ce226d9ba111ebad6e44271e39e41> 16:04 huginn` News from kohagit: Bug 7534: (RM follow-up) Fix TT syntax <http://git.koha-community.org/gitweb/?p=koha.git;a=commitdiff;h=86bcc81122f20a096f46ac66de3d95ec21dcbd96> 16:04 huginn` News from kohagit: Bug 19550: (RM follow-up) Add filters <http://git.koha-community.org/gitweb/?p=koha.git;a=commitdiff;h=ec463e80aadbf30144d417e123e884726fff77f2> 16:04 huginn` News from kohagit: Bug 21319: Remove highlight and tooltip on Koha Team version <http://git.koha-community.org/gitweb/?p=koha.git;a=commitdiff;h=289e96848a2320e5c8c93f46327143a4b73c267f> 16:04 huginn` News from kohagit: Bug 13618: Do not use html filters with KohaSpan <http://git.koha-community.org/gitweb/?p=koha.git;a=commitdiff;h=9dbcbe587db1f50594f17f91ab6643acb7bcc3df> 16:04 huginn` News from kohagit: Bug 17530: (QA follow-up) Add pref ArticleRequestsLinkControl <http://git.koha-community.org/gitweb/?p=koha.git;a=commitdiff;h=d6424c1999d3563c5243185503dd5a9b5b928f8f> 16:04 huginn` News from kohagit: Bug 21235: Remove table services_throttle <http://git.koha-community.org/gitweb/?p=koha.git;a=commitdiff;h=6a2a80988dd121215284c4458438fdb0fe41b86c> 16:04 huginn` News from kohagit: Bug 17530: (QA follow-up) Move may_article_request to ItemType <http://git.koha-community.org/gitweb/?p=koha.git;a=commitdiff;h=e85d6e12ea4dccd8fa08ec600864c2f985dcf886> 16:04 huginn` News from kohagit: Bug 17530: (QA follow-up) Replace class_or_self variables <http://git.koha-community.org/gitweb/?p=koha.git;a=commitdiff;h=8d53a1508d3fb8c6336839995f61036809ffedd2> 16:04 huginn` News from kohagit: Bug 20776: Add Selenium::Remote::Driver to the dependency list <http://git.koha-community.org/gitweb/?p=koha.git;a=commitdiff;h=418c65d2e28eb6a2c9e3bb56505918434cf5f04c> 16:04 huginn` News from kohagit: Bug 17530: (QA follow-up) Replace our variable by cached value <http://git.koha-community.org/gitweb/?p=koha.git;a=commitdiff;h=70c6266081a566149c7b3b49c95958a31417d435> 16:04 huginn` News from kohagit: Bug 17530: Use can_article_request to control sidebar link <http://git.koha-community.org/gitweb/?p=koha.git;a=commitdiff;h=b6813142ddedebf96bb6dfa50d5544d42c30e5e1> 16:04 huginn` News from kohagit: Bug 17530: Use may_article_request method in opac-search <http://git.koha-community.org/gitweb/?p=koha.git;a=commitdiff;h=2b0e73b9e1b7f19a55510521a990fa00411157c5> 16:04 huginn` News from kohagit: Bug 17530: Add Koha::IssuingRules->guess_article_requestable_itemtypes <http://git.koha-community.org/gitweb/?p=koha.git;a=commitdiff;h=c1d2363063d1c3eb2d37e45c9a3074cea9c783b4> 16:04 huginn` News from kohagit: Bug 19550: Add links to related authorities for UNIMARC <http://git.koha-community.org/gitweb/?p=koha.git;a=commitdiff;h=d96e2e71b8ac77e09194d02e72d67ec5c03187ec> 16:29 jenkins Yippee, build fixed! 16:29 jenkins Project Koha_Master_D9 build #552: FIXED in 25 min: https://jenkins.koha-community.org/job/Koha_Master_D9/552/ 16:34 jenkins Yippee, build fixed! 16:34 jenkins Project Koha_Master_U18 build #40: FIXED in 29 min: https://jenkins.koha-community.org/job/Koha_Master_U18/40/ 16:43 jenkins Yippee, build fixed! 16:43 jenkins Project Koha_Master_D8 build #46: FIXED in 35 min: https://jenkins.koha-community.org/job/Koha_Master_D8/46/ 18:23 oleonard Oh dang FuzzyLogicHottie left before I could get their number. 19:08 caroline_ How can I open the records I download from the opac (.marcstd, .utf8, or .marcxml) in marcedit? 19:22 caroline_ I was able to open it by changing the extension. Don't know if that's what I'm supposed to do... 19:24 caroline_ I know I'm talking in the void right now (but maybe someone will read my question later!), why would anybody use MarcEdit with Koha? It seems most functionalities are already available in Koha like batch edit, etc. 20:21 tuxayo oleonard: In BibLibre's channel, AnnaBoten answers "CATURDAY! \o/" when one mentions caturday and the day is friday. 20:51 cait caroline_: changing the extension is what i'd do too 20:52 caroline_ thx cait! 20:52 Dyrcona It's Caturday somewhere. 21:54 caroline_ bye!