IRC log for #koha, 2006-07-12

← Previous day | Today | Next day → | Search | Index

All times shown according to UTC.

Time Nick Message
12:03 shedges going to leave now -- go back to pushing budget numbers around, and when the laptop goes to sleep it sometimes looses the wireless network
12:03 so I might as well leave gracefully...
12:03 kados :-)
12:04 ciao
12:05 owen: so ... are you generally busy today, or have some time to hack away on Koha?
12:08 owen I just have to switch gears, but yeah, I'm not too busy
12:10 kados cool
12:15 owen So what's up?
12:18 kados owen: well ... several things
12:18 I stopped briefly to show the new search to the plains librarians
12:18 and they have 800x600 resolution on their circ computer
12:18 owen Yep.
12:18 kados so maybe one thing would be getting the interface to look nice on small resolutions
12:20 kyle I just noticed some comments on my templates ; )
12:20 owen :)
12:20 kyle The style strongly inspired by another ILS that we were looking at as an alternative to koha.
12:21 The librarians were ready to cut a check just based on the way it looked.
12:21 So that's where that came from.
12:21 And as far as maintainence, all I did was make a few changes to the npl templates.
12:22 kados just like pretty much everything else in Koha :-)
12:22 function is based on user needs :-)
12:22 kyle exactly.
12:22 kados kyle: I contend that you could have done a layout.css and colors.css with backround images to acomplish the same look without modifying NPL templates at all :-)
12:23 kyle: course, that's none of my business :-)
12:23 kyle I find the colors to be garish, but it doesn't matter what my tastes are, they are designed to be more usable.
12:23 A tab style template *could* have been done with css, but it would not have the polished look.
12:23 CSS is still to feature lacking.
12:24 owen And my point was just that I would hate to have to keep track of all those graphics
12:24 CSS can present a lot of problems, particularly if you can't influence your organization's browser choice.
12:24 kyle owen: yes, there are quite a few graphics, but if you look at the code, it's actually quite simple, and very easy to understand.
12:25 the graphics are also very aptly named.
12:25 kados yep ...
12:25 kyle: there is some history here
12:25 kyle: the original versions of Koha had lots of graphics too
12:25 kyle: but we discovered we couldn't translate graphics :-)
12:26 kyle kados: have any screenshots? ; )
12:26 kados kyle: now, we could do graphics as background images in css with the text in front
12:26 kyle I tried that, no good.
12:26 kados kyle: so I still contend that given some time, I could create a duplicate of CCFLS's templates using just css :-)
12:26 kyle: for example:
12:26 http://liblime.com/
12:26 kyle it would have been extremely complex to make tabs with the tab image in the backgound that stretches to the width of the tab lable.
12:27 kados kyle: the tabs you see for 'home' 'koha ils' 'open source' 'contact' are done as I describe
12:27 kyle: and the 'quicklinks' at the top are also done this way
12:27 kyle: just css
12:28 kyle how do they work?
12:28 kados kyle: use the source, luke :-)
12:28 kyle: it's very clever actually :-)
12:29 kyle: you've got two images:
12:29 http://liblime.com/images/nav/norm_left_on.gif
12:29 http://liblime.com/images/nav/norm_right_on.gif
12:29 (and the 'off' ones as well)
12:30 and they 'slide' using some clever css trickery
12:30 kyle yeah, I've seen that before. I tried it, but I can't remember why I passed on it.
12:31 Probably because my tabs overlap, and are not box shaped.
12:32 I'm not a fan of clever anyway, I believe in writing code that is obvious. When you are writing something for others to use, or even yourself later on, obvious trumps clever everytime in my book.
12:33 I can't count the number of times I've looked at 'clever' code I wrote, and said 'what was I thinking!!?!?!, even wth comments ; )
12:34 And I still contend that my template set is actually *simpler* that the npl template set.
12:35 if you remove the unused leftover files that I haven't cleaned out, you'll find there are far fewer files used.
12:48 tumer kados:are you around?
12:48 kados tumer: sure am
12:48 tumer: circ isn't working in dev-week
12:48 tumer: at leat it doesn't use zebra
12:48 tumer about circulation not updatong
12:48 kados great, you already know :-)
12:49 tumer is zebra giving any errors or its just you did not map onloan field anywhere
12:49 kados ahh ... perhaps I didn't map
12:50 tumer: could you walk through it for me?
12:50 tumer: the mapping is in the framework?
12:50 tumer if NPL is using 952 for holdings..
12:50 kados yes, they are
12:50 tumer any free subfield in framework would do
12:51 so you need walking how to do that
12:51 kados tumer: no
12:51 tumer: but I do need help understanding other fields you have mapped
12:51 tumer ok yhe field is called onloan
12:51 kados tumer: cutterextra for instance
12:51 tumer: what is it used for and how?
12:52 tumer cutterextra helps with sorting LC
12:52 you probably wont need that
12:52 kados well I'd like to understand regardless :-)
12:53 tumer in NEU we use LC so for LC sorting we use fields 050a and 050b
12:53 kados tumer: do you map 'itemlost, wthdrawn, issues, renewals, reserves, restricted,binding, etc>
12:53 ok
12:53 050a and 050b, got it
12:53 NPL uses 080a and 080b
12:53 (dewey)
12:54 tumer we preprosees that and put them in a field i named lcsort
12:54 kados ok
12:54 tumer this is at biblioagraphic level
12:54 kados that's in the items table?
12:54 ahh
12:54 biblio table then
12:54 tumer biblioitems
12:54 kados gotcha
12:54 tumer but then an item has some extra bits added to sorting
12:55 like v.1 v.3 etc
12:55 kados right
12:55 tumer those bits are kept at cutterextra
12:55 kados I see
12:55 so you sort first by lcsort
12:55 then by cutterextra
12:56 very slick
12:56 tumer thats it
12:56 kados tumer: do you map 'itemlost, wthdrawn, issues, renewals, reserves, restricted,binding, etc?
12:56 tumer not in dew_week
12:56 kados ok
12:56 so if they were mapped, would zebra update correctly?
12:57 tumer by the way if its dewey sorting its different
12:57 kados yea?
12:58 tumer so map their 080a and 080b to dewey and subclass
12:58 and set zebra to sort on these fields
12:59 lc sorting requires lots of 000's padded
12:59 kados right
12:59 tumer dewey is straight sorting
12:59 kados tumer: I've got an auto-migrate script written
12:59 tumer: it takes about 25+ hours to run in total :-)
12:59 tumer i noticed
13:00 kados tumer: but it works perfectly :-)
13:00 I need to genericize it and commit to dev-week
13:00 tumer i am having a big problem of zebra stopping for the last 2 nights
13:00 kados yea?
13:00 what's it doing?
13:00 tumer suddenly says database not available
13:01 and have to reindex again
13:01 kados I've seen that message before
13:01 tumer have been doing it 3 times today already
13:01 kados it seems like it happens if you index with the wrong db name
13:01 one time
13:01 tumer how can we do that in koha?
13:02 kados I did it manually a couple of times by mistake
13:02 tumer yes mauoal you can but ib koha it should not
13:03 kados maybe a mistake in the perl somewhere
13:03 tumer unless the handles get messed up is such a thing possible?
13:03 kados it's possible
13:03 I haven't seen it personally
13:03 does it happen with a specific transaction type>
13:03 like circ?
13:03 tumer its a nightmare surrently its doing it on production
13:03 kados or marc editing?
13:04 yikes
13:04 what operations does it happen with?
13:04 tumer only marc editing, currently thats all we are doing 40 cataloguers
13:04 kados right
13:04 hmmm
13:05 tumer and they are working 16hrs  a day on as a summercamp project
13:06 kados wow ...
13:06 tumer i am having sleepless nights trying to understand zebra
13:06 kados that is annoying
13:06 had a meeting this morning and I was like a zombie :-)
13:07 hehe
13:07 tumer: that's the kind of bug that's really difficult to reproduce
13:07 tumer which version of zebra you hane?
13:07 kados tumer: in a test environment
13:07 I'm running the latest 1.3 series
13:08 tumer yes very difficult to reproduce
13:08 kados 1.3.36
13:08 tumer: you might want to throw some warn messages in
13:08 tumer i have taken the zebra server to command line for the last hour trying to catch anything
13:09 kados tumer: to alert you if koha ever sends a command to zebra with a different database name
13:09 tumer i have warn messages in biblio.pm
13:09 kados ahh
13:09 tumer it show me the server name and the error occured
13:09 kados anything useful?
13:09 tumer all it says bibliserver not available
13:10 or zebra server timedout
13:10 or cannot connet
13:10 kados hmmm
13:10 tumer error updating
13:10 kados maybe it is a zebra bug
13:10 tumer etc etc
13:10 kados we need to write some test scripts
13:10 that pound the zebra server with updates
13:10 actually, I suppose that's what bulkmarcimport is
13:11 tumer we have to be able to test it heavily
13:11 we have to simulate differnt process trying it at the same time
13:11 kados agreed
13:11 I have some threaded request code I wrote for evergreen
13:11 tumer bulkmacrimport is one
13:12 kados if I have time this week I'll try to write a test suite for zebra
13:12 tumer and even with bulk marcimport alone my zebra breaks now (ver 1.4.1)
13:12 ID moved to ver 2.0
13:13 kados wow
13:13 bulkmarcimport.pl breaks it?
13:13 tumer it did lately
13:14 kados just took forever
13:14 tumer blank database-- bulkmarcimport 150k records never managed to finish it
13:15 kados hmmm
13:15 tumer: send me the records
13:15 tumer with zebraidx though no problem
13:15 kados tumer: or post them somewhere
13:15 and I'll try
13:16 tumer i have closed all the ports currenly to try and undertsand whats happening
13:16 when i open them i will post it on server
13:16 kados sweet
13:18 thd tumer: do you use the item part of the call number in your LC call number sort?
13:19 tumer kados: the only major change i did is that i changed record.abs
13:19 kados:i was not yet
13:19 thd tumer: I mean do you use the cutter number in sorting?
13:20 tumer kados:some scripts do use it like inventory control
13:21 kados: i am indexing almost every field of MARC21 to a different @attr now
13:21 that is slowing the updates very much
13:21 may be thats my problem
13:21 i now have about 16 indexes and 5 sort field
13:22 any idea?
13:22 thd:oh thd i did not realise i was answering to kados
13:22 kados :-)
13:23 tumer thd:cutterextra i use in copuple of scripts but not all
13:23 opac does not use it
13:24 thd: i sort on 050a and 050b togeetger
13:25 i precombine them properly padded to a different marc field
13:25 thd tumer if you sort on 050 $b as well then you are sorting with the cutter ( item) number
13:27 tumer kados: 050$b is the general cutter. At item level there are the extra bits of volume no etc that i use
13:27 kados hmmm
13:27 tumer s/kados/thd
13:27 kados:how many fields do you index at record.abs
13:28 kados tumer: more than 16 I think
13:28 thd kados: if you use 082 $b you will not have a numeric sort unless you transform the number and pad it as tumer has done for LC numbers
13:28 kados tumer: plus I'm doing some mappings within a field for searching fixed fields
13:28 tumer i mean with different attributes
13:29 kados tumer: my record.abs is in cvs
13:30 tumer: in zebraplugin dir off of root
13:30 tumer head?
13:30 dewey head is head
13:30 kados tumer: no, dev-week
13:30 tumer i go and check
13:31 kados thd: I could use some advise
13:31 thd: looking at the latest marc21 framework in rel_2_2
13:31 thd: I need to figure out where to map the 'onloan' field
13:31 thd yes kados
13:31 kados thd: but there aren't any subfields left :-)
13:32 thd kados: I thought that status would be stored in the SQL DB
13:32 kados: do you need it for migration?
13:33 kados thd: it is stored in the zebra now as well
13:33 thd: also, I get an error on line 43:
13:33 ERROR 1136 (21S01) at line 43: Column count doesn't match value count at row 1
13:34 thd oops: I did not verify before committing
13:35 kados thd: INSERT INTO `marc_tag_structure` VALUES ('090', 'SYSTEM CONTROL NUMBERS (KOHA)', 'SYSTEM CONTROL NUMBERS (KOHA)', 1, 0, '', '');
13:35 thd: that's line 43
13:36 looks like we're missing one value
13:36 there are 8 columns in marc_tag_structure
13:36 thd kados: really, are there not enough or too many commas?
13:37 kados strange
13:37 here is NPL's marc_tag_structure:
13:37 | tagfield         | char(3)    |      | PRI |         |       |
13:37 | liblibrarian     | char(255)  |      |     |         |       |
13:37 | libopac          | char(255)  |      |     |         |       |
13:37 | repeatable       | tinyint(4) |      |     | 0       |       |
13:37 | mandatory        | tinyint(4) |      |     | 0       |       |
13:37 | authorised_value | char(10)   | YES  |     | NULL    |       |
13:37 | frameworkcode    | char(4)    |      | PRI |         |       |
13:37 | hidden           | tinyint(1) | YES  |     | NULL    |       |
13:38 rel_2_2 has:
13:38 | tagfield         | char(3)    |      | PRI |         |       |
13:38 | liblibrarian     | char(255)  |      |     |         |       |
13:38 | libopac          | char(255)  |      |     |         |       |
13:38 | repeatable       | tinyint(4) |      |     | 0       |       |
13:38 | mandatory        | tinyint(4) |      |     | 0       |       |
13:38 | authorised_value | char(10)   | YES  |     | NULL    |       |
13:38 | frameworkcode    | char(4)    |      | PRI |         |       |
13:38 where did hidden come from?
13:38 tumer kados: it has to be inserted into an item field. onloan is an item field and KOHA demands they all be in one field!!!!
13:39 so it has to be 952 0-9 a-z
13:39 kados tumer: right
13:40 tumer in the forthcoming version of koha all these restrictions gone
13:40 kados excellent
13:41 thd kados: your error is that you do not have enough columns in the table
13:41 tumer excellent work thd
13:41 kados but ...
13:41 the first paste is from the one that's not working
13:42 the second one is from a rel_2_2 database
13:42 so the one that's not working has 8 columns in the table
13:43 is 'hidden' a valid column for marc_tag_structure?
13:43 thd kados:: NPL has current database and there is something missing from your rel_2_2 database columns
13:44 kados thd: so why does the framework only have 7 fields listed instead of 8?
13:44 thd kados: yes hidden was the one we worked on all night a couple of months ago :)
13:44 kados thd: was that in the tag structure?
13:44 thd: I thought it was in the subfield structure
13:45 tumer hidden i have in subfield structure
13:45 thd kados: oh yes you are right
13:45 kados so I should remove this column from NPL's db
13:45 tumer 952$4 use restrictions --NEU maps onloan to there if interested
13:45 thd kados: it should be in both in many ways but now I am confused :)
13:46 kados: maybe it was added long ago in the wrong place accidentally
13:46 kados perhaps
13:47 thd kados: does the column have any values in the marc_tag_structure table?
13:47 kados thd: also, when I import this file, it doesn't clean up the old one
13:47 thd: no values
13:47 thd: ie, it gives me a warning:
13:47 ERROR 1062 (23000) at line 43: Duplicate entry '090' for key 1
13:48 thd kados: what do you mean by clean up?
13:48 kados meaning it wasn' exported with the --add-drop-table option perhaps?
13:48 meaning it doesn't overwrite the existing values
13:48 thd kados: which script are you using?
13:48 kados the structure_def.sql
13:49 I am manually importing with
13:49 mysql -u -p koha < structure_def.sql
13:49 thd kados: that is the one for a new koha install not for updating old ones
13:49 kados ahh
13:49 thd kados: look in the misc directory
13:51 kados got it
13:53 tumer: ok, I mapped onloan to 952$a to test
13:53 tumer: still, zebra is not called at all when issuing
13:53 tumer: the screen does not show the issue either
13:53 thd kados tumer: when you run out of a-z 0-9 for subfield names you can do what RLIN and other systems do and use punctuation for subfield names.
13:54 kados tumer: I get some errors too:
13:54 DBD::mysql::st execute failed: Table 'koha.repeatable_holidays' doesn't exist at /koha/intranet/modules/C4/Calendar/Calendar.pm line 91.
13:54 DBD::mysql::st fetchrow failed: fetch() without execute() at /koha/intranet/modules/C4/Calendar/Calendar.pm line 93.
13:54 DBD::mysql::st execute failed: Table 'koha.repeatable_holidays' doesn't exist at /koha/intranet/modules/C4/Calendar/Calendar.pm line 101.
13:54 DBD::mysql::st fetchrow failed: fetch() without execute() at /koha/intranet/modules/C4/Calendar/Calendar.pm line 103.
13:54 DBD::mysql::st execute failed: Table 'koha.special_holidays' doesn't exist at /koha/intranet/modules/C4/Calendar/Calendar.pm line 111.
13:54 DBD::mysql::st fetchrow failed: fetch() without execute() at /koha/intranet/modules/C4/Calendar/Calendar.pm line 113.
13:54 thd kados tumer: maybe capital A-Z would also work but I have not seen capitals used for other systems
13:54 kados DBD::mysql::st execute failed: Table 'koha.special_holidays' doesn't exist at /koha/intranet/modules/C4/Calendar/Calendar.pm line 121.
13:54 DBD::mysql::st fetchrow failed: fetch() without execute() at /koha/intranet/modules/C4/Calendar/Calendar.pm line 123.
13:55 DBD::mysql::st execute failed: Unknown column 'issue_date' in 'field list' at /koha/intranet/modules/C4/Circulation/Circ2.pm line 1056.
13:55 thd: unfortunately, mysql doesn't distinguish between A and a by default
13:56 thd kados: I suspect that is why other systems also do not use capitals but there are quite a few punctuation marks
13:56 kados thd: yep
13:56 tumer: any ideas?
13:56 tumer i was away let me catch up
13:57 kados tumer: I assume I need to add items.issue_date?
13:57 and map it to MARC too?
13:57 tumer no
13:57 not work zebra to show an item when it is due
13:58 s/work/for/
13:58 holiday management was added to koha rel2_2 so it should work
13:59 kados so issues aren't working
13:59 tumer kados:table issues have a field called issue_date dont you have it
13:59 kados right, ok I'll add it
13:59 see if that helps
14:00 thd kados: I thought my previous advocacy for storing status in MARC was mistaken on efficiency grounds.
14:00 kados tumer: what is the data type of the issue_date column?
14:01 tumer date
14:01 thats in issues table not items table
14:01 kados ahh
14:02 tumer but thats standart koha field
14:02 or is it not?
14:03 kados coudl be
14:03 but remember that NPL is a hybrid system :-)
14:03 ok the item issued
14:03 but zebra didn't do anything
14:04 tumer even if zebra does not work normal issues should work
14:04 kados DBD::mysql::st execute failed: Table 'koha.repeatable_holidays' doesn't exist at /koha/intranet/modules/C4/Calendar/Calendar.pm line 91.
14:04 DBD::mysql::st fetchrow failed: fetch() without execute() at /koha/intranet/modules/C4/Calendar/Calendar.pm line 93.
14:05 I wonder if that's related
14:05 maybe that's a bug?
14:08 ok, statuses are working ... but I would feel much better if biblioitems.marc and zebra were up to date
14:08 tumer kados:repeatable_holidays is a complete new table was supposed to be there thats why its braking hang on
14:11 thd kados: are you using status in MARC only for migration?
14:11 kados thd: I don't understand the question
14:11 thd kados: I thought my previous advocacy for storing status in MARC was mistaken on efficiency grounds.
14:12 kados thd: we're storing all the item fields (952) in MARC now ... at least theoretically :-)
14:12 thd: well we need to test to make sure it's fast enough anyway
14:13 thd kados: can that keep up with a heavy circulation volume?
14:13 kados thd: we hope so
14:13 thd: only testing can tell
14:13 owen: still around?
14:13 thd kados: Is NPL the live testing victim? :)
14:13 kados thd: yes :-)
14:14 thd: if it's not fast enough, ID has promised to look into efficency options
14:18 tumer kados: are you using dev-week circulation
14:18 kados tumer: yes
14:18 tumer: zoomopac is stock dev-week with only minor changes to searching soon to be committed
14:18 tumer: running directly off a CVS repository
14:18 tumer i commited a patched vesrion of Circ2.pm that removed calendar dependency try that
14:19 kados ok
14:19 tumer i did not test my script though
14:20 thd kados: I would really recommend using punctuation as opposed to changing the alphanumeric subfield assignments for 952.  you otherwise would be interfering with the previous labour to map preexisting 952 and added usage to standard MARC 21 holdings.  Temporary status is not standard in MARC so it should have the non-standard subfields :)
14:20 s/map/correlate/
14:21 kados tumer: still zebra is not involved in issues or returns
14:22 tumer: am I correct that dev-week is supposed to update zebra with circulation data?
14:23 tumer yes you are right
14:23 thd kados: I tried to use the same subfield assignments as closely as I could given that some were already in use before my attempt to rationalise the remaining ones.
14:23 tumer in circ2.pm add a line at 1057 after $sth->finish
14:23 kados ok
14:24 tumer before MARCmoditemonefield and see whether you are there
14:24 kados add a warn?
14:24 tumer add a warn i mean
14:24 kados ok
14:24 thd s/assignments/assignments as standard MARC 21/
14:25 kados tumer: the warn does not show up
14:25 tumer so not issuing?
14:25 thats the issuing script
14:25 kados it is issuing
14:25 and the status is updating
14:25 :-)
14:26 just not in zebra
14:26 tumer kadow wait zebra crashed
14:27 kados ?
14:27 ahh, you mean your zebra crashed?
14:27 :(
14:28 tumer yes zebra crashed again sayin some memory location cannot be raed application fault ......bla bla
14:29 retsarted. I have to report this to ID
14:29 ok back to your problem
14:29 kados yea, I'd do that
14:29 ok I was looking in the wrong log
14:29 the warn is working
14:30 thd tumer: are your crashing problems unique to a MS Windows install of Zebra?
14:30 tumer thd:gow knows
14:30 thd:god knows
14:31 thd tumer: and God is not telling? :)
14:31 tumer kados: after that line MARCmoditemonefield will only update is items,onloan is mapped
14:31 kados items.onloan is mapped to 952$a
14:32 tumer MARCmoditemonefield is in biblio.pm updates marc and zebra
14:32 kados yep, I see that
14:32 I followed it through to MARCaddbiblio
14:33 tumer so what else can I say
14:33 kados nothing :-)
14:33 tumer is it actually finding items.onloan i donno
14:34 952$a was not used before?
14:35 kados right
14:35 and I didn't rebuildnonmarc
14:35 but it shoudl at least work for new items
14:35 or throw an error
14:35 hey cm
14:35 tumer should
14:35 kados strange
14:35 cm hey.  just peeking in.  :)
14:35 kados :-)
14:35 tumer zebra should trigger
14:38 if status is being updated then you shuold look at some other problem not zebra
14:39 kados tumer: if ( ( $tagfield, $tagsubfield ) = $sth->fetchrow ) {
14:39 tumer: Biblio.pm line 859
14:39 tumer: warn inside that if isn't trigered
14:39 tumer yep
14:41 kados tumer: another matter ... circulation.pl in dev_week is very different than in rel_2_2 ... is there anything special in there or can I just sync with rel_2_2?
14:41 so it's failing on "select tagfield,tagsubfield from marc_subfield_structure where kohafield=?"
14:41 ie, nothing is found
14:42 tumer and it works with all other fields
14:43 warn to see what field name its trying to find
14:43 kados sure enough, it's items.onloan
14:43 but it's mapped!
14:43 owen This snippet in the dev_week circulation.pl tells me it's not ready for prime time: $picture = "http://cc.neu.edu.tr/stdpictures/".$borrower->{'cardnumber'}.".jpg";
14:43 tumer so your db not in good shape?
14:44 kados owen: we should just be able to run rel_2_2 circulation.pl
14:44 as far as I know the API is the same, right tumer?
14:44 tumer yep very minor changes
14:45 you can merge it to your version
14:45 kados ok
14:45 tumer in fact the only line you need is MARCmoditemonefield added to your version
14:46 wherever there is a db update just add that afterwards to your version and it should happily work
14:47 kados ok
14:48 it should be in rel_2_2 anyway, right?
14:48 tumer and thats only 4 lines of it in Circ2
14:48 kados because as currently written, koha's not updating the MARC properly if I understand, right?
14:48 tumer rel2_2 does not update marc at all
14:49 kados not even for branches I think
14:49 which should be filed as a bug in my opinion
14:49 blocker even :-)
14:49 tumer it does not update holding branch when transfered
14:49 kados right, it doesn't for me either :-)
14:50 tumer this one liner can go in anyversion of Circ2 and it should update MARC and zebra
14:51 kados owen: soon as I get circ working with zebra I'll update circulation.pl
14:52 hmmm
14:52 tumer ???
14:52 kados I found the problem
14:52 tumer shoot
14:52 kados the koha2marc links script doesn't work anymore :(
14:53 you have to update the framework in the framework section
14:54 sigh
14:54 still doesn't update zebra
14:55 tumer are you using a named framework or default?
14:55 kados I'm using thd's framework with some modifications
14:56 tumer kados:have you given it a name or what?
14:56 no name= default=''
14:56 kados ahh
14:57 text for librarian is 'Invalid or canceled piece designation (canceled barcode) (similar to 876-8 $r)'
14:57 no text for OPAC
14:57 managed in tab ignore
14:57 hidden is set to -1
14:57 not repeatable or mandatory
14:57 tumer it has to be managed in tab 10 may be hidden
14:57 kados ahh
14:58 thd oops
14:58 tumer all item fields have to be defined in tab 10 to be updated even if hidden. KOHA logic
14:58 kados right
14:58 still not working
15:00 tumer kados: where is itemnumber defined?
15:00 kados grrr
15:00 tumer mapped rather
15:00 kados subfield u
15:01 tumer so all looks good
15:01 kados does you marc editor work?
15:02 kados no!
15:02 it's completely blank!
15:02 this is strange
15:03 tumer kados i think there is some confusion in you system with the new framework and all that
15:03 kados yea, seems like it :-)
15:05 tumer: now you know why I wanted to start with a new database for NPL :-)
15:05 thd kados:  952 $a was set to tab 10 in my copy of the framework but the OPAC text was missing.
15:05 kados thd: would that matter?
15:05 tumer it shouldnot matter
15:05 thd kados: I believe we had a problem with no librarian text
15:06 kados: I do not recall a problem with no OPAC text
15:06 kados didn't help
15:06 wow, this is really strange
15:06 thd kados: those were template problems for submitting a value
15:06 manually
15:07 kados when I ran updatadatabase I got :
15:07 DBD::mysql::st execute failed: Duplicate column name 'authtypecode' at /koha/cvsrepos/22/koha/updater/updatedatabase line 1920.
15:07 DBD::mysql::db do failed: Can't DROP 'PRIMARY'; check that column/key exists at /koha/cvsrepos/22/koha/updater/updatedatabase line 1948.
15:07 DBD::mysql::db do failed: Can't DROP 'PRIMARY'; check that column/key exists at /koha/cvsrepos/22/koha/updater/updatedatabase line 1953.
15:10 thd kados: Koha refuses to work if I misspelt cancelled :0
15:10 kados thd: ?
15:10 thd: did you?
15:10 thd kados: yes :0
15:10 kados hehe
15:11 thd: where?
15:11 thd 952 $a librarian's text
15:13 wait a minute maybe I am misspelling it now.  Or it was universally misspelt by LC.
15:16 kados arrrg!
15:17 thd kados: arrrg?  do you not have enough arguments?
15:18 kados hehe
15:20 marc_biblio             |
15:20 | marc_blob_subfield      |
15:20 | marc_breeding           |
15:20 | marc_subfield_structure |
15:20 | marc_subfield_table     |
15:20 | marc_tag_structure      |
15:20 all are the same with another rel_2_2 db I have
15:32 thd: something about this marc21 framework isn't sitting right with NPL's system
15:33 works fine in stock rel_2_2
15:34 so it can't be related to marc_tag_structure or marc_subfield_structure
15:35 could it be dev_week codebase?
15:35 thd kados: owen refused to make any changes in the NPL framework long before I had worked on a standard MARC 21 framework because previous template problems with editing the framework had caused corruption and were very difficult to undo.
15:35 kados thd: yep, I remember that
15:35 thd: back then frameworks were a mystery to us :-)
15:36 thd kados: The NPL SQL DB has legacy buggy crust from previous versions like extra columns where they are not used.
15:37 kados hehe
15:38 thd kados: extra columns should not be a problem really if the code is verbose enough to be careful about columns.
15:40 kados: my framework code is not careful so to name the columns on each line.  I discussed the issue with paul before I committed.  He agreed that this was not a problem for the framework until a column is added in the future and then the framework would need updating in any case.
15:41 kados hmmm
15:41 some strangeness happening
15:42 thd kados: less verbose lines were easier to edit in vim
15:42 kados Q2 : select distinct m1.bibid from biblio,biblioitems,marc_biblio,marc_word as m1,marc_word as m2,marc_word as m3,marc_word as m4,marc_word as m5,marc_word as m6,marc_word as m7,marc_word as m8,marc_word as m9 where biblio.biblionumber=marc_biblio.biblionumber and biblio.biblionumber=biblioitems.biblionumber and m1.bibid=marc_biblio.bibid and (m1.bibid=m2.bibid and m1.bibid=m3.bibid and m1.bibid=m4.bibid and m1.bibid=m5.bibid and m1.bibid=m6.bibid and m1.bibid=m7.bib
15:42 tons of things like that
15:42 in the log
15:44 tumer[A]: I ran:
15:44 update koha.biblio,koha.marc_biblio set biblio.frameworkcode=marc_biblio.frameworkcode where marc_biblio.biblionumber=biblio.biblionumber;
15:44 tumer[A]: could that be related to the problem?
15:44 thd kados: export the NPL SQL DB tables and column names without the data and do the same for rel_2_2 then run a diff on the output
15:44 kados thd: ok
15:51 thd: doesn't look like any significant changes :(
15:55 brb
16:15 still no ideas for why the frameworks are messed up :(
16:16 thd kados: are the frameworks messed up?
16:16 kados thd: well ... I can't use the editor
16:16 thd: it comes up blank
16:17 thd kados: mysqldump -d --allow-keywords --singletransacton [-h YourMySQLServername] -u YourKohaMySQLUsername -p YourKohaDatabasename > KohaNoDataBackup.sql
16:18 tumer kados:biblio now holds the frameworkcode but they are still in marc_subfields_structure table
16:19 kados thd: mysqldump: unknown option '--singletransacton'
16:19 so I need to remove that column from marc_subfields_structure?
16:19 thd kados: the -d or --no-data option exclude the data then you can diff the good version and the problem version DB structure.
16:20 kados: leave that option out if it is incompatible with your MySQL install
16:20 kados thd: http://zoomopac.liblime.com/koha.sql
16:20 thd: that's the one that is failing
16:21 thd: I assume you have a rel_2_2 db to diff it with
16:21 thd kados: yes but you have many do you not?
16:22 kados: you had uninteresting differences
16:22 ?
16:22 kados yes, like encoding
16:22 thd and ?
16:22 kados and new columns added in to work with dev-week
16:22 that's all I saw
16:23 tumer kados: can you revert to NPL framework?
16:23 thd kados: do you not need the devel-week columns?
16:23 kados tumer: yes
16:24 tumer in fact go as back as your editor was working
16:24 and thats get circ working on that
16:27 ping me as i am deep under a zebra
16:29 kados tumer: I reverted and the editor still doesn't work
16:29 tumer: I wonder if it's the code in dev-week
16:29 strange that there is no error
16:30 tumer dev_week addbiblio.pl templates are all the same as any rel_2 no changes
16:31 kados yea
16:32 it must be npl database
16:32 but I can't find where :(
16:32 tumer dev_week differs in biblio,pm some dtabase added columns and circ2.pm
16:34 i  thought up untill now your code was working with dev_week zebra serach, marc editor etc
16:36 kados select count(*) from marc_tag_structure where frameworkcode='';
16:36 108
16:36 tumer: it was working with a stock rel_2_2 db with some modifs
16:36 tumer: now I attempt to upgrade a NPL database
16:44 tumer: so if i start with a stock rel_2_2 it works, but if I upgrade NPL it doesn't :(
16:45 tumer so upgrading path problrms?
16:46 kados yes
16:46 tumer is NPL dd so much different?
16:46 kados but I can't identify where the problem is
16:51 ha!
16:51 select frameworktext, frameworkcode from biblio_framework;
16:51 empty set
16:51 rach morning
16:51 kados hmmm
16:51 empty on rel_2_2 too
16:51 morning rach
16:52 tumer kados:its normal
16:52 biblio holds the name of the framework if it exsist for that specific biblio
16:52 if it is default (ususlly is) its empty
16:53 empty frameworkname is no problem and at this stage more healthy
16:53 untill we resolve other issues
16:54 select * from marc_subfield_structure where kohafield='items.onloan'  -- does this work
16:55 kados tumer: no!
16:55 tumer so you could not map it than /you meaning the code
16:56 kados yea
16:56 who!
16:57 select kohafield from marc_subfield_structure where kohafield is not null;
16:57 gives a bunch of blanks
16:58 and some with values
16:58 and duplicates!
16:59 tumer manually add it=> "UPDATE marc_subfeld_structure set kohafeld='items.onloan' where tagfeld='952' and tagsubfield='a'
16:59 duplicates unless have differnt frameworkcodes messes it up
17:00 try: select kohafield from marc_subfield_structure where kohafield<>''
17:03 kados weird
17:03 tumer: UPDATE marc_subfield_structure set kohafield='items.onloan' where tagfield='952' and tagsubfield='a';
17:03 Query OK, 0 rows affected (0.00 sec)
17:03 Rows matched: 0  Changed: 0  Warnings: 0
17:03 select kohafield from marc_subfield_structure where kohafield = 'items.onloan';
17:03 Empty set (0.00 sec)
17:03 wtf!
17:03 tumer so you do not have 952$a either
17:03 kados ahh ... 952 doesn't exist
17:04 952 b is there, but duplicated
17:04 tumer i thought they use 952
17:04 kados | 952      | b           | homebranch   | homebranch |          0 |         0 | items.homebranch |   10 | branches         |                    |               | NULL    | NULL         |   NULL |  NULL |               | NULL |
17:04 | 952      | b           | homebranch   | homebranch |          0 |         0 | items.homebranch |   10 | branches         | NULL               |               |         |              |      0 |     0 |               |      |
17:04 so one frameworkcode is null, the other is blank
17:05 no, both are blank
17:05 tumer kados thats not normal
17:05 kados so that's got to be the problem
17:06 tumer where do they map items?
17:06 kados 952
17:07 tumer where is it?
17:07 kados where is what?
17:08 tumer you only have 952$b where is the rest
17:08 kados it's all in there
17:08 I deleted everything now
17:08 marc*structure
17:08 and imported thd's framework from rel_2_2
17:08 now there are no dupliantes
17:08 duplicates even
17:08 still no MARC editor :(
17:08 thd kados: you have a frameworkcode column in the biblio table
17:09 tumer thd: it used to be in marc_biblio(deprecetaed) now in biblio
17:10 kados tumer: should I remove it from marc_biblio?
17:10 tumer should not matter. In fact remove the whole table
17:12 marc editor does not rely on neither. No frameworkcode means default frameworkcode
17:12 kados drop table if exists marc_biblio;
17:13 no change of course :-0
17:15 thd kados: `bibliothesaurus.father` was changed from char(80) NOT NULL default '' to bigint(20) NOT NULL default '0'
17:15 kados ok, I'm gonna take dinner
17:15 I'll come back with a fresh mind
17:16 (I hope)
17:16 tumer goodnight all
17:17 thd good night tumer
17:34 kados thd: find anything interesting? :-)
17:34 thd kados: only what I posted above
17:34 kados: `bibliothesaurus.father` was changed from char(80) NOT NULL default '' to bigint(20) NOT NULL default '0'
17:35 kados thd: that doesn't seem related does it?
17:35 thd kados: changing data types could be a problem especially if the old default is now invalid
17:36 kados thd: yes, but bibliothesaurus.father isn't used in the marc editor that I'm aware of
17:37 rach man you're a quick eater :-)
17:37 kados rach: :-)
17:38 thd kados: there are also three columns in a different order from previously but Koha code should be careful about naming the columns to be filled
17:38 kados yep
17:38 thd rach: who can eat when some code is broken? :)
17:39 rach: or sleep even?
17:41 kados: I assume that you no longer have the extra hidden column as indicated by your MySQL dump.
17:45 kados ?
17:45 which extra hidden column?
17:46 thd kados: `marc_tag_structure.hidden`
17:47 kados no, no hidden there anymore
17:48 thd kados: the size you have for `systempreferences.value` as varchar (200) will lead to horrible problems with truncated values in the ISBD preference
17:49 kados: I have `systempreferences.value` as TEXT
17:49 kados right
17:49 but that's unrelated to our current problem :-)
17:50 thd kados: maybe that is a clue.  I know that data size errors have caused Koha to stop functioning when a value was arbitrarily truncated.
17:54 kados: I do not see any other data size differences
17:55 kados bbiab
17:55 thd kados: I mostly see that you have extra columns for Zebra
17:56 dewey: iab?
17:56 dewey no idea, thd
17:57 thd dewey: shortly?
17:57 dewey thd: wish i knew
17:58 thd dewey: a bit?
17:58 dewey thd: bugger all, i dunno
18:00 thd dewey: has your memory been wiped?
18:00 dewey thd: bugger all, i dunno
18:00 thd apparently ;)
18:46 kados if I switch the codebase back to rel_2_2 I can edit MARC records again :(
18:52 thd kados: I thought that editing was specifically broken in rel_2_2
18:53 s/broken/very buggy/
18:53 kados it is
18:53 but in dev-week the editor doesn't work at all ... the record doesn't even display :-)
18:53 thd kados: so the only code that works does not work?
18:54 kados thd: http://zoomkoha.liblime.com/cg[…]mple/addbiblio.pl
19:19 thd kados: I missed a typo that hid 006.  It is rarely used so it may not matter hugely.  I corrected the problem before but Imagined that I had not created it.
19:20 kados: I have committed the correction
19:32 kados thx
03:26 chris evening
07:24 btoumi hi all
08:05 kyle kados: are you around?
08:10 kados kyle: sure am
08:10 kyle: what's up?
08:28 btoumi kdaos are u around?
08:28 sorry kados are u around?
08:29 kados: are u around?
08:30 kados btoumi: yep
08:30 btoumi hi kados how are u?
08:30 kados pretty good, and you?
08:30 so very happy :-)
08:30 add / edit / with biblio/items and circ is working :-)
08:30 as well as search :-)
08:30 btoumi little sad for french football team but happy for koha team
08:31 kados hehe
08:31 btoumi i have a question about fines
08:31 kados sure
08:31 btoumi i work on it now
08:31 kados great!
08:31 fines are a mess IMO :-)
08:31 btoumi and i want to know what is the different possible value for accounttype
08:32 kados right
08:32 btoumi can u help me
08:32 kados chris would be the one to ask ...
08:32 btoumi ?
08:32 kados sorry :-)
08:32 btoumi no problemo;=)
08:34 but i think there is a lot of work on this part
08:36 kados: another question for u
08:36 are u ok?
08:36 kados am I ok?
08:37 well ... I'm very tired :-)
08:37 but other than that, yes :-)
08:37 i will be much more ok when this zebra project is completed
08:37 btoumi ok i make u a promise it's the last question
08:39 have u ever seen this message =>"Can't locate object method               "_conn" via package "error""
08:40 when i try to use catalogue menu and try to do a search
08:43 kyle kados: I see there is a notes field in the items table, but I've looked through both the npl and default templates, and cannot find an area actually *add* a note to an item. Am I just not seeing it, or has nobody implemented it in any template set?
08:50 kados kyle: if it is exposed in the framework it will show up in the item editor
08:51 btoumi: yes, I have :-)
08:51 btoumi: but can't remember where :-) ... maybe google knows
08:51 kyle kados: I just found the notes field in the default template set, but koha never saves the note.
08:52 kados kyle: if it is exposed in the framework it will show up in the item editor
08:52 kyle: you need to make sure you have a MARC mapping set up for the itemnotes field
08:52 kyle: in your Biblio Framework
08:53 kyle: if you do, and the visibility flag for it is correct, it will show up in the item edit screen
08:53 btoumi ok ty and good night kados:
08:53 kyle kados: Thanks for the tip. Also, Cindy wanted to know how to change the instances of Branch Codes into Branch Names in the OPAC
08:54 kados there should be a variable in the template called branchname
08:54 just substitute branchcode for branchname
08:55 kyle just to make sure we're on the same page, you mean that any instance of NPL would then be replaced with Nelsonville Public Library?
09:04 kados yep
09:05 kyle excellent, thanks for the info.
09:05 brb, fire drill ; )
10:02 kados hey owen
10:02 owen: we're all synched up :-)
10:02 owen: there are still a few manual synchs I'm working on
10:02 owen: how's it going?
10:04 sweet
10:04 owen Encoding seems to be a problem for anyone who tries to do something out of the ordinary!
10:05 kados yea
10:05 owen I'm not sure I understand where dev_week is in the grand scheme of things
10:06 kados ok ... here's my plan
10:06 rel_2_2 is very close to 2.2.6
10:06 dev_week is rel_2_2 with zebra ... ie, same API as rel_2_2
10:07 so dev_week will become rel_2_4 and 2.4
10:07 basically, we just need to test it
10:07 to make sure everything is working
10:07 then, we need to wait on paul to fix some bugs in rel_2_2
10:07 merge them in
10:07 (like acquisitions)
10:07 and we can release 2.4
10:07 HEAD is using a completely different API
10:08 which will become 3.0 eventually
10:08 make sense?
10:09 owen Yeah, I think so.
10:09 kados so our job is to test the heck out of dev_week
10:09 we need to make some changes to the templates too
10:10 to add the new search API
10:10 (the one API that is different in dev_week)
10:10 owen What's the status of the MARC editor?  You said you reverted to a working version but it lacks some of the recently added features?
10:10 kados right
10:10 I made a booboo :-)
10:10 and reverted rel_2_2 a bit too far back
10:11 I'll fix it today
10:12 owen If it was completely broken anyway, maybe it's not a bad thing
10:12 kados yea ... at least it works now
10:13 I'm also working on a new framework for NPL
10:13 that will be updated tonight
10:56 owen: so your plate pretty full at the moment?
10:57 owen I'm just trying to decide what to fill it up with
10:57 kados :-)
10:58 we're pretty close to golive as far as NPL's database goes
10:58 I've got to spend about half an hour writing an email here in a sec (just had an interesting chat with a company who's looking for an ILS solution)
10:59 but when I get back I'd like to start hammering away at testing on zoomkoha and zoomopac
10:59 and implementing the stuff we talked about yesterday
10:59 statuses and such
10:59 owen Sounds good.
10:59 kados so if you're available to work on that with me, that'd be fantastic :-)
11:01 owen Yes

← Previous day | Today | Next day → | Search | Index

koha1