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