| Time |
Nick |
Message |
| 04:42 |
|
dickreckard joined #evergreen |
| 04:44 |
dickreckard |
uhm do you have any idea what could it be, if i can authenticate via srfsh and the web interface, but keeps failing with the staff client? and when it fails i get a 503 service unavailable in the jabber logs |
| 05:11 |
dickreckard |
well since it doesn't work anyway i'll update to 3.1.2 and see :P |
| 06:30 |
pinesol_green |
News from qatests: Testing Success <http://testing.evergreen-ils.org/~live> |
| 07:07 |
|
JBoyer joined #evergreen |
| 07:16 |
|
rjackson_isl joined #evergreen |
| 07:17 |
|
agoben joined #evergreen |
| 07:19 |
|
annagoben joined #evergreen |
| 07:21 |
|
agoben joined #evergreen |
| 07:33 |
|
justin___ joined #evergreen |
| 07:33 |
justin___ |
hello |
| 07:33 |
justin___ |
i just started a fellowship working at a small library in senegal (i am american) |
| 07:34 |
justin___ |
the staff would like software to manage their collection, and im trying to figure out if evergreen (or koha?) would be better |
| 07:35 |
justin___ |
one big problem is that the internet here goes in and out a lot |
| 07:36 |
justin___ |
ideally, an ILS that could stay updated over multiple terminals through intranet would be helpful |
| 07:54 |
|
jvwoolf joined #evergreen |
| 07:59 |
|
jvwoolf1 joined #evergreen |
| 08:03 |
csharp |
gsams++ # pushing a fix |
| 08:04 |
csharp |
gsams: I overlooked your comment yesterday |
| 08:24 |
|
collum joined #evergreen |
| 08:33 |
|
Dyrcona joined #evergreen |
| 08:35 |
Dyrcona |
@later tell Jaswinder: The table with auto-increment ids that doesn't return the id with pcrud, is that a table that you added or is it an existing table in Evergreen? |
| 08:35 |
pinesol_green |
Dyrcona: The operation succeeded. |
| 08:42 |
|
mmorgan joined #evergreen |
| 08:43 |
|
kmlussier joined #evergreen |
| 08:53 |
dickreckard |
is there a way to delete all records, copies, volumes and buckets, but keep all the rest of the db like copy locations, holding import profiles, etc..? |
| 08:53 |
|
lsach joined #evergreen |
| 08:55 |
|
bos20k joined #evergreen |
| 08:56 |
JBoyer |
dickreckard, You can, but it's a very manual process because you've got to disabled a lot of checks and constraints. There's no way in the interface to do any of it. |
| 08:57 |
dickreckard |
so you suggest to just start the db over |
| 09:03 |
dickreckard |
with build-db.sh |
| 09:04 |
JBoyer |
That depends on how much you're trying to save. If it's just a couple org units and a few locations I'd probably just do that, yeah. |
| 09:20 |
|
yboston joined #evergreen |
| 09:21 |
Dyrcona |
dickeckard: Quickest thing is dump the table data you want to keep with pg_dump's --data-only option, then rebuild just the schema, and restore the dump. |
| 09:22 |
Dyrcona |
Well, I say "quickest," but depending on what you've already got, it may not be. :) |
| 09:22 |
|
beanjammin joined #evergreen |
| 09:23 |
dickreckard |
JBoyer: Dyrcona tnx both ;) |
| 09:24 |
dickreckard |
JBoyer++ Dyrcona++ |
| 09:24 |
Dyrcona |
My method may run into duplicate key issues, depending.... |
| 09:24 |
dickreckard |
another thing, is the auto-suggest system working on the catalog search? i activated it in theory in the global flags, but dont see any change.. |
| 09:25 |
|
dwgreen joined #evergreen |
| 09:29 |
dickreckard |
funny, the copy locations must be saved somewhere else cos they survived the dbdrop ! |
| 09:30 |
dickreckard |
or maybe some cache somehow |
| 09:30 |
JBoyer |
Possibly in the output of autogen.sh, because they're gone, gone, gone. |
| 09:34 |
|
dkyle1 joined #evergreen |
| 09:40 |
|
jwoodard joined #evergreen |
| 09:48 |
|
Christineb joined #evergreen |
| 09:51 |
gsams |
csharp: To be fair it was late for most people in here. |
| 09:51 |
csharp |
:-) |
| 09:52 |
gsams |
I was too excited not to say something here though. |
| 09:52 |
gsams |
thanks for signing off on it! |
| 09:53 |
csharp |
gsams++ # happy to do it |
| 09:57 |
miker |
csharp: thanks for working on the bundling stuff. we can actually get rid of the first 2 hunks in d807d8ae329f78890d33ed0500c88741679f10b1 since that's automatic. it was transfering from chunk to bundle that needed the can() tests. the third can stay (and is a good example of the method dynamically adjusting when necessary) |
| 09:57 |
* miker |
runs to a meeting |
| 10:00 |
mmorgan |
gsams++ |
| 10:02 |
kmlussier |
gsams++ |
| 10:20 |
remingtron |
gsams++ #fixing stuff |
| 10:39 |
Dyrcona |
gsams++ |
| 10:41 |
Dyrcona |
Sometimes, putting things in IRC is a bad way to make a note. |
| 10:42 |
Dyrcona |
I recall saying that I wanted to make a PostgreSQL setting change in the past few months, but I can't find in my local logs. |
| 10:51 |
Dyrcona |
Oh well.... |
| 10:52 |
|
dwgreen joined #evergreen |
| 11:06 |
|
tlittle joined #evergreen |
| 11:17 |
|
stephengwills joined #evergreen |
| 11:18 |
|
jvwoolf joined #evergreen |
| 11:21 |
dbs |
tlittle: i'm working on your pubkey request |
| 11:21 |
|
terran joined #evergreen |
| 11:42 |
|
khuckins joined #evergreen |
| 11:47 |
|
idjit joined #evergreen |
| 12:08 |
rhamby |
Hack-A-Way 2018 details are starting to emerge: https://wiki.evergreen-ils.org/doku.php?id=hack-a-way-2018 |
| 12:08 |
|
beanjammin joined #evergreen |
| 12:10 |
csharp |
cool - right near our new office |
| 12:10 |
rhamby |
csharp: coolness, where is your new office at? That area is just down the road from me. |
| 12:11 |
csharp |
rhamby: right across from Gwinnett Place mall - office park is called Satellite Place I think? |
| 12:12 |
rhamby |
csharp: sounds familiar, I drive through there pretty regularly |
| 12:12 |
csharp |
we'll be 3 miles from the venue |
| 12:12 |
rhamby |
I live off Sugarloaf down towards Lawrenceville |
| 12:12 |
csharp |
ah - cool |
| 12:13 |
csharp |
I anticipate needing to (re-)learn all the back roads in that area between Duluth and Tucker |
| 12:13 |
* csharp |
lived in the Gwinnett County end of Tucker in the late 90s |
| 12:14 |
berick |
rhamby++ |
| 12:14 |
|
yboston joined #evergreen |
| 12:14 |
csharp |
for Stanger Things fans, I understand that Gwinnett Place is the setting for the mall in the upcoming season |
| 12:14 |
|
jihpringle joined #evergreen |
| 12:15 |
rhamby |
csharp: yeah, they've got one end of the mall setup with a bunch of 80s looking stores and you can walk through it when they're not shooting |
| 12:15 |
csharp |
not too hard - not many upgrades to that mall since it was built |
| 12:16 |
* csharp |
remembers when that mall was the largest in Georgia (the world?) |
| 12:23 |
phasefx |
kmlussier: https://www.humblebundle.com/books/pocket-primers-books |
| 12:28 |
csharp |
dbs++ # helpin' |
| 12:31 |
|
yboston joined #evergreen |
| 12:52 |
|
bdljohn joined #evergreen |
| 13:30 |
jonadab |
Hmm, how do I tell launchpad what my freenode nicks are? |
| 13:31 |
jeff |
jonadab: if you go to https://launchpad.net/~username (where username is your launchpad username) you may see an IRC: section with a yellow edit button. |
| 13:31 |
kmlussier |
jonadab: Click your name and then click Edit Details. |
| 13:32 |
jeff |
or just https://launchpad.net/~username/+editircnicknames seems to get there also |
| 13:32 |
kmlussier |
Yes, what jeff said. Change Details doesn't get you there. |
| 13:34 |
jonadab |
Ah, ok, found it now, thanks. |
| 13:44 |
jeff |
and with some exploration, https://launchpad.net/~/+editircnicknames seems to be the way to link to that page for your currently signed in user, without knowing your username. |
| 13:48 |
kmlussier |
jeff++ |
| 13:53 |
jonadab |
jeff++ indeed |
| 14:03 |
jeffdavis |
bug 1775234 |
| 14:03 |
pinesol_green |
Launchpad bug 1775234 in Evergreen "New user added to wrong group if actor.usr id and usrgroup sequences are out of sync" [Undecided,New] https://launchpad.net/bugs/1775234 |
| 14:04 |
JBoyer |
csharp, I think you're going to want to look at bug 1768022 in reference to your bug 1469758 ... |
| 14:04 |
pinesol_green |
Launchpad bug 1768022 in Evergreen "Webclient Holds Pull List Returns 0 Results" [Undecided,New] https://launchpad.net/bugs/1768022 |
| 14:04 |
pinesol_green |
Launchpad bug 1469758 in Evergreen "Simplified Pull List Interface query is very slow" [Undecided,Triaged] https://launchpad.net/bugs/1469758 |
| 14:12 |
jeffdavis |
So that bug I just posted seems like a significant privacy issue. I'm not sure how common it is for the id and usrgroup sequences to be out of sync, but it creates quite a mess. |
| 14:13 |
jeffdavis |
I'm not sure of the scope of usergroup functionality though. |
| 14:31 |
csharp |
JBoyer: thanks! - I'll take a look |
| 14:31 |
JBoyer |
jeffdavis, I haven't looked at the group code that closely but my assumption is that groups consist of all of those users that have the same group number and it needn't be related to anyone's actual id. Are you seeing the same group id being assigned to unrelated users? |
| 14:33 |
jeffdavis |
I'm seeing cases where the usrgroup sequence falls behind, so a new user gets created with id = 100 and usrgroup = 99. In some cases usr id = 99 already exists so the two end up as a group, even if they're unrelated. |
| 14:35 |
jeffdavis |
I could be wrong and there's no link at all between id and usrgroup. |
| 14:35 |
JBoyer |
In that situation does user id=99 also have a usrgroup field of 99 or is it something else? |
| 14:36 |
JBoyer |
In my understanding there shouldn't be a link, no. if your id is 50 and your usrgroup is 75, you're not a member of both groups, only 75. |
| 14:37 |
JBoyer |
Otherwise you couldn't "group" anyone. |
| 14:37 |
JBoyer |
(Like I said though, assumptions. I'm not clear what features act on groups either and haven't looked in depth) |
| 14:38 |
jeffdavis |
My understanding was that the usrgroup is the id of the "group lead" user. |
| 14:41 |
JBoyer |
That's the au.master_account boolena. |
| 14:43 |
JBoyer |
If an account has this: id=42, usrgroup=50, master_account=t, they're the lead of all other members of group 50, but they're not a part of group 42. |
| 14:49 |
csharp |
jeffdavis: that sounds very very familiar - we dealt with that issue or similar several years ago |
| 14:49 |
csharp |
I'll do some digging to see what we did |
| 14:49 |
csharp |
I *thought* it was reported as a bug |
| 14:53 |
jeffdavis |
Thanks JBoyer (and csharp), sounds like I'm wrong about the mechanism. We do have a bunch of mis-grouped patrons though. |
| 14:54 |
JBoyer |
I have heard that things get funky with groups and the web client, but I haven't looked into that much either. |
| 14:54 |
jeffdavis |
It came to our attention via Group Fines displaying in the web client. |
| 14:56 |
jeffdavis |
Some of the fines included in group fines included unrelated patrons from completely different libraries. |
| 14:59 |
JBoyer |
Because I don't want to inadvertently poison the well (or the logs) I did go look up the implementation of open-ils.actor.usergroup.members.retrieve and it does basically boil down to "select id from actor.usr where not deleted and usrgroup={}" |
| 15:00 |
JBoyer |
So that's good. However, if the usrgroup field isn't set appropriately somehow (web client registration weirdness, etc.?) then that does need to be addressed. |
| 15:03 |
phasefx |
I think the original mechanism for creating grouped users was the Save & Clone method from registration. And then we later got the existing group manipulation functions (everyone is in at least a group of just themselves) |
| 15:03 |
JBoyer |
jeffdavis, are all of the users that are mis-groups "newer" users or does it appear to be spread out a bit? |
| 15:05 |
StomproJ |
Does anyone know if there is a loc.gov services status page? Z39.50 searches of loc have been failing for us after the first few in an hour, and I cannot get id.log.gov/search to return anything. |
| 15:09 |
|
mmorgan joined #evergreen |
| 15:13 |
jeff |
I wonder if there is pcrud-focused group fines logic in the web client that is using incorrect logic. |
| 15:14 |
jeff |
either by way of a wrong/old IDL def or query. |
| 15:15 |
|
stephengwills joined #evergreen |
| 15:19 |
jeff |
jeffdavis: can you clarify where the group fines display for you? |
| 15:25 |
jeffdavis |
It's a data issue, not a retrieval/display issue. I am looking in the database at two accounts with the same usrgroup value. One account has a home_ou in BC and the other in Manitoba. |
| 15:25 |
jeffdavis |
jeff: I believe this is the Group Fines total that appears in the left-hand patron summary sidebar below Fines Owed. |
| 15:26 |
jeffdavis |
I don't think the fines themselves are displayed on the patron account, not sure if there is a way to view them from a non-master account? |
| 15:35 |
|
khuckins joined #evergreen |
| 15:47 |
|
stephengwills joined #evergreen |
| 15:58 |
|
khuckins_ joined #evergreen |
| 16:06 |
idjit |
hello #evergreen. i just updated bug 1775216. the pullrequest involves a tweak to a database function defined Open-ILS/src/sql/Pg/040.schema.asset.sql. what else should i be updating? the same function is defined in various files in Open-ILS/src/sql/Pg/version-upgrade and Open-ILS/src/sql/PG/upgrade. |
| 16:06 |
pinesol_green |
Launchpad bug 1775216 in Evergreen "Inconsistency between client and opac availability counts for statuses with is available flag" [Medium,Confirmed] https://launchpad.net/bugs/1775216 |
| 16:06 |
idjit |
s/PG/Pg/ |
| 16:12 |
|
yboston joined #evergreen |
| 16:14 |
|
beanjammin joined #evergreen |
| 16:15 |
dbs |
why is it that http://docs.evergreen-ils.org/ for 3.1 and master still only show the 3.0 release notes? |
| 16:15 |
jeffdavis |
idjit: you should include both a change to 040.schema.asset.sql and an upgrade script in Open-ILS/src/sql/PG/upgrade that makes the same change to an existing install (e.g. by doing CREATE OR REPLACE FUNCTION if you have modified a function definition) |
| 16:16 |
jeffdavis |
dbs: bug 1773404 ? |
| 16:16 |
pinesol_green |
Launchpad bug 1773404 in Evergreen "Consolidated Manual documentation for 3.1 appears to be for 3.0" [Undecided,Confirmed] https://launchpad.net/bugs/1773404 |
| 16:19 |
idjit |
jeffdavis++ # thanks! i'll update the branch. |
| 16:21 |
dbs |
jeffdavis: thanks, I'll poke at it |
| 16:27 |
|
mmorgan1 joined #evergreen |
| 16:36 |
pinesol_green |
[evergreen|abneiman] LP#1773404 Update root.adoc to show 3.1 release notes - <http://git.evergreen-ils.org/?p=Evergreen.git;a=commit;h=14d534c> |
| 16:41 |
mmorgan |
I have a dumb question about bookings |
| 16:42 |
mmorgan |
A patron picks up a booked item. The item gets Checked out status, but there's no associated row in the circ table. |
| 16:42 |
mmorgan |
I look up the item, see it's checked out, but how do I see who has it? |
| 16:47 |
phasefx |
mmorgan: look in booking.reservation |
| 16:48 |
phasefx |
incidentally, booking.reservation, action.circulation, and money.grocery are all child tables of money.billable_xact |
| 16:50 |
mmorgan |
Look in booking.reservation in the database? I don't see "Reservation" as an option under "Booking" in the client. |
| 16:50 |
phasefx |
sorry, I live in the database. Not sure about from a UI perspective :( |
| 16:51 |
mmorgan |
makes sense that booking.reservation would be a child table of money.billable_xact, thanks for mentioning that. |
| 16:51 |
mmorgan |
Yes, I'm happy in the db, too, but the question came from someone who uses the client. |
| 16:52 |
mmorgan |
I can't see a way of getting to the reservation from the item. |
| 16:52 |
phasefx |
mmorgan: web client or xul? |
| 16:52 |
mmorgan |
xul, atm, I'll check the web client. |
| 16:55 |
mmorgan |
Can't see a way to do it in the web client, either. I can see the patron if I return the item, but then I've returned the item... |
| 16:56 |
|
kmlussier joined #evergreen |
| 17:00 |
phasefx |
mmorgan: yeah, I'm not seeing anything obvious either |
| 17:03 |
phasefx |
well, if we ever wanted to reproduce the g.my_libs_tree is null error, we have it on demo.evergreencatalog.com for the admin user on the xul client :) |
| 17:08 |
mmorgan |
phasefx++ # thanks for looking! |
| 17:09 |
|
mmorgan left #evergreen |
| 17:09 |
phasefx |
@later tell mmorgan I was able to create a lookup report with the web reporter. Klunky, but it works |
| 17:09 |
pinesol_green |
phasefx: The operation succeeded. |
| 17:11 |
phasefx |
worthy of a bug report/wishlist, IMO |
| 17:43 |
|
beanjammin joined #evergreen |
| 18:30 |
pinesol_green |
News from qatests: Testing Success <http://testing.evergreen-ils.org/~live> |
| 21:57 |
|
stephengwills joined #evergreen |
| 22:16 |
|
stephengwills joined #evergreen |
| 22:33 |
|
stephengwills joined #evergreen |
