Evergreen ILS Website

IRC log for #evergreen, 2014-04-04

| Channels | #evergreen index | Today | | Search | Google Search | Plain-Text | summary | Join Webchat

All times shown according to the server's local time.

Time Nick Message
00:05 ningalls joined #evergreen
00:10 torrie joined #evergreen
04:57 pinesol_green Incoming from qatests: Test Success - http://testing.evergreen-ils.org/~live/test.html <http://testing.evergreen-ils.org/~live/test.html>
07:36 Dyrcona joined #evergreen
07:54 collum joined #evergreen
08:12 csharp hmm - looks like the change in 80e3f6f may have borked some long-standing PINES reports templates
08:12 pinesol_green [evergreen|Mike Rylander] Correctly mark nested INNER joins as such - <http://git.evergreen-ils.org/?p=​Evergreen.git;a=commit;h=80e3f6f>
08:13 csharp no complaints about the new behavior, just an observation and warning to others that the change alters the way JOINs are done ;-)
08:13 Dyrcona joined #evergreen
08:13 timlaptop joined #evergreen
08:13 asimon joined #evergreen
08:15 akilsdonk joined #evergreen
08:19 asimon *: I am trying to load a file of bib records into a test server.  In order to preserve the rest of the data, I did a truncate cascade on the bre table (there are no copy records) and set record_entry_id_seq to 500000.  When I load the records, the id numbering starts at 001.  The load script is clearly using the TCN (which begins at 500001) as the id.  How is this possible?
08:22 csharp asimon: there's a "global flag" that determines that behavior, if I recall correctly
08:23 csharp config.global_flag?  (I don't have access to our DB right this second to check)
08:24 csharp also available via the staff client in the Server Admin section, btw
08:28 asimon csharp: I see a 'cat.bib.use_id_for_tcn' in config.global.flag which is set to TRUE, but this should not affect setting the id during a load.
08:29 Shae joined #evergreen
08:34 Dyrcona asimon: It will move the 001 to 035 and put the id in 001.
08:36 asimon Dyrcona:  How does this relate to a PostgreSQL COPY which is supposed to honor record_entry_id_seq?
08:36 Dyrcona asimon: The id column of the bre entry is not changed. The 001 in the MARC record is changed.
08:37 Dyrcona biblio.record_entry.id is unchanged.
08:37 Dyrcona biblio.record_entry.marc is changed.
08:38 asimon Dyrcona: OK.
08:38 Dyrcona asimon: If you copy includes the id column, it won't honor record_entry_id_seq.
08:42 mtate joined #evergreen
08:46 mmorgan joined #evergreen
08:56 akilsdonk_ joined #evergreen
09:04 rjackson-isl joined #evergreen
09:09 ericar joined #evergreen
09:10 mrpeters joined #evergreen
09:11 RoganH joined #evergreen
09:15 Sato`kun joined #evergreen
09:16 dluch joined #evergreen
09:25 mllewellyn joined #evergreen
09:33 yboston joined #evergreen
09:37 denishpatel joined #evergreen
09:41 denishpatel joined #evergreen
09:42 dbs berick: thanks for putting up with my late-night antics. I know the Mozilla folks want to add more live examples, maybe I'll tackle that one
09:44 berick heh, ain't no thing
09:45 berick (but, of course, a chicken wing)
09:46 berick more moz live examples would be nice
09:47 jeff w3schools? That's IT! You're OUT of the band!
09:54 Stareagle joined #evergreen
10:06 atlas__ joined #evergreen
10:12 Bmagic anyone know of any issues with the newer version of DBD::Pg against evergreen code? it looks like the version is 2.17.1 from 2010
10:30 atlas__ joined #evergreen
10:38 mmorgan Anybody tried to use the new library setting in 2.5 from lp 856688 ?
10:38 pinesol_green Launchpad bug 856688 in Evergreen "Option to disallow use of an org unit as a pickup library for holds" (affected: 4, heat: 18) [Wishlist,Fix released] https://launchpad.net/bugs/856688
10:39 bshum mmorgan: I haven't, but what are you seeing ?  :)
10:39 mmorgan It doesn't prevent me from choosing the ou as a pickup point when I place the hold, doesn't grey it out.
10:39 mmorgan but when I edit the hold, the ou IS greyed out.
10:40 mmorgan so seems like the place hold screen isn't looking at the setting?
10:40 bshum My kneejerk reaction is to ask you if you've restarted apache lately
10:40 bshum Because maybe it's caching the original dropdown choices and not the one reflecting the disallowed ou from the setting
10:40 mmorgan fresh install on our training server this week. Just restarted apache a few minutes ago.
10:41 bshum But then again, maybe it is ignoring it for some reason :)
10:45 mmorgan tried restarting and clearing cache on everything I could think of and still no luck :-(
10:47 csharp Bmagic: we're running Ubuntu 12.04 with version 2.19 from the Ubuntu repos and it works fine for us
10:47 csharp mmorgan: I think we saw similar issues...
10:48 * csharp looks around for terran
10:52 mmorgan ok - a launchpad question, so if the new ou setting isn't working, is that an update to the existing bug which is marked "fix released" or a new bug?
10:52 bshum New bug usually.
10:53 bshum would be what I would recommend when dealing with something that's already been released.
10:54 mmorgan I'll poke around some more and open one if warranted. Thanks!
10:58 bshum Hmm
10:58 bshum mmorgan: Can you tell us a little more about the org unit structure and which ou you're disallowing from hold pickup?
10:59 bshum (when I tested it just now, it worked fine to disable the option on the place hold screen...)
11:01 mmorgan Interesting. Here's a pic: http://screencast.com/t/AIs8afgOj0gZ
11:02 csharp could it be autogen.sh related?
11:02 mmorgan We have NOBLE(All libs) as consortium, then Phillips Academy as a system. It's some of the branches I'm trying to disallow, like Phillips Addison
11:02 csharp autogen.sh-- # btw
11:03 mmorgan ok, I will give autogen a try, but I DID see the choices greyed out when I tried editing the pickup library of an existing hold.
11:04 bshum fwiw, when I applied the setting in my system, I didn't restart anything and it was greyed out when I went to look.
11:04 bshum Same when removing that setting
11:05 csharp bshum: ok - just a shot in the dark
11:05 bshum Does NOBLE use custom org units trees?
11:06 bshum (we don't, so I'm just curious if maybe that's causing some weird issue)
11:06 bshum Or actually, it probably shouldn't affect it.
11:06 bshum Hmm
11:06 mmorgan Yes, we do use custom org unit trees.
11:08 csharp oh, yeah - *that* was our issue
11:08 mmorgan Here's a pic of editing a pickup location on an existing hold: http://screencast.com/t/sb1b2A6pjv
11:08 csharp we hack our OU display to show System - Branch, and that was interfering with it
11:08 mmorgan It's working there.
11:09 csharp in our case, rearranging the template code resolved the issue
11:09 mmorgan csharp: So a custom tpac file?
11:09 csharp yeah
11:10 csharp well, not file, just some custom code within one of the templates
11:13 bshum csharp: Something weird to rearrange in org_selector.tt2 maybe?
11:15 bshum but this is the thing I'm not sure about
11:15 bshum The dropdown picker from place_hold.tt2 doesn't have an INCLUDE parameter for show_loc_group
11:16 bshum So I wouldn't expect it to interfere if you have custom org unit trees
11:19 denishpatel joined #evergreen
11:21 bshum Okay, I have no new ideas yet and it's time to go find lunch.
11:21 kbutler joined #evergreen
11:22 mmorgan I know what to look at now, thanks for your help!
11:22 mmorgan bshum++
11:22 mmorgan csharp++
11:25 bshum mmorgan: Good luck, I'll be curious to see what the final issue turns out to be.
11:32 kbeswick joined #evergreen
11:32 mcooper joined #evergreen
11:46 yboston hello everyone, not so long ago I was able to run a nifty query to get counts of every bib tag and sudield combination we have in our system using metabib.full_rec
11:47 yboston but now I need to run a similar query on auth tag/subfield combinations. I assuem I can't use soemthing equivalent to metabib.full_rec for auth since it might not exist yet?
11:49 pastebot "yboston" at 64.57.241.14 pasted "query using metabib.full_rec to get counts of all bib tag/subfield combinations" (7 lines) at http://paste.evergreen-ils.org/43
11:51 dbs yboston: check authority.full_rec
11:51 jeff you can change metabib.full_rec to authority.full_rec in that query and get results.
11:53 yboston ¡ dbs & jeff muchas gracias!
12:01 cmorgan joined #evergreen
12:05 jihpringle joined #evergreen
12:25 lcathenry joined #evergreen
12:28 Dyrcona Is this to be expected: psql:0875.schema.authority​.in-line-headings.sql:14: NOTICE:  index "unique_by_heading_and_thesaurus" does not exist, skipping
12:29 csharp reports--
12:29 Dyrcona Thing is, I know we recreate that index when reloading the database.
12:29 Dyrcona I wonder if 0874 causes it to disappear.
12:34 gerson joined #evergreen
12:37 Dyrcona Oh, never mind.
12:38 Dyrcona I see that message comes from a "drop if exists," so we'd be dropping it anyway.
12:43 bshum gmcharlt: Your contrived examples in the reply to list make me queasy :(
12:44 * Dyrcona finds "contrived" examples happen all too often in reality. ;)
12:49 dbs gmcharlt's workflows were good examples of what I was implying
12:50 Dyrcona Grr.
12:50 * Dyrcona doesn't like it when man pages are not installed on the server.
12:50 dbs Gotta save those MB of space!
12:52 Dyrcona :)
12:55 Dyrcona Most of them can be found via this thing called Google, too. ;)
12:58 * dbs runs into "Method [open-ils.circ.copy_note.retrieve.all] not found for OpenILS::Application::Circ" on a freshly upgraded master vm. time to dig.
12:59 Dyrcona Not seen that one.
13:02 dbs Oh, probably missing Business::Stripe
13:03 Dyrcona Could be.
13:03 dbs Yep.
13:04 jeff I would love to have a standard way for us to not require some of those modules unless they're actually in use.
13:04 jeff I think there's existing examples for that, possibly already within Evergreen itself already.
13:05 jeff But installing PayPal and Stripe things for a site that doesn't make use of online payments at all seems... dunno.
13:05 dbs jeff: alternately, "cpan *"
13:05 bshum Haha
13:06 Dyrcona :)
13:07 * dbs wonders if anyone is willing to add serial.* data to the --load-all side of things
13:08 bshum berick: I have a question about websockets and upcoming changes to OpenSRF.
13:08 bshum As I work my thoughts together about the XUL vs. web client
13:09 bshum I'm wondering if any changes in the underlying architecture would require us to test also the XUL client to make sure we don't break things?
13:09 bshum While we transition to the web client
13:10 berick bshum: websockets will have no effect on the xul client.  it has to be activated within the script / application to be used, and the browser client code is the only thing (for now, anyway) that activates it.
13:10 berick the activation occurs within the base browser staff template
13:10 bshum berick: Ah, cool deal.  Then I feel slightly better on that front.
13:10 berick all other code will continue using XHR as before
13:11 Dyrcona Waiting for long upgrade scripts isn't much fun.
13:13 bshum I'm generally happier with the idea of having the web client be its own thing instead of trying to hammer it to live alongside the existing client.  I'd be happiest if we don't break anything XUL side till we're done and can do a full transition.
13:14 bshum Mostly because I don't think our folks would really want to handle a hybrid situation.
13:15 berick bshum: *nod*
13:23 atlas__ joined #evergreen
13:25 jl- hello
13:37 bshum jl-: Greetings.
13:53 kgaug joined #evergreen
13:54 mdriscoll joined #evergreen
13:55 yboston Heads up, the IRC practice time isstarting at 2 PM EST, I suspect we will not have as many visitors as last time
13:57 akilsdonk joined #evergreen
14:00 jl- @coffee
14:00 * pinesol_green brews and pours a cup of Nicaragua Maragogipe Organic, and sends it sliding down the bar to jl-
14:01 b_bonner joined #evergreen
14:02 yboston IF any one is here for the IRC practice time. Welcome
14:03 yboston If you are an IRC newcomer go ahead an d introduce yourselves.
14:03 * bshum waves at yboston
14:04 yboston bshum: thanks, I don't think any newcomers are here
14:04 yboston I forgot to send a reminder during the week to the general list :(
14:04 yboston I only emailed the dev
14:04 yboston list
14:06 Josephine joined #evergreen
14:07 yboston if anyone is here for the IRC practice time, feel free to introduce your self
14:09 kgaug left #evergreen
14:09 kbeswick joined #evergreen
14:17 schrader_ joined #evergreen
14:19 hbrennan joined #evergreen
14:20 schrader_ joined #evergreen
14:21 hbrennan Hello Evergreeners! I'm back from vacation and ready to catch up on IRC chat since the conference. Oh boy!!
14:21 yboston hello
14:22 yboston are you  here for the IRC practice time?
14:22 hbrennan Oh, no. Is that scheduled for right now?
14:22 yboston yes, but this practice time is not as popular as the first
14:22 hbrennan I literally just returned to work and have resisted reading emails
14:22 schrader_ I was here for the practice time. Is that why no posts display?
14:22 yboston no worries,
14:23 yboston no thinkgs are just quiet, less showed up, but I am here to help folks practice
14:23 hbrennan Just wanted to say I'm back. I'll just watch, or help if I can
14:23 dbs hbrennan++ # i'm impressed at being able to resist reading emails at any time!
14:23 yboston BTW, here here is the EG community IRC "quick start guide" put together by kmlussier (Kathy) http://wiki.evergreen-ils.org/doku​.php?id=community:irc-quick-start
14:24 hbrennan dbs; Only 401 new emails, plus 99 from EG list...
14:24 yboston schrader_: this my attempt to "reply" to you by starting this messgae with your nickname and a colon
14:24 hbrennan dbs: Wouldn't want to be bored my first day back
14:24 yboston schrader_: try replying to me if you want
14:25 schrader_ yboston : okay, here it is
14:25 hbrennan schrader_: no space
14:25 yboston schrader_: good job.
14:25 jl- schrader_: welcome
14:26 yboston replying makes the other persons IRC software try to alert you someone is trying to get your attention
14:26 yboston I hear on the web browser version of IRC the replies appear in red(?)
14:26 hbrennan yboston: yep
14:26 hbrennan and it flashes the browser window
14:27 hbrennan great when you have multiple conversations going
14:27 yboston another trick is that you can just write the first couple of letters of someone's nickname, then hit the "tab" key to trigger auto completion
14:28 schrader_ hbrennan:didn't think I had a space
14:28 schrader_ Maybe it was in my name. Have I told everyone how much I hate invisible spaces?
14:28 hbrennan schrader_: It might work.. not sure. But I always write the username: then a space, but not between the username and colon
14:29 hbrennan schrader_ : Does this still notify you?
14:29 schrader_ hbrennan :yes I can see both posts to me
14:29 hbrennan schrader_: Great! Then the space doesn't matter
14:31 yboston another useful feature is to create a private chat with some. Usually done in case you want to have a long conversation and don't want to clutter up the public channel
14:31 schrader_ Just throwing something out here. I'd like to know who to talk to about Vandelay improvements.
14:31 yboston you start your message with:  /msg nickname
14:32 hbrennan schrader_: That would be a good topic to throw out to the email list.
14:32 yboston so if I want to start a private message/chat with schrader_ , I would start a message with /ms schrader_
14:32 hbrennan schrader_: You can also search Launchpad to see if others have requested what you want, or start your own "bug report" which can just be a wish
14:32 yboston in most IRC software and even the web version, you will see a new "tab" that will display the private chat
14:33 yboston schrader_: I am interested in improving Vandelay's support for authorities, like having authority overlays on import
14:34 yboston schrader_: what kind of improvements are you interested in?
14:36 schrader_ yboston: get invalid command when using /ms
14:36 yboston you need three letters /msg  try it on me
14:37 * Dyrcona still waits on upgrade scripts.
14:37 Dyrcona On the plus side, I think this is the last one.
14:38 yboston for the record, here is a link of Evergreen community memebers that have publicly identified their IRC nicknames http://evergreen-ils.org/dokuwiki/​doku.php?id=community:irc_channel
14:40 yboston schrader_: are you familiar with Launchpad as hbrennan_away suggested. I can tell you about it if you don;t
14:44 hbrennan yboston: Oops, thanks for following up on that one for me
14:46 schrader_ hbrennan : what's it like in Alaska now? I am still waiting for snow to melt
14:47 yboston hbrennan: you are welcome
14:48 hbrennan schrader_: Wonderful. Glad to be back in warmer temps. :) It snowed in NY on Monday!
14:48 Dyrcona @wunder 01845
14:48 pinesol_green Dyrcona: The current temperature in WB1CHU, Lawrence, Massachusetts is 46.0°F (2:48 PM EDT on April 04, 2014). Conditions: Mostly Cloudy. Humidity: 58%. Dew Point: 32.0°F. Windchill: 42.8°F. Pressure: 30.13 in 1020 hPa (Falling).
14:50 schrader_ Sleet last week in MA, with snow and freezing rain as a bonus. Currently 52 here for Red Sox home opener
14:52 hbrennan schrader_: That's because I left. I was in Boston on Wednesday, which kicked off the nice temps
14:52 yboston schrader_: did we meet at the conferece or before?
14:52 yboston hbrennan: BTW, what is the time differece in where you are in Alaska?
14:53 hbrennan yboston: 4 hours earlier. I left Boston Wed evening at 6, got to Alaska at 7am yesterday. Now I'm at work to start the day and my body/brain say its time to go home
14:54 hbrennan yboston: But I am so appreciative for the EG community hosting most meetings in "afternoon" so I can participate! Wouldn't be where I am now if it hadn't been for that involvement
14:55 yboston hbrennan: that is why I asked and why I made sure the IRC practice time happened at 2 PM EST at the earliest
14:56 hbrennan yboston++ for thinking of the west coasters (and far west coasters)
14:56 * ericar is thankful that she did not bring the cold weather back to Georgia. Already have peppers and tomatoes in the ground.
14:58 yboston hbrennan: to be honest I was thinking of west coasters when I had drawn up plans for these practice session before the conference.
14:58 jl- ericar: hi erica this is ben wiens
14:58 yboston hbrennan: then I heard where you were from, and realized I need to think bigger
14:59 jl- I'll have to wait a little longer until I plant tomatoes
14:59 hbrennan yboston: Haha. Well thanks. There are two EG libraries in AK but I haven't met anyone from the other library
14:59 ericar jl: Hello!
14:59 yboston hbrennan: on the other side of the spectrum, Berklee College (my employer), has a small campus (with a library) in Spain. So I have to adjust my maintenace plans for their open hours too
15:00 yboston hbrennan: what city/town are you based out of?
15:00 atlas__ hey EG IRC, glad to see this channel so active!  I'm going to attempt installing Evergreen for the first time here, noticed that the instructions have notes for both Fedora and Ubuntu -- any reason to pick one over the other?
15:00 hbrennan yboston: Homer
15:01 jl- atlas__: debian
15:01 atlas__ jl-: squeeze?
15:01 jl- or the latest stable (wheezy)
15:01 atlas__ okay thanks
15:02 jl- no problem
15:03 jl- apt-get makes everything so much easier
15:03 atlas__ yum is quite nice too ;)
15:03 jl- sure if you like compiling from source
15:03 jl- :)
15:04 yboston hbrennan: thanks for sharing. Like I told most of you I live like 20 minutes walking from the confernce hotel but I am originally from Puerto Rico
15:04 yboston @wunder 00936
15:04 jl- I've lost a good amount of hair trying to make islandora work on fedora, since then I just use debian for everything
15:04 pinesol_green yboston: The current temperature in San Ignacio, San Juan, Puerto Rico is 81.3°F (3:04 PM AST on April 04, 2014). Conditions: Mostly Cloudy. Humidity: 71%. Dew Point: 71.6°F. Pressure: 30.01 in 1016 hPa (Falling).
15:04 dbs atlas__: I'm one of the only people who runs Fedora, most people run ubuntu or debian. So there's that.
15:05 atlas__ jl-: damn, thats too bad, it seems like the latest fedora release always has good up to date packages in the repo, but I'm down for trying debian too if its repo is better for the dependencies evergreen needs
15:06 hbrennan yboston: Checked out the outside of your campus. Talked to you about the cool bike lock-up area you have!
15:06 jl- atlas__: I love fedora as my desktop but it threw me too many curveballs when running applications like islandora.. I haven't tried evergreen on it tho
15:06 collum hairloss--
15:06 yboston For the record, we have hit 3 PM and this concludes today's IRC practice time. YOu can go back to beating your local weather and ordering beverages fromt eh pinesol_green bar
15:07 yboston s/beating/talking about the/
15:07 hbrennan yboston++ Thanks for hosting these sessions. Glad to have more new people joining!
15:07 jl- yboston++
15:08 hbrennan bshum: We need a new Top 50 karma count. I'm interested to see the difference pre and post conference!
15:08 yboston hbrennan: you missed the first practice time, we had a lot of newcomers. I was really happy
15:08 bshum hbrennan: Heh, I'll see what I can do in a moment.
15:08 hbrennan yboston: Darn my vacation. Next time I'll take time off before the conference, because I really wanted to get back to work after this one!
15:08 bshum One of the things I noticed that they do in #code4lib is to reset the karma between conferences.
15:08 bshum So that each year they track anew
15:08 ericar yboston++
15:09 yboston I want to try to host these IRC training after every conference at the very least
15:09 hbrennan Great idea
15:10 yboston a variation is to have a newcomer session were we create a luanchpad account, try IRC , learn to browse the git.evergreen-ils.org
15:10 hbrennan yboston: Maybe before anticipated big conversations, like when we want to discuss the new browser
15:10 yboston at the cofnerence
15:10 yboston hbrennan: that is brilliant
15:11 hbrennan yboston: Because that's a time when I think we'll see more library staff involvement, who probably don't use IRC much if ever
15:11 yboston hbrennan: makes semse
15:11 yboston *sense
15:12 * dbs notes concerto record 186 still shows "Genre" results from field 659, which is actually undefined in MARC21
15:12 kbeswick joined #evergreen
15:15 jl- good news, I migrated all of our universities' records (1 out of 18).. but then when I logged into the staff client, it's like I glimpsed into the matrix.. so much.. library stuff that I have no clue about
15:15 jl- around 250k records for now, which might be enough for a pilot
15:18 hbrennan jl-: Awesome! You've made a lot of progress in the past 4 weeks!
15:19 jl- hbrennan: indeed, splitting the imports into batches of 10k did it for me. 50k would go into a neverending loop..
15:19 jl- too bad there's no clear cut way for migration
15:20 hbrennan jl-: That's the world of libraries.. everyone's a little different
15:20 dbs For that matter, the 69x mappings are supposed to be local too. There are only a couple that match even OCLC's definitions.
15:20 yboston jl-: congrats
15:20 yboston jl-: which import approach did you use?
15:20 jl- I'm hoping to get one of our libraries as a gineau pig for a pilot now, maybe for a dvd collection, or something.. wean them off voyager
15:21 jl- yboston: I used the sql_loader which is pretty close to the staging table from dbs
15:21 jl- in /openils/Evergreen-ILS-2.5.1/​Open-ILS/tests/datasets/sql/
15:22 jl- I made a script that formats them simialr to the concerto files
15:26 jl- anyway, have a good weekend everyone
15:27 jeff neat, we have an action.billable_cirulations view. i wonder if that's a known typo or something specific to us. :-)
15:28 hbrennan jl-: Ugh, it's 11:30 here, but my body thinks it's later so I can leave too right?
15:28 jeff (we also have action.billable_circulations)
15:29 jl- hbrennan: I didn't realize Alaska was that far behind ;)
15:29 hbrennan jl-: It's true.
15:35 jl- are the fairbanks remote?
15:36 hbrennan jl-: You talkin to me?
15:37 jl- hbrennan: yes
15:37 mmorgan jeff: no action.billable_cirulations view here! Must be just you.
15:38 hbrennan jl-: Can you repeat the question? Haha.
15:40 jl- hbrennan: nvm ;)
15:40 hbrennan jl-: I can tell you that Fairbanks is 600 miles north of me. :)
15:41 kbeswick joined #evergreen
15:42 rjackson-isl jeff: we have one here at EI --> select count(*) from  action.billable_cirulations; yields--> 1071972
15:42 rjackson-isl I've noticed that table as well in the past and wondered...
15:43 dbs none here
15:44 dbs and nothing matching: grep -r "cirulation" Open-ILS/sql/*
15:44 dbs perhaps a local support provider copy/pasteo?
15:44 rjackson-isl ours appears to be in sync with the "real" named table based on checking max(id) values...
15:45 jeff rjackson-isl: it's a view, so that's to be expected.
15:45 rjackson-isl jeff: dang - caught again!
16:01 bshum Huh.... I just noticed a new question in LP
16:01 bshum https://answers.launchpad.ne​t/evergreen/+question/246347
16:01 bshum That's the first time in a long time someone's used that...
16:03 bshum I suppose we don't really use LP that way.
16:05 madseumas joined #evergreen
16:10 ericar bshum: out of curiosity, I just tried recreating what she's reporting. I can't reproduce the results. tested on 2.5.3b
16:11 bshum ericar: Thanks for taking a look over.  I wasn't too sure what all the circumstances are here.
16:12 bshum The LP account who opened that question seems to be someone from Evergreen Indiana.
16:12 ericar bshum: me either
16:12 bshum Could be a local system issue of some sort
16:12 mmorgan We're on 2.4, and one of our libraries has reported a similar problem.
16:13 ericar bshum: it stays on Patron Search when I try it. Probably right.
16:13 mmorgan I think the same thing results from holding down a function key for too long.
16:14 mmorgan Press F1 for checkout, but don't let go of the key right away.
16:14 kbutler I'm able to get one popup to happen intermittantly, if I time it right.
16:14 Bmagic csharp: Thanks for the info
16:14 bshum mmorgan: Oh interesting... holding the key down does give me various JS errors.
16:14 bshum For different Fn keys
16:15 madseumas Hello, everyone.  I just updated a small (20k items or so) library from 2.3.2 to 2.5.3b on a test VM.  Upgrades all went fine, no db errors. She (it's my wife's library; I'm a unix admin by trade so I help her maintain it) was using jspac, which is gone now.  Should the uncustomized tpac still be able to return records or does it need some basic level of customization before it will?  Keyword searches that work on her liv
16:15 bshum madseumas: You got cut off at "keyword searches that work on her live"
16:15 bshum IRC has a cap on how much you can type at once.  So just break up the sentences a bit :)
16:16 madseumas argh sorry, will do
16:16 madseumas should read " Keyword searches that work on her live system return nada on this test one."
16:16 ericar mmorgan: yes, first time got TypeError: $("patronStrings").getString is not a function second try got TypeError: $("commonStrings") is null. Held the key for about 2 seconds
16:16 madseumas haven't done IRC in 10 years or so :)
16:17 mmorgan lp 1300789
16:17 pinesol_green Launchpad bug 1300789 in Evergreen "F4 (Search for Patrons) Results in Multiple Popup Errors if Interrupted" (affected: 1, heat: 6) [Undecided,New] https://launchpad.net/bugs/1300789
16:19 bshum madseumas: I would expect even an uncustomized TPAC to return results.  If it's not there may be a few things to check on.
16:19 bshum Are you getting no results in the public catalog vs. staff client catalog search?
16:19 bshum I'd be curious if maybe there are problems with missing 901c entries too in the MARC data which would break TPAC display of a bib.
16:20 * bshum hasn't used JSPAC since 2.0 so is super rusty
16:20 madseumas no results in either.  A strict title search will work, but keyword/subject/etc no results
16:20 csharp madseumas: have you checked the opensrf logs?
16:21 madseumas csharp: no errors in any of the logs
16:21 csharp ok
16:22 csharp madseumas: did you perform post-upgrade db VACUUM ANALYZEs?
16:23 madseumas csharp: no, I didn't, can run those quick.
16:23 * bshum wonders about opac visible copies or reingests
16:24 csharp madseumas: and you did the reingests after each version upgrade?
16:24 csharp (e.g. 2.3-2.4-supplemental.sh)
16:24 rjackson-isl regarding https://bugs.launchpad.net/evergreen/+bug/1300789 this occurrs only on the patron search in how I described in ticket
16:24 pinesol_green Launchpad bug 1300789 in Evergreen "F4 (Search for Patrons) Results in Multiple Popup Errors if Interrupted" (affected: 3, heat: 14) [Undecided,Confirmed]
16:24 rjackson-isl it is repeatable
16:24 madseumas csharp: yes, ran reingests, very carefully followed DB script output from each
16:24 rjackson-isl use F4 and before the screen pops up hit another F key
16:25 dbs madseumas: does the test VM have enough memory? 2.0 GB of RAM or more?
16:25 csharp madseumas: well, at the very least, VACUUM ANALYZE all of the metabib.* tables
16:25 rjackson-isl other sequence such as F1 then F4 does not produce this
16:25 madseumas dbs: test VM has 2GB of RAM.  No memory pressure, catalog is quite small
16:26 dbs although... if title searches are working, one would think all db calls should
16:26 dbs madseumas: heh, 2.0 GB is barely enough for our ~200 test record set with all services running
16:27 csharp yeah, I use a minimum of 4 GB, even on small test servers
16:27 ericar rjackson-isl: I just reproduced the error you describe above. However, it was from holding the F4 key while still trying to use another F key. Also, holding the F4 too long will reproduce the results
16:27 dbs bshum: 901c, yeah, that's something
16:27 csharp but you should see swapping or i/o wait in top when the searches are processed
16:27 madseumas well, hypervisor has 8 GB free so I can ramp it up if need be, but there is no swap and no i/o wait
16:28 dbs madseumas: can you do a very specific author search that matches one of the titles that gets returned from a title search?
16:28 bshum It'd be more problematic coming from before 2.3 but I wonder if JSPAC was more tolerant and so they wouldn't have noticed in their previous use.
16:29 madseumas dbs: let me check, one sec
16:29 csharp madseumas: you can see what happens on the command line when doing searches: http://wiki.evergreen-ils.org/doku​.php?id=scratchpad:random_magic_sp​ells#use_srfsh_to_search_the_opac
16:30 * dbs also wonders about the usual dump/restore lost indexes issue
16:30 madseumas dbs: author search works correctly
16:30 madseumas csharp: will do
16:32 dbs madseumas: wondering if it's the missing 901 fields, then, as bshum suggested
16:33 mrpeters left #evergreen
16:34 madseumas csharp: command line search, limit 10, I see 10 ids being returned
16:34 dbs SELECT COUNT(*) FROM biblio.record_entry WHERE marc !~ 'tag="901"'; -- if you can query the database would be a good test
16:34 dbs Result should be 0.
16:34 madseumas dbs: will do, one sec
16:35 madseumas dbs: result was 11780
16:35 bshum Oops
16:35 bshum :)
16:35 madseumas so, missing 901 fields then? :)
16:37 bshum Perhaps
16:37 bshum So at the end of the 2.1-2.2-upgrade-db.sql script there's some comments explaining problems with 901c missing entries
16:38 madseumas bshum: thanks, will check that.  this is the first upgrade since we moved from 1.6 to 2.3.2 a few years ago
16:39 dbs s/Perhaps/Definitely/ :)
16:40 bshum Maybe something like http://pastie.org/8994997 I guess
16:41 bshum That should run the triggers through on the bibs that either have missing or broken 901c
16:41 Dyrcona bshum: You should try dbs' query again with and deleted = 'f' just to see what that gives.
16:42 bshum Ah true, I forgot to put down deleted in it :(
16:42 bshum We shouldn't have any....
16:44 bshum 0 for us.  Either way.
16:44 bshum As it should be!
16:45 madseumas found the comments at the end of 2.1-2.2 upgrade script.  will snap system and run script.
16:46 Dyrcona Oops. I misread the scroll back.
16:46 Dyrcona Oh well.
16:51 mdriscoll left #evergreen
16:51 dbs berick: https://developer.mozilla.org/en-​US/docs/Web/HTML/Element/datalist now has a live sample for your edification :)
16:56 berick dbs++ # nice!
17:13 madseumas still running, but from what I can see it is correcting it.  Keyword searches are starting to return results.  Thanks guys!
17:13 alynn26 joined #evergreen
17:13 madseumas I must have completely missed that step back when I upgraded a few years ago
17:14 bshum Happens to all of us.
17:14 bshum Ah yes, the (not so) good ol' days.
17:16 dbs madseumas++
17:16 dbs bshum++ # remembering that issue from those days
17:18 madseumas Now to go learn how to customize tpac :)
17:18 mmorgan left #evergreen
17:18 madseumas we've been running this 1.2, but there tends to be long stretches between upgrades
17:18 madseumas err *since 1.2
17:21 bshum madseumas++
17:21 bshum You guys have been working with it longer than me then.  I showed up between 1.4 and 1.6 era.
17:24 madseumas she has a small special library here in the Chicago suburbs, for an educational nonprofit that does adult literacy, ESL, early childhood and a few other things.  Original library was a card catalog, and original librarian passed away (in 1999 or so?), librarian after him turned it all into an un-searchable access database.
17:24 madseumas it was very very horrible :)
17:25 madseumas my wife inherited it after that, and once she found evergreen and she got a grant to get OCLC records we haven't looked back
17:26 hbrennan Access?! Oh jeez.
17:27 madseumas yah, the forms allowed you to search by specific title or author but that was it.  cataloging was a nightmare.
17:27 hbrennan I can only imagine.
17:30 pinesol_green Incoming from qatests: Test Success - http://testing.evergreen-ils.org/~live/test.html <http://testing.evergreen-ils.org/~live/test.html>
17:32 madseumas quick question, where do the default book jackets in a tpac catalog search come from?
17:32 madseumas I had thought google books stuff was turned off by default
17:33 bshum madseumas: By default in newer versions I believe the added content handler is for OpenLibrary
17:33 madseumas ahh thank you
17:39 madseumas bshum: dbs: updates have finished running.  Populating the 901c fields has completely fixed my issue.  thank you so very much, you saved me a bunch of banging my head on walls
17:40 Christineb joined #evergreen
17:47 bshum madseumas: Glad to help where we can. Enjoy the weekend and happy customizing the new catalog.
19:08 madseumas left #evergreen
23:13 ktomita joined #evergreen
23:27 fparks_ joined #evergreen

| Channels | #evergreen index | Today | | Search | Google Search | Plain-Text | summary | Join Webchat