2009-07-14T00:30:26 *** gmcharlt has joined #OpenILS-Evergreen 2009-07-14T00:42:09 *** dbs has quit IRC 2009-07-14T01:09:11 *** gmcharlt has quit IRC 2009-07-14T01:54:53 *** brendan_ga has quit IRC 2009-07-14T04:32:01 *** BenO has joined #openils-evergreen 2009-07-14T06:38:45 *** natschil has joined #openils-evergreen 2009-07-14T06:57:22 *** gmcharlt has joined #OpenILS-Evergreen 2009-07-14T07:29:14 *** mck9 has joined #openils-evergreen 2009-07-14T07:55:01 *** gmcharlt has quit IRC 2009-07-14T08:13:34 *** stompro__ has quit IRC 2009-07-14T08:13:44 *** Stompro has joined #openils-evergreen 2009-07-14T08:21:07 If I run a cstore query from an opensrf c server, how can I check whether the query returned any results? 2009-07-14T08:21:21 (i.e. a direct.classname.retrieve query) 2009-07-14T08:24:30 mck9 and dbs: regarding the JSON error yesterday...i dont quite understand the explanation....this was after doing a search in the OPAC so i'm not sure where the problem is caused 2009-07-14T08:25:12 http://paste.lisp.org/display/83539 was the error 2009-07-14T08:31:06 mrpeters-isl: I can explain why the JSON is invalid -- apparently there's a quotation mark missing; 2009-07-14T08:31:15 I can't explain how it got that way. 2009-07-14T08:31:28 mck9: yeah, im not too sure either 2009-07-14T08:31:40 i just found this http://osdir.com/ml/education.libraries.open-ils.devel/2008-08/msg00010.html releveant document so im going to try that 2009-07-14T08:33:23 *** Stompro has quit IRC 2009-07-14T08:33:28 *** Stompro has joined #openils-evergreen 2009-07-14T08:40:28 mck9 fwiw it doesnt appear i have a search.biblio.multiclass.query table? 2009-07-14T08:40:36 anyone know why that would not have been created? 2009-07-14T08:41:12 *** dbs has joined #openils-evergreen 2009-07-14T08:42:28 mrpeters-isl annotated #83539 "settings-tester.pl" at http://paste.lisp.org/display/83539#1 2009-07-14T08:42:54 settings-tester.pl if relevant to the problem with search.biblio.multiclass.query 2009-07-14T08:43:35 I'm pretty sure the problem has to do with tsearch2; settings-tester.pl doesn't check for that 2009-07-14T08:43:47 *** wlayton has joined #openils-evergreen 2009-07-14T08:43:51 dbs: is there any way to test for a problem 2009-07-14T08:44:11 wlayton: I backported your refworks stuff to 1.6, after making it a bit more configurable 2009-07-14T08:44:18 wlayton++ 2009-07-14T08:44:36 mrpeters-isl: try installing the tsearch2 contrib module again? 2009-07-14T08:44:38 mrpeters-isl: Unless I'm missing something, the search schema has only one table, namely search.relevance_adjustment 2009-07-14T08:44:46 Plus some functions 2009-07-14T08:44:52 dbs: how would i do that? 2009-07-14T08:45:14 mrpeters-isl: let me take a look at the 1.2 install instructinos 2009-07-14T08:45:19 dbs: thanks 2009-07-14T08:45:45 i figured that was in the makefile (i used http://svn.open-ils.org/trac/ILS/export/10741/trunk/Open-ILS/src/extras/Makefile.install) 2009-07-14T08:45:53 "psql -f /usr/share/postgresql/8.1/contrib/tsearch2.sql evergreen" according to http://open-ils.org/dokuwiki/doku.php?id=installing_evergreen_1.2_on_debian_etch_x86_32-bit 2009-07-14T08:46:30 dbs: Wow! Thanks 2009-07-14T08:47:03 dbs++ #More like dbs+=100 2009-07-14T08:47:13 dbs: i get a long run of this error "psql:/usr/share/postgresql/8.2/contrib/tsearch2.sql:1231: ERROR: current transaction is aborted, commands ignored until end of transaction block" 2009-07-14T08:47:25 then it ends with ROLLBACK 2009-07-14T08:47:26 mrpeters-isl: 2009-07-14T08:47:39 search.biblio.multiclass.query appears to be a partial name of a method 2009-07-14T08:47:46 wlayton: hell, man, you did 98% of the work, miker_ did 1.5%, I just took care of the remainder 2009-07-14T08:47:59 Full name is openils.search.biblio.multiclass.query 2009-07-14T08:48:00 * dbs reboots, thanks ubuntu 2009-07-14T08:48:06 mck9: yeah, i was misreading 2009-07-14T08:48:07 *** dbs has quit IRC 2009-07-14T08:49:01 how would I check if a request from within a c application returned anything? 2009-07-14T08:53:05 natschil:what function are you calling to launch the query? 2009-07-14T08:53:58 *** Dyrcona has joined #openils-evergreen 2009-07-14T09:00:15 dbs: Yeah, but you've been doing all sorts of other stuff, too (from which we're benefiting) 2009-07-14T09:05:12 *** dbs has joined #openils-evergreen 2009-07-14T09:06:07 dbs: Yeah, but you've been doing all sorts of other stuff, too (from which we're benefiting) 2009-07-14T09:07:28 mck9: oilsUtilsQuickReq 2009-07-14T09:08:04 *** kbeswick has joined #openils-evergreen 2009-07-14T09:08:26 sorry, I mean oilsUtilsCstoreReq 2009-07-14T09:08:47 s/oilsUtilsCstoreReq/oilsUtilsCStoreReq/ 2009-07-14T09:11:50 dbs: berick: what is a picklist? 2009-07-14T09:13:28 a picklist is a selection list - a list of items that you're considering purchasing. those items might turn into line items on a purchase order, or they might exist as desiderata forever 2009-07-14T09:14:36 alright, so no need to worry about them when importing our data, right? 2009-07-14T09:16:10 kbeswick: right, you have historical data, so everything is lineitems attached to POs 2009-07-14T09:18:56 and for acq.lineitem.marc, would i just be able to get the data from biblio.record_entry.marc since it is historical data and we should have the items? 2009-07-14T09:19:22 kbeswick: yeppers 2009-07-14T09:20:01 dbs: one more thing.. about the existing purchase order numbers 2009-07-14T09:20:12 dbs: the tsearch2.sql didnt do the trick...any other ideas or relevant files i can post to help? 2009-07-14T09:20:20 kbeswick: uh huh? 2009-07-14T09:20:28 dbs: there is no place for them in acq.purchase_order, should i try dropping the PO- prefixes? 2009-07-14T09:21:21 *** ben-ct has joined #OpenILS-Evergreen 2009-07-14T09:21:45 kbeswick: sure, looks like that would work 2009-07-14T09:22:18 mrpeters-isl annotated #83539 "gateway.log" at http://paste.lisp.org/display/83539#2 2009-07-14T09:22:23 I would have expected the PO name to be separate from the ID, but I guess it isn't. hrm 2009-07-14T09:22:36 dbs: as long as dropping the prefix doesn't create duplicates wit hthe ones that don't have a prefix. i'll let you know 2009-07-14T09:22:50 I'm sure you will :) 2009-07-14T09:24:30 mrpeters-isl: maybe try setting ON_ERROR_STOP in your .psqlrc file and run it again so we see the first error 2009-07-14T09:24:45 *** ben-ct has quit IRC 2009-07-14T09:25:49 *** ben-ct has joined #OpenILS-Evergreen 2009-07-14T09:27:25 *** ben-ct has quit IRC 2009-07-14T09:28:19 *** ben-ct has joined #OpenILS-Evergreen 2009-07-14T09:28:30 dbs: im not sure where the .psqlrc file is located? 2009-07-14T09:28:45 mrpeters-isl: try googling "ON_ERROR_STOP" 2009-07-14T09:29:02 * dbs heads to a meeting 2009-07-14T09:30:58 psql:/usr/share/postgresql/8.2/contrib/tsearch2.sql:13: ERROR: relation "pg_ts_dict" already exists 2009-07-14T09:42:42 dbs: i found this - http://list.georgialibraries.org/pipermail/open-ils-dev/2008-June/003244.html - that it appears you worked on (i did the same thing...restore from a db backup) do you recall what your solution was in this case? 2009-07-14T09:47:08 natschil: to begin with, if oilsUtilsCStoreReq() returns NULL, it didn't work. In fact it didn't call the method at all because the request was malformed. So that's a start. I'm still looking for the rest... 2009-07-14T09:49:01 mck9: I think you might've misunderstood me...the request is fine, but I want to make sure that if it runs a cstore.direct.classname.retrieve 201 and if there is no id 201 it will raise an error 2009-07-14T09:49:28 note that classname is simply a placeholder for an arbitary but valid name of a class in the IDL 2009-07-14T09:50:40 natschil: No, I expected the request was okay. I'm just climbing down the rabbit hole and reporting on what I see. Still climbing. 2009-07-14T09:52:23 Another possibility, and probably not a likely one, is that you get a pointer to a jsonObject of type JSON_NULL. 2009-07-14T09:53:02 Again that would indicate an error on your side, i.e. the client, not on the server. 2009-07-14T09:59:36 *** natschil_ has joined #openils-evergreen 2009-07-14T10:04:23 *** ben-ct has quit IRC 2009-07-14T10:16:17 natschil_: I find myself in a maze of twisty little passages, all different. 2009-07-14T10:16:23 *** natschil has quit IRC 2009-07-14T10:16:41 My best guess is that if retrieve doesn't find a row, you'll get a NULL back. 2009-07-14T10:17:01 But don't trust my word. Do some reverse engineering. 2009-07-14T10:17:32 Capture the jsonObject*. If it's NULL, issue a temporary message to yourself to say so. 2009-07-14T10:17:56 Otherwise turn it into a JSON string and report that to yourself. 2009-07-14T10:18:16 Then try it for known good queries and known bad queries, and compare. 2009-07-14T10:18:38 *** ben-ct has joined #OpenILS-Evergreen 2009-07-14T10:29:50 *** natschil_ has quit IRC 2009-07-14T10:33:38 *** mrpeters-isl has quit IRC 2009-07-14T10:33:55 *** mrpeters-isl has joined #openils-evergreen 2009-07-14T10:37:03 *** Attempting has joined #openils-evergreen 2009-07-14T10:37:15 *** Attempting has quit IRC 2009-07-14T10:37:27 *** Attempting_Insta has joined #openils-evergreen 2009-07-14T10:41:49 *** Attempting_Insta has quit IRC 2009-07-14T10:57:52 mrpeters-isl: did you look at the followup to that message that you posted? http://list.georgialibraries.org/pipermail/open-ils-dev/2008-June/003247.html 2009-07-14T11:06:29 berick: having purchase order ID column as the only identifier is a bit of a problem for standing orders (an order that you place one year and accept items whenever they come in over the subsequent years) 2009-07-14T11:06:58 dbs: yep, plan is to support a localy defined PO number 2009-07-14T11:07:01 in the past, you would just roll over the same PO # into the next year 2009-07-14T11:07:07 ah, goodie :) 2009-07-14T11:08:02 for rel_1_6 I guess we'll have to do something horrible like concatenate year + PO #, then adjust later when that plan comes together 2009-07-14T11:08:39 *** rickd has quit IRC 2009-07-14T11:33:09 *** brendan_ga has joined #OpenILS-Evergreen 2009-07-14T11:35:10 *** brendan_ga has quit IRC 2009-07-14T11:48:29 *** brendan_ga has joined #OpenILS-Evergreen 2009-07-14T11:56:54 *** BenO has quit IRC 2009-07-14T12:05:39 *** brendan_ga has quit IRC 2009-07-14T12:06:29 *** brendan_ga has joined #OpenILS-Evergreen 2009-07-14T12:28:17 *** brendan_ga has quit IRC 2009-07-14T13:26:17 *** dchristens has joined #OpenILS-Evergreen 2009-07-14T14:24:43 Hey, I'm doing some testing with Evergreen 1.4.0.4 and have come across an error when attempting to run the offline-blocked-list.pl script. This is the error message: malformed JSON string, neither array, object, number, string or atom, at character offset 0 ["Connected to OpenSRF..."] at /usr/local/share/perl/5.10.0/OpenSRF/Utils/JSON.pm line 126, line 3. 2009-07-14T14:44:46 *** rsinger has joined #OpenILS-Evergreen 2009-07-14T15:13:11 *** shantanoo has joined #OpenILS-Evergreen 2009-07-14T15:13:26 hi 2009-07-14T15:14:10 is evergreen also supports digital library? 2009-07-14T15:15:40 there are no specific affordances or workflows for digital libraries, but nothing is stopping you from linking out to digital resources with any MARC records you put into Evergreen 2009-07-14T15:16:38 phasefx_: digital library supports searching of content in the uploaded content. 2009-07-14T15:17:06 was looking for something like http://cdsware.cern.ch/ 2009-07-14T15:17:58 have you looked into Kete? http://kete.net.nz/ It's open source. There are others. 2009-07-14T15:20:21 and greenstone: http://www.greenstone.org/ I'm not familiar with any of these though 2009-07-14T15:21:04 dspace? http://www.dspace.org/ 2009-07-14T15:21:35 Fedora, http://www.fedora-commons.org/ 2009-07-14T15:22:13 phasefx_: i am looking for foss product which supports both. should be supporting cataloging and issuing of hardcopy material (books, magazines, etc. may also include vcds, dvds, ...) along with softcopy. 2009-07-14T15:22:34 I imagine Evergreen will be integrated with one or more of these before long. I think Koha is supposed to integrate with Kete, maybe Greenstone as well 2009-07-14T15:23:28 you could send an inquiry to the code4lib mailing list (or even ask on the #code4lib irc channel) 2009-07-14T15:23:34 hmm. koha+kete can be nice combo. 2009-07-14T15:23:48 could also ask some of the academic Evergreen libraries what they're doing 2009-07-14T15:33:49 *** pinesol has joined #openils-evergreen 2009-07-14T15:36:26 *** jamesrf has joined #openils-evergreen 2009-07-14T15:39:50 *** rsinger_ has joined #OpenILS-Evergreen 2009-07-14T15:51:55 *** rsinger has quit IRC 2009-07-14T15:53:42 *** shantanoo_ has joined #OpenILS-Evergreen 2009-07-14T15:55:54 \q 2009-07-14T15:56:00 whoops. 2009-07-14T15:56:03 err... 2009-07-14T15:56:05 *** kbeswick has quit IRC 2009-07-14T16:02:20 *** shantanoo has quit IRC 2009-07-14T16:05:55 *** _bott_ has quit IRC 2009-07-14T16:07:16 *** rsinger_ has quit IRC 2009-07-14T16:17:47 *** _bott_ has joined #OpenILS-Evergreen 2009-07-14T16:18:44 *** jamesrf has left #openils-evergreen 2009-07-14T16:20:33 *** ben-ct has quit IRC 2009-07-14T16:29:51 *** shantanoo_ has quit IRC 2009-07-14T16:36:38 hmm latest trunk has issues with staff client login? 2009-07-14T16:37:09 since I've just started work with eg (more or less) I had the svn from a couple of weeks ago 2009-07-14T16:37:33 so I decided to pull another svn today, compile, make, install 2009-07-14T16:37:42 moodaepo: might need to give out the VIEW_ORG_SETTINGS permission to staff 2009-07-14T16:39:15 berick: hmm when I go to /cgi-bin/perms-setup.cgi 2009-07-14T16:40:10 so I need to check that line and say update? 2009-07-14T16:40:36 moodaepo: I mentioned that in my 1.6 testing notes on open-ils-dev mailing list 2009-07-14T16:41:16 dbs: ah crap I'm not on the dev list : ) signing up right now 2009-07-14T16:41:35 heh, good list to be on if you're running trunk :) 2009-07-14T16:44:18 *** rsinger has joined #OpenILS-Evergreen 2009-07-14T16:48:13 *** wlayton has quit IRC 2009-07-14T16:50:07 *** Dyrcona has quit IRC 2009-07-14T16:57:48 signed up! 2009-07-14T16:58:19 dbs: but I am running svn from 2 weeks ago todays upgrade shouldn't require a view_org permissions update... 2009-07-14T17:01:18 moodaepo: you must be right then 2009-07-14T17:09:33 moodaepo pasted "Error Info - Staff Client Login" at http://paste.lisp.org/display/83602 2009-07-14T17:13:32 moodaepo: have you hand crafted SQL upgrade scripts that match the schema changes between 2 weeks ago and today? 2009-07-14T17:13:44 moodaepo annotated #83602 "Staff Client GUI More Info" at http://paste.lisp.org/display/83602#1 2009-07-14T17:14:26 dbs: I thought I checked the trac/svn site to see if there were any changes and there didn't seem to be...I'm checking my steps again 2009-07-14T17:22:01 argh there have been a few...can I just run the sql files that have changed (about 5 files I see) that have changed 2009-07-14T17:29:11 *** dchristens has left #OpenILS-Evergreen 2009-07-14T17:30:28 *** jamesrf has joined #openils-evergreen 2009-07-14T17:32:26 *** dbs has quit IRC 2009-07-14T17:32:29 *** rsinger has quit IRC 2009-07-14T17:35:42 Hmm I think line 970 in "src/sql/Pg/002.schema.config.sql" is whacked 2009-07-14T17:36:28 oops I mean in file "999.functions.global.sql" 2009-07-14T17:45:07 are the files in "src/sql/Pg/" numbered in some order? 2009-07-14T19:28:45 *** moodaepo has quit IRC 2009-07-14T20:25:09 @later tell moodaepo you can't expect to re-run the sql files on an existing db and get back 'in sync' with trunk. either start with a new db or compare the sql files you used with the current sql files and manually issue commands to update. 2009-07-14T20:25:09 jeff: The operation succeeded. 2009-07-14T20:39:04 *** sarabee has joined #openils-evergreen 2009-07-14T20:59:25 *** rsinger has joined #OpenILS-Evergreen 2009-07-14T21:32:24 *** gmcharlt has joined #OpenILS-Evergreen 2009-07-14T21:47:43 *** jamesrf has quit IRC 2009-07-14T22:31:41 *** moodaepo has joined #openils-evergreen 2009-07-14T22:51:18 *** moodaepo1 has joined #openils-evergreen 2009-07-14T23:02:07 *** moodaepo has quit IRC 2009-07-14T23:15:50 *** rsinger has quit IRC 2009-07-14T23:26:22 *** Kiyo has joined #openils-evergreen 2009-07-14T23:30:07 *** Kiyo has quit IRC 2009-07-14T23:39:18 *** brendan_ga has joined #OpenILS-Evergreen