Time Nick Message 00:09 martian523 back at the problem...really wanna fix this 00:14 wizzycray right so. our database says we have a table. Our Koha says we don't. 00:14 martian523 right. that's just wrong 00:16 wizzycray so hm 00:17 wizzycray ok in your koha-conf.xml 00:17 wizzycray sudo less /etc/koha/koha-conf.xml 00:17 wizzycray down to <config> 00:17 wizzycray and look for <intranetdir> 00:17 wizzycray what's that path? 00:18 wizzycray and also 00:18 wizzycray sudo locate opac-main.pl 00:18 wizzycray (1st is the koha we think we are talking to, the 2nd is all of the places we *could* be looking) 00:21 wizzycray though tbh, koha's had aq stuff for a long time before you started. 00:21 martian523 <intranetdir>/usr/share/koha/intranet/cgi-bin</intranetdir> 00:24 martian523 http://paste.koha-community.org/280 00:30 martian523 wizzycray any idea? 00:34 wizzycray hehe sorry work work :) 00:34 martian523 it's ok 00:35 wizzycray hm nope all that looks ok - the one in koha-conf matches at least one of those entries from your locate, so that should be ok 00:35 wizzycray when you did your upgrade, how did you do it? 00:36 martian523 last week 00:36 wahanui rumour has it last week is just one big blur :) 00:37 wizzycray hm, not when, how? 00:37 wizzycray i.e. what command did you run or what process did you follow 00:37 martian523 the upgrade koha procedure from download.koha-community.org 00:38 martian523 extracting from tar.gz file 00:48 wizzycray https://wiki.koha-community.org/wiki/Koha_on_ubuntu_-_tarball#Upgrade_Instructions something like this? 00:48 wizzycray cuz if you didn't do that sudo make upgrade 00:48 wizzycray it's possible that your upgrade isn't complete 00:49 wizzycray (the whole process there, actually.) 00:49 wizzycray under upgrade. Not install. 00:50 martian523 something like that 00:52 wizzycray and when you logged in first time after that, you upgraded the database? 00:52 martian523 yes, we used the instructions as on the link 00:52 wizzycray it prompted you to 00:52 wizzycray and you did it, and there were no errors? 00:53 martian523 no error 00:54 wizzycray and your More -> About Koha lists 16.(whatever) as your installed version? 00:54 martian523 yes 00:54 martian523 16.05.07 00:57 wizzycray I'm feeling like this must be bad data somehow. 00:57 wizzycray can you add a new vendor? 00:59 martian523 no, cannot add new vendor. came back with error: Can't use an undefined value as an ARRAY reference at /usr/lib/perl5/DBI.pm line 2054. 01:12 wizzycray out of curiosity 01:12 wizzycray what do you get if you d 01:13 wizzycray apt-cache policy mysql-client 01:13 wizzycray for "installed: 01:13 wizzycray (we don't care about the version table) 01:13 martian523 so put apt-cache policy mysql-client? 01:14 wizzycray just on the command line yep 01:14 martian523 5.5.40-0+wheezy1 01:16 wizzycray oh, wheezy 01:17 martian523 it shouldn't be? 01:17 wizzycray do 01:17 wizzycray cat /etc/issue 01:18 wizzycray what does that say please? 01:18 martian523 Debian GNU/Linux 7 \n \l 01:18 * wizzycray checks something 01:20 wizzycray 16.05 might be ok on wheezy but wheezy was deprecated for sure for 16.11 01:21 wizzycray https://koha-community.org/koha-16-11-released-2/ see "deprecation notice" 01:21 martian523 but would that be a problem that caused it? 01:21 wizzycray and I'd guess it'd be dodgy on 16.05 01:21 wizzycray if you don't have the right versions of dependencies it might 01:22 martian523 i see 01:22 wizzycray it'd take more time than I have at the moment to dig into that I'm afraid 01:22 wizzycray but a thing you might consider, and you need to do anyway 01:22 martian523 ok. i'll let the IT know tmr. 01:23 wizzycray is to upgrade your server to Debian 8 01:23 martian523 is... 01:23 martian523 ok 01:23 martian523 i'll let them know 01:23 martian523 hopefully it can fix it 01:23 wizzycray but, take a full backup and off-machine it of your koha 01:23 wizzycray before you do that. 01:23 martian523 ok. thanks! 01:24 wizzycray drojf would know more about any potential problems with wheezy and 16.05, though since you didn't use the packages it's kinda all bets are off 01:24 wizzycray even better idea, might be to build a new server 01:24 wizzycray on jessie 01:24 wizzycray and install koha with the packages 01:24 wizzycray and import the database 01:24 wizzycray then you'd have a right proper setup 01:24 wizzycray and we could help a lot more easily 01:25 wizzycray (cool tools like "koha-mysql" and "koha-shell" and instances and well known locations of things and so on) 01:25 martian523 thanks! 01:26 martian523 gotta go 01:26 wizzycray good luck let us know how it turns out 01:26 martian523 will do 06:05 drojf morning #koha 06:15 drojf is it just me or is something broken with matching/importing biblios? i upload a mrc with biblios and one with items and match on 001 and i end up with seperate records instead of adding the items to the biblios. i have done the exact thing with the exact same system before without any problems 06:56 * magnuse waves 06:56 drojf hei magnuse 06:57 magnuse moin drojf 06:57 magnuse hm, i had an import problem, lemme check 06:58 drojf i think it is different 06:58 drojf it seems like the matching settings get lost between staging and managing staged records 06:58 magnuse bug 17608 06:58 huginn 04Bug http://bugs.koha-community.org/bugzilla3/show_bug.cgi?id=17608 normal, P5 - low, ---, gmcharlt, NEW , Fix behaviour of bulkmarcimport.pl -insert 06:58 magnuse ah, ok 06:59 drojf hmm something is broken there 06:59 drojf i tried to apply different rules and now nothing is happening 06:59 drojf unless that really takes ages 07:00 drojf [off] that has to happen now when everything was done. great 07:01 drojf it might be related to the progress bar not working most of the time 07:02 drojf aaaaha. getting there 07:03 drojf i hope 07:03 drojf … 07:04 LibraryClaire morning #koha 07:05 drojf the progress bar did not work. so i checked the manage staged records page if the staging was done. it said yes. so i imported. but it was not actually done staging. or it says staged before the matching is finished 07:05 drojf hi LibraryClaire 07:06 LibraryClaire moin drojf 07:13 Joubu o/ 07:14 * Joubu wonders if this aqorders table existed or not 07:15 LibraryClaire hi Joubu 07:19 Joubu drojf: nothing in the logs I guess? 07:19 Joubu did you try different files? 07:21 drojf Joubu: it works. it is just a misleading info in staged records management. it says staged before the matching is finished. when i ignore the broken progress bar while staging and wait forever, eventually it jumps to the finished-page and then everything works as expected. it's just an unfortunate case of slow server and minor errors in koha 07:22 drojf progress bar does 0 and 100% ^^ 07:22 drojf who needs the stuff in between 07:22 LibraryClaire precision is overrated 07:23 drojf indeed 07:23 LibraryClaire @wunder konstanz 07:23 huginn LibraryClaire: The current temperature in Mainaustraße, Konstanz, Germany is -3.0°C (8:19 AM CET on January 26, 2017). Conditions: Overcast. Humidity: 79%. Dew Point: -6.0°C. Windchill: -3.0°C. Pressure: 30.27 in 1025 hPa (Steady). 07:23 drojf @wunder berlin, germany 07:23 huginn drojf: The current temperature in Berlin, Berlin, Germany is -0.5°C (8:19 AM CET on January 26, 2017). Conditions: Mostly Cloudy. Humidity: 100%. Dew Point: -0.0°C. Windchill: 0.0°C. Pressure: 30.48 in 1032 hPa (Steady). 07:24 LibraryClaire brr 07:34 alex_a bonjour 07:34 wahanui hey, alex_a 07:34 LibraryClaire salut alex_a 07:34 alex_a salut LibraryClaire 07:39 magnuse @wunder enbo 07:39 huginn magnuse: The current temperature in Bodo, Norway is 5.0°C (8:20 AM CET on January 26, 2017). Conditions: Light Rain. Humidity: 93%. Dew Point: 4.0°C. Windchill: 2.0°C. Pressure: 29.68 in 1005 hPa (Steady). 07:46 Joubu jajm: do you think you will be able to continue QAing auth merge patches? 07:52 jajm Joubu, yeah probably 07:56 marcelr hi #koha 07:57 LibraryClaire hey marcelr 07:57 marcelr hi LibraryClaire 08:26 LibraryClaire laters #koha 08:28 gaetan_B hello 08:28 wahanui hola, gaetan_B 08:36 fridolin hie 10:41 LibraryClaire hi #koha 10:43 magnuse guten tag BüchereiKlara 10:43 LibraryClaire hei magnuse :) 10:44 eythian hi LibraryClaire, magnuse 10:44 eythian @wunder ams 10:44 huginn eythian: The current temperature in Amsterdam, Netherlands is -2.0°C (11:25 AM CET on January 26, 2017). Conditions: Partly Cloudy. Humidity: 80%. Dew Point: -5.0°C. Windchill: -7.0°C. Pressure: 30.27 in 1025 hPa (Steady). 10:45 magnuse hiya eythian 10:45 eythian it's warmed up a bit since I biked in. 10:45 magnuse @wunder enbo 10:45 huginn magnuse: The current temperature in Bodo, Norway is 8.0°C (11:20 AM CET on January 26, 2017). Conditions: Rain. Humidity: 100%. Dew Point: 8.0°C. Windchill: 4.0°C. Pressure: 29.71 in 1006 hPa (Steady). 10:45 LibraryClaire @wunder konstanz 10:45 huginn LibraryClaire: The current temperature in Mainaustraße, Konstanz, Germany is -1.8°C (11:40 AM CET on January 26, 2017). Conditions: Mostly Cloudy. Humidity: 77%. Dew Point: -5.0°C. Windchill: -2.0°C. Pressure: 30.24 in 1024 hPa (Steady). 10:45 magnuse @wunder marseille, france 10:45 huginn magnuse: The current temperature in Marseille, France is 9.0°C (11:30 AM CET on January 26, 2017). Conditions: Light Rain. Humidity: 76%. Dew Point: 5.0°C. Pressure: 30.12 in 1020 hPa (Steady). 10:45 magnuse oops 10:46 drojf @wunder berlin, germany 10:46 huginn drojf: The current temperature in Berlin, Berlin, Germany is 1.2°C (11:45 AM CET on January 26, 2017). Conditions: Mostly Cloudy. Humidity: 98%. Dew Point: 1.0°C. Windchill: 1.0°C. Pressure: 30.48 in 1032 hPa (Steady). 10:46 drojf ha. plus! 10:46 LibraryClaire chuffing cold 10:46 LibraryClaire is how i describe all current weather 10:46 * drojf throws away shirt 10:47 LibraryClaire I had to use two duvets last night 10:52 Joubu Could someone confirm that lost items must be skipped by the overdue_notice script? see bug 17952 10:52 huginn 04Bug http://bugs.koha-community.org/bugzilla3/show_bug.cgi?id=17952 normal, P5 - low, ---, kyle, Signed Off , Lost items not skipped by overdue_notices.pl 10:52 Joubu It sounds like it is the expected behavior but I'd like to get other inputs 10:52 drojf later #koha 10:52 * Joubu is sorry not to talk about weather 10:53 LibraryClaire join us Joubu 10:53 Joubu @wunder Toulon, France 10:53 huginn Joubu: The current temperature in Boulevard de Strasbourg, Toulon, France is 11.5°C (11:52 AM CET on January 26, 2017). Conditions: Mostly Cloudy. Humidity: 96%. Dew Point: 11.0°C. Pressure: 30.15 in 1021 hPa (Steady). 10:53 * LibraryClaire holds up flashcards of weather symbols 10:53 * Joubu wins 10:53 LibraryClaire damn... 10:53 Joubu We got huge thunderstorms yesterday night 10:54 LibraryClaire Thunderstorms would mean it was warm enough to rain. I'd be ok with that 10:54 Joubu @answer Does the lost items should be skipped by the overdue_notice script? 10:55 huginn Joubu: downloading the Perl source 10:55 Joubu yes or no? 10:55 kidclamp yes 10:55 kidclamp marking lost is a final action for an overdue I would say - once you do that you aren't sending reminders anymore Joubu 10:56 kidclamp we don't expect a lost item to return 10:57 * kidclamp thinks maybe you wanted an opinion of someone who isn't supervised by khall though 10:57 Joubu It often happens to my girlfriend to "loose" something and to find it back few hours later 10:57 LibraryClaire in terms of day to day work, I would say you wouldn't want to see lost items 10:58 kidclamp it also bascially kills the script in a large library if they are considered - years of lost items all being checked for overdue notices - the script was running for 14+ hours 10:59 Joubu But I thought an item was marked as returned when marked as lost 10:59 kidclamp longoverdue only returns if you tell it to - you have the option of leaving the item on the patron account 11:00 kidclamp some libraries who do not charge do that as a way to keep a restriction on the patrons record 11:00 LibraryClaire also stays on the account until patron has paid for or replaced it or in case they find it 11:01 LibraryClaire (was our preferred method) 11:15 Joubu ashimema: Hi! I have a DBIC question 11:16 Joubu I think I already asked you 11:17 Joubu when I store a new row and I want to access an "DEFAULT CURRENT_TIMESTAMP" field, what should I do? 11:17 Joubu I thought discard_changes did that, but apparently not 11:17 Joubu I'd like to avoid a new fetch 11:19 Joubu khall or kidclamp maybe? ^ 11:19 khall Joubu: you can't avoid a fetch since the db is generating the timestamp 11:20 khall Joubu: are you saying discard_changes was ineffective? 11:20 Joubu yes true, but I wanted to say "avoid to recreate an object" 11:20 khall hmm, that should have worked, let me look into that 11:24 khall Joubu: discard_changes worked for me 11:24 khall Joubu: another alterntive if you wanted to be "close enough" would be to just stuff the current time into the un-updated object 11:25 khall Joubu: like $patron->updated_on( dt_from_string() ); 11:25 khall right after your store it 11:25 khall that would avoid the db fetch 11:25 khall would be close but not absolutely accurate 11:27 rsantellan good morning #koha 11:27 Joubu khall: I have attached a try on bug 17782 to show what's wrong 11:27 huginn 04Bug http://bugs.koha-community.org/bugzilla3/show_bug.cgi?id=17782 major, P5 - low, ---, nick, Signed Off , Patron updated_on field should be set to current timestamp when borrower is deleted 11:27 khall Joubu: I'll take a look 11:28 Joubu If I uncomment the discard changes, I get DBIx::Class::ResultSource::_pri_cols_or_die(): Operation requires a primary key to be declared on 'Deletedborrower' via set_primary_key at t/db_dependent/Koha/Patrons.t line 329 11:28 Joubu ha yes, there is no PK on deleted_borrowers! 11:28 Joubu erk 11:32 Joubu I do not understand why actually, there should not have a way to delete 2 borrowers row with same borrowernumber 11:37 Joubu ashimema: it would be great to get your QA stamp on bug 6979, I am not confident with LDAP code 11:37 huginn 04Bug http://bugs.koha-community.org/bugzilla3/show_bug.cgi?id=6979 major, P1 - high, ---, alex.arnaud, Signed Off , LDAP authentication fails during password comparison 11:37 Joubu @later tell ashimema: it would be great to get your QA stamp on bug 6979, I am not confident with LDAP code 11:37 huginn Joubu: The operation succeeded. 11:43 * ashimema is reading the history of the bug 11:50 ashimema man I hate out LDAP code 11:50 * ashimema scurries off to read all/any tests for that module.. 11:51 ashimema I'm not confident that the patch won't break some configurations at this point.. but I'll keep digging for a little bit 11:54 * cait keeps fingers crossed 11:56 ashimema there are simply too many different ways to configure ldap in koha at the moment ;) 11:56 ashimema it's really hard to account for all codepaths 11:57 cait i am not against simplyfying it, but unsure what people are actually using and what makes sense 11:57 cait we only have one library with ldap so far 11:57 ashimema indeed.. that's the hardest part of the problem 12:48 oleonard Hi #koha 13:09 LibraryClaire hi oleonard 13:09 wahanui hi olé onard 13:28 khall Joubu: just posted a followup to 17782 that allows discard_changes to work for Deletedborrower, it's a one-liner 13:29 Joubu khall: Don't you think we should also add the constraint that at the DB level as well? 13:29 Joubu in that case we will do that on another bug report 13:29 Joubu we may find issues for DB using old data 13:30 khall Joubu: yeah, that would definitely be a good idea 13:40 Joubu khall: ok, I have to go right now. I will try to PQA this one and open a new one to add the PK 13:45 khall Joubu: good thought 13:58 edveal morning kidclamp! 13:58 kidclamp morning edveal 13:58 kidclamp how's houston? 13:59 edveal Great! 14:01 edveal @ later tell talljoy Please ping me when you can. I have a windows question for you. :) 14:01 huginn edveal: The operation succeeded. 14:12 edveal Morning NateC 14:14 NateC morning edveal ! 14:55 drojf @wunder berlin, germany 14:55 huginn drojf: The current temperature in Berlin, Berlin, Germany is 1.0°C (3:50 PM CET on January 26, 2017). Conditions: Mostly Cloudy. Humidity: 90%. Dew Point: -0.0°C. Windchill: 1.0°C. Pressure: 30.42 in 1030 hPa (Steady). 15:25 oleonard Hi talljoy 16:45 reiveune bye 17:15 pastebot "crispybran" at 10.100.30.72 pasted "Vagrant Issue CB" (38 lines) at http://paste.koha-community.org/283 19:03 oleonard Does kohadevbox expect the user to have SSH keys set up? 19:03 cait hm? 19:04 kidclamp doesn't vagrant set up all the keys oleonard? 19:04 oleonard CrispyBran is running into problems installing kohadevbox on Windows: http://paste.koha-community.org/283 19:04 oleonard I don't know what to suggest for this problem. I dont remember running into it myself. 19:04 kidclamp CrispyBran is 64 bti emulation enabled on your machine? 19:05 CrispyBran I have no idea 19:06 kidclamp it would be in your bios likely 19:06 kidclamp it doesn't seem like an ssh problem, but like the guest machine isn't booting 19:07 oleonard I don't remember ever having to mess with my bios to get Virtualbox running. 19:07 CrispyBran That's what it looks like to me. 19:07 CrispyBran I can start a virtualbox from scratch through the manager. 19:07 kidclamp I had to enable it on one of my machines in the past, a 64 bit machine? 19:08 kidclamp then it could be something else, try extending the timeout or ask tcohen if/when he is around 19:08 kidclamp likely not today 19:10 CrispyBran I don't see 64 bit options in the manager. 19:13 kidclamp https://forums.virtualbox.org/viewtopic.php?f=1&t=62339 19:13 kidclamp just a guess really CrispyBran could be something else blocking the box - i don't know if there are more verbose logs anywhere 19:14 CrispyBran I have something I need to check. I'll have to reboot. Be back shortly. 19:29 oleonard [off] I've been trying to convince CrispyBran that getting kohadevbox installed is worth the effort 19:29 oleonard [off] I hope I'm not wrong! 19:29 kidclamp yeah, when you hit a snag it is rough, but once you have it going it is delightful 19:30 kidclamp even when it blows up the worst you have to do is destroy and rebuild 19:39 CrispyBran oleonard, I think kidclamp deserves a raise 19:41 CrispyBran vagrant is doing a lot more than it ever did now. The bios virtualization settings were off. 19:41 oleonard Well whaddaya know. 19:42 nuentoter thats a nice easy fix, those are always a relief lol 19:46 CrispyBran So it stopped with an anisble error. So I am running vagrant up --provision 19:47 CrispyBran seems to be continuing 19:56 CrispyBran This process seems to take quite a while. 19:57 oleonard Yes, it has to clone the whole git repository which is very large 19:59 oleonard Bye all. I think I'll actually submit a patch tomorrow maybe. 19:59 * oleonard crosses fingers 20:19 nuentoter wondering if someone could help me out with some sql report stuff maybe, Right now I have a sql report that allows me to pull all the barcodes between <<From Acc>> AND <<To ACC>> and it works great, is there a way though to augment it so that I can type in a list of barcodes and it will pull that list, not all in between 22:11 * dcook waves 22:12 dcook Hmm... can't find my name in the scrollback but the channel was green..