IRC log for #koha, 2017-01-26

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

All times shown according to UTC.

Time Nick Message
00:09 martian523 back at the problem...really wanna fix this
00:09 Francesca joined #koha
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 ok in your koha-conf.xml
00:17 sudo less /etc/koha/koha-conf.xml
00:17 down to <config>
00:17 and look for <intranetdir>
00:17 what's that path?
00:18 and also
00:18 sudo locate opac-main.pl
00:18 (1st is the koha we think we are talking to, the 2nd is all of the places we *could* be looking)
00:21 though tbh, koha's had aq stuff for a long time before you started.
00:21 kholt joined #koha
00:21 martian523 <intranetdir>/usr/share/koha/i​ntranet/cgi-bin</intranetdir>
00:24 http://paste.koha-community.org/280
00:30 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 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 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 extracting from tar.gz file
00:48 wizzycray https://wiki.koha-community.or[…]rade_Instructions something like this?
00:48 cuz if you didn't do that sudo make upgrade
00:48 it's possible that your upgrade isn't complete
00:49 (the whole process there, actually.)
00:49 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 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 16.05.07
00:57 wizzycray I'm feeling like this must be bad data somehow.
00:57 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 what do you get if you d
01:13 apt-cache policy mysql-client
01:13 for "installed:
01:13 (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 cat /etc/issue
01:18 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 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 JoshB joined #koha
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 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 ok
01:23 i'll let them know
01:23 hopefully it can fix it
01:23 wizzycray but, take a full backup and off-machine it of your koha
01:23 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 even better idea, might be to build a new server
01:24 on jessie
01:24 and install koha with the packages
01:24 and import the database
01:24 then you'd have a right proper setup
01:24 and we could help a lot more easily
01:25 (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 gotta go
01:26 wizzycray good luck let us know how it turns out
01:26 martian523 will do
03:07 Francesca joined #koha
03:15 JoshB joined #koha
03:27 alexbuckley joined #koha
03:40 kholt joined #koha
03:57 Francesca joined #koha
04:18 Francesca joined #koha
04:36 irma joined #koha
04:39 alexbuckley joined #koha
05:42 Francesca joined #koha
06:05 drojf joined #koha
06:05 drojf morning #koha
06:15 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:18 alexbuckley joined #koha
06:34 Francesca joined #koha
06:36 Francesca joined #koha
06:56 * magnuse waves
06:56 drojf hei magnuse
06:57 magnuse moin drojf
06:57 hm, i had an import problem, lemme check
06:58 drojf i think it is different
06:58 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[…]_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 i tried to apply different rules and now nothing is happening
06:59 unless that really takes ages
07:01 it might be related to the progress bar not working most of the time
07:02 aaaaha. getting there
07:03 i hope
07:03
07:04 LibraryClaire joined #koha
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 hi LibraryClaire
07:06 LibraryClaire moin drojf
07:13 Joubu o/
07:14 * Joubu wonders if this aqorders table existed or not
07:15 cait joined #koha
07:15 LibraryClaire hi Joubu
07:19 Joubu drojf: nothing in the logs I guess?
07:19 did you try different files?
07:21 josef_moravec joined #koha
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 progress bar does 0 and 100% ^^
07:22 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Ã&#376;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:33 laurence joined #koha
07:33 alex_a joined #koha
07:34 alex_a bonjour
07:34 wahanui hey, alex_a
07:34 LibraryClaire salut alex_a
07:34 alex_a salut LibraryClaire
07:35 paul_p__ joined #koha
07:38 paul_p joined #koha
07:38 fridolin joined #koha
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:55 AndrewIsh joined #koha
07:56 marcelr joined #koha
07:56 marcelr hi #koha
07:57 LibraryClaire hey marcelr
07:57 Francesca joined #koha
07:57 marcelr hi LibraryClaire
08:03 alexbuckley joined #koha
08:03 sameeenz joined #koha
08:08 Francesca joined #koha
08:15 cait joined #koha
08:25 reiveune joined #koha
08:26 LibraryClaire laters #koha
08:26 LibraryClaire left #koha
08:28 gaetan_B joined #koha
08:28 gaetan_B hello
08:28 wahanui hola, gaetan_B
08:36 fridolin hie
08:44 reiveune joined #koha
09:08 irma joined #koha
09:29 laurence left #koha
09:52 Francesca joined #koha
10:40 LibraryClaire joined #koha
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 @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Ã&#376;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 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[…]_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 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 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 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 (was our preferred method)
11:02 drojf joined #koha
11:15 Joubu ashimema: Hi! I have a DBIC question
11:16 I think I already asked you
11:17 when I store a new row and I want to access an "DEFAULT CURRENT_TIMESTAMP" field, what should I do?
11:17 I thought discard_changes did that, but apparently not
11:17 I'd like to avoid a new fetch
11:19 khall or kidclamp maybe? ^
11:19 khall Joubu: you can't avoid a fetch since the db is generating the timestamp
11:20 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 Joubu: discard_changes worked for me
11:24 rsantellan joined #koha
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 Joubu: like $patron->updated_on( dt_from_string() );
11:25 right after your store it
11:25 that would avoid the db fetch
11:25 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[…]_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 ha yes, there is no PK on deleted_borrowers!
11:28 erk
11:32 I do not understand why actually, there should not have a way to delete 2 borrowers row with same borrowernumber
11:32 drojf joined #koha
11:35 drojf joined #koha
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[…]w_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:45 cait joined #koha
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 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 we only have one library with ldap so far
11:57 ashimema indeed.. that's the hardest part of the problem
12:43 oleonard joined #koha
12:45 meliss joined #koha
12:48 oleonard Hi #koha
13:05 alex_a joined #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 in that case we will do that on another bug report
13:29 we may find issues for DB using old data
13:30 khall Joubu: yeah, that would definitely be a good idea
13:30 drojf joined #koha
13:36 Dyrcona joined #koha
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:42 kmlussier joined #koha
13:45 khall Joubu: good thought
13:46 nengard joined #koha
13:47 drojf joined #koha
13:48 rsantellan joined #koha
13:56 edveal joined #koha
13:58 edveal morning kidclamp!
13:58 kidclamp morning edveal
13:58 how's houston?
13:59 edveal Great!
14:01 @ later tell talljoy Please ping me when you can. I have a windows question for you. :)
14:01 huginn edveal: The operation succeeded.
14:06 kellym joined #koha
14:09 NateC joined #koha
14:12 edveal Morning NateC
14:14 NateC morning edveal !
14:29 kidclamp joined #koha
14:38 kholt joined #koha
14:46 JoshB joined #koha
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:02 edveal left #koha
15:06 jac joined #koha
15:17 kholt left #koha
15:21 talljoy joined #koha
15:25 oleonard Hi talljoy
15:27 fridolin left #koha
15:33 CrispyBran joined #koha
15:42 LibraryClaire left #koha
15:55 edveal joined #koha
15:57 TGoat joined #koha
16:12 jbeno joined #koha
16:17 khall joined #koha
16:45 cait left #koha
16:45 reiveune bye
16:45 reiveune left #koha
17:15 pastebot "crispybran" at 10.100.30.72 pasted "Vagrant Issue CB" (38 lines) at http://paste.koha-community.org/283
17:25 CrispyBran joined #koha
17:37 cait joined #koha
19:03 oleonard Does kohadevbox expect the user to have SSH keys set up?
19:03 alexbuckley joined #koha
19:03 cait hm?
19:03 alexbuckley__ joined #koha
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 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 kathryn joined #koha
19:06 kidclamp it would be in your bios likely
19:06 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 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 then it could be something else, try extending the timeout or ask tcohen if/when he is around
19:08 likely not today
19:10 CrispyBran I don't see 64 bit options in the manager.
19:13 nuentoter joined #koha
19:13 kidclamp https://forums.virtualbox.org/[…]c.php?f=1&t=62339
19:13 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 kidclamp yeah, when you hit a snag it is rough, but once you have it going it is delightful
19:30 even when it blows up the worst you have to do is destroy and rebuild
19:39 CrispyBran joined #koha
19:39 CrispyBran oleonard, I think kidclamp deserves a raise
19:41 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:43 misilot joined #koha
19:46 CrispyBran So it stopped with an anisble error.  So I am running vagrant up --provision
19:47 seems to be continuing
19:51 misilot joined #koha
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 Bye all. I think I'll actually submit a patch tomorrow maybe.
19:59 * oleonard crosses fingers
20:18 rocio joined #koha
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
20:19 edveal joined #koha
20:24 edveal left #koha
20:43 nuentoter left #koha
20:46 cait joined #koha
21:04 JoshB joined #koha
21:06 Francesca joined #koha
21:55 CrispyBran joined #koha
22:11 * dcook waves
22:12 dcook Hmm... can't find my name in the scrollback but the channel was green..
22:13 JesseM joined #koha
22:13 edveal joined #koha
22:14 edveal left #koha
22:14 magnuse joined #koha
22:27 irma joined #koha
23:32 papa joined #koha
23:49 NateC joined #koha

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

koha1