Hi, Paul,
I had a similar problem but determined it is not (or at least, mine was
not) a DBI or DBD::mysql issue.
I did find the cause, in my case. I'm not sure how this could happen
and why it would only affect one item out of thousands, but there was
"corruption" in the database itself (I
Did you find a solution to this problem? Cos I'm having the same difficulties.
so what does it mean?
http://pastebin.com/iTPCMusG
1.
<- dbd_st_execute 1 rows
2.
-> dbd_st_fetch for 2acbf5c22de0, chopblanks 0
3.
fetch() without execute() error 19 recorded: fetch() without execute()
it means it executed OK? $sth->rows will return 1 bu
have some
encoding issue with our Catalyst application.
then we upgraded the Perl to 5.10.1 and re-build the mod_perl 2.0.4
but in the new server, we keeping getting
DBD::mysql::st fetchrow_array failed: fetch() without execute()
or
DBD::mysql::db selectrow_array failed: fetch() without
1 and re-build the mod_perl 2.0.4
but in the new server, we keeping getting
DBD::mysql::st fetchrow_array failed: fetch() without execute()
or
DBD::mysql::db selectrow_array failed: fetch() without execute()
we have several MySQL servers and all the errors happens with
5.1.39-community-log
ld.sbc.com
-Original Message-
From: Ronald J Kimball [mailto:[EMAIL PROTECTED]
Sent: Tuesday, October 14, 2003 8:25 AM
To: NIPP, SCOTT V (SBCSI)
Cc: [EMAIL PROTECTED]
Subject: Re: Fetch without Execute...
On Tue, Oct 14, 2003 at 08:06:30AM -0500, NIPP, SCOTT V (SBCSI) wrote:
> I have
ailed: You have an error in your SQL syntax near
> 'key ='
> 1281-02F'' at line 1 at ./emc_data2.pl line 35, line 134.
> DBD::mysql::st fetch failed: fetch() without execute() at ./emc_data2.pl
> line 36
> , line 134.
You're focusing on the wrong error me
l line 35, line 134.
DBD::mysql::st fetch failed: fetch() without execute() at ./emc_data2.pl
line 36
, line 134.
Here is the pertinent section of script:
opendir(DATA, "$file_source");
while ($file = readdir(DATA)) {
if ($file =~ /^emc/) {
print "Processing $file
If the error is on the first fetchrow_hashref, there is not enough code to see
what the problem is. If it is the second fetchrow_hashref, finish should be
called after the while, if at all. If your while loop fetches all of the rows
and
fetches again to get the undef value which indicates no more
d
At 01:08 PM 9/3/2003 -0400, Michael Ragsdale wrote:
>At 12:43 PM 9/3/2003, NIPP, SCOTT V (SBCSI) wrote:
>>I keep coming up with this error, but I AM performing an execute
>>prior to the fetch. I have seen some other threads on this, and have
>>upgraded the DBD:Mysql to the latest version o
At 12:43 PM 9/3/2003, NIPP, SCOTT V (SBCSI) wrote:
I keep coming up with this error, but I AM performing an execute
prior to the fetch. I have seen some other threads on this, and have
upgraded the DBD:Mysql to the latest version on CPAN. Any ideas? Here is a
small portion of the code:
i
I don't think you should be calling finish before fetching. I think
that is the problem here.
Michael
> Date: Wed, 3 Sep 2003 12:01:03 -0500
> From: "NIPP, SCOTT V (SBCSI)" <[EMAIL PROTECTED]>
> To: [EMAIL PROTECTED]
> Cc: [EMAIL PROTECTED]
> Subject: R
ROTECTED]
Sent: Wednesday, September 03, 2003 11:54 AM
To: NIPP, SCOTT V (SBCSI)
Cc: [EMAIL PROTECTED]
Subject: Re: fetch( ) without execute( ) Error...
Which fetchrow_hashref line? I see two of them, but only one execute. You
need to include more code for anyone to kno
On Wed, Sep 03, 2003 at 11:43:48AM -0500, NIPP, SCOTT V (SBCSI) wrote:
> I keep coming up with this error, but I AM performing an execute
> prior to the fetch. I have seen some other threads on this, and have
> upgraded the DBD:Mysql to the latest version on CPAN. Any ideas? Here is a
> sm
)" <[EMAIL PROTECTED]>
09/03/2003 12:43 PM
To: [EMAIL PROTECTED]
cc:
Subject: fetch( ) without execute( ) Error...
I keep coming up with this error, but I AM performing an
execute
prior to the fetch. I have seen some other thre
I keep coming up with this error, but I AM performing an execute
prior to the fetch. I have seen some other threads on this, and have
upgraded the DBD:Mysql to the latest version on CPAN. Any ideas? Here is a
small portion of the code:
if ($rows2 == 1) {
my $vals = $test2->fetchrow_
16 matches
Mail list logo