MySQL Forums
Forum List  »  Perl

fetch() wihtout execute
Posted by: J Wyllie
Date: April 02, 2009 10:16AM

Hi

In our web server logs i have :

DBD::mysql::st fetchrow_arrayref failed: fetch() without execute()

The code is:

1 $self->{materialize_sth}->bind_param(1, $session->{data}->{_session_id});
2 $self->{materialize_sth}->execute;
3 my $results = $self->{materialize_sth}->fetchrow_arrayref;

This is in Apache::Session::Store::DBI.pm

My question is: under what circumstances could I see this message? Line 3 is failing but what happened at line 2?

The mysql error logs were not being maintained - i was hoping to see something there. I don't think just passing say undef as the parameter causes this error.

RaiseError is on.

Thanks

Justin

(ps. I have now got it to output the DBI::errstr but I'm trying to retrospectively see what could have gone wrong.)

Thanks

Options: ReplyQuote


Subject
Written By
Posted
fetch() wihtout execute
April 02, 2009 10:16AM


Sorry, you can't reply to this topic. It has been closed.

Content reproduced on this site is the property of the respective copyright holders. It is not reviewed in advance by Oracle and does not necessarily represent the opinion of Oracle or any other party.