[Koha-devel] marc_word rebuild problems
Joshua Ferraro
jferraro at athenscounty.lib.oh.us
Tue Jun 8 20:49:05 CEST 2004
Paul et al,
OK, I think I've got a marc_word rebuild script working finally ...
as long as subfieldvalue in marc_subfield_table is the same as
'sentence' in the MARCaddword subroutine.
However, I have been getting an internal server error from
apache as well as some strange errors in the opac-error_log when
I do a search using the new opac MARC search. I assume they are
related to recent changes in the code and constitute bugs but I
thought I'd better check and make sure that it's not a data problem
first. Here are the errors:
[Tue Jun 8 23:41:14 2004] [error] [client 24.208.182.186] Premature end of script headers: /usr/local/koha/opac/cgi-bin/opac-search.pl
DBD::mysql::st execute failed: Unknown column 'frameworkcode' in 'where clause' at /usr/local/koha/intranet/modules//C4/Biblio.pm line 230.
DBD::mysql::st fetchrow failed: fetch() without execute() at /usr/local/koha/intranet/modules//C4/Biblio.pm line 231.
DBD::mysql::st execute failed: Unknown column 'frameworkcode' in 'where clause' at /usr/local/koha/intranet/modules//C4/Biblio.pm line 234.
DBD::mysql::st fetchrow failed: fetch() without execute() at /usr/local/koha/intranet/modules//C4/Biblio.pm line 236.
DBD::mysql::st execute failed: Unknown column 'hidden' in 'field list' at /usr/local/koha/intranet/modules//C4/Biblio.pm line 244.
DBD::mysql::st fetchrow failed: fetch() without execute() at /usr/local/koha/intranet/modules//C4/Biblio.pm line 254.
Q : select distinct m1.bibid from biblio,biblioitems,marc_biblio,marc_word as m1 where biblio.biblionumber=marc_biblio.biblionumber and biblio.biblionumber=biblioitems.biblionumber and m1.bibid=marc_biblio.bibid and (m1.word like 'Chorao%' and m1.tag+m1.subfieldid in ('100a')) order by biblio.title at /usr/local/koha/intranet/modules//C4/SearchMarc.pm line 170.
Can't use an undefined value as a HASH reference at /usr/local/koha/intranet/modules//C4/SearchMarc.pm line 266.
[Tue Jun 8 23:41:29 2004] [error] [client 24.208.182.186] Premature end of script headers: /usr/local/koha/opac/cgi-bin/opac-search.pl
BTW: here is the final build_marc_word script:
#!/usr/bin/perl -w
use lib '/usr/local/koha/intranet/modules/';
use strict;
use C4::Context;
use C4::Biblio;
my $dbh=C4::Context->dbh;
my @tags=(100, 245);
foreach my $tag (@tags) {
my $query="SELECT bibid,tag,tagorder,subfieldid,subfieldorder,subfieldvalue FROM marc_subfield_table WHERE tag=? limit 0,20";
my $sth=$dbh->prepare($query);
$sth->execute($tag);
while (my $data=$sth->fetchrow_hashref()){
MARCaddword($dbh,$data->{'bibid'},$data->{'tag'},$data->{'tagorder'},$data->{'subfieldid'},$data->{'subfieldorder'},$data->{'subfieldvalue'});
}
}
$dbh->disconnect();
NPL is compiling a list of important tags to index and I'll add those when
I have the complete list and commit the script to CVS...
Thanks,
Joshua
> Paul et al,
>
> Here's the latest version of the script (the other one had some serious
> syntax errors :-)). I still get the following error when I run it and
> marc_word is not getting populated. Is the MARCaddword subroutine not
> working properly or am I confused about how to use it? 'sentence' is
> just the 'subfieldvalue' in marc_subfield_table, right?
>
> #!/usr/bin/perl -w
> use lib '/usr/local/koha/intranet/modules/';
> use strict;
> use C4::Context;
> use C4::Biblio;
> my $dbh=C4::Context->dbh;
> #FIXME: for now tag 100 is hardcoded; eventually I plan
> #to derive a list of tags (and subfields?) from an outfile
> my $tag="100";
>
> my $query="SELECT bibid,tag,tagorder,subfieldid,subfieldorder,subfieldvalue FROM marc_subfield_table WHERE tag=? LIMIT 0,20";
> my $sth=$dbh->prepare($query);
> $sth->execute($tag);
> while (my $data=$sth->fetchrow_hashref()){
> MARCaddword($dbh,$data->{'bibid'},$data->{'tag'},$data->{'subfieldid'},$data->{'subfieldorder'},$data->{'subfieldvalue'});
> }
> $dbh->disconnect();
>
>
> -------------------------------------------------------
> This SF.Net email is sponsored by: GNOME Foundation
> Hackers Unite! GUADEC: The world's #1 Open Source Desktop Event.
> GNOME Users and Developers European Conference, 28-30th June in Norway
> http://2004/guadec.org
> _______________________________________________
> Koha-devel mailing list
> Koha-devel at lists.sourceforge.net
> https://lists.sourceforge.net/lists/listinfo/koha-devel
More information about the Koha-devel
mailing list