| # | Time | Nick | Message |
|---|
| # | 02:55:38 | csharp__ has quit IRC |
| # | 02:55:51 | enhancin has quit IRC |
| # | 02:56:09 | edoceo has quit IRC |
| # | 02:57:44 | csharp__ has joined #evergreen |
| # | 02:58:08 | mcarlson has quit IRC |
| # | 02:58:08 | b_bonner has quit IRC |
| # | 02:59:38 | mcarlson has joined #evergreen |
| # | 03:00:08 | b_bonner has joined #evergreen |
| # | 03:08:33 | edoceo has joined #evergreen |
| # | 03:45:45 | _bott_ has quit IRC |
| # | 03:46:23 | _bott_ has joined #evergreen |
| # | 03:49:08 | mcarlson has quit IRC |
| # | 03:50:09 | mcarlson has joined #evergreen |
| # | 04:38:18 | natschil has joined #evergreen |
| # | 04:39:32 | natschil | Hi, the "official" documentation doesn't seem to mention this, so I'll ask here.... does one still have to setup cron to run various scheduled tasks such as thawing holds etc? |
| # | 07:07:06 | tsbere | natschil: There is still an example crontab file. Things like Action/Triggers, hold retargeting for pull lists and such, fine generation, etc are still handled by cron jobs. |
| # | 07:34:47 | natschil | tsbere: ok thanks |
| # | 07:35:13 | natschil has quit IRC |
| # | 08:04:52 | granitize has joined #evergreen |
| # | 08:06:09 | granitize1 has joined #evergreen |
| # | 08:09:15 | granitize has quit IRC |
| # | 08:59:54 | hopkinsju has quit IRC |
| # | 09:03:16 | granitize1 has quit IRC |
| # | 09:58:39 | granitize has joined #evergreen |
| # | 10:43:55 | granitize has left #evergreen |
| # | 11:19:10 | granitize1 has joined #evergreen |
| # | 12:37:15 | granitize has joined #evergreen |
| # | 12:40:26 | granitize1 has quit IRC |
| # | 12:59:36 | granitize1 has joined #evergreen |
| # | 13:01:41 | granitize has quit IRC |
| # | 13:07:23 | granitize1 has quit IRC |
| # | 13:11:24 | granitize has joined #evergreen |
| # | 13:12:07 | mcarlson has quit IRC |
| # | 13:12:07 | b_bonner has quit IRC |
| # | 13:12:07 | tsbere has quit IRC |
| # | 13:13:03 | granitize has quit IRC |
| # | 13:13:24 | mcarlson has joined #evergreen |
| # | 13:13:24 | b_bonner has joined #evergreen |
| # | 13:13:24 | tsbere has joined #evergreen |
| # | 13:45:47 | natschil has joined #evergreen |
| # | 13:46:11 | natschil | tsbere: where is this example crontab file located? |
| # | 13:46:23 | natschil | tsbere: (that you mentioned earlier today) |
| # | 13:47:50 | natschil | tsbere: is it this one: http://open-ils.org/dokuwiki/doku.php?id=evergreen-admin:cron_services ? |
| # | 14:11:07 | natschil | nevermind, I found it. |
| # | 14:12:31 | natschil | reshelving_complete.srfsh doesn't seem to work on 2.1, anybody know why this could be? |
| # | 14:12:51 | natschil goes to check launchpad |
| # | 14:24:56 | tsbere | natschil: How long have your items been in reshelving status? |
| # | 14:25:27 | natschil | tsbere: either I have no items in reshelving status, or for over a year |
| # | 14:25:51 | tsbere | natschil: Are the "over a year" ones deleted? |
| # | 14:26:20 | natschil | tsbere: probably not. |
| # | 14:26:30 | natschil | tsbere: how would I know |
| # | 14:26:39 | tsbere | the deleted flag on asset.copy |
| # | 14:26:55 | natschil | tsbere: select * from asset.copy where deleted=true? |
| # | 14:27:17 | tsbere | natschil: Yea. Perhaps with a "and status = whatever number reshelving is" |
| # | 14:27:55 | natschil | tsbere: how do I know what number reshelving is? |
| # | 14:28:48 | natschil | tsbere: would it do any harm to run delete from asset.copy where deleted=true? |
| # | 14:29:29 | tsbere | natschil: I think that will just trigger the "don't really delete" trigger. |
| # | 14:29:45 | tsbere | as for reshelving, select * from config.copy_status should give you the id numbers, I think |
| # | 14:29:53 | natschil | tsbere: all of the "status" values are either 0,5 or 7, with most of them being 0. |
| # | 14:30:23 | tsbere | That sounds somewhat right. 0 is Available. Forget what 5 and 7 are. |
| # | 14:30:29 | tsbere | I think 7 might be reshelving.... |
| # | 14:30:53 | natschil | tsbere: from the error message I get when running the reshelving complete script, it looks like 7 might be reshelving |
| # | 14:31:23 | tsbere | Wait, you are getting an error? |
| # | 14:31:27 | natschil | tsbere: yes. |
| # | 14:31:34 | tsbere | I don't think you mentioned that earlier. |
| # | 14:31:41 | natschil | tsbere: sorry, my bad. |
| # | 14:32:56 | natschil | tsbere: the error basically spits out a bunch of sql, including a ? for the placeholder. What is weird is that if one replaces that ? with something like "24h", the sql runs okay, but it also says that ParamValues:1=undef , suggesting that it has no parameter |
| # | 14:33:13 | natschil | I would paste the sql, but I currently have no internet on the computer I am running evergreen on. |
| # | 14:33:19 | tsbere | 1=undef is the problem. Are you giving the script a parameter? |
| # | 14:34:01 | natschil | tsbere: I haven't changed the script from what it is at install, so yes. |
| # | 14:34:10 | tsbere | Oh, wait, the default srfsh script does that.....hmmm..... |
| # | 14:34:44 | natschil | tsbere: I first thought it might be because I have no reshelving intervals set up, but it still gave the same error even after I had set them up. |
| # | 14:35:08 | natschil | tsbere: the error message also includes that DBD::Pg::st execute failed: called with 3 bind variables when 1 are needed |
| # | 14:35:26 | tsbere | hmm |
| # | 14:36:47 | tsbere | Nope, don't see an obvious issue in 2.1 for that. |
| # | 14:38:09 | natschil | tsbere: weird. the only other part of the of the sql that looks weird to me is BTRIM(setting.value,'"') |
| # | 14:38:25 | natschil | tsbere: let me have a look at the open-ils.storage code and get back to you. |
| # | 14:38:45 | tsbere | That is to remove quotes from the setting. The quotes make it a valid json string. |
| # | 14:39:37 | natschil | tsbere: do you happen to know off the top of your head where the perl services are stored? |
| # | 14:39:51 | tsbere | Before or after install? |
| # | 14:39:56 | natschil | tsbere: after |
| # | 14:40:07 | tsbere | Probably somewhere in /usr <_< |
| # | 14:40:25 | tsbere uses find / -name 'action.pm' and similar usually |
| # | 14:41:03 | natschil | thanks, I will look at the source code |
| # | 14:43:54 | natschil | weird, I can't see anything that would be obviously wrong. |
| # | 14:49:31 | natschil | tsbere: I decided to replace the question mark with '24h', and I still get the same error, which is even weirder. |
| # | 14:49:51 | tsbere | Well, you may have to restart the service first |
| # | 14:49:57 | natschil | tsbere: given the fact that running the sql on its own gives me no errors.... hmm, maybe there is an error with how open-ils.storage connects to the database |
| # | 14:50:01 | natschil | tsbere: I did |
| # | 14:50:09 | natschil | tsbere: and the error message reflected my change |
| # | 14:50:16 | tsbere | This a clean install on a new server or an upgrade from pre-2.1? |
| # | 14:50:25 | tsbere | (database aside) |
| # | 14:50:31 | natschil | tsbere: clean install |
| # | 14:50:37 | natschil | the database is not |
| # | 14:52:51 | natschil | tsbere: maybe the error is the fact that the run() method is provided too many parameters |
| # | 14:53:07 | natschil | tsbere: ha, there we go. |
| # | 14:54:18 | natschil | line 161 of Storage/Publisher/action.pm should read "$sth->execute($window);" instead of "$sth->execute($window,$window,$window);" |
| # | 14:55:00 | tsbere-droid has joined #evergreen |
| # | 14:55:41 | natschil | tsbere: if you have a running 2.1 system, it might be a good idea to check whether /openils/bin/reshelving_complete.srfsh works for you. If not, then it seems like the line mentioned above is e could be why it doesn't |
| # | 14:56:08 | tsbere | I have master systems |
| # | 14:56:33 | tsbere-droid has left #evergreen |
| # | 14:57:09 | natschil | tsbere: sorry for my lack of knowledge... what do you mean with that? |
| # | 14:58:04 | tsbere | We run our production servers on the master branch out of git. |
| # | 14:59:24 | natschil | tsbere: doesn't that mean you need to constantly upgrade? |
| # | 14:59:33 | natschil | (I mean things like the staff client) |
| # | 14:59:34 | tsbere | Meh. Not that bad. |
| # | 14:59:57 | tsbere | Tis a sinch since I wrote the "enable the xulrunner automatic upgrade" patch ;) |
| # | 15:00:12 | natschil | if your reshelving complete script works, good then. |
| # | 15:00:32 | natschil | that would mean someone has fixed that bug already. |
| # | 15:07:18 | edoceo has quit IRC |
| # | 15:08:00 | natschil | btw, I just did a search on evergreen and noticed that on the side pane, there are no longer links that have "related subjects".... is there any easy way to get those back? |
| # | 15:09:04 | tsbere | Stuff moved. Some things are best left till TPac, IMO. Beyond that, I never ran an actual system pre-2.1, really, and thus can't say where things went. |
| # | 15:09:54 | natschil | TPac? |
| # | 15:10:16 | tsbere | Not that we don't get requests for "can we have that?" when our libraries see catalogs running 1.4, 1.6, or 2.0 with things they want. >_> |
| # | 15:10:33 | tsbere | TPac - The Template Toolkit OPAC. Coming in 2.2. |
| # | 15:12:58 | natschil | there must have been a major rewrite at some point, then? |
| # | 15:13:19 | natschil | (I used to know more about evergreen as I did a lot with it and opensrf about a year ago, but since then it seems a lot has changed) |
| # | 15:13:25 | tsbere | TPac is written from scratch, currently alongside the JSPac |
| # | 15:15:32 | natschil | tsbere: what's weird though is that the "related subjects" links on the side used to exist and seemed to work well, but probably there was some reason to remove them. |
| # | 15:15:47 | natschil | anywho, I need to go, thanks for the help! |
| # | 15:16:54 | natschil | oh I see, the "subjects" list has been moved into the record summary, that explains everything. |
| # | 15:16:58 | natschil has quit IRC |
| # | 16:12:06 | moodaepo has joined #evergreen |
| # | 16:13:10 | bshum | @later tell natschil The reshelving issue was fixed with http://git.evergreen-ils.org/?p=Evergreen.git;a=commit;h=a70e7212db7e4932d2447019d0bd2b71f6db4e48 but that isn't in 2.1.1 |
| # | 16:13:10 | pinesol_green` | bshum: The operation succeeded. |
| # | 17:09:25 | moodaepo has quit IRC |
| # | 21:12:59 | moodaepo has joined #evergreen |
| # | 21:42:09 | moodaepo has quit IRC |
| # | 21:42:14 | hopkinsju has joined #evergreen |
| # | 23:06:10 | tater-laptop has quit IRC |
| # | 23:09:55 | csharp___ has joined #evergreen |
| # | 23:11:08 | csharp__ has quit IRC |
| # | 23:21:38 | b_bonner has quit IRC |
| # | 23:27:11 | b_bonner has joined #evergreen |
April 10-13