| Time |
Nick |
Message |
| 02:04 |
|
b_bonner joined #evergreen |
| 02:05 |
|
mtcarlson_away joined #evergreen |
| 05:02 |
pinesol_green |
Incoming from qatests: Test Success - http://testing.evergreen-ils.org/~live/test.html <http://testing.evergreen-ils.org/~live/test.html> |
| 07:39 |
|
akilsdonk joined #evergreen |
| 08:28 |
|
mrpeters joined #evergreen |
| 08:34 |
|
Dyrcona joined #evergreen |
| 08:34 |
|
Dyrcona left #evergreen |
| 08:35 |
|
Dyrcona joined #evergreen |
| 08:36 |
|
timf joined #evergreen |
| 08:44 |
|
mmorgan joined #evergreen |
| 08:44 |
|
Shae joined #evergreen |
| 08:50 |
|
jwoodard joined #evergreen |
| 08:52 |
|
kbeswick joined #evergreen |
| 09:07 |
|
ldw joined #evergreen |
| 09:17 |
pinesol_green |
[evergreen|Galen Charlton] LP#1321411: restore ability to handle credit payments using a processor other than Stripe - <http://git.evergreen-ils.org/?p=Evergreen.git;a=commit;h=e2261fe> |
| 09:34 |
|
yboston joined #evergreen |
| 09:45 |
pastebot |
"mrpeters" at 64.57.241.14 pasted "An easier way to audit in-db circ rules via PostgreSQL" (7 lines) at http://paste.evergreen-ils.org/39 |
| 09:46 |
mrpeters |
^^ whipped that up, threw it on random magic spells also |
| 09:46 |
mrpeters |
makes it more similar to what you see in the staff client when editing circ policies |
| 09:47 |
mrpeters |
actually should take it one step more and add copy location |
| 09:47 |
bshum |
mrpeters: http://pastie.org/9199134 |
| 09:47 |
bshum |
That's what we use in our consortium to track circ policy |
| 09:47 |
bshum |
I added limit sets too :) |
| 09:47 |
mrpeters |
oh, shoot, look at me reinventing the wheel again :( |
| 09:47 |
bshum |
We don't circ based on copy locations for us |
| 09:48 |
bshum |
No I probably need to adjust ours anyways |
| 09:48 |
bshum |
Actually definitely |
| 09:48 |
bshum |
It should be more like yours with LEFT OUTER JOIN |
| 09:48 |
bshum |
Not INNER JOIN for those duration, etc. |
| 09:48 |
bshum |
Since there's fall through to consider |
| 09:50 |
* mrpeters |
needs to learn more about which joins to use in various cases |
| 09:51 |
bshum |
I like to think of it as INNER is 1:1 (expect something on both sides to link with) |
| 09:51 |
* Dyrcona |
uses a Perl script to dump everything to an Excel spreadsheet, naturally. |
| 09:51 |
bshum |
LEFT OUTER means expect 1:0 (always something on the left, sometimes something on the right |
| 09:51 |
Dyrcona |
It's available in my evergreen_utilites repo, naturally. |
| 09:51 |
pastebot |
"mrpeters" at 64.57.241.14 pasted "An easier way to audit in-db circ rules via PostgreSQL (now with copy locations)" (8 lines) at http://paste.evergreen-ils.org/40 |
| 09:51 |
mrpeters |
Dyrcona: now that is awesome! |
| 09:52 |
mrpeters |
i just run this with a COPY WITH CSV HEADER but thats pretty sweet |
| 09:52 |
* bshum |
rarely uses RIGHT OUTER JOINs. |
| 09:52 |
mrpeters |
i should have asked around first :( |
| 09:52 |
Dyrcona |
mrpeters: You should reserve your judgment until you see what you actually get. :) |
| 09:54 |
bshum |
Oh I guess I could use string_agg now |
| 09:54 |
bshum |
new_postgresql++ |
| 09:55 |
mrpeters |
Dyrcona: well, i got what i needed from mine but i will give yours a look when i have some free time |
| 09:55 |
mrpeters |
something with my query is boned though, becuase i get the same config.circ_matrix_matchpoint ID value multiple times in some cases |
| 09:56 |
Dyrcona |
mrpeters: Mine ignores a few things because we don't really use them that heavily here. |
| 09:56 |
|
PSM joined #evergreen |
| 09:58 |
PSM |
good morning, I installed eg server 2.6 and was unfortunately unable to restart PostgresSQL using pg_ctl start. I received the error 'command not found', could you help me with this please? |
| 10:01 |
csharp |
PSM: what OS are you on? how did you install postgresql? |
| 10:01 |
pinesol_green |
[evergreen|Remington Steed] Remove buggy, unused function get_leaders_from_usergroup - <http://git.evergreen-ils.org/?p=Evergreen.git;a=commit;h=0575262> |
| 10:02 |
PSM |
ubuntu 12.04 precise, I believe I installed it using software center |
| 10:02 |
csharp |
PSM: then you should probably try 'sudo /etc/init.d/postgresql restart'? |
| 10:03 |
|
kmlussier joined #evergreen |
| 10:08 |
csharp |
PSM: note that if you restart postgresql, you'll also need to restart opensrf |
| 10:08 |
phasefx |
jfyi, and maybe apropos to PSM, I'm redoing the checking_for_errors document for osrf_control |
| 10:09 |
|
ldw joined #evergreen |
| 10:13 |
Bmagic |
im having an issue with /openils/bin/opensrf_router . it is telling me that it can't load libopensrf.so.2 (file not found). When I do an strace, it's looking for it here: /lib/tls/x86_64/libopensrf.so.2 Why? It should be looking for it in /openils/lib right? |
| 10:15 |
tsbere |
Bmagic: Did you do the /etc/ld.so.conf.d/opensrf.conf and ldconfig steps? |
| 10:16 |
Bmagic |
echo "/usr/local/lib/dbd" > /etc/ld.so.conf.d/eg.conf yes |
| 10:16 |
Bmagic |
ldconfig yes |
| 10:16 |
Bmagic |
tsbere: oh wait, let me check opensrf |
| 10:17 |
|
zerick2 joined #evergreen |
| 10:17 |
|
mllewellyn joined #evergreen |
| 10:18 |
Bmagic |
tsbere: echo openils/lib > /etc/ld.so.conf.d/opensrf.conf yes |
| 10:19 |
Bmagic |
tsbere: I may have found it |
| 10:19 |
Bmagic |
contents of /etc/ld.so.conf.d/opensrf.conf was this "openils/lib" It needs the beginning "/" I bet |
| 10:19 |
tsbere |
Bmagic: I was going to mention the missing / from the echo when you said you may have found it |
| 10:20 |
Bmagic |
tsbere: Thanks, sometimes its the simple things |
| 10:20 |
Bmagic |
tsbere++ |
| 10:21 |
PSM |
<csharp> Great, 'sudo /etc/init.d/postgresql restart' worked. Does restarting the computer restart also opensrf? I would like also to ask if there is a certain procedure I have to follow to close eg before shuting down the computer? |
| 10:25 |
Dyrcona |
PSM: Unless you have created your own init scripts, you will want to manually stop OpenSRF before shutting down and starting OpenSRF after starting the computer/vm. |
| 10:25 |
csharp |
PSM: to restart opensrf, you should, as the opensrf user, do 'osrf_ctl -l -a restart_all' (or 'osrf_control --localhost --restart-all' if you're on a newer version) - unless you've created an init/upstart script, you have to do it manually |
| 10:26 |
Dyrcona |
PSM: You will likely have to restart Apache after starting OpenSRF. |
| 10:26 |
csharp |
Dyrcona beat me to it ;-) |
| 10:26 |
Dyrcona |
PSM: Depending on the version of OpenSRF, I'd recommend osrf_control over osrf_ctl.sh. |
| 10:27 |
Dyrcona |
If you don't stop OpenSRF before shutting down, it's usually not a big deal, but you'll get messages about stale PID files when starting OpenSRF after the reboot. |
| 10:32 |
PSM |
Thanks. I have another issue that is still persistent every time I try to save a new record in my Staff Client I receive an error: 'Event: 2002: DATABASE_QUERY_FAILED-> The attempt to query to the DB failed' I would really appreciate if you can help me with this issue as well. |
| 10:38 |
|
ldw joined #evergreen |
| 10:49 |
Dyrcona |
PSM: That's a more difficult problem as bad data or bad code could cause it and without direct access to the hardware to look at logs, it would be difficult to determine what, exactly, is causing your problem. |
| 10:50 |
Dyrcona |
PSM: A good place to start would be the logs on the postgresql server. There should be entries in there with the details of the query that failed. |
| 10:51 |
PSM |
<Dyrcona> Sounds like a good start. Where can I find these logs? |
| 10:51 |
Dyrcona |
PSM: On your server that runs postgres. The location may depend on what gnu/linux distro you use. |
| 10:52 |
PSM |
I am running precise |
| 10:56 |
Dyrcona |
/var/log/postgresql/postgresql-{version}-main.log |
| 10:57 |
Dyrcona |
Where {version} is the version of postgres, like 9.1 or 9.3 or whatever. |
| 10:57 |
PSM |
9.1 |
| 11:06 |
PSM |
<Dyrcona> got it, following are few of the lines that I copied from postgresql log file 2014-05-22 09:11:50 CDT LOG: database system is shut down 2014-05-22 09:13:10 CDT LOG: database system was shut down at 2014-05-22 09:11:50 CDT 2014-05-22 09:13:10 CDT LOG: database system is ready to accept connections 2014-05-22 09:13:10 CDT LOG: autovacuum launcher started 2014-05-22 09:13:10 CDT LOG: incomplete startup packet 2014-05-22 0 |
| 11:07 |
PSM |
<Dyrcona> 2014-05-22 09:14:42 CDT ERROR: "search_result" is a composite type at character 15 2014-05-22 09:14:42 CDT STATEMENT: SELECT * FROM search.search_result AS x WHERE 1=0; 2014-05-22 09:14:42 CDT ERROR: "search_result" is a composite type at character 15 2014-05-22 09:14:42 CDT STATEMENT: SELECT * FROM search.search_result AS x WHERE 1=0; 2014-05-22 09:14:42 CDT ERROR: "search_result" is a composite type at character 15 2 |
| 11:08 |
Dyrcona |
PSM: Stop pasting all that in the channel, please. |
| 11:08 |
PSM |
ok |
| 11:09 |
Dyrcona |
Here's what I suggest: tail -f /var/log/postgresql/postgresql-9.1-main.log |
| 11:10 |
Dyrcona |
Have the window with that visible while you try to add a record in the staff client. |
| 11:10 |
Dyrcona |
you should see the error go scrolling by in the window with the tail -f running. |
| 11:12 |
PSM |
ok, let me try |
| 11:18 |
PSM |
<Dyrcona> the first line of the errors says: CDT ERROR: new row for relation "lineitem" violates check constraint "picklist_or_po" |
| 11:20 |
|
RoganH joined #evergreen |
| 11:21 |
PSM |
<Dyrcona> may be the second line will you give more light, it says: CDT STATEMENT: INSERT INTO acq.lineitem |
| 11:21 |
Dyrcona |
Ah, you're trying to create records via acquistions, it sounds like. |
| 11:22 |
Dyrcona |
I don't really know much about acquisitions. |
| 11:22 |
PSM |
that's right |
| 11:22 |
Dyrcona |
You should use New MARC Record from the CAtaloging menu. |
| 11:23 |
PSM |
I tried that, but was unable to type in the typing places, but I will try that again now |
| 11:24 |
dbwells |
grabbing 0881 |
| 11:28 |
PSM |
<Dyrcona> I went to Cataloging, load, Create Record, I can click next to title where it gives me a space to type, but no entries can be done, same problem also when I try to go to add volumes. I noticed there is no new logs in the postgresql log file |
| 11:30 |
pinesol_green |
[evergreen|Jason Etheridge] LP#1314920 change the desc for the org hiding setting - <http://git.evergreen-ils.org/?p=Evergreen.git;a=commit;h=4dbe9b1> |
| 11:30 |
pinesol_green |
[evergreen|Dan Wells] LP#1314920 Stamping upgrade script - <http://git.evergreen-ils.org/?p=Evergreen.git;a=commit;h=5beaf3a> |
| 11:31 |
Dyrcona |
PSM: At that point, I don't think you're even getting to the database. |
| 11:32 |
Dyrcona |
PSM: Your problems are more complicated than I can help with over IRC. I suggest you reinstall everything. |
| 11:34 |
PSM |
<Dyrcona> Ok, this is a new installation, I installed server 2.6 by mistake, would you suggest I reinstall 2.6 or go with 2.5 instead? |
| 11:35 |
Dyrcona |
PSM: I don't understand why you say you installed 2.6 by mistake? It is the latest version. |
| 11:37 |
PSM |
<Dyrcona> It's because eg download site says 'Currently the latest release from the Evergreen 2.5 series is recommended for new installations' which I haven't read before I started |
| 11:39 |
kmlussier |
Downloads page needs to be updated? |
| 11:39 |
* kmlussier |
can do it unless bshum beats me to it. |
| 11:40 |
bshum |
kmlussier: I'm at a day conference and intermittently here and there today. |
| 11:40 |
bshum |
So you can beat me to it ;) |
| 11:40 |
kmlussier |
Happy to. :) |
| 11:41 |
Dyrcona |
PSM: I recommend using git to get the code directly from the repositories and install the master branch. I do not recommend using the release tarballs. |
| 11:42 |
bshum |
PSM: That said, 2.6 is supposed to be the recommended version on the downloads page. |
| 11:43 |
kmlussier |
Done |
| 11:43 |
bshum |
kmlussier++ |
| 11:44 |
PSM |
I am glad to hear that and thanks for updating the website so quickly. Where can I find the instructions to use git and to install the master branch as you kindly recommended? |
| 11:45 |
Dyrcona |
PSM: There aren't any such instructions because I'm the only who recommends doing it that way. Everyone else recommends the tarballs. |
| 11:46 |
Dyrcona |
You either have the patience to figure it out, or you don't. |
| 11:46 |
PSM |
<Dyrcona> I would love to do it your way, if you tell how to. |
| 11:59 |
PSM |
I am sorry I have to go now. I will try to reinstall 2.6 as you kindly suggested. Thanks for the excellent support I received today. |
| 12:04 |
pinesol_green |
[evergreen|Josh Stompro] (doc) add overdues to summary of the phone list feature - <http://git.evergreen-ils.org/?p=Evergreen.git;a=commit;h=926ac84> |
| 12:04 |
pinesol_green |
[evergreen|Josh Stompro] (doc) 'debian-wheezy' was left out of the OS options - <http://git.evergreen-ils.org/?p=Evergreen.git;a=commit;h=d286fbe> |
| 12:04 |
|
pmurray joined #evergreen |
| 12:07 |
|
bmills joined #evergreen |
| 12:15 |
|
vlewis joined #evergreen |
| 12:59 |
|
kmlussier joined #evergreen |
| 12:59 |
|
RoganH joined #evergreen |
| 13:03 |
|
hbrennan joined #evergreen |
| 13:08 |
|
dMiller_ joined #evergreen |
| 13:12 |
|
dluch joined #evergreen |
| 13:28 |
|
ldw joined #evergreen |
| 13:33 |
|
jeffdavis joined #evergreen |
| 13:39 |
|
kayals joined #evergreen |
| 13:42 |
jeff |
syslog and Data::Dumper aren't good friends. |
| 13:42 |
jeff |
especially not Dumper(\$ctx) in tpac :-) |
| 13:55 |
|
jwoodard joined #evergreen |
| 14:06 |
jboyer-isl |
gmcharlt: I've got a commit for contrib/equinox that adds holds extracts to CollectionHQ, would it be best to just send the details here, or via email, or via someone else entirely? (Don't want to be a bother) |
| 14:06 |
gmcharlt |
jboyer-isl: shoot me an email |
| 14:06 |
gmcharlt |
and thanks! |
| 14:06 |
jboyer-isl |
On it's way. |
| 14:09 |
phasefx |
ha, lost my unsaved work in the wiki when firefox crashed |
| 14:09 |
|
PSm joined #evergreen |
| 14:09 |
jeff |
you should have bought a squirrel! |
| 14:09 |
* phasefx |
will edit in vim from now on :-) |
| 14:09 |
jeff |
and by "bought a squirrel", I mean "edited outside the browser" |
| 14:09 |
jeff |
:-) |
| 14:09 |
phasefx |
brought it on myself |
| 14:11 |
* phasefx |
usually uses chrome, but there's this web app that actually exercises a chrome bug :( |
| 14:11 |
PSm |
Hi, I am trying to install staff client 2.6 on my server 2.6 Currently I am at the step 4 'download the 32-bit or 64-bit version of the staff client from your Web server at http://hostname/updates/manualupdate.html' I am not sure where can I find this download, could you help me please? |
| 14:12 |
phasefx |
PSm: if you're not going for a self-upgrading client, I would just download the client from evergreen-ils.org |
| 14:12 |
Dyrcona |
PSm: You have to have built the staff client during the server installation for that to exist. |
| 14:13 |
phasefx |
is that actually in installation instructions somewhere? |
| 14:13 |
Dyrcona |
probably on the wiki's staff client pages somewhere. |
| 14:13 |
phasefx |
PSm: step 4 where? |
| 14:14 |
PSm |
here http://docs.evergreen-ils.org/2.3/_installing_on_linux.html |
| 14:14 |
Dyrcona |
PSm: I don't recommend you run the staff client on the server. |
| 14:15 |
Dyrcona |
PSm: You should use these docs instead http://docs.evergreen-ils.org/2.6/ |
| 14:16 |
phasefx |
I think that section of the documentation is inconsistent/misleading.. compare Installing on Windows with Installing on Linux |
| 14:17 |
phasefx |
not enough tuits |
| 14:18 |
* dbs |
likes the header at http://www.postgresql.org/docs/8.0/interactive/mvcc.html which lists the Unsupported Versions of the docs. Could still use a clearer "unsupported" warning for any given page though |
| 14:18 |
dbs |
Something like a "WARNING: This version of the softare is no longer supported." watermark |
| 14:19 |
Dyrcona |
If you do step 3 before step2, then you don't have to be root to do step 2. |
| 14:20 |
Dyrcona |
You also have to restart Apache, I think before step 4 works, but I usually build my clients while installing the rest of the server components. |
| 14:21 |
Dyrcona |
PSm: You really only need to do the steps on that page if you use a custom staff client version for some reason. This means most people, probably including you, don't have to do those steps. |
| 14:21 |
phasefx |
I think it'd be kind of neat to have localized overlays for the docs too.. encourage some of the big sites to improve the main documentation instead of writing their own, and just have the local site-specific stuff in "sidebars" and "examples" that could be filtered out |
| 14:22 |
dbs |
hmm, downloads page links to http://evergreen-ils.org/dokuwiki/doku.php?id=evergreen-user:installing_and_running_the_staff_client#installing_on_linux for building and installing the client |
| 14:23 |
Dyrcona |
PSm: Step four assumes you are on a different computer from the server and that you replace "hostname" with the fully qualified domain name of your Evergreen server. |
| 14:23 |
dbs |
mebbe we should get that sorted out |
| 14:23 |
bshum |
dbs: Sigh, yeah, that's the traditional link from past website versions. Back from before we had actual Linux builds. |
| 14:24 |
bshum |
Could probably just remove it |
| 14:24 |
dbs |
phasefx: that sounds confusing and likely unworkable to me. better to encourage them to fork the git docs repo, build their own local version of the docs, and make their docs openly available under a CC-BY-SA license so DIG can roll whatever they want back in |
| 14:24 |
Dyrcona |
dbs: Those instructions are ever worse and mostly untrue. |
| 14:24 |
bshum |
And link to the tarballs for Linux? |
| 14:24 |
dbs |
bshum++ # yes |
| 14:26 |
phasefx |
dbs: I can dream; I doubt anything will happen along either of those lines :) but take a drop-down for switching languages on the fly, and just extend the concept. That's what I was thinking |
| 14:27 |
dbs |
We basically jumpstarted the docs thanks to SITKA and Michigan Evergreen and a few others who had their own local docs |
| 14:28 |
bshum |
dbs: I'll try and take a poke at it later this afternoon if someone else doesn't get there first. I'm at a day conference and learning about OpenStack right now :) |
| 14:30 |
PSm |
Do you think I should not install client same machine as the server, not even to be able to test the DB? |
| 14:31 |
Dyrcona |
PSm: I'd recommend downloading a client to your local computer and testing it from there. |
| 14:31 |
PSm |
ok, thanks for the advice |
| 14:34 |
Dyrcona |
bshum: Kill it with fire. Those instructions are for 1.6! |
| 14:36 |
|
Callender joined #evergreen |
| 15:04 |
|
mllewellyn left #evergreen |
| 15:09 |
hbrennan |
Dyrcona: You can have the 45,000 acres of forest burning 50 miles from my house. :) |
| 15:09 |
hbrennan |
(Yeah, that was a 40 minute delayed joke) |
| 15:10 |
Dyrcona |
hbrennan: Oh, thank you! You can send the title to my agent in Anchorage. He works for the state library. |
| 15:11 |
hbrennan |
Dyrcona: :) |
| 15:11 |
Dyrcona |
hbrennan: Sorry to hear about the fire. Hopes it hasn't been deadly. |
| 15:12 |
hbrennan |
Not so far. Poor moose though.. it's calving season |
| 15:15 |
* berick |
looks up for a second... returns to his 1's and 0's |
| 15:19 |
kmlussier |
hbrennan: Still smoky there? |
| 15:20 |
hbrennan |
kmlussier: Yes. It's so gross! Straight from terrible pollen to smoke and ash falling... |
| 15:21 |
hbrennan |
https://www.facebook.com/photo.php?fbid=877018186806&l=c433076f9b |
| 15:21 |
hbrennan |
There's a photo of what the sun and sky looked like the other day |
| 15:22 |
kmlussier |
Terrible. I think I would prefer the pollen. |
| 15:22 |
bshum |
dbs: I pulled the link to that horribly old wiki page. And then I put the 32-bit and 64-bit package file links for the various versions. |
| 15:22 |
hbrennan |
Me too. At least it was yellow. :) |
| 15:22 |
hbrennan |
Okay, my show and tell is over. Back to work! |
| 15:23 |
dbs |
bshum++ |
| 15:23 |
bshum |
Just to get us moving in the right direction again for now. |
| 15:43 |
mrpeters |
if i'm reading Holds.pm correctly, an error such as: "Can't call method "id" on an undefined value at /usr/local/share/perl/5.14.2/OpenILS/Application/Circ/Holds.pm line 3261." would indicate it |
| 15:43 |
mrpeters |
is trying to pull a hold where the target doesnt exist? |
| 15:45 |
tsbere |
mrpeters: Maybe? Not sure what the actual contents of that line is in your system compared to my dev machine |
| 15:46 |
mrpeters |
2.3.5 -- let me paste |
| 15:46 |
mrpeters |
oh, thats surely it |
| 15:46 |
mrpeters |
SELECT id, target, hold_type FROM action.hold_request WHERE requestor IN (SELECT id FROM actor.usr WHERE home_ou=117) AND hold_type='T' AND target NOT IN (SELECT id FROM biblio.record_entry); |
| 15:47 |
mrpeters |
yep, thats gonna cause a problem lol |
| 15:48 |
tsbere |
mrpeters: Fun query: SELECT ahr.* FROM action.hold_request ahr LEFT JOIN reporter.hold_request_record rhrr USING (id) WHERE rhrr.bib_record IS NULL; |
| 15:48 |
mrpeters |
actually, the issue is they are mapped as T holds and should be C |
| 15:48 |
mrpeters |
easy peasy fix |
| 15:49 |
|
dkyle left #evergreen |
| 15:51 |
|
jihpringle joined #evergreen |
| 16:01 |
|
akilsdonk joined #evergreen |
| 16:26 |
jeff |
pretty sure this FIRST() is pointless, but would appreciate a sanity check: FIRST((SELECT create_date FROM biblio.record_entry rbr WHERE rbr.id = m.source)) |
| 16:27 |
tsbere |
jeff: I can't give you a sanity check without the rest of the query. |
| 16:28 |
tsbere |
jeff: If something other than m.source is being grouped by, for example, thus leaving the potential of multiple lookups like that, then it is, in fact, doing something useful... |
| 16:31 |
jeff |
tsbere: right around here: http://git.evergreen-ils.org/?p=Evergreen.git;a=blob;f=Open-ILS/src/perlmods/lib/OpenILS/Application/Storage/Driver/Pg/QueryParser.pm;h=147b16571eb73ba8b08ae9fa5b02afafdc21d680;hb=HEAD#l816 |
| 16:32 |
tsbere |
jeff: When doing a standard search it is less useful. When doing a metarecord search it is more useful. |
| 16:35 |
tsbere |
jeff: That is not to say it couldn't be done more efficiently in some cases. I haven't double-checked, but when biblio.record_entry is in the joins *anyway* we can probably skip the subquery... |
| 16:37 |
tsbere |
jeff: Are you seeing a problem with it, or just trying to improve search speeds? |
| 16:42 |
jeff |
tsbere: I created a problem for myself when playing with a container_date sort, and that made me look at and question the use of FIRST() there. See the two tip commits here: http://git.evergreen-ils.org/?p=working/Evergreen.git;a=shortlog;h=refs/heads/user/jeff/container_date_sort |
| 16:42 |
yboston |
I am customizing my TPAC skin/theme and wondering if there is a way to analyze the DOM of the TPAC HTML that is loaded inside the EG client? |
| 16:42 |
yboston |
The reason is that the custom skin works well when just using TPAC in a browser, but when searching the catalog within the browser I am having some issues |
| 16:42 |
yboston |
I see that there is an option inside the client for a DOM inspecotr, but it is grayed out. For the record, I am running 2.5.1 |
| 16:46 |
tsbere |
jeff: I might have solved your second commit's problem with something along the lines of wrapping create_time in an aggregate. MIN(create_date) instead of ordering with limit and all. Dunno which is actually going to be faster though... |
| 16:47 |
|
ldw joined #evergreen |
| 16:47 |
jeff |
hrm. yeah, not sure why i didn't go that route, now that i think about it. |
| 16:48 |
jeff |
though in the case of the route i selected, I'd use MAX() |
| 16:52 |
tsbere |
jeff: I would have been tempted to teach the container stuff to drop the filter_alias into a visible spot and have it put the relevant data there. Then container_<filter alias>.whatever would be available without a subquery for sorting. Again, haven't done any analysis for performance reasons, but that would also mean you don't have to worry about container type. The first container of any type could be used. |
| 16:55 |
jeff |
i like the direction of that. it might be a good second approach. |
| 16:55 |
jeff |
this is mostly proof of concept (though it has escaped into production) |
| 16:56 |
Dyrcona |
yboston: You might be able to download the DOM instpector from addons.mozilla.org. I got Venkman that way. |
| 16:56 |
Dyrcona |
Venkman == JavaScript debugger. |
| 16:59 |
* Dyrcona |
disappears in a puff of logic. |
| 17:00 |
|
kmlussier left #evergreen |
| 17:19 |
|
mmorgan left #evergreen |
| 17:35 |
|
bmills joined #evergreen |
| 17:35 |
pinesol_green |
Incoming from qatests: Test Success - http://testing.evergreen-ils.org/~live/test.html <http://testing.evergreen-ils.org/~live/test.html> |
| 19:55 |
|
gamambel joined #evergreen |
| 19:56 |
gamambel |
is it possible to federate libraries with evergreen? i want users to be able to return books at a different library, for example, but have the libraries run independent instances |
| 20:45 |
|
kbeswick joined #evergreen |
