--- trunk/index_DBI_cache.pm 2004/02/11 08:33:51 226 +++ branches/drustvene/index_DBI_cache.pm 2005/01/02 21:24:51 627 @@ -69,9 +69,9 @@ #print "#### delete_and_create($field)\n"; my $sql = "select count(*) from $field"; - my $sth = $self->{dbh}->prepare($sql) || die $self->{dbh}->errstr(); + my $sth = $self->{dbh}->prepare($sql); # FIX: this is not a good way to check if table exists! - if ($sth->execute() && $sth->fetchrow_hashref) { + if ($sth && $sth->execute() && $sth->fetchrow_hashref) { my $sql = "drop table $field"; my $sth = $self->{dbh}->do($sql) || warn "SQL: $sql - ".$sth->errstr(); } @@ -102,13 +102,6 @@ #$sth_cache{$field."select"}->execute($index_data) || die "cache: $field select; ".$self->{dbh}->errstr(); - # XXX for some strange reason, it seems that some entries in my - # database produce strings which start with null byte. I suspect - # this to be bug in OpenIsis 0.9.0. - # This should fix it.. - $index_data =~ s/^[^\w]+//; - $index_data = substr($index_data,0,255); - my $uc = uc($index_data); if (! $c_table->{$field}->{$uc}) { #print stderr "in index: $index_data\n";