Time Nick Message
22:00 Space_Librarian hey rangi
22:00 rangi hiya Space_Librarian
22:00 Space_Librarian morning #koha
21:28 cait :)
21:28 cait magnus_away: ? )
21:27 rangi you could have some fun with foaf and authors
21:27 rangi :)
21:27 rangi foaf
21:26 magnus_afk use the rdf, luke!
21:21 cait rangi: whatever it was - seems to be gone
21:20 cait what are you talking about?
21:20 wahanui yes, cait?
21:20 cait wahanui?
21:20 wahanui well, not sure cait is leistungsfähig
21:20 rangi not sure cait
21:18 cait search also links in frameworks - those were related to nozebra, is that right?
21:18 huginn 04Bug http://bugs.koha-community.org/bugzilla3/show_bug.cgi?id=2778 normal, P3, ---, gmcharlt, NEW , Search Also missing from subfied framework edit
21:18 cait bug 2778
21:04 jcamins Good night, #koha.
21:04 jcamins Okay, time for me to call it a day, too.
21:03 mbalmer well, it already is slow ;)
21:02 mbalmer it will make Koha slow..
21:02 libsysguy later #koha
21:02 mbalmer ah, I see. I think LCD is a bad way. It does prevent us from using advanced features of a database.
21:02 libsysguy I hate to jet but I've gotta get on the road…I'll see you guys tomorrow
21:02 libsysguy if you really cared about database independence perhaps you should push for complete database abstraction
21:01 jcamins Lowest Common Denominator.
21:01 mib_tv8sa8 least commaon denominator
21:01 mbalmer jcamins, what does LCD in this context stand for?
21:01 huginn bag: The current temperature in K6LCM-Westside/Mesa, Santa Barbara, California is 21.4°C (2:00 PM PDT on April 02, 2012). Conditions: Clear. Humidity: 28%. Dew Point: 2.0°C. Pressure: 29.99 in 1016 hPa (Falling).
21:01 bag @wunder 93109
21:01 mib_tv8sa8 and given mysql's oracle takeover i'm not expecting mysql to grow at its previous pace
21:01 jcamins Sure, but why don't we just program to LCD?
21:00 mib_tv8sa8 true mbalmer
20:59 mbalmer if we create a proper abstraction for MySQL and PostgreSQL now, I am sure it will be easier to support other databases in the future, too.
20:59 libsysguy yeah I get database independence and best practices…but like rangi said…its the tone
20:57 rangi i guess thats what it all boils down to, tone
20:57 mbalmer not a crusade, but I see advantages of PostgresSQL over MySQL on various levels/issues. And these are coherent with what I see from users/customers. And keep in mind that I always said: Support both of them. I did not say "switch to PG". Users should choose.
20:56 jcamins Heh.
20:55 * libsysguy was just lurking
20:55 libsysguy it sounds like you are on some kind of crusade
20:55 mbalmer ???
20:55 libsysguy [off] mbalmer did mysql cheat on you or something?
20:54 mbalmer cu
20:54 sekjal cheers, #koha
20:54 sekjal I would very much like to stay and continue, but I've got to catch a bus.
20:54 mbalmer mveron had his disk filled up up by a rogie script (actually a bug of mine), then MySQL stop working, then the machines stopped working, he had to reboot, and then it tooks hours to rebuild the MySQL DB. MySQL just is not very robust when it comes to suche cases.
20:52 mib_tv8sa8 mysql could not stay running with this table
20:52 mbalmer and wiki/PostgreSQL
20:51 sekjal mbalmer: at a practical, let's-write-some-patches level, I think the two approaches are completely compatible at this time. once they're not, then we'll have to discuss in more depth
20:51 mib_tv8sa8 well i had a problem where a single table in a database cause mysql to crash 3 seconds after starting, the table indicated that it had about 100 records more than was actually there
20:51 mbalmer the buglets ;)
20:51 mbalmer and the sub bugs
20:51 huginn 04Bug http://bugs.koha-community.org/bugzilla3/show_bug.cgi?id=7365 enhancement, P5 - low, ---, marc, In Discussion , Koha uses MySQL
20:51 mbalmer look at bug 7365
20:51 gmcharlt more code less arguing?
20:51 gmcharlt working code wins?
20:51 gmcharlt and the fact that you're willing to work on it is great ... just, well
20:50 gmcharlt mbalmer: I don't think there is actually much disagreement that support for Pg (in the guise of DB-independence) would be a Nice Thing
20:50 mbalmer I don't care to much if you run on MySQL. The goal is to run on both.
20:49 cait sekjal++ for being a librarian :)
20:49 mbalmer I force nobody to run on PostgreSQL, but we decided to support PostgreSQL, so that is what I am doing. Giving users a choice.
20:49 sekjal mbalmer: I'm a librarian... I'll always be one of those folks holding up the "citation needed" sign
20:49 schuster walking away... It's actually better than what I had that was proprietary before this...
20:48 schuster mbalmer - running 4 years just fine here pretty big db if you ask me...
20:48 rangi LOL
20:48 mbalmer nothing I need to defend, it's just a fact.
20:48 mbalmer very easy to currupt a MySQL DB, very hard to corrupt a PostgreSQL DB.
20:47 mbalmer sure, sekjal.
20:47 jcamins mbalmer: but we could run on Postgres if we coded for the LCD.
20:47 sekjal mbalmer: that's a bold claim, and would require bold evidence to be taken as anything more than an opinion
20:47 rangi wow, exactly the blah i was meaning
20:46 mbalmer MySQL is not a stable DB.
20:46 sekjal where the measure of "worth" is patron satisfaction
20:46 mbalmer jcamins, running on a stable DB is already a gain.
20:46 sekjal mbalmer: I guess what I'm after is: what beyond the least common denominator is worth coding up special exemptions for?
20:45 jcamins mbalmer: and what does that get the patrons?
20:45 huginn cait: The operation succeeded.
20:45 cait @later tell oleonard can you take a look at 2733? I am not sure what to do about this - perhaps we could rename to print account? Is the print page maintained? Or perhaps should be removed?
20:44 mbalmer aka not the least common denominator.
20:44 mbalmer I am currently working towards a DB independent solutions that still lets us use features from a DB.
20:44 sekjal jcamins: for most functionality, I think it is
20:44 jcamins sekjal: I've always understood that an RDBMS is an RDBMS is an RDBMS.
20:44 rangi i like drizzle
20:43 mbalmer or s/mysql/PostgreSQL/ or even a better solution where both can be used.
20:43 * cait waves
20:43 cait heya jo
20:43 gmcharlt mbalmer: well, there's always s/mysql/mariadb/
20:43 rangi yes, i am aware of that
20:43 sekjal but if some feature of one database or another can make or break a feature for patron usage, then I'm all ears
20:42 mbalmer rangi, yes, there is an issue; MySQL has been bought by Oracle, and that fact alone makes a good lot of MySQL users very nervous.
20:42 jcamins Make the people arguing disappear.
20:42 rangi mbalmer: mark kirkwood
20:42 jcamins rangi: I always use C-x M-c M-butterfly when those conversations come up.
20:42 sekjal right, in the end, it'll be up to each sysadmin what platform they think is best for their stuff
20:41 mbalmer rangi, vi is better ;P
20:41 rangi i think what sekjal was asking is what can it do for patrons
20:41 * gmcharlt is occupying the fence, doncha know ;)
20:41 rangi emacs blah blah
20:41 gmcharlt well, mysql supports replication as well
20:41 rangi what i dont want to see is yet another blah blah postgres is better than mysql blah blah vim blah blah
20:41 mbalmer rangi, who is that?
20:41 rangi and we use it for most of our work like tab.co.nz and stuff.co.nz
20:40 mbalmer oh yes, MySQL can store illegal dates. Crazy… ;)
20:40 mbalmer sekjal, I think that asynchronous and synchronous replication are one feature that you want. Plus that your data is more safe when it comes to system crashes etc.
20:40 * rangi works with a postgres developer
20:39 gmcharlt (though mysql can be made stricter, too -- just isn't normally configured that way)
20:39 gmcharlt it has better type checking enabled by default
20:39 mbalmer Imo, DB independence has to solve one big problem: To not only use the least common features of all DBs, but to allow us to use advanced features where available. That is a ture problem.
20:38 gmcharlt although, of course, that wouldn't really be consistent with DBMS-independence
20:38 rangi ive seen it used well on a quite a few high traffic projects
20:38 gmcharlt Postgres is also a *lot* nicer to develop stored procedures for
20:38 sekjal rangi: that sounds pretty sweet
20:37 rangi you can share a lot of load around
20:37 rangi and since 98% of the work koha does is reads
20:37 rangi then you can read from slaves write to master
20:37 rangi a read and a write handle
20:36 jcamins Ooh, I like that idea!
20:35 rangi it also had 2 separate database handles, one for staff one for opac, bring that back would be good too
20:34 sekjal mbalmer: do you know of any Postgres-specific features that would provide a direct benefit to library patrons? It's been a long while since I used it
20:34 sekjal I think there is plenty of work as things stand now that moves equally towards both goals
20:22 gmcharlt mbalmer: let the bots have the indigestion, not the people ;)
20:22 mbalmer I learned that in Marseille.
20:22 mbalmer but yes, automated tests are good.
20:22 mbalmer heh, but folks need a person to blame ;)
20:21 sekjal I second gmcharlt's suggestion
20:21 sekjal ^^
20:21 gmcharlt that way, the "complaining" would be done via bot, not personally
20:21 gmcharlt mbalmer: there's another appraoch to try after 3.8 is released -- submitting a test case that looks for backticks in the appropriate source files and fails the test if it detects an SQL query that uses them
20:19 mbalmer and when there is no mysqlism to copy, there is no mysqlism to paste.
20:19 mbalmer but changing the backticks in one patch will already help greatly, since many people just copy and paste.
20:16 mbalmer jcamins, It makes people aware of the problem.
20:16 jcamins chris_n: huh?
20:16 chris_n tact?
20:16 jcamins mbalmer: that doesn't seem very productive.
20:15 mbalmer my grep pattern is easy: whenever I see a ^+ line that contains a MySQLism, I will complain on the mailing list.
20:15 jcamins Have a good evening.
20:15 * chris_n heads out for the day
20:15 chris_n ie. archive the existing repo and open an new one with mass changes completed
20:14 mbalmer the backticks I plan to remove in one monster-patch..
20:14 jcamins The logic will be a lot easier to trace backwards.
20:14 chris_n which makes fredericd 's "new" git thought all the more interesting
20:14 huginn 04Bug http://bugs.koha-community.org/bugzilla3/show_bug.cgi?id=7365 enhancement, P5 - low, ---, marc, In Discussion , Koha uses MySQL
20:14 mbalmer bug 7365 has some sub-bugs with patches to remove some mysqlism.
20:14 jcamins chris_n: it is, but if we're talking about changing backticks in one file, that's not so bad.
20:14 rangi Bbiab
20:14 rangi My bus stop
20:13 chris_n jcamins: and that is probably an issue for mass mysqlism changes as well
20:13 mbalmer maximep, in PostgresSQL, you have to quote column names that are e.g. keywords.
20:12 chris_n jcamins: right
20:12 jcamins sending_patches++
20:12 jcamins chris_n: yeah, but this seems rather less destructive to history than a mass Perl-tidy.
20:12 chris_n sending_patches++
20:12 gmcharlt sending_patches++
20:12 mbalmer but everyone who changes SQL code should do it proper now.
20:11 chris_n sorta like the perl-tidy issues
20:11 gmcharlt mbalmer: sure, that's a possible strategy, but not necessarily the most effective one to achieve your end (the complaining about it)
20:11 chris_n chipping away line by line will be extremely slow going
20:11 rangi Go for it
20:11 mbalmer yes, I will go through all code and remove backquotes.
20:11 mbalmer I will just continue to complain about MySQLisms.
20:11 chris_n mbalmer: probably a better way would be to followup with a patch that removes backticks entirely from that file
20:11 jcamins We generally defer to our elected QA team for making these decisions.
20:11 mbalmer rangi. no that is up to the one who posts a patch.
20:10 rangi Send a followup mbalmer
20:10 maximep just curious, how do you escape characters in field names in postgres?
20:10 mbalmer but MySQLisms were changed, which is not acceptable either. Easy to remove, so please remove them.
20:09 jcamins There weren't any MySQLisms added in that patch.
20:08 mbalmer Please remove the backquotes.
20:08 cait I renumbered
20:08 mbalmer +INSERT INTO `authorised_values` (`id`, `category`, `authorised_value`, `lib`) VALUES (LAST_INSERT_ID( ) + 4,'LOST','4','Отсутствует при инвентиризации');
20:07 cait but I think that's a patch for another day
20:07 cait I didn#t rework the whole file
20:07 cait there is no chance i added new
20:07 mbalmer yes, you did.
20:07 cait I removed lines
20:07 cait I added no new mysqlisms
20:07 mbalmer cait, please no new MySQLisms, please rework your patch.
20:05 chris_n bye
20:05 oleonard See y'all later, #koha
20:00 jcamins (still should be done, but if you're a day late, it probably won't delay your patch getting in... at least that's my theory)
20:00 jcamins Most people have switched to using git-bz, so it's not so important now, I think.
19:58 oleonard git bz makes it easy to forget :)
19:57 mbalmer will do.
19:57 cait jcamins: which I forgot twice today already... hmpf :)
19:57 mbalmer ok.
19:57 jcamins mbalmer: if there hasn't been any patch submitted previously, you should send it to the list as well.
19:56 mib_tv8sa8 i installed from the tarball i will run the script right now
19:56 cait and from another bug we know it works for overdues
19:56 mbalmer is it enough to add patches to a bug or do I need to mail them to koha-patches as well?
19:56 cait it as reported against 3.0 and there are no current bugs reporting that it's not applied to some kind of message
19:56 huginn 04Bug http://bugs.koha-community.org/bugzilla3/show_bug.cgi?id=2657 normal, P3, ---, paul.poulain, ASSIGNED , AutoEmailPrimaryAddress preference not universally applied
19:56 cait anyone opposed to closing bug 2657?
19:55 jcamins You want to use the rebuil_zebra.pl one.
19:55 jcamins See the last question for the command.
19:54 wahanui i heard searching faq was at http://koha-community.org/documentation/faq/
19:54 jcamins searching faq?
19:54 jcamins Okay.
19:54 mib_tv8sa8 tarball
19:54 mib_tv8sa8 from pkg
19:54 mib_tv8sa8 i had to drop the contents of those tables in order to get mysql to run
19:53 oleonard mib_tv8sa8: It's usually something your system administrator would handle
19:53 jcamins (packages, git, tarball, etc.)
19:53 jcamins mib_tv8sa8: how did you install Koha?
19:53 mib_tv8sa8 how do i reindex?
19:53 mbalmer definitely not italian..
19:53 jcamins That sounds like a month, or something not Italian.
19:52 jcamins mbalmer: yeah, that's what I thought.
19:52 jcamins mib_tv8sa8: did you reindex?
19:52 mbalmer Marzio sounds quite wrong.
19:52 jcamins mbalmer: cool, looks like ordering beer is enough, thanks. :)
19:52 mbalmer Maurizio, jcamins
19:52 mib_tv8sa8 the system had gone down, when it came back mysql kept crashing, turns out to be a problem with sessions table and zebraqueue table
19:51 jcamins mbalmer: I'm trying to figure out whether Marzio or Marizio is more likely to be the right name in Italian.
19:51 mib_tv8sa8 it seem all references for catalogs over about 1750 are missing...i checked the biblio table and it has about 1700records another table that seem to have and audit log or something indicates catalog numbers in the 2400+ region
19:51 mbalmer jcamins, I can order beer in italian, does that count?
19:49 jcamins mib_tv8sa8: what changed before this error started occurring?
19:49 jcamins Any Italian speakers around?
19:48 jcamins Ah well.
19:48 jcamins Zeno isn't here, is he?
19:47 jcamins Clever.
19:47 mbalmer good evening koha community
19:47 cait first thing I did
19:47 cait nope, I checked the opac
19:47 mib_tv8sa8 http://lib.themico.edu.jm/cgi-bin/koha/opac-search.pl?q=harcourt, that was the search term when i click on any of the results past about 10 i get error 404
19:47 jcamins cait: oh, thanks. I guess mib_tv8sa8 just said that and I didn't notice?
19:46 cait 3.4
19:46 wahanui somebody said morning was a state of mind.
19:46 jcamins Morning.
19:46 cait 3.04 :)
19:46 jcamins ^^ that's the question I wanted to ask. :)
19:46 cait morning rangi
19:46 wahanui well, Third question is "What version of Koha are you using?" http://koha-community.org/faq/find-version-koha-running/
19:46 jcamins Third question?
19:46 jcamins No.
19:46 wahanui i guess Second question is "What is the exact error message?"
19:46 jcamins Second question?
19:46 jcamins However, before going into troubleshooting...
19:46 rangi Morning
19:46 jcamins I think you need to reindex, most likely.
19:45 oleonard mib_tv8sa8: Are you talking about "Error 404" ?
19:45 mib_tv8sa8 i'm wondering if maybe the data was lost or something
19:45 mib_tv8sa8 how do i fix that?
19:44 cait or a problem with translation
19:44 mib_tv8sa8 http://lib.themico.edu.jm/cgi-bin/koha/opac-search.pl?idx=kw&q=harcourt&offset=20
19:44 cait it sounds like an index problem
19:44 mib_tv8sa8 i have an issue when we search the catalog it returns results however clicking some of the results gives an error, i was told by the librarian that she didnt delete any of the affected records
19:27 francharb sssssssssseeee yaaaaa
17:57 schuster thanks
17:56 jcamins I'm definitely pro-Postfix.
17:56 schuster K thanks - this will have to run through a mail proxy too... just venturing in ...
17:54 jcamins No one prefers sendmail. ;)
17:54 jcamins schuster: some people prefer Exim.
17:54 schuster thanks
17:53 schuster was getting the popcorn ready for a lecture...
17:52 jcamins schuster: I prefer Postfix.
17:52 chris_n lol
17:52 jcamins schuster: bring out the comfy chair!
17:52 * chris_n looks worriedly to see if jcamins has gone for the thumb-screws
17:52 schuster So I'm setting up a new Koha system any recommendations on the email on debian to use?
17:51 chris_n I suppose I should use some sort of CMS
17:51 chris_n :-)
17:51 jcamins (I bet you weren't expecting a kind of Spanish inquisition!)
17:50 chris_n at the moment I'm doing it from the backend, but I've not thought that far ahead
17:50 jcamins How are you uploading the files?
17:49 chris_n no, just a vanilla apache install on ubuntu or debian depending on the mood :-)
17:47 * jcamins chuckles at this understatement.
17:47 jcamins chris_n: I meant on the backend. If you're using something heavy-duty like Fez/Fedora, you'd probably want it on a separate server because Tomcat is hefty.
17:47 * chris_n would like to have a fancy reader like internet archive, but that's probably not possible atm
17:46 chris_n jcamins: viewable in browser with the option to download
17:44 jcamins chris_n: how are you serving the media?
17:37 gmcharlt that allows browsers to pull in static content with more parallelism
17:37 chris_n we're getting ready to inculcate pdf scans some public domain works... older ones
17:37 gmcharlt also, if one is embedding (say) images in the OPAC, if you're using one server for both Koha and content, it still helps to use different virtual host names
17:36 jcamins They have that file upload thing.
17:36 jcamins chris_n: you should check with BibLibre, though.
17:36 cait chris_n: sorry no - we have only links in the records
17:36 jcamins chris_n: I'd think it would be.
17:35 chris_n just wondering if its best to use a different box, etc
17:35 chris_n or anyone else :-)
17:35 wizzyrea no, we don't
17:35 wahanui I LIKE SCIENCE
17:35 chris_n or wizzyrea
17:34 chris_n cait: do any of your libraries serve electronic resources off of the same server as koha?
17:23 huginn maximep: The current temperature in Quebec, Quebec is 6.0°C (1:00 PM EDT on April 02, 2012). Conditions: Partly Cloudy. Humidity: 27%. Dew Point: -12.0°C. Windchill: 2.0°C. Pressure: 29.75 in 1007 hPa (Steady).
17:23 maximep @wunder cyqb
17:12 cait back
17:05 huginn schuster: The current temperature in Brookview, Plano, Texas is 24.4°C (11:53 AM CDT on April 02, 2012). Conditions: Mostly Cloudy. Humidity: 60%. Dew Point: 16.0°C. Pressure: 29.68 in 1005 hPa (Falling).
17:05 schuster @wunder 75074
16:55 jcamins It seems to me that an rsync server would be the solution for keeping downloads small.
16:52 jcamins At least, that's how it seems to me.
16:51 jcamins slef: every time.
16:51 jcamins slef: you end up downloading more.
16:51 slef jcamins: packages mean downloading the whole thing each upgrade. git means big upload up front, then smaller. I wish I could figure out shallow clones properly.
16:50 huginn 04Bug http://bugs.koha-community.org/bugzilla3/show_bug.cgi?id=7852 major, P1 - high, ---, kyle.m.hall, Needs Signoff , Hourly loan fines are not working
16:50 libsysguy would anybody be up to signing off on bug 7852?
16:48 jcamins Well, I guess it wasn't that much colder, but the fact that it was pouring and there was no subway meant that it felt bitterly cold by the time we got home.
16:47 jcamins Yesterday it was bitterly cold.
16:47 wizzyrea ok that's getting into "br, for spring" territory
16:46 huginn jcamins: The current temperature in APRSWXNET Jackson Heights NY US, Corona, New York is 8.3°C (12:12 PM EDT on April 02, 2012). Conditions: Mostly Cloudy. Humidity: 52%. Dew Point: -1.0°C. Windchill: 5.0°C. Pressure: 29.78 in 1008 hPa (Steady).
16:46 jcamins @wunder 11375
16:46 wizzyrea i won't lie, it's gorgeous here
16:46 * cait heads out to the supermarket
16:46 cait spring :)
16:46 wizzyrea everybody has normal weather but me!
16:46 huginn cait: The current temperature in Taegerwilen, Taegerwilen, Germany is 14.4°C (6:39 PM CEST on April 02, 2012). Conditions: Clear. Humidity: 39%. Dew Point: 1.0°C. Pressure: 29.68 in 1005 hPa (Falling).
16:46 cait @wunder konstanz
16:46 wizzyrea 12 is chillyish.
16:46 oleonard that's more sane
16:46 huginn oleonard: The current temperature in Ohio University, Athens, Ohio is 12.0°C (12:40 PM EDT on April 02, 2012). Conditions: Clear. Humidity: 46%. Dew Point: 1.0°C. Pressure: 29.98 in 1015 hPa (Falling).
16:46 oleonard @wunder 45701
16:46 bag yup that's mental
16:45 wizzyrea that is INSANE.
16:45 bag yeah I should go surfing :)
16:45 wizzyrea on april 2
16:45 wizzyrea 27, at 11:45am
16:45 huginn wizzyrea: The current temperature in Channel 6 Downtown, Lawrence, Kansas is 27.2°C (11:42 AM CDT on April 02, 2012). Conditions: Clear. Humidity: 58%. Dew Point: 18.0°C. Pressure: 29.60 in 1002 hPa (Rising).
16:45 wizzyrea @wunder lawrence ks
16:44 oleonard High surf advisory... we don't get many of those around here.
16:44 wahanui Search.pm is complicated and has been the source of much contention in the wake of KohaCon with BibLibre rewriting it for Solr/Lucene instead of Zebra support.
16:44 cait Search.pm?
16:44 oleonard C4/[ insert your least favorite .pm here ]
16:44 huginn bag: The current temperature in Samarkand San Roque Upper SB Weather, Santa Barbara, California is 14.8°C (9:43 AM PDT on April 02, 2012). Conditions: Clear. Humidity: 38%. Dew Point: 1.0°C. Pressure: 30.06 in 1018 hPa (Rising). High surf advisory in effect until noon PDT today...
16:44 bag @wunder 93105
16:43 * wizzyrea nods
16:43 huginn wizzyrea: Quote #164: "<sekjal> word of advice to folks: take an aspirin before reading C4/Overdues.pm" (added by wizzyrea at 09:08 PM, November 14, 2011)
16:43 wizzyrea @quote random
16:43 wizzyrea that's a great one.
16:43 cait lol
16:43 huginn cait: Quote #142: "Pianohacker: hrm. What's the plural of ILS again? Rangi: ILSESESESESESES" (added by wizzyrea at 08:54 PM, June 08, 2011)
16:43 cait @quote random
16:42 wizzyrea mhm.
16:42 huginn wizzyrea: Quote #128: "When TDF was founded, the group's leadership invited Oracle to participate in the hope that the database giant would be willing to hand over the OOo trademark and allow the vendor-neutral governance body to take over stewardship of the project" (added by wizzyrea at 07:11 PM, April 18, 2011)
16:42 wizzyrea @quote random
16:41 huginn wizzyrea: The operation succeeded. Quote #196 added.
16:41 wizzyrea @quote add oleonard: maybe if I didn't have all this Bugzilla stuff stored in my head I would be able to walk and chew gum at the same time.
16:41 cait lol
16:41 jcamins lol
16:41 oleonard Maybe if I didn't have all this Bugzilla stuff stored in my head I would be able to walk and chew gum at the same time.
16:41 wizzyrea as it's different
16:41 wizzyrea well I think I'll file this one anyway
16:40 cait thx owen!
16:40 cait yes, I meant that
16:40 cait ooh
16:40 huginn 04Bug http://bugs.koha-community.org/bugzilla3/show_bug.cgi?id=4068 major, P5 - low, ---, henridamien, NEW , Accepting a suggestion hides 'pending' tab
16:40 oleonard Bug 4068 is about tabs weirdness, not exactly the same thing.
16:39 cait wizzyrea: ignore me - I can't find it
16:39 cait bye paul_p
16:38 cait wizzyrea: that's good :)
16:38 juan_sieira bye Paul ¡¡
16:38 paul_p time to go back home for me. have a good day #koha !
16:37 wizzyrea in 3.6.4 all of the tabs are there
16:37 cait and I had to go bck to the start page and back into the module to see all my suggestions
16:37 wizzyrea hmm
16:37 cait except for the one I was redirected to
16:37 cait wizzyrea: what I saw was all tabs were gone
16:35 cait but I know there is one
16:35 cait hm not finding it
16:33 wizzyrea aha
16:33 cait there is something weird about redirecting in suggestions :(
16:33 cait wizzyrea: I think there is one
16:32 wizzyrea k will file one
16:32 oleonard sounds like a bug
16:31 wizzyrea count for pending suggestions)
16:31 wizzyrea (your fancy and awesome number
16:31 wizzyrea oleonard: intentional or a bug that the link from the home page for pending suggestions takes you to accepted suggestions instead of the pending tab?
16:23 cait so it should be ok :)
16:22 oleonard Oh, okay.
16:22 cait in the table definition
16:22 cait the field defaults to 0
16:22 oleonard Hm, and lines in updatedatabase.pl: UPDATE items SET damaged = 0 WHERE damaged IS NULL
16:21 oleonard Doing a search for "damaged =" returns some hits in pendingreserves.pl and reserveratios.pl
16:21 cait and sorry for not making much sense- blame the dentist :)
16:21 cait hm most of the fields default to 0 in the database
16:19 cait but I guess... not it's empty if you don't set something and nothing exploded sofar
16:18 cait oleonard: I meant some piece of code really looking for 0
16:17 oleonard One disadvantage to setting a description for the 0 value is that it's harder to scan the list of items in cataloging. It's easier to see which ones are "Damaged" if you're not scanning through a bunch which say "Not damaged"
16:15 oleonard What do you mean by a real 0 value?
16:14 cait but if someone has an example for a real 0 value... they appear in withdrawn, lost, damaged, notforloan and restricted
16:14 cait if they haven't figured that out already :)
16:14 cait you can tell them to delete them
16:14 cait if someone complains
16:14 wizzyrea by all means. Go ahead.
16:13 cait i wouldn't write an update
16:13 cait nope
16:13 wizzyrea it won't touch existing installations
16:13 cait yeah,that was my idea
16:13 wizzyrea so you're saying remove it from the sample authorized values
16:13 cait afaikt at least
16:13 cait :)
16:13 wizzyrea ok
16:13 cait and it makes us end up with 2 empty lines now
16:13 cait as auth value
16:13 cait that's why people added 0
16:13 wizzyrea aha
16:12 cait I think it didn't always
16:12 cait now
16:12 cait that works
16:12 wizzyrea isn't that the point of the 0 value?
16:12 wizzyrea a library wants to choose not to choose
16:12 wizzyrea what if, hypothetically
16:12 cait I think we should get really rid of them
16:12 cait we have no value defined
16:12 cait no
16:11 cait 0 the same then empty
16:11 wizzyrea "no value defined"
16:11 wizzyrea the question is: what should the label be
16:11 cait i gues sit doesn't mean anything
16:11 wizzyrea so
16:11 wizzyrea ok
16:11 wizzyrea lerd.
16:11 cait 0 no label
16:11 cait wizzy: all of them
16:10 wizzyrea we should fix that.
16:10 wizzyrea do we have default values that are 0 and have no labels?
16:10 wizzyrea i agree with hdl
16:10 hdl 0 value is a value, if it means something, it should have a label
16:09 oleonard I think one problem may be that the additem interface offers a blank entry so that you can not set a value, but authorised_values might also contain a blank entry which has a value of "0"
16:08 cait and try to ask about some other old bugs later :)
16:07 cait and will provide a patch
16:07 cait I am trying it for german
16:07 cait but I don't want to decide alone...
16:06 oleonard cait: You could get a lot of issues decided if you ask when no one is around to object ;)
16:00 cait or not
16:00 cait I am willing to do it - but unsure if it's a good idea
16:00 huginn 04Bug http://bugs.koha-community.org/bugzilla3/show_bug.cgi?id=2399 normal, P3, ---, gmcharlt, NEW , All status fields in the item edit interface offer two blank/null entries per dropdown instead of one
16:00 cait ok, bug 2399 - will it work to remove the blank values from the sample files?
15:58 melia morning
15:58 cait hi melia
15:58 wahanui Cookies are delicious delicacies
15:58 cait or cookies?
15:58 cait anyone else wants karma?
15:58 cait oleonard++ for giving his opinion :)
15:52 oleonard I vote close
15:52 cait no opinions? ooh
15:50 cait hm now I scared the first one away.... any more who want to leave now?
15:50 fabio_t bye :)
15:50 cait like add some [tag] to the description?
15:50 cait should we mark those 'omnibus' bus in some way to their purpose is clear?
15:49 cait or close when last patch is pushed?
15:49 huginn 04Bug http://bugs.koha-community.org/bugzilla3/show_bug.cgi?id=1953 normal, P3, ---, gmcharlt, REOPENED , remove possible SQL injection attacks
15:49 cait I wonder - do we keep bugs like bug 1953 open forever
15:48 cait ok, #koha - I started looking at some old bugs this morning :)
15:43 cait :)
15:43 mle ; )
15:43 mle I was hanging out in the Library bar today
15:43 mle It is lovely
15:43 cait it looks like a real nice place
15:42 cait hope we can fit all in then :)
15:42 cait ah
15:42 mle cait but it will be a bit less than that, due to room layout
15:42 mle Capacity 150 http://www.eusa.ed.ac.uk/yourvenues/teviot/
15:41 alex_a dpavlin: ping
15:41 mle cait: plenty
15:40 mle I don't think I had ever been in the Dining Hall before
15:40 mle I have asked if there is a room in Informatics for the Hackfest, since certain obstables have now been overcome on that front. : )
15:40 jcamins Can't say I spent much time there (in the dining hall), but I recall it vaguely.
15:39 cait how many people will fit in there?
15:39 cait :)
15:38 mle it is in the Dining Hall @ Teviot. It is a wonderful space.
15:38 cait was not sure if it meant only people presenting or all of us :)
15:38 jcamins mle: oh, I didn't realize the conference was actually going to be in Teviot.
15:38 cait ah :)
15:37 mle erm. yes people coming to the conference
15:37 cait delegates?
15:37 mle init
15:37 cait woohoo nice!
15:37 mle cait: @Teviot.... 64 bytes from serene.ttllp.co.uk (86.54.115.53): icmp_req=7 ttl=55 time=12.6 ms but that is on the staff wireless ; ) I have confirmation that delegates will have internets. It is likely that it will be good enough uplink to stream. ; >
15:11 jcamins So instead of downloading 355MB with one command, you download it with two. Right?
15:11 cait and keeping things together is better then
15:11 jcamins paul_p: if you're doing development, you need to download everything eventually anyway.
15:08 paul_p jcamins one point for you ;-)
15:08 jcamins Or tarball.
15:08 jcamins paul_p: I know, but if you're concerned about bandwidth, packages are a smaller solution.
15:07 paul_p jcamins = all our productions servers are using git. But not master. using git <> running master
15:07 jcamins Use the packages.
15:07 * jcamins is concerned about solr because of the overhead and what it would mean for developing countries, but if someone in Afghanistan is setting up Koha, I'm going to tell them not to download the git repo at all.
15:07 libsysguy I keep thinking about master as production not development and that is really my downfall :p
15:07 paul_p jcamins = with frederic's suggestion, we don't loose history, we just split it in 2 places.
15:06 cait gmcharlt++ :)
15:06 gmcharlt I would encourage somebody to set up regional mirrors, in that case
15:06 cait libsysguy: you could always remove the install folders with sample data and po files if you don't plan on using them
15:06 paul_p cait : bandwith is not a problem for ppl from germany (or france, or US), but for some ppl from africa or other foreign countries it can be.
15:06 libsysguy jcamins has a point
15:06 cait libsysguy: I think those parts are not the big problem
15:06 jcamins libsysguy: or, rather, use git for development, but not, for goodness sake, in production.
15:06 libsysguy you could really cut down on some space
15:06 jcamins libsysguy: don't use git.
15:05 jcamins I think the loss of history is a bigger problem than anything else.
15:05 libsysguy my thought was what if your library doesn't use acq, or doesn't circulate
15:05 paul_p gmcharlt & cait = feel free to jump in the discussion on koha-devel ! I have no strong opinion here, so...
15:05 cait yes, but it#s a one time thing
15:05 paul_p cait : when someone want to clone, it's large.
15:05 * libsysguy is glad I brought this up on here first them :p
15:05 cait you clone it once, then you are ok, and bandwitdh is not really much of a problem nowadays?
15:05 gmcharlt fragmenting the codebase across multiple repositories is not worth it IMO
15:04 libsysguy each module would have its own repo paul_p
15:04 cait why is the repo size such a problem?
15:04 paul_p libsysguy I don't see the link to git repo size ?
15:04 cait or they should be for an ils :)
15:04 cait hm I am not sure that will work well - because they modules are integrated
15:04 libsysguy paul_p what about having a koha core install, then module installs for acq, circ, cataloging, etc
15:03 paul_p (I was just reviving someone else idea ;-) )
15:02 libsysguy the one about the git repo size
15:02 paul_p s/on/one/
15:02 libsysguy hehe
15:02 paul_p libsysguy which on ? because I write a lot of mails to koha-devel ;-)
15:02 libsysguy and had an idea, but wanted to run it here before I sounded retarded via email :p
15:02 libsysguy So I just saw paul_p's message to the devel list
15:01 libsysguy o/
14:47 kmkale huh what did i do?
14:32 fabio_t kmkale++
14:08 oleonard Hmmm... the one listed on that page for Ohio isn't the one I get
14:07 * wizzyrea doesn't care so much - shoulda just said "flyover country"
14:07 oleonard Poor Kansas, lumped together with "all of tornado country"
14:06 wizzyrea is what mine said.
14:06 wizzyrea just "midwest"
14:06 oleonard wizzyrea: Although I don't see Kansas listed
14:05 wizzyrea ha that's awesome
14:05 francharb thanks oleonard !
14:05 oleonard wizzyrea: http://www.reddit.com/r/comics/comments/rnpiw/mindboggling_xkcd_april_fools_comic/
14:05 francharb oleonard, i sorted by component and was checkiing the cataloging bugs
14:04 francharb exactly
14:04 francharb ahah
14:04 wizzyrea lolwut
14:04 francharb you can't add the authority if you don't put something in the mandatory subfiled
14:04 huginn 04Bug http://bugs.koha-community.org/bugzilla3/show_bug.cgi?id=7725 minor, P5 - low, ---, gmcharlt, NEW , Marking a subfield mandatory makes the entire field mandatory
14:03 oleonard francharb: Bug 7725?
14:03 francharb if you have an optional field with a mandatory subfield
14:03 oleonard wizzyrea: You know you see a different comic than people in different places?
14:02 francharb In the authority framework
14:02 francharb I think it's weird that no one reported it yet
14:02 francharb I'm looking into bugzilla but I can't find this bug
14:01 * francharb waves #koha
14:01 wizzyrea lol @ xkcd today - this is my life. http://xkcd.com/1037/
13:53 fabio_t I have some authorities records not showing in Koha backend and I don't know how to safely delete them (I've already ran koha-rebuild-zebra -f but with no success, they still appears in db)
13:51 fabio_t is it safe to run a "delete from auth_header" over koha's database?
13:47 * kf waves and heads out
13:47 kf thx...
13:46 fabio_t hi there wizzyrea
13:46 * magnuse waves to wizzyrea
13:45 * wizzyrea also waves good morning
13:45 * wizzyrea goes to look at the ones needing signoff
13:45 francharb ahah
13:45 francharb good luck kf
13:45 magnuse ooh, good luck kf
13:45 * magnuse adds another patch that needs signoff to the queue, making the total number 92
13:45 kf ok... off to dentist :(
13:42 magnuse thanks oleonard
13:42 oleonard New patches yes, not signoffs
13:41 magnuse i forget - should patches still be sent to the mailinglist?
13:41 fabio_t is it safe for auth_header table too?
13:40 fabio_t thanks kmkale
13:40 kmkale fabio_t: delete all from biblio and biblioitems tables
13:37 fabio_t hough. Thanks a lot!
13:37 fabio_t Hi koha folks... I have an issue. I have deleted any bibliographic record (items included) from Koha backend (via items batch deletion and revert imported records tools) and ran koha-rebuild-zebra -f. If I search for records, none is returned (as expected) BUT some records are still in biblio database table. How could I get rid of them in a safe way? By truncating or deleting the table? Same applies to authorities and auth_header table; items table is empty t
13:36 Oak or*
13:36 Oak of kf_mtg
13:36 Oak i can't afford to annoy kf!
13:35 Oak :)
13:35 Oak i'll annoy you when you are cait
13:35 Oak thank you!
13:35 kmkale for innodb you need the ibdata* and ib_logfile* files too
13:34 kf Oak: I don't have an snwer for your question - it seems very non-silly to me :)
13:34 Oak i'll only ask silly questions for one or two months... after that I'll start asking average, non-silly questions.
13:33 kmkale which is probably what you are using.
13:33 kmkale Oak: not if you are using innodb
13:18 Oak I now know the /var/spool/koha/kohadb folder... and the tar.gz and sql.gz files are the proper backup. but still just wondering if I can use the *.frm files...
13:16 Oak if I backup /var/lib/mysql/kohadb/*.frm then is it of any use?
13:15 kmkale Namaskaar #koha
13:05 NateC Hi magnuse!
13:03 magnuse heh
13:03 talljoy heh
13:03 wahanui i guess magnuse is afraid that we added another 10000 bugs while he was eating pizza.
13:03 talljoy hey magnuse!
13:02 magnuse hiya talljoy and NateC
13:02 Oak :)
13:02 magnuse yay!
13:02 Oak magnuse
13:02 magnuse Oak
13:01 Oak kia ora #koha
13:00 NateC Hi kf :)
13:00 talljoy hi kf!!
13:00 kf hi NateC and talljoy
12:59 NateC morning #Koha!
12:58 NateC Morning Ruth!
12:54 huginn 04Bug http://bugs.koha-community.org/bugzilla3/show_bug.cgi?id=7445 normal, P5 - low, ---, oleonard, NEW , Clicking on a tag gives "Language ... does not exist"
12:54 * magnuse takes a shot at tackling bug 7445
12:43 kf hi gmcharlt and magnuse :)
12:42 * magnuse waves
12:40 gmcharlt good morning
12:28 kf then it looks right, thx jcamins_away :)
12:28 kf ok
12:23 jcamins_away PERL5LIB=/usr/share/koha/lib?
12:20 kf perl5lib path for a standard install?
12:20 kf hm
12:20 oleonard Good choice
12:19 kf was thinking of you when I closed the amazon one :)
12:19 kf oh thx :)
12:18 oleonard kf++ # for bug-wrangling
12:18 slef oleonard: yeah. Much less annoying. I just spent the day mostly offline.
12:18 oleonard Hi
12:17 kf hey owen :)
12:17 kf :)
12:15 oleonard I like April 1 falling on a Sunday.
11:49 cait-m test
11:48 slef mailed Draft sponsorship requests to kohacon12volunteers
11:31 wahanui rumour has it asaurat is 161
11:31 marcelr asaurat?
10:51 marcelr asaurat: if there are no private shelves, there can be more than 10 public shelves
10:50 marcelr asaurat: could you check my amendment; do you agree?
10:42 marcelr ok will look at it
10:42 asaurat marcelr: didn't notice this behaviour in OPAC, no
10:41 asaurat oh yes, I don't use this often, can be useful
10:41 marcelr asaurat: we should do this too in opac template?
10:40 rangi when i remember to do that :)
10:40 rangi asaurat: what i do, is git blame to find the commit then that commit message has the bug number
10:39 asaurat and it needs sign off, yes =)
10:39 kmkale rangi tried bc, ge and bc, le didn't work.
10:39 wahanui marcelr: that doesn't look right
10:39 marcelr change the name?
10:39 marcelr ok i look there
10:39 huginn 04Bug http://bugs.koha-community.org/bugzilla3/show_bug.cgi?id=7868 minor, P5 - low, ---, adrien.saurat, Needs Signoff , Warnings in logs for search.pl
10:39 asaurat bug 7868
10:38 asaurat no I had already created a new bug, didn't know about this 7786
10:38 marcelr followup on 7786?
10:38 marcelr ok should i sign off?
10:38 asaurat marcelr: yes, just added a tiny check
10:38 rangi because i can do it easier in sql
10:37 rangi have never tried tho
10:37 rangi kmkale: i think you would need an index on them and then do a > and < type search
10:37 huginn 04Bug http://bugs.koha-community.org/bugzilla3/show_bug.cgi?id=7821 blocker, P5 - low, ---, dpavlin, Pushed to Master , XSLT systempreference multi-language support
10:37 jenkins_koha dpavlin: Bug 7821 - fix C4::Templates::_current_language
10:37 marcelr asaurat: are you fixing 7786 error?
10:37 jenkins_koha Project Koha_master build #691: FIXED in 47 min: http://jenkins.koha-community.org/job/Koha_master/691/
10:37 jenkins_koha Yippie, build fixed!
10:36 asaurat :D
10:36 wahanui asaurat is probably 161
10:36 marcelr asaurat?
10:36 kmkale Rangi do you know of a way to search over a range of barcodes in zebra? Barcodes are alphanumeric.
10:34 rangi we should do battledecks :)
10:34 kf asaurat++ for fixing bugs!
10:34 kmkale I hope there is more about solr
10:32 rangi i hope paul_p talks about the sandboxes
10:28 kf rangi++ :)
10:27 rangi i guess i should go submit that
10:26 kf :)
10:26 rangi i could talk about writing plugins, and how its essentially perl, so it does things like warnings
10:26 asaurat might be useful, yep
10:25 kf yep for the TT talk
10:24 kf yep
10:24 asaurat we have to check if addbarshelvesloop.size is defined
10:24 rangi hmm do you think a talk at the hackfest about Template::Toolkit might be good?
10:24 asaurat indeed
10:23 asaurat oh ok
10:23 rangi yep, bug 7786 caused it
10:22 asaurat for this one I've found something, yes
10:22 huginn 04Bug http://bugs.koha-community.org/bugzilla3/show_bug.cgi?id=7868 minor, P5 - low, ---, adrien.saurat, ASSIGNED , Warnings in logs for search.pl
10:22 asaurat rangi: do you mean bug 7868 ?
10:19 huginn 04Bug http://bugs.koha-community.org/bugzilla3/show_bug.cgi?id=7786 enhancement, P5 - low, ---, m.de.rooy, Pushed to Master , Adding More Lists to the Add-to combo of staff search results
10:19 rangi asaurat: you found the cause of that error eh? bug 7786
10:08 kf slef: so all good
10:07 kf it is
10:07 kf me neither
10:07 slef kf: I don't know if it's in the feed
10:03 kf slef: sorry, I missed that!
10:02 kf ah, that's from the calendar?
10:02 slef kf: yes. Does http://koha-community.org/kohacon12-call-for-papers-opened/ not work?
10:00 rangi as always with perl, lots of ways to do it :)
10:00 rangi and then it would be different again with AUTOLOAD
10:00 kf slef: should we put a note for call for papers on the kc.org start page? so it ends up in rss feeds?
09:59 * kf needs to resume her perl reading
09:59 kf wow
09:58 rangi (thats why it fails, because it's not predeclared by EXPORTER)
09:58 rangi foo;# like foo() IFF sub foo predeclared, else "foo"
09:57 rangi &foo; # foo() get current args, like foo(@_) !!
09:53 rangi this will stop the 47 tests failing :)
09:53 rangi but not urgent
09:53 rangi it came across from C4::Output .. and its the last thing that isnt OO about it, be good to get rid of it
09:52 rangi we should check the accessor has the right value, then kill that internal sub
09:52 rangi the xslt file doesnt exist for details ..
09:51 rangi it doesnt call it
09:51 paul_p rangi so we should make a followup and use ->lang() instead of the internal sub ?
09:50 paul_p (why do you say detail.pl doesn't use XSLT ? -> line 88)
09:50 rangi $template->lang();
09:50 rangi if you want to know the lang
09:49 rangi the object has accessors
09:49 jenkins_koha Starting build #691 for job Koha_master (previous build: UNSTABLE -- last SUCCESS #689 3 days 11 hr ago)
09:48 rangi the real way to call it would be $template->_current_language .. but even that is wrong the _ denotes its an internal function, shouldnt be called outside C4::Templates
09:47 * slef cranks up patches2bugs
09:47 rangi because detail.pl doesnt use XSLT
09:46 paul_p rangi but why is it working well when you display, for example, detail.pl ?
09:44 rangi its an object, you shouldnt be calling functions in it, they are methods and should be accessed via the object
09:43 rangi its base class is Class::Accessor
09:43 rangi C4::Templates is not an exporter
09:43 rangi paul_p: want to know why you need the ()
09:36 huginn New commit(s) kohagit: Bug 7821 - fix C4::Templates::_current_language <http://git.koha-community.org/gitweb/?p=koha.git;a=commitdiff;h=574f46fb19a933a6ef25d32423785cafc378213c>
09:33 huginn 04Bug http://bugs.koha-community.org/bugzilla3/show_bug.cgi?id=7821 blocker, P5 - low, ---, dpavlin, Passed QA , XSLT systempreference multi-language support
09:33 paul_p magnus_away i'm on the way to push the fix for bug 7821
08:49 rangi :)
08:49 magnuse ultrasound-time!
08:48 magnuse always nice when things are already fixed :-)
08:48 magnuse rangi: cool, thanks
08:46 huginn 04Bug http://bugs.koha-community.org/bugzilla3/show_bug.cgi?id=7821 blocker, P5 - low, ---, dpavlin, Passed QA , XSLT systempreference multi-language support
08:46 rangi bug 7821
08:45 rangi (its the blocker one there)
08:45 rangi sitting in passed qa
08:45 rangi theres a fix for that
08:45 rangi yep
08:43 pastebot "magnuse" at 109.189.7.19 pasted "here's the full error" (8 lines) at http://paste.koha-community.org/328
08:28 rangi https://twitter.com/#!/mrkrazycab/status/186729862030045184/photo/1
08:23 magnuse :-(
08:23 rangi and then Passchendale even worse
08:21 rangi http://www.nzhistory.net.nz/war/battle-of-the-somme/new-zealands-somme-experience
08:21 rangi the somme was actually worse for NZ
08:19 rangi ah yep
08:18 magnuse http://en.wikipedia.org/wiki/And_the_Band_Played_Waltzing_Matilda
08:18 magnuse "And the band played Waltzing Mathilda" - probably not a pogues original
08:17 * magnuse knows that from a pogues song
08:16 magnuse rangi: ah, guess we'll pass on the 25th then...
08:16 rangi http://en.wikipedia.org/wiki/Anzac_Day#Gallipoli_campaign
08:16 rangi well, since i told it to it does
08:16 rangi magnuse: yeah jenkins runs devel::cover
08:15 * magnuse should dig deeper into jenkins
08:15 rangi ahh you need to get your army slaughtered by a british generals incompetence to get that holiday
08:15 magnuse i had a play with Devel::Cover the other day, but i'm not sure it tells us anything we don't know yet? http://div.libriotech.no/kohamisc/coverage/
08:14 magnuse we miss out on that one, sadly...
08:13 magnuse ah
08:13 rangi anzac day
08:13 rangi we get the 25th off too
08:13 rangi yep
08:13 rangi ywp
08:11 magnuse good thing about easter: no holidays that get eaten by weekends!
08:10 magnuse unless you are self-employed, of course
08:10 * kf moves to norway
08:09 magnuse in norway the norm is half of wednesday off + thursday + friday + monday
08:09 magnuse ah
08:09 rangi (friday and monday)
08:09 rangi and one next week for me
08:09 rangi just one this week
08:08 * rangi wonders if the whole of biblibre will come to scotland
08:08 magnuse so how many days do people get off from work this week?
08:08 asaurat hi! :)
08:08 * magnuse waves
08:07 kf hi asaurat and clrh :)
08:04 clrh jcamins_away: hello sorry for the gdoc, I think it is better now
08:02 asaurat père Castoooor :D
07:58 rangi maybe i will bring it to kohacon and record french speakers reading it :)
07:57 kf rangi: bet not worse than mine :)
07:56 rangi my pronounciation was probably really really bad
07:56 rangi hdl1: i tried to read a story from Petites Histoires du Pere Castor to Kahu tonight
07:54 hdl1 Amit_Gupta:
07:31 rangi evening
07:20 * magnuse wanders over to fsf.org, but can't see anything ;-)
07:08 clrh oups hello
07:08 paul_p FSF announced GPL V4 yesterday :D :D
07:08 clrh bonjour
07:07 francharb hello #koha
07:02 magnuse we have been talking about moving further south, so let's see what happens...
07:01 huginn magnuse: The current temperature in Holter, Holter, Norway is 0.9°C (8:59 AM CEST on April 02, 2012). Conditions: Clear. Humidity: 29%. Dew Point: -16.0°C. Windchill: -2.0°C. Pressure: 29.53 in 1000 hPa (Steady).
07:01 magnuse @wunder oslo, norway
07:00 magnuse or both...
07:00 magnuse i know, i must be stupid or crazy :-)
06:59 magnuse lol!
06:59 paul_p lol: adrien just said : "-4°C in norway, and +14 in Marseille... and he stays in Bodo ... when you don't know that's understandable, but when you know..."
06:57 magnuse heh
06:57 huginn magnuse: The current temperature in Marseille, France is 14.0°C (8:30 AM CEST on April 02, 2012). Conditions: Mostly Cloudy. Humidity: 72%. Dew Point: 9.0°C. Pressure: 29.83 in 1010 hPa (Steady).
06:57 magnuse @wunder marseille
06:57 huginn magnuse: The current temperature in Bodo, Norway is -4.0°C (8:50 AM CEST on April 02, 2012). Conditions: Mostly Cloudy. Humidity: 74%. Dew Point: -8.0°C. Windchill: -9.0°C. Pressure: 29.44 in 997 hPa (Rising).
06:57 magnuse @wunder boo
06:57 paul_p good morning magnuse & all
06:56 magnuse bonjour paul_p
06:54 magnuse cait++ for signing off on 7850
06:54 julian_m hello magnuse
06:54 magnuse hiya julian_m
06:50 magnuse hiya marcelr
06:49 marcelr hi magnuse
06:49 magnuse kia ora #koha
06:38 marcelr hi koha
06:37 wahanui que tal, reiveune
06:37 reiveune hello
06:13 kmkale Aahh
06:12 cait ask Brooke
06:10 kmkale Why gullible?
05:57 alex_a morning cait
05:55 cait morning alex_a
05:35 Space_Librarian Right. time to sign off for the evening. Toodle pip, and I'll see ya'll tomorrow. :)
05:34 Amit_Gupta ok
05:31 Space_Librarian that's probably why
05:31 Space_Librarian We do most of that in the item editing, rather than the marc record
05:31 cait Amit_Gupta: it will not work afaik - no reordering
05:31 cait but not change the order
05:31 cait you can hide fields you don't use
05:30 * Space_Librarian goes to look for 952
05:30 wahanui 952 is probably the field used for items in Koha. See http://wiki.koha-community.org/wiki/Holdings_data_fields_%289xx%29
05:30 cait 952?
05:30 Space_Librarian It's hidden in our default.
05:30 cait for entering the data
05:29 cait Space_Librarian: I think the order in 952 is not optimal always - I had libraries asking about that
05:23 Space_Librarian the only time we change subfields is in 260, we put b before a... but why in 952?
05:21 Space_Librarian what eythian said.
05:20 eythian why?
05:20 Amit_Gupta while exporting
05:20 Amit_Gupta i want to reorder subfield
05:20 Amit_Gupta in item tag 952
05:19 wahanui rumour has it Space_librarian is a Koha poet or the sweetest lil lady you'll ever know
05:19 Amit_Gupta Heya Space_librarian
05:15 Space_Librarian So within a marc field, we have b, a, c as an order, for example
05:14 cait but what Space_Librarian said :)
05:14 cait I don't think you can change the order in the frameworks
05:13 Space_Librarian the little arrows next to the subfields can be moved up and down.
05:13 Space_Librarian Amit_Gupta we do
05:13 Amit_Gupta heya cait
05:12 Amit_Gupta can we reorder marc subfield while creating marc record
04:49 Oak kia ora #koha
04:33 Space_Librarian I wonder if that would be used
04:33 rangi cant hurt :)
04:32 Space_Librarian I could actually put our coursework paper framework up too...
04:32 Space_Librarian Milton and I are stoked.
04:31 Space_Librarian :D
04:31 rangi Space_Librarian: https://twitter.com/#!/nengard/status/186671213635059714 famous already
04:20 bag heya Amit_Gupta
03:58 Amit_Gupta heya bag
03:45 Space_Librarian Wellington Accountants. I've cleaned it out of the file I've just uploaded to the wiki.
03:44 eythian Space_Librarian: what is 'WAC'?
03:40 rangi sweet
03:39 Space_Librarian done. All clean and ready to roll.
03:36 Space_Librarian (whoops)
03:36 Space_Librarian I must just go through and take a couple of our pre-pops out...
03:32 rangi I like it!
03:26 Space_Librarian How's that?
03:25 Space_Librarian Boom. http://wiki.koha-community.org/wiki/MARC_frameworks
03:22 rangi sweeet
03:21 * Space_Librarian links stuff through now
03:21 Space_Librarian gmcharlt++
03:14 rangi gmcharlt++
03:14 gmcharlt Space_Librarian: give it a try now
03:10 rangi sweet
03:09 Space_Librarian Once that's done, I'll add it
03:09 Space_Librarian cool
03:09 rangi ill ask gmcharlt to allow .sql too
03:09 Space_Librarian yup
03:08 rangi how annoying
03:08 rangi ahh
03:08 Space_Librarian I've renamed it to .sql - "Permitted file types: png, gif, jpg, jpeg, odt, pdf, csv, mrc"
03:07 rangi ? even
03:07 rangi >
03:07 rangi can you rename it to .sql
03:07 Space_Librarian perfectly. It just won't let me upload a .txt file
03:04 rangi does that make sense?
03:04 rangi once you upload it, you can just put a link to it on that other page
03:04 rangi Space_Librarian: http://wiki.koha-community.org/wiki/Special:Upload
03:04 eythian Oh hey, oocalc will open the XML format nicely too
03:03 rangi id just load it as a file, not cut and paste it in
03:03 Space_Librarian This is one very, very long sql file. What should I be bracketing it with? Or should I just put it on the wiki and somebody could help me clean it up...?
02:57 rangi i think sql is the best option
02:56 Space_Librarian Argh. Editing wiki pages is evil
02:55 Space_Librarian or should I try something else?
02:55 * Space_Librarian exports framework to sql
02:54 * Space_Librarian nods
02:54 rangi will make it easy for others to add frameworks too
02:54 rangi and we could link to the page on the frameworks page, like we do for the sql reports
02:54 * Space_Librarian ponders this...
02:54 rangi it might be nicer/easier to have a page on the wiki
02:53 rangi or you could make a patch and put it in the sample data
02:53 rangi http://wiki.koha-community.org/wiki/MARC_frameworks
02:52 rangi one would be to make a wiki page, like the sql reports and upload and link the file there
02:51 rangi 2 ways to do it
02:51 rangi yes :)
02:50 Space_Librarian rangi, our articles framework... would it be possible to submit it to be included in a future version of Koha for other special libraries to use and tweak?
02:48 Space_Librarian hey.
02:48 rangi hiya Space_Librarian
02:47 Space_Librarian o/
01:57 libsysguy thanks rangi, will try
01:56 * mtj watches the memcached.log...
01:56 rangi makes the db work a lot less
01:56 rangi in sysprefs
01:56 rangi switch on sessions
01:55 mtj ooh, its working sweet!
01:55 rangi libsysguy: update should do it, i think if you explicity update it it will stick
01:53 mtj aah yeah, nice :)
01:52 rangi since if the env variable is not set, it wont use memcached, .. i havent test that at all, but it should work
01:52 rangi blocks .. part of the opac/staff side
01:51 rangi using <Location>
01:51 rangi or even
01:51 mtj merci
01:51 rangi you can run memcached for just the opac if you wanted
01:51 rangi it has the sideffect
01:51 rangi like that in your conf
01:51 rangi SetEnv MEMCACHED_NAMESPACE "KOHA"
01:51 rangi SetEnv MEMCACHED_SERVERS "127.0.0.1:11211"
01:51 libsysguy random question…if you wanted to change a timestamp that was update on change…how would you go about that?
01:50 rangi yup :)
01:50 mtj 83 $servers = $ENV{'MEMCACHED_SERVERS'};
01:49 mtj # Check if there are memcached servers set
01:48 * libsysguy thinks that rangi is really the physical form of bugzilla
01:48 rangi check C4/Context
01:48 rangi yeah its in ENV variables now
01:48 mtj 'Version: rel_3_8'
01:47 rangi http://www.stuff.co.nz/national/6677942/Dolphins-spotted-in-Wellingtons-Island-Bay
01:47 huginn 04Bug http://bugs.koha-community.org/bugzilla3/show_bug.cgi?id=6193 enhancement, P3, ---, tomascohen, Pushed to Stable , Use memcached cache koha-conf.xml configuration variables
01:47 libsysguy bug 6193
01:47 mtj but the bugs status incorrectly says 'Status: Pushed to Stable' ?
01:47 mtj 6193
01:46 libsysguy yeah thats what it is…sorry im running master and just set it up the other day
01:46 mtj hmm, looks like the apache ENV stuff for memcache is happening for 3.8
01:41 wahanui libsysguy: I forgot bug 5339
01:41 libsysguy wahanui forget bug 5339
01:40 huginn 04Bug http://bugs.koha-community.org/bugzilla3/show_bug.cgi?id=5339 enhancement, P3, ---, julian.maurice, Signed Off , Parcel closing in acq
01:40 wahanui bug 5339 is looking for a second sign off :)
01:40 libsysguy bug 5339
01:40 * libsysguy is sorry to butt in
01:40 mtj the qa contact is some email addy, always
01:40 libsysguy I thought that config got moved into koha-http.conf
01:39 libsysguy mtj is that for something old?
01:39 mtj <memcached_namespace>koha</memcached_namespace>
01:39 libsysguy if the bugs list is the QA contact for a bug…what does that mean
01:39 mtj <memcached_servers>127.0.0.1:1121</memcached_servers>
01:38 mtj i think ill go with ..
01:38 mtj <memcached_namespace></memcached_namespace>
01:37 mtj <memcached_servers></memcached_servers>
01:37 mtj hmm, any example for these 2 variables in koha-conf.xml ?
01:31 mtj ... and add some new $ENV variable in apache too?
01:31 mtj so, update the memcached bit in your koha-conf.xml file...
01:30 bag I usually just apt-get and then stop and restart it ;)
01:29 bag sorry mtj I don't know of any documentation
01:29 bag memcache?
01:29 wahanui memcached is probably running, but I dunno it Koha uses it.
01:29 bag memcached?
01:27 mtj could anyone point me to some recent doco re: memcache setup?
01:26 mtj hi #koha, ive a question about setting up memcache with Koha
00:17 ronald ronald waves back to mtj : )
00:15 * mtj waves to ronald :)
00:09 ronald hiya rangi :)
00:08 rangi hi ronald
00:07 ronald Hello #koha