Time Nick Message 00:01 dcook Trying to recall how to develop with DBIC when you're adding DB tables... :S 00:04 dcook Also trying to recall if we can import MARCXML into Koha... 00:04 dcook I guess that's an easy one to test 00:29 wajasu wanting to run the installer on the command line to get my db schema setup for t tests. i can't recall what script i can run. 00:31 wizzyrea koha-upgrade-schema <site> 00:31 wizzyrea (for a package) 00:32 * wajasu trying 00:48 wajasu found it. installer/debian/data/mysql/kohastructure.sql ;) 00:56 mtj hmm, i'm not sure that would work so well 00:57 mtj ...you'll be missing some stuff from your db still 00:57 dcook ^ 00:58 mtj tho, having said that... i cant offer a better solution 00:59 mtj ... other than prep a clean db, and dump it - for testing 00:59 mtj (its what i do) 01:01 mtj its a bummer there is (afaik) no command-line equiv. of the web-installer 01:02 * dcook loves underdocumented CPAN modules 01:02 dcook mtj: I think that koha-upgrade-schema script works for Debian? 01:02 dcook Maybe not... maybe that's just for updates... 01:02 * dcook just uses a clean db and dumps too usually 01:03 mtj would be very handy to automate the initial web-install steps, from a script 01:03 dcook totes 01:04 mtj you could pass koha-create some args, or a config-file to make all the correct selections 01:04 dcook Probably :) 01:05 mtj koha-upgrade-schema assumes a pre-installed db, afaik 01:05 dcook Probably :) 01:06 dcook I don't use Debian at work, so I don't know much about the Debian scripts 01:07 mtj i'm talking about a script to do the inital db configuration steps (that the web-installer currently handles) 01:08 mtj ok, no probs 01:09 dcook tcohen, gmcharlt: I don't suppose either of you are around atm? 01:09 dcook Or rangi maybe? 01:10 dcook Hmm, maybe I'll just find a sample patch for DBIC.. 01:12 dcook http://koha.1045719.n5.nabble.com/QA-Patches-with-database-changes-DBix-Class-td5779577.html 01:12 dcook :) 01:13 wizzyrea note I haven't tried it, can't you koha-create --populate-db <site> 01:13 wizzyrea well I mean I know you can 01:13 wizzyrea but I"m not sure what exactly it does. 01:13 wizzyrea it *seems* like it would do mostly what you're thinking of. 01:21 wajasu hooray! i built a koha package with passing tests. using docker! now i can build packages more easily, and test installs into fresh distributions more quickly. 01:24 wajasu gonna have to tweak and document this. will have to see if i can build ubunto too. 01:25 * wajasu time for dinner 01:26 dcook Dinger, I wanted to do the Docker workshop at OSDC... 01:26 dcook :/ 01:28 wajasu once i tweak it, the pkg maintainer can take it and decide to run with it. i learned too much about package building. did not use pbuilder, but just dpkg-buildpackage. 01:29 wajasu so i don't need a fakeroot, since i am in a docker root with a minimum debian squeeze. 01:29 dcook I occasionally think about learning more about building RPMS, but seeing as there are at least two different types of RPMs, I decided on a big nope 01:33 wajasu i am runnign a laptop with wheezy amd64 and wheezy-backport linux kernel to get docker running. 01:33 wajasu this might be a quicker sandbox, since its using lxc. 01:35 mtj wizzyrea: populate-db does loads a default koha.sql file, but takes no options 01:36 mtj but, yeah - its a good start, afaik 01:36 wizzyrea hey, a thing to extend :) 01:37 mtj i guess its a oldish db - but can be updated with the koha-upgrade-schema script, after loading 01:40 mtj yep, a thing to extend :) 01:42 mtj hmm, but i dont think a default koha.sql exists in the repo - you might need to add one yourself 01:45 wizzyrea I would hesitate on that, I'm not super clear (it's one of those things I should look into, honestly) on the details of how the database is built up these days, but it isn't as straight forward as it used to be as far as I can tell. 01:46 * dcook is also curious about how the DB works these days 01:49 wajasu i looked at the koha-upgrade-schema and it ran updatedatabase.sql and it only had 57 tables. so i ran mysqladmin ... < installer/data/mysql/kohastructure.sql first. 01:51 mtj youll be missing some stuff wajasu 01:51 mtj sysprefs, frameworks, branches 01:53 mtj probably saner to just do a web-install, then dump/load your db, for testing 01:53 mtj that way, you know its correct 01:54 wizzyrea that's what most people do 01:54 mtj would be a bummer to waste time testing on a glitched db :/ 01:54 wajasu ok. 01:54 wizzyrea nice for people to routinely check the web installer though 01:55 wizzyrea i did, once, do an install of koha using lynx 01:55 wizzyrea it seemed to work ok 01:55 mtj yeah, ive done that ok too 01:56 wajasu maybe www mechanize ...? 01:56 mtj yeah, good call wajasu - (or selenium) 01:58 wajasu i'm going to plod through to test bug 12856 01:58 huginn 04Bug http://bugs.koha-community.org/bugzilla3/show_bug.cgi?id=12856 normal, P5 - low, ---, gmcharlt, Needs Signoff , koha-disable fails without disabling site 01:59 mtj this looks interesting too... -> http://phantomjs.org/ 01:59 mtj (a bit off-topic) 01:59 wizzyrea \o/ 02:33 * dcook wonders what the "z3950queue" is... 02:33 dcook Hmm, maybe that's a local thing 02:33 dcook And that's what I get for not using a clean DB 02:34 * wizzyrea doesn't have that one 02:34 dcook Hmm, definitely local then 02:34 dcook I remember we had a custom Z39.50 thingo 02:34 dcook Wondering about terminology for this OAI harvester... 02:35 dcook "oai_harvest", "import_oai", "oai_queue", "OAIqueue" 02:35 dcook I guess we don't use CAPS so the last one is out 02:36 dcook Mmm, "oai_harvest" it is 02:55 dcook Interesting...I can't install resolve some Perl dependencies when installing fresh... but it's not an issue when upgrading? :S 02:56 dcook Any FriBidi gurus around at the moment? 03:07 dcook Anyone else having issues installing Text::Bidi? 04:10 mtj seems to work ok on deb-stable, dcook 04:10 dcook I figured it probably would on Debian :) 04:10 mtj # apt-get install libtext-bidi-perl 04:10 dcook Oh, the perils of not using a Debian-based OS 04:13 mtj sorry to torment you, dcook 04:13 dcook No worries :p 04:13 dcook I figured there would be an uproar if it didn't work on Debian ;) 04:14 mtj hey, do peeps have a good suggestion for xml2csv.pl conversions, for koha 04:14 dcook O_o 04:14 dcook Why would you want to do xml2csv? 04:14 dcook Also, what's xml2csv.pl? :) 04:15 mtj im looking thru this at the mo.. -> https://gitorious.org/koha-toolbox/koha-migration-toolbox 04:16 mtj why?, i have a reliable workflow to convert csv to marc 04:16 mtj but no workflow to convert xml to marc 04:17 mtj so, if i can convert xml to csv - then i'm good 04:18 mtj xml2csv.pl is an imaginary name of a perl script... that converts xml to csv 04:25 jcamins mtj: use XSLT. 04:26 mtj i've been using some homemade perl scripts, using anydata - with some success... 04:26 jcamins Or, if the XML is actually equivalent to a CSV, use a regular expression. 04:26 mtj http://search.cpan.org/~sdowideit/AnyData-0.11/lib/AnyData.pm 04:26 mtj ..but, i was curious if anyone else had a better way 04:27 mtj xslt sounds a bit... labour intensive 04:28 mtj i think i would have to write the xslt myself 04:28 mtj jcamins: thanks for the reply 04:29 mtj do you know of any examples, using xslt, on the webs? 04:29 jcamins Well, yeah. If you want to take advantage of the structure of generic XML, there's no way around it. If you don't want to take advantage of the stucture, regular expressions would most likely be fine. 04:29 jcamins mods? 04:29 wahanui hmmm... mods is a zillion times more sane 04:29 jcamins mods? 04:29 wahanui mods is probably a zillion times more sane 04:30 jcamins Eh. Well, find the MODS2MARCXML stylesheet that LC has. 04:31 dcook XSLTs aren't that bad to write after you play around for a bit. 04:32 mtj fwiw, ive played with xslt a bunch - i hate it 04:32 * dcook shrugs 04:32 dcook You could use LibXML to read the data and then write it out to a MARC::Record object 04:32 dcook That would also be heaps easy 04:35 mtj hmm, ok - thanks for the suggestion guys 04:35 mtj i'll let you know how i get on 04:36 dcook :D 04:36 dcook I figured out my issue in the end as well 04:36 dcook Well, I lie 04:36 dcook Someone else figured it out for me :P 04:36 dcook Had the fribidi package installed but not fribidi-devel 04:37 dcook fribidi? 04:37 dcook Hmm, probably not relevant to anyone else really.. 04:39 dcook Yay! Now I can finally install Koha again... 04:50 dcook Oh my... I didn't realize "update_dbix_class_files.pl" would refresh the whole thing... 05:17 dcook Oh DBIC... 05:32 wajasu mtj: maybe xmlstarlet can help convert your xml to csv http://www.joyofdata.de/blog/transforming-xml-document-into-csv-using-xmlstarlet/ 05:37 wajasu mtj: http://stackoverflow.com/questions/13317053/how-should-i-go-about-converting-xml-into-csv 06:08 dcook DBIC grrr 06:14 dcook Interesting... I wonder how find_or_new works for DBIC... 06:17 dcook Identical content but there must be some difference... control characters or encoding or something... 06:17 dcook Neato burrito in any case 07:24 * magnuse waves 07:24 magnuse @later tell bag HI 07:24 huginn magnuse: The operation succeeded. 07:25 * cait waves at magnuse 07:25 * magnuse waves at cait 07:26 magnuse dcook: https://metacpan.org/pod/DBIx::Class::ResultSet#find_or_new ? 07:28 magnuse mtj: https://metacpan.org/pod/Catmandu::Importer::XML -> https://metacpan.org/pod/Catmandu::Exporter::MARC 07:35 reiveune hello 07:36 magnuse bonjour irma et reiveune 07:37 reiveune salut magnuse dcook and everybody 07:57 alex_a bonjour 07:57 Joubu hello 08:06 magnuse @wunder boo 08:07 huginn magnuse: The current temperature in Bodo, Norway is 2.0°C (8:50 AM CET on November 04, 2014). Conditions: Partly Cloudy. Humidity: 60%. Dew Point: -5.0°C. Windchill: -3.0°C. Pressure: 29.44 in 997 hPa (Rising). 08:28 gaetan_B hello 09:10 ashimema morning #koha 09:14 mtj thanks for the links magnuse ^ 09:15 bensinober morning ashimema, still excited by the discussion on APIs from yesterday, we will continue on koha-restful but on the idea of migrating to Koha::Service in due course 09:15 mtj hey Joubu, do you think we should start to use bugzilla for the qa-tool? 09:15 bensinober please dont hesitate if you need us to test code or help in any other way 09:15 bensinober we realize its 100% focus on qa and 3.18 now.. 09:16 Joubu mtj: Hi, why? :) I don't have a lot of request 09:16 mtj Joubu: i was thinking of making some :) 09:16 cait hi #koha 09:17 mtj perhaps the tool is critical enough now, that we should? 09:18 mtj i understand its a bit more work... :/ but perhaps its worth it? 09:20 ashimema What are you suggesting mtj... 09:20 ashimema integrating the qa tool into bz to autorun upon bug uploads or somthing like that? 09:20 mtj no 09:21 Joubu I think we can use github to do it 09:21 mtj we can use github, but im suggesting to use bz instead 09:22 mtj (just a suggestion) 09:23 ashimema care to explain then? 09:23 mtj ie; use bz's workflow to accept patches foe the qa-tool - rather than githubs issue-tracker 09:23 Joubu what kind of stuffs do you want to add? 09:23 ashimema rangi et al seems fairly set against moving too much workflow into github btw.. not being open soruce itself.. 09:24 mtj Joubu: basically, more verbosity 09:24 ashimema there are similar efforts out there though ;) 09:25 mtj better descriptions of the FAILS, line numbers... 09:25 mtj that kind of stuff.. 09:25 Joubu mtj: won't be easy to do 09:26 ashimema Is that not what Splinter Review is for? 09:26 ashimema that's what I use it for 09:26 mtj some stuff will be easy, Joubu... like line numbers 09:26 Joubu mtj: it's quite trivial to find the line numbers, just run perl -wc and perlcritic and they will give us the ln 09:26 Joubu mtj: not sure it's easy :) 09:27 Joubu but if you think it's easy, go 09:29 mtj i agree, its trival to find the line number of some errors 09:30 mtj so.. we should display that helpful info in the qa-tool's output 09:32 Joubu mtj: the problem is that we don't have the line numbers when we display le report 09:33 mtj hmm, really? but why not? 09:33 mtj perhaps i can fix that then 09:33 Joubu hum, not sure I can explain you easily. 09:34 mtj ok, no probs 09:34 Joubu but quickly: we launch perl -wc (for instance) on file.pl, before the patches applied 09:34 Joubu we kept the error message (warn XXX at line L1) 09:35 Joubu after the patches applied, perl -wc file.pl 09:35 Joubu we kept the error message (warn XXX at line L1 AND warn YYY at line L2) 09:35 Joubu we don't want to warn the XXX warning/error 09:35 Joubu it's not a new one 09:35 mtj *nod* 09:36 mtj so, we have a new YYY warn... 09:36 Joubu but if the L1 is not L1 (the patches added/removed lines before the warn) 09:36 Joubu we will warn it 09:37 Joubu so the script removes the line numbers from the messages 09:37 Joubu but maybe we can store them somewhere on the second pass 09:38 Joubu I don't remember the structure we used 09:38 mtj sure, store them in a file - for starters? 09:39 mtj but, yeah - it sounds do-able to compare the before/after errors 09:40 mtj we may get some false-positives, but thats worth it, for helpful line numbers 09:41 Joubu not sure :) 09:41 mtj anyhoo Joubu... no need for you to explain to me - ill take a look myself 09:41 mtj ...and see if i can make some improvements 09:42 mtj thanks for the explaination 09:44 mtj Joubu: i should take a look first - before i say how easy it will be! 09:45 mtj ashimema: btw whats 'Splinter Review',? i get no luck using google 09:46 mtj its something for bz? 09:46 magnuse mtj: there is a link to the right of every patch on bz 09:47 magnuse "Details | Diff | Splinter Review" 09:48 mtj aah, ok 09:49 mtj ..that looks a bit different than what we are talking about here 09:49 mtj basically, the ability for qa-tool to give line-numbers for its various errors 09:57 ashimema Sounds like you found it ;) 09:58 ashimema It's for reviewing patches inline on bz.. 09:58 ashimema so your takling about he qa tool spitting out line numbers.. 09:58 ashimema how does it relate to bz is my question.. 09:58 ashimema just wondering as it sounds like an interesting idea :) 10:01 magnuse i think mtj wants to add the line number feature, and is asking where he should be reporting that bug/enh? in bz or on github 10:08 mtj yep, thats it magnuse 10:10 mtj ashimema: fyi, i think getting the qa-tool to autorun on newly sumbitted patches is a great idea 10:11 mtj ... but that was not what i was talking about before, (thats all) 10:13 mtj people have mentioned that (at some stage) the qa-tool code might be merged into the koha repo itself 10:22 Joubu mtj: it is: http://git.koha-community.org/gitweb/?p=qa-test-tools.git;a=summary 10:25 mtj Joubu: i mean merged into the koha.git repo - rather than hosted on the kc.org git server 10:47 ashimema I see now... i was really getting wires corssed then.. 10:47 ashimema thanks for the clarifications. 10:48 cait I think i like it separate 10:49 cait becuse i am testing qa against various versions 10:49 cait and i alays want to use the most recent qa tool 10:49 cait well on the main repo, but not part of Koha is what i meant :) 11:23 magnuse bonjour khall 11:23 khall mornin! 11:24 cait morning khall! 11:24 khall morning cait! 11:25 cait khall: can I attack you with a bug fix wish? 11:26 khall sure! 11:26 cait bug 10382 11:26 huginn 04Bug http://bugs.koha-community.org/bugzilla3/show_bug.cgi?id=10382 critical, P5 - low, ---, kyle, Failed QA , collection not returning to null when removed from course reserves 11:27 khall ooh, that one is wicked difficult! I'll have to revisit it 11:28 cait i think it's quite an evil one tho 12:23 tcohen morning! 12:23 tcohen @wunder cordoba, argentina 12:23 huginn tcohen: The current temperature in Cordoba Aerodrome, Argentina is 14.0°C (9:00 AM ART on November 04, 2014). Conditions: Scattered Clouds. Humidity: 36%. Dew Point: 3.0°C. Pressure: 30.11 in 1020 hPa (Rising). 12:24 cait good morning tcohen :) 12:24 tcohen hi cait 12:27 cait hm hi tcohen... whenever you come back :) 12:28 cait Joubu: i think we wrote a comment almost at the same time - bug 12851 12:28 huginn 04Bug http://bugs.koha-community.org/bugzilla3/show_bug.cgi?id=12851 normal, P5 - low, ---, jonathan.druart, In Discussion , order tags are not removed on claiming serials/orders 12:31 Joubu cait: yep :) 12:50 fridolin hie all 12:54 oleonard Hi #koha 13:10 magnuse bug 13194 - easiest signoff evvah! 13:10 huginn 04Bug http://bugs.koha-community.org/bugzilla3/show_bug.cgi?id=13194 trivial, P5 - low, ---, magnus, Needs Signoff , Tiny typo in POD for SetMessagingPreferencesFromDefaults 15:33 ashimema is the wiki down? 15:33 ashimema hmm.. appears to just be me 15:33 ashimema odd 15:37 ashimema @later tell eythian Could you take a look at bug 7904 possibly.. I'd be interested to hear your view on how it may affect packages. 15:37 huginn ashimema: The operation succeeded. 15:38 ashimema bug 7904 15:38 huginn 04Bug http://bugs.koha-community.org/bugzilla3/show_bug.cgi?id=7904 enhancement, P5 - low, ---, colin.campbell, Needs Signoff , SIP modules handling of @INC is confused 16:17 bag @notes khall 16:17 huginn bag: Error: I have no notes for that nick. 16:17 ashimema is anyone lese getting dns error for the wiki.. 16:17 ashimema I can't for the life of me get to it at the moment. 16:18 bag khall: http://bugs.koha-community.org/bugzilla3/show_bug.cgi?id=12971 16:18 huginn 04Bug 12971: critical, P5 - low, ---, kyle, NEW , Printing member information lacks data 16:22 reiveune bye 16:31 bag @later tell gmcharlt http://bugs.koha-community.org/bugzilla3/show_bug.cgi?id=11944 Is waiting for some feedback from you 16:31 huginn bag: The operation succeeded. 16:31 huginn 04Bug 11944: major, P5 - low, ---, jonathan.druart, Passed QA , Cleanup Koha UTF-8 16:41 oleonard So it looks like "Always show checkouts immediately" option means "...until the next browser session" 16:41 oleonard Not the same definition of "always" that I work with 16:48 hbraum oleonard we’ve found it’s set that way until you clear the browser cache….so if the cache is cleared on the browser closing, yep, it has to be set again after the next login. 16:54 oleonard Based on the code I don't see how that can be true hbraum. The cookie is not set with an explicit expiration, so it is created as a session cookie. 16:56 hbraum oleonard i just know what we’ve experienced with our libraries vs my computer. i don’t have the cache set to clear on chrome or firefox on my computer, and that always show setting holds, even when I have to log back in to Koha. But on all of our library computers, where the cache IS cleared on browser close, the libraries have to recheck that always show button on the next session 16:56 hbraum i’m admittedly not entirely happy about the setting…but checkouts are MUCH faster, so trying to live with it right now. 17:02 barton can someone give wiki.koha-community.org a kick? 'tis hanging. 17:11 hbraum barton I just noticed that too. 17:14 bag hbraum: we have khall working on all those bugs :) we're going to bust our butts so that feature is nice and clean in 3.18 :) (backporting as much as we can too) 17:14 bag oleonard ^^^^ 17:14 oleonard Bug 13196 17:14 huginn 04Bug http://bugs.koha-community.org/bugzilla3/show_bug.cgi?id=13196 normal, P5 - low, ---, oleonard, ASSIGNED , "Always show checkouts immediately" cookie should persist across sessions 17:15 bag khall ^^^^ 17:15 hbraum bag I know :) I’ve been pulling along others as they’ve griped about it :) once I explain why that happened, and that it was part of the way to speed up checkout…people are much happier for now. 17:16 hbraum bag I can say that checkout IS much faster across the board…we may not even have to purge datatables any more! 17:16 bag ummm heh - yes you do ;) 17:17 hbraum well…our special purging…how’s that? 17:17 hbraum not having to purge accountlines anymore will make me VERY happy. 17:18 gaetan_B bye! 17:18 bag heh hbraum - of course we shall see :D 17:18 hbraum (because I have to maintain an offline backup…for 1 library) 17:18 bag that's a pain eh 17:20 larryb hello #koha 17:20 larryb gmcharlt, do you have access to the debian.koha-community.org server? 17:21 bag larryb: I think that's catalyst perhaps 17:21 larryb it appears to be down. 17:21 bag maybe eythian controls that 17:21 bag cait do you know? 17:21 wahanui cait is probably happy about some example opacs :) 17:21 bag cait++ 17:21 cait sorry, have to read back later 17:21 cait still fihgting with booking a bus ticket... 17:21 bag ah no luck larryb cait is busy 17:21 bag Joubu: do you know who hosts debian.k-c.org? 17:22 larryb according to the whois, the IP is registered to Equinox Software 17:22 bag ah there you go - larryb I think gmcharlt is on a plane to atantla 17:22 larryb damn 17:23 bag larryb: there are equinox peeps here 17:23 bag phasefx: this is jason right? 17:23 larryb hola equinox. does anyone here have access to the debian.k-c.org server? It may need a reboot. 17:24 larryb (sound of crickets chirping) 17:25 bag yeah larryb I'd hop into #evergreen on freenode 17:25 bag seeing if I can do that 17:25 larryb thanks 17:29 larryb bag, I'm txting with gmcharlt now. He's still on the ground 17:29 larryb bag, he says he can reboot it 17:30 cait great.... train strike and now the website for the bus is dead :( 17:31 oleonard cait: Ask gmcharlt to reboot it? 17:31 cait not sure that will work :( 17:31 cait and it's my dad's birthday this weekend... and he told me yesterday to get a bus ticket 17:32 barton cait -- wow, why did they route the trains through the server room? ;-) 17:32 bag ha oleonard that's funny 17:32 cait *grump* 17:39 cait no chance now for the ticket :( 17:40 oleonard svc/holds really spams the error logs... "Use of uninitialized value in string eq at svc/holds line 77" once for every hold 17:41 cait do we have all the bugs linked to the main one? 17:42 larryb woohoo, debian.k-c.org is back online 17:53 barton what day did salvation army come on line? 18:27 jcamins barton: they've been following the fold for 149 years. 18:27 barton heh. wrong window. 18:34 cait i got a bus ticket!! 18:36 bag cait: great news!!! 18:39 jcamins barton: then stray no more! 18:40 druthb cait++ 18:41 bag hola druthb 18:42 bag congrats on the birthcretifate change 18:42 bag freaking spelling 18:42 druthb thanks, bag! :D 18:44 barton yeah bag, a birth certificate is definitely somewhere that you want to get the freaking spelling *right* ;-) 18:47 druthb yep. They left two very important letters off of my birth certificate, and it has taken me 46 *years* to get it fixed. 18:47 barton goodness. 18:48 druthb yah. In the box marked "Sex", they left of the "fe" at the first of the word… 18:52 cait druthb++ :) 18:55 druthb :) 19:00 rangi khall: is there somewhere other than libki.org i can get the code :) is the sourceforge git repo up to date? 19:00 khall rangi: the current canonical source is https://bitbucket.org/libki-kms/ 19:01 rangi ta 19:01 khall np! 19:03 oleonard Hi rangi 19:04 rangi heya oleonard 19:04 wahanui oleonard is not really here. He said so. He did! 19:05 * druthb lols 19:05 druthb wahanui: botsnack cookie 19:05 wahanui :) 19:08 * oleonard is gaslighting wahanui 19:08 cait what? 19:10 oleonard A term which comes from the film "Gaslight" which means doing stuff to make someone think they're going crazy 19:10 druthb Oh, no need for that, oleonard. wahanui has always been about half-mad. And doesn't seem to mind. 19:10 cait he is probably happier that way :) 19:44 oleonard khall: Perhaps one solution to Bug 12971 would be to make it like slips: Have it use an html-formatted notice template? 19:44 huginn 04Bug http://bugs.koha-community.org/bugzilla3/show_bug.cgi?id=12971 critical, P5 - low, ---, kyle, NEW , Printing member information lacks data 20:08 bag heya ashimema do you all have any update on this http://bugs.koha-community.org/bugzilla3/show_bug.cgi?id=7736 20:08 huginn 04Bug 7736: new feature, P5 - low, ---, colin.campbell, ASSIGNED , Edifact QUOTE and ORDER functionality 20:11 cait bag: 21:00 here, he might have stopped working :) 20:11 bag yeah I will @later thanks cait 20:12 cait he shoudl have stopped working... 20:13 bag @later tell ashimema heya ashimema do you all have any update on this http://bugs.koha-community.org/bugzilla3/show_bug.cgi?id=7736 20:13 huginn bag: The operation succeeded. 20:13 huginn 04Bug 7736: new feature, P5 - low, ---, colin.campbell, ASSIGNED , Edifact QUOTE and ORDER functionality 21:51 tcohen hi 21:51 wahanui bonjour, tcohen 21:54 bag hola tcohen 21:54 cait hola 22:03 tcohen hola cait 22:41 wizzyrea on a pristine database, can you replicate 12838? Just realised that the bug may only be with upgraded ones 22:41 wizzyrea this ~3.12 era one doesn't seem to have the problem 22:41 dcook bug 12838 22:41 huginn 04Bug http://bugs.koha-community.org/bugzilla3/show_bug.cgi?id=12838 minor, P5 - low, ---, fridolyn.somers, Needs Signoff , Deleting a borrower orphans that borrower's lists 22:41 wizzyrea but another 3.12 does, but it was an upgrade one 22:42 dcook I should have a pristine database right here that I could quickly check.. 22:43 wizzyrea another possible difference, I was testing on mariadb instead of mysql but... 22:43 dcook Hmm, we're also using mariadb 22:44 dcook If it's orphaning them, I imagine either there's a missing cascade delete in the DB or there's a code difference? 22:44 * dcook hasn't actually looked at the bug report 22:44 dcook Crap...I don't have any records to test on.. 22:44 wizzyrea that's what I'm wondering, if the problem only manifests because older databases never got a cascade delete on upgrade, but new ones have it 22:45 dcook Well, I can check the db right now for that 22:45 dcook Yep, there's a cascade delete on borrowernumber for patrons_list 22:45 dcook for 3.17 22:45 * dcook checks an older version.. 22:46 dcook No idea what patron_lists_patrons is.. 22:46 dcook 3.14 looks ok 22:46 wizzyrea wonder when that was added. 22:46 dcook Ah, my bad 22:47 dcook patron lists isn't the right thing 22:47 wizzyrea virtualshelves 22:47 dcook borrower's lists would be virtualshelves 22:47 dcook 3.8 looks bad 22:47 dcook "set null" instead of cascade 22:47 wizzyrea YES that's exactly it then. new db's -> ok, upgraded ones -> bad 22:47 dcook Same on a 3.14 upgraded from 3.8 22:48 wizzyrea \o/ 22:48 dcook Hmm 22:48 dcook My 3.17 says "set null" as well 22:49 dcook So I don't think that's it? 22:49 dcook My 3.17 is pristine 22:50 wizzyrea no cascaded delete, please see HandleDelBorrower in VirtualShelves.pm 22:50 wizzyrea ) ENGINE=InnoD 22:50 wizzyrea in the schema 22:50 wizzyrea on the virtualshelves 22:50 wizzyrea that's 3.17 22:52 wizzyrea annoying problem. 22:52 * wizzyrea keeps testing 22:52 wizzyrea thanks for looking 22:55 dcook No worries :) 23:35 dcook I don't suppose a gmcharlt, rangi, or khall_away would be around? 23:35 dcook Or anyone familiar with DBIC? 23:35 dcook Just trying to iterate through a list of results returned from a search 23:35 rangi yep 23:35 dcook \o/ 23:36 dcook Or even if you can point me to some examples. The ones I found on the wiki weren't very helpful :/. 23:36 rangi my $row = $self->{rs}->next(); 23:36 rangi have a look at 23:36 rangi http://git.catalyst.net.nz/gw?p=koha.git;a=blob;f=Koha/Biblio/Iterator.pm;h=fc150f433c1b68de7cada6bf22e77ffd02ef911f;hb=3e1705213116472b44fb1f0d618875db2538d34d 23:36 dcook I was thinking about doing it that way 23:36 dcook But then I noticed the thing about list context returning a list of result objects? 23:37 dcook Also thought about using the hashrefinflator? 23:37 * dcook takes a look at the link 23:42 dcook That %options bit looks neat 23:42 dcook Is that where you include the "items" option? 23:43 dcook Thanks for that, rangi. That's helpful :) 23:44 rangi *nod* 23:44 rangi cool 23:44 rangi thats what we use to index stuff for elasticsearch 23:44 dcook Yeah, I recall eythian mentioning it a while ago :) 23:45 dcook How's the ES stuff coming along? 23:45 rangi hows osdc going? 23:45 rangi pretty good 23:45 rangi http://bugs.koha-community.org/bugzilla3/show_bug.cgi?id=12478#c13 23:45 huginn 04Bug 12478: enhancement, P5 - low, ---, robin, NEW , Elasticsearch support for Koha 23:46 dcook I ended up cancelling my OSDC trip so I could be at home with the wife 23:46 dcook Disappointed to miss some of the sessions, but oh well 23:46 rangi ahhh 23:46 dcook Disappointed not to meet eythian in the flesh as well, but there's always next time :) 23:47 rangi yep, there will be others 23:47 dcook :) 23:58 dcook Interesting... it looks like if you use list context, it does return a list of objects and you can just iterate through those using foreach 23:58 dcook I wonder which is faster..