IRC log for #koha, 2005-02-18

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

All times shown according to UTC.

Time Nick Message
11:29 kados hi paul
11:29 paul hi, (on phone)
11:29 kados :-)
11:30 (for some reason our marcDetail.pl scripts (in both opac and intranet) are turning up blank: http://66.213.78.67/cgi-bin/ko[…]tail.pl?bib=16595
11:34 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 in fact, when I go to edit the marc record it's blank too
11:42 I also have this error:
11:42 [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/ko[…]ains&value=S.%20/
11:45 I'm not sure if they are related though
12:04 paul kados, i'm back
12:04 the biblionumber=bibli is probably the origin of your problem
12:05 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 hello owen
12:39 g'morning
12:39 owen Hi paul
12:40 I finally got your frameworks system figured out pretty well.
12:41 It's neat.  I can really see how it will be useful.
12:45 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 (note that ENSMP ask for better authorities support, and should fund some features)
12:56 no modifs in DB, just in scripts & GUI
13:05 owen How is Thesaurus different from Authorised Values?
13:05 paul mmm...
13:06 authorised values are useful for limited number of values.
13:06 a maximum of 30-50
13:06 thesaurus/authorities are useful for large number of values.
13:06 thesaurus are ordered list where authorities are not
13:07 (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 (on a different topic ;-))
13:08 paul ??? for me (cvs i hope), MARCdetail uses SearchMarc.pm
13:08 kados hmmm
13:08 I added the "warn "Q : $query"
13:09 to line 272 of SearchMarc.pm and I don't get any warns in the log when I view MARCdetail
13:10 http://66.213.78.67/cgi-bin/ko[…]tail.pl?bib=16595
13:10 here's an example of what's happening
13:24 so paul ... we just tried switching to the default template and we have the same problem
13:24 I'm not really sure where to look next
13:27 I added warn "==>DUMP: @item_value_loop"; to line 181 of opac-MARCdetail.pl and it comes up blank
13:27 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 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 (& it's 6PM, my ideas are not really clear)
14:08 kados :-)
14:09 well we were planning to move to Koha 2.2 this week but this is a show stopper for us ...
14:11 I rerun updatedatabase and I get these errors:
14:11 DBD::mysql::st execute failed: Duplicate column name 'authtypecode' at updatedatabase line 1243.
14:11 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 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 might they be related?
16:34 owen Hi rach
17:25 rach hi owen
17:27 Owen check it out > http://katipo.co.nz/gallery/al[…]iance_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 and it's green :-)
17:30 cute aye
17:31 owen Very spiffy.
17:31 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.

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

koha1