MySQL Forums
Forum List  »  Perl

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


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

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.



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


Options: ReplyQuote

Written By
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.