Time Nick Message 11:29 kados hi paul 11:29 paul hi, (on phone) 11:29 kados :-) 11:30 kados (for some reason our marcDetail.pl scripts (in both opac and intranet) are turning up blank: http://66.213.78.67/cgi-bin/koha/opac-MARCdetail.pl?bib=16595 11:34 kados I tried adding warn "==>DUMP: @item_value_loop"; to line 181 to see if the data was getting into the array but I don't get anything 11:36 kados in fact, when I go to edit the marc record it's blank too 11:42 kados I also have this error: 11:42 kados [Tue Feb 15 16:10:04 2005] [error] [client 192.168.5.27] DBD::mysql::st execute failed: You have an error in your SQL syntax near 'where biblio.biblionumber=marc_biblio.biblionumber and biblio.biblionumber=bibli' at line 1 at /usr/local/koha/intranet/modules/C4/SearchMarc.pm line 272., referer: http://66.213.78.67/cgi-bin/koha/opac-search.pl?op=do_search&marclist=biblio.title&and_or=and&operator=contains&value=S.%20/ 11:45 kados I'm not sure if they are related though 12:04 paul kados, i'm back 12:04 paul the biblionumber=bibli is probably the origin of your problem 12:05 paul you should warn "Q : $query" just before the execute. 12:28 kados paul: Wwhich execute ? 12:31 paul the one that causes the DBD mysqle execute failed 12:39 paul hello owen 12:39 paul g'morning 12:39 owen Hi paul 12:40 owen I finally got your frameworks system figured out pretty well. 12:41 owen It's neat. I can really see how it will be useful. 12:45 owen I think I understand how authorities work now too, but I'm still not sure about Thesaurus. 12:55 paul ask me, i'll answer if I can 12:56 paul (note that ENSMP ask for better authorities support, and should fund some features) 12:56 paul no modifs in DB, just in scripts & GUI 13:05 owen How is Thesaurus different from Authorised Values? 13:05 paul mmm... 13:06 paul authorised values are useful for limited number of values. 13:06 paul a maximum of 30-50 13:06 paul thesaurus/authorities are useful for large number of values. 13:06 paul thesaurus are ordered list where authorities are not 13:07 paul (ordered hierarchically) 13:07 kados paul: I don't think that MARCdetail.pl uses SearchMarc.pm which is where the error is coming from 13:08 kados (on a different topic ;-)) 13:08 paul ??? for me (cvs i hope), MARCdetail uses SearchMarc.pm 13:08 kados hmmm 13:08 kados I added the "warn "Q : $query" 13:09 kados to line 272 of SearchMarc.pm and I don't get any warns in the log when I view MARCdetail 13:10 kados http://66.213.78.67/cgi-bin/koha/opac-MARCdetail.pl?bib=16595 13:10 kados here's an example of what's happening 13:24 kados so paul ... we just tried switching to the default template and we have the same problem 13:24 kados I'm not really sure where to look next 13:27 kados I added warn "==>DUMP: @item_value_loop"; to line 181 of opac-MARCdetail.pl and it comes up blank 13:27 kados NULL I think 13:27 paul (on phone) 13:31 kados under the '# now, construct template !' section on line 181 I added 'warn "==>DUMP: $witness{$subfield_code}";' to the last foreach ... and the warn doesn't show up in the log ...so that means that it's not called right? 14:06 kados paul I just checked out a brand new copy from CVS and the error is still there ... is it possible it's a bug either in the updatedatabase script or the scripts/modules/templates in CVS? 14:07 paul i don't have problems like you, that's all I can say ! 14:08 paul (& it's 6PM, my ideas are not really clear) 14:08 kados :-) 14:09 kados well we were planning to move to Koha 2.2 this week but this is a show stopper for us ... 14:11 kados I rerun updatedatabase and I get these errors: 14:11 kados DBD::mysql::st execute failed: Duplicate column name 'authtypecode' at updatedatabase line 1243. 14:11 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. 14:11 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. 14:12 kados might they be related? 16:34 owen Hi rach 17:25 rach hi owen 17:27 rach Owen check it out > http://katipo.co.nz/gallery/album18/appliance_better_copy 17:28 owen What is it?! 17:29 rach it's our new koha appliance - a server with koha and your library stuff preinstalled, delivered to your door ready to plug into your network with a one year support and maintenance programme :-) 17:29 rach and it's green :-) 17:30 rach cute aye 17:31 owen Very spiffy. 17:31 owen Now the katipo site needs a shopping cart system so people can come in and buy 3 at a time! 17:34 rach exactly, you're on to it :-) 17:42 hdl hello.