Time Nick Message 19:33 kados thanks chris! 19:33 kados nevermind ... it is working 19:17 kados hmmm, didn't seem to fix it 19:14 chris that oughta fix it 19:14 chris yep 19:14 chris "today" 19:14 kados it should be today ... right? 19:14 kados so instead of $iteminformation->{date_due 19:14 chris there ya go 19:14 kados $datedue = UnixDate(DateCalc($iteminformation->{date_due},"$loanlength days"),"%Y-%m-%d"); 19:14 kados this line: 19:13 chris id hope so :) 19:13 kados looks like both use renewbook in Circ2.pm 19:12 kados right 19:12 chris there and in issues 19:12 chris couple of places 19:12 kados renewscript.pl still how renewals are done? 19:11 chris since 2.2.0 anyway .. i dont think many ppl have that in production yet tho 19:10 owen I'm surprised it took me so long to notice. I assume it's been that way for a little while now. 19:10 chris i doubt it was done on purpose 19:09 chris i think it would just have been an oversight when paul was rewriting the circ code 19:09 owen I'm glad I'm not crazy thinking it's not working as expected. 19:09 owen rosa and chris, thanks for the input on the renewals thing. 19:05 kados I'll wait just to be sure 19:05 kados it's creating indexes too 19:05 chris not sure 19:05 chris maybe if its building new indices it might take a while .. 19:04 chris update database should be just running some alter tables 19:04 chris yeah the import does a lot more 19:04 kados ahh 19:04 kados the import takes about 5 hours 19:04 chris even so 19:04 kados hmmm, our database is quite large now ... 1.5 gig 19:04 chris id expect it to take 10-15 mins 19:04 kados well I'll wait a couple more hours 19:03 kados k 19:03 chris probably .. but im not sure how 19:03 kados is there some way for me to tell if 293 is a child of 148? 19:03 kados 293 | kohaadmin | localhost | Koha | Sleep | 10347 | | 19:02 kados 148 | kohaadmin | localhost | Koha | Query | 4380 | copy to tmp table | create index Search_Marc on marc_word (tagsubfield,word) 19:02 kados there are actually two processes listed ... 19:02 chris sounds like it 19:02 kados btw: chris (since your about) the updatedatabase command has been running for about 7 hours ... when i do mysqladmin proc it shows a process in SLEEP mode ... does that mean it's died? 19:01 chris thats what id expect 19:01 chris yeah 19:01 rosa Old birds who renew their books today wanta nother three weeks, not two weeks and 3 days if they're already overdue 19:01 chris yeah 19:01 kados I'm thinking it can't be that hard of a fix 19:00 kados yes 19:00 kados I haven't looked at the code yet but we need it to act as before 19:00 chris i think the way it worked before was less suprising 19:00 rosa and unpopular, methinks 19:00 rosa oh, that's tricky 19:00 chris i think owen is wondering if this is desirable ... it doesnt sound right to me 19:00 chris its makes the new due date be old due date + issuing period 18:59 chris which is how it used to work 18:59 chris the way it works is when u renew, instead of extending the due date to today + issuing period 18:59 rosa that's why I can't help, I assumed 18:59 chris rosa: how 2.2 is working is different to 1.2 and 2.0 18:58 rosa hi owen. can't help sorry. Yes I am a library person, but we haven't implemented 2.2 yet 18:28 owen Koha's renewal behavior has changed recently and I'm trying to figure out if it's the expected behavior for anyone. 18:25 owen rosa, I don't remember--are you a library person? 17:03 kados thanks paul! 16:55 paul happy to have be able to help you 16:54 paul ok, I go to bed now 16:54 paul updatedatabase works like a charm 16:54 paul i've updated successfully from 2.0 to 2.2.0 3 libraries. 16:54 paul but for ppl that have non-standard DB it can't 16:54 paul kados : between 2 official versions of Koha, updatedatabase is as intelligent as possible. 16:29 kados sigh 16:27 kados and I've a feeling our indexes are different, etc. 16:27 kados somehow we've got extra fields (like the hidden) 16:27 kados I'd really like to get our database "standard koha" if possible but I'm not sure how 16:26 kados I'm a bit lost :-) 16:26 paul right. I've missed the real origin of the problem 16:25 paul (you can't have the same as me, as frameworkcode is in my PK, and can't be null) 16:25 kados yes we have that problem ^^ see above 16:25 paul mmm... you will also have problem with primary key. 16:24 kados I am also thinking I will drop the tagsubfield from marc_word before the next time I run updatedatabase 16:24 kados ok ... 16:24 kados ahh 16:24 paul oups, sorry... you have to do this in marc_subfield_structure too 16:24 kados I thought we were talking about marc_tag_structure 16:24 kados ? 16:23 paul note you have to do this in marc_tag_structure too 16:23 paul (the alter can't be run before there is no more empty values) 16:23 kados great ... thanks paul! 16:23 paul yep 16:23 kados then 'alter table marc_tag_structure set frameworkcode='''? 16:22 kados ahh ... so I run 'update marc_tag_structure set frameworkcode=''' 16:22 paul (that would have frameworkcode empty again !) 16:21 paul the alter will prevent any future problem if you edit the marc structure & add a new marc tag 16:21 kados ok 16:21 paul the update solves the problem NOW 16:21 kados ? 16:21 paul (the alter table being for future marc add, the update being for what exists) 16:20 paul then your alter table 16:20 paul just update marc_tag_structure set frameworkcode='' 16:20 paul_away still here 16:20 kados :-) 16:20 kados wait !! how do I fix it? 16:19 paul_away ok, i leave now. Have a good day 16:19 paul_away nice baby ;-) 16:19 kados hehe 16:19 paul_away he told me where was your problem ! 16:19 kados hehe 16:19 paul_away and suddenly. 16:19 paul_away i was with my baby. 16:18 kados great! 16:18 paul_away yep 16:18 kados paul_away: still there? 16:18 kados alter table marc_tag_structure set frameworkcode NOT NUll default ''; ?? 16:17 kados ;-) 16:17 kados so how do I fix it? 16:16 kados wow ... paul .. thanks!!! 16:16 kados ok ... here 16:12 nausicaa @ bientôt 16:12 nausicaa bon appétit et bonne nuit... 16:10 nausicaa ;-) 16:10 nausicaa ... juste en passant... j'ai réinstallé koha et j'importe des notices bientôt 16:08 paul_away you know what ? I'm happy 16:08 paul_away & the template stay empty ! 16:08 paul_away so the next unles... is always used 16:08 paul_away and the MARCdetail... is empty too... 16:08 paul_away so the tag list is always empty 16:07 paul_away with null default null, I bet USD100000000 that you have null everywhere 16:07 paul_away frameworkcode NOT NULL default '' 16:07 paul_away should be 16:07 paul_away THAT'S WRONG 16:07 paul_away frameworkcode is NULL default NULL 16:07 paul_away marc_tag_structure 16:06 paul_away owen, kados, come, come 16:06 paul_away owen, kados, come, come 16:06 paul_away I've FOUND YOUR PROBLEM 16:06 paul_away (here after dinner. I had an idea) 16:06 paul_away kados ? 15:41 kados it could also just be because updatedatabase hasn't finished 15:41 kados I wonder if that's our problem 15:41 kados on 69 there is no PRI in Key column 15:40 kados | tagsubfield | char(1) | | PRI | | | 15:40 kados | tagfield | char(3) | | PRI | | | 15:40 kados here's an interesting thing ... on 101 (the server that's working) marc_subfield_structure looks like this: 15:13 kados and it gives me "Warning: something's wrong" in the log 15:13 kados I put a warn $tagslib->{$fields[$x_i]->tag()}->{$subf[$i][0]}->{tab}; just before the first next if 15:12 kados paul if you pop back in here's something interesting 15:12 kados yep ... should be set to go 14:49 kados adding warn after the next ifs doesn't work ... so that's probably the problem 14:49 kados thanks for the help paul! 14:45 paul (ok, I must leave now, sorry) 14:45 paul you shoud find where Koha exit 14:45 kados yes ... 108 is reached 14:45 paul then line 115, after the 2 next if 14:45 paul the line 112 (while) 14:44 paul (test the } else { line 108 14:43 kados the tag()<10 is not reached btw 14:43 kados darn ... we were hoping to deploy 2.2 over weekend 14:43 paul (so, monday) 14:42 paul not tommorrow (teaching Koha at CMI) 14:42 paul look if the tag()<10 is reached or not 14:42 kados maybe 2:00am for me ;-) 14:42 kados could we make an appointment to further troubleshoot? 14:42 kados ok ... thanks for the help paul 14:42 paul but that may be a good point 14:42 kados but line 97 is 14:42 paul i'll have to leave for dinner 14:41 paul so, the line 124 is never reached 14:41 kados meaning never called eh? 14:41 paul should have (is called at line 124) 14:40 paul mmm... interesting 14:40 kados hmmm, warn $value doesn't show up in the log 14:40 paul so my idea is to de-activate it 14:40 paul (it's a new sub, maybe it's the origin of your pb) 14:40 paul no, just return the value (=> do nothing) 14:39 kados should I "warn $value"? 14:39 kados hmmm, didn't seem to do anything 14:38 paul (that will not change anything : addbiblio should work at least) 14:38 kados ok 14:38 paul my($tag, $subfield, $value, $framework, $dbh) = @_; 14:38 paul add a return $value just after the 14:37 paul sub get_authorised_value_desc ($$$$$) { 14:37 paul ! another idea ! 14:36 paul (but i don't think it would change anything, but you can give it a try) 14:36 kados ok ... wonder how it got there 14:36 paul you could delete it 14:36 paul (i've no "hidden" field) 14:35 kados | 108 | 14:35 kados select count(*) from marc_tag_structure; 14:35 kados | hidden | tinyint(1) | YES | | NULL | | 14:35 kados | frameworkcode | char(4) | YES | | NULL | | 14:35 kados | authorised_value | char(10) | YES | | NULL | | 14:35 kados | mandatory | tinyint(4) | | | 0 | | 14:35 kados | repeatable | tinyint(4) | | | 0 | | 14:35 kados | libopac | char(255) | | | | | 14:35 kados | liblibrarian | char(255) | | | | | 14:35 kados | tagfield | char(3) | | | | | 14:34 paul (structure & content size) 14:34 paul what is your marc_tag_structure table ? 14:34 paul seems 14:34 paul yes 14:34 owen so it seems that it isn't related to retrieval, it's related to building the marc display? 14:33 owen and it shows up blank too if you try to start with an empty record 14:33 kados right 14:33 paul cgi-bin/koha/acqui.simple/addbiblio.pl?oldbiblionumber=16595 14:32 kados no ... it shows up as blank too 14:32 paul yep 14:32 kados from addbiblio.pl? 14:32 paul can you edit the marc biblio ? 14:31 kados this bug is very strange 14:31 kados but yes 14:31 kados I think he knew all along ;-) 14:30 kados :-) 14:30 paul should be easier to convince your president that there is no massive weapons in Irak than understand this bug... 14:30 paul really really really really strange... 14:30 kados :) 14:29 kados NULL 14:29 paul ok, so it'not because you've asked to hide everything ;-) 14:29 kados yeilds nothing 14:29 paul select distinct hidden from marc_subfield_structure 14:29 kados select hidden from marc_subfield_structure where hidden is not NULL limit 0,20; 14:29 paul ok 14:29 kados when I do select hidden from marc_subfield_structure limit 0,20; 14:29 paul just 20 ? 14:28 kados 20 NULLs 14:28 kados all nulls 14:28 paul ok, nothing here I agree. 14:27 kados I don't see it either: http://66.213.78.67/cgi-bin/koha/opac-MARCdetail.pl?bib=16595 14:27 paul mmm... a stupid idea : what does hidden contain (in marc_subfield_structure) 14:27 owen You can't see the loop in the source. sorry, I just saw the second part :) 14:27 kados :-) 14:26 paul ;-) 14:26 paul look or see ? 14:26 paul no to which question ? 14:26 owen No. 14:26 paul or not ? 14:26 paul did you look at the html source ? do you "see" the loop (with empty values) 14:26 kados yes 14:26 kados warn "$tabloop => $x_i"; 14:25 paul so the loop is done. more & more mysterious... 14:25 paul i bet $tabloop & $x_i 14:24 paul (what did you warn) 14:21 kados etc ... 14:21 kados 2 => 9 14:21 kados I get lots of numbers like this: 2 => 7 14:19 kados ok 14:18 paul (line 97) 14:18 paul for (my $x_i=0;$x_i<=$#fields;$x_i++) { 14:16 kados which loops would be the best to check? 14:15 kados ok 14:14 paul I go back to the suggestion of putting "warn" into the loops 14:14 paul but that should not be the origin of your problem 14:14 paul the thesaurus_category must be dropped (probably manually) after the updatedatabase 14:13 kados yes 14:13 paul the updatedatabase is stille running i bet ? 14:09 kados | link | varchar(80) | YES | | NULL | | 14:09 kados | frameworkcode | varchar(4) | YES | MUL | NULL | | 14:09 kados | isurl | tinyint(1) | YES | | NULL | | 14:09 kados | hidden | tinyint(1) | YES | | NULL | | 14:09 kados | authtypecode | varchar(10) | YES | | NULL | | 14:09 kados | seealso | varchar(255) | YES | | NULL | | 14:09 kados | value_builder | varchar(80) | YES | | NULL | | 14:09 kados | thesaurus_category | varchar(10) | YES | | NULL | | 14:09 kados | authorised_value | varchar(10) | YES | | NULL | | 14:09 kados | tab | tinyint(1) | YES | | NULL | | 14:09 kados | kohafield | varchar(40) | YES | | NULL | | 14:09 kados | mandatory | tinyint(4) | | | 0 | | 14:09 kados | repeatable | tinyint(4) | | | 0 | | 14:09 kados | libopac | varchar(255) | | | | | 14:09 kados | liblibrarian | varchar(255) | | | | | 14:09 kados | tagsubfield | char(1) | | | | | 14:09 kados | tagfield | char(3) | | | | | 14:08 paul (field list) 14:08 paul what is marc_subfield_structure for you ? 14:08 paul mmm... another idea 14:08 paul to see if they are reached 14:07 paul you should try to set some warn "" in the loops 14:04 kados yes and opac-MARCdetail.pl 14:04 paul you are speaking of MARCdeail.pl ? 14:04 kados we're baffled too 14:04 paul I must say it's really a mistery... 14:04 paul ok, so this table is correct too 13:58 kados | 10 | 6 | 13:58 kados | 5 | 3 | 13:58 kados | 4 | 17 | 13:58 kados | 3 | 23 | 13:58 kados | 2 | 9 | 13:58 kados | 1 | 27 | 13:58 kados | 0 | 14 | 13:58 kados | -1 | 1034 | 13:57 paul should give entries with -1,0,1,2,...,10 13:57 paul gives what ? 13:57 paul select tab,count(*) from marc_subfield_structure group by tab 13:56 kados (so that may be why) 13:56 kados (updatedatabase is still running though) 13:56 kados the Add Bibliographic Record link doesn't do anything 13:56 kados strange ... the addbiblio.pl screen is blank 13:55 kados checking 13:55 paul do you see something ? can you add a biblio & then see it ? 13:54 paul what is shown if you try to add a new biblio ? 13:54 owen And it's the same in default/css and npl templates 13:54 kados does not appear in either 13:54 kados yes 13:54 kados hmmm, strange since we checked out fresh CVS copies of everything 13:54 paul it does not appear in opac or in librarian interface ? 13:53 paul so, it's a perl or template one. 13:53 kados whew! 13:53 paul good news, it's not a MARC problem. 13:53 kados in the log 13:52 kados ok ... I added that line and the marc record is showing up 13:52 kados great! 13:50 paul (the package is ready, just some more tests & it's here) 13:49 paul kados : 2.2.1 will be released tommorow afternoon or monday 13:44 paul (if yes, the pb is after the marc building) 13:44 kados ok 13:44 paul thus, you can see if the marc record is correctly build 13:44 paul in MARCgetbiblio, you should add a warn "".$record->as_formatted just before the return 13:43 kados right ... I added these tables earlier so our opac would have marc searching 13:43 kados :-) 13:43 paul so, the updatedatabase is not the culprit. 13:43 kados yes 13:43 paul ? 13:43 paul does it contain tag+subfield values 13:42 kados yes ... added to allow marc searching 13:42 paul do you have a tagsubfield column in marc_word table ? 13:42 paul the last (1280) needs some checkings 13:42 paul the 2nd (1262 & 1265) are not problems, but should be solved for better perfs 13:41 paul the 1st (1243) error should mean you have both thesaurus_category & authtypecode columns 13:31 kados this is because I added these tables earlier (before 2.2 was ready) so our opac would have marc searching 13:30 kados updatatedatabase is giving me 13:30 kados DBD::mysql::db do failed: Duplicate column name 'tagsubfield' at updatedatabase line 1280. 13:30 kados Modifying marc_word (concat on tag and subfield for better perfs) 13:30 kados DBD::mysql::db do failed: All parts of a PRIMARY KEY must be NOT NULL; If you need NULL in a key, use UNIQUE instead at updatedatabase line 1265. 13:30 kados DBD::mysql::db do failed: All parts of a PRIMARY KEY must be NOT NULL; If you need NULL in a key, use UNIQUE instead at updatedatabase line 1262. 13:29 kados DBD::mysql::st execute failed: Duplicate column name 'authtypecode' at updatedatabase line 1243. 13:29 kados paul: here are some errors 13:28 paul (was with me today, usually working through webcam) 13:28 kados great! 13:28 paul ) 13:28 paul (henri damien laurent is going back home. Will commit the 1st report stuf tomorrow morning 13:28 kados I hope not! 13:28 kados yes ... working on that now ... I reimported the data and running updatedatabase on it now 13:27 kados :-) 13:27 paul it may be a hidden database problem ! 13:27 paul but you must find why the MARCdetail don't work for you 13:27 paul (no, evening ;-) g'morning to you josh) 13:27 kados morning paul 13:26 kados well we may need 'normal view' because MARCdetail isn't working for us :-( 13:26 paul (being kept after upgrades) 13:26 paul you also have the "opacstylesheet" that can be used to define a stylesheet external to the templates 13:26 owen It would be useful to us--I'm going to be changing the link in the intranet to point to detail.pl instead of MARCdetail.pl 13:26 paul (although a little bit tougher, due to the number of pages) 13:25 paul if you think it's useful for librarian too, it could be done probably 13:25 paul it defines the default view for OPAC. 13:25 paul yes 13:24 owen Paul: the BiblioDefaultView preference--is that just for the OPAC? 13:24 owen That's not good! 13:04 paul "the page does not exist :-(" 13:04 paul http://katipo.co.nz/solutions/products/koha.html 13:04 paul chris, rach, & other katipo folks : 12:54 owen Very interesting. I hadn't seen anything like that before. 12:51 paul nope, but i've installed kartouche for translation to various iso-8859-1 languages 12:34 owen Are you working on Italian? 12:34 paul nope, mostly french & italian translations 12:33 paul hi owen. 12:33 owen Wow, paul, lots of new stuff!