List:General Discussion« Previous MessageNext Message »
From:Greg Meckes Date:May 2 2003 3:48pm
Subject:Re: fetchrow_array() failed: fetch() without execute() ..., with intermittant syntax error
View as plain text  
Sounds as if there might be a Perl syntax error???

This has happened to me as a result from single quotes from the input that aren't parsed
correctly. Also, maybe some vars aren't getting initialized.

Can we see the code?

Greg

--- Joel Rees <joel@stripped> wrote:
> We have a web system (Perl) that is intermittantly giving this error:
> 
>     DBD::mysql::st fetchrow_array() failed: fetch() without 
>     execute() at ... webmin
> 
> Sometimes it also gives this error
> 
>     DBD::mysql::st execute failed: You have an error in your 
>     SQL syntax near ') GROUP BY 
> 
> and so forth. 
> 
> We've dumped the statement that is being executed and run it from the
> command line without errors, but since these errors are intermittant,
> that is not surprising.
> 
> System information:
> Solaris 2.8 -- sparc
> perl 5.6.1
> MySQL 3.23.45
> Apache 1.3.27
> Mod-ssl 2.8.11
> OpenSSL 0.9.6i
> 
> These errors started showing up after upgrading apache and installing
> mod-ssl, and after raising the log level on apache. We are not,
> therefore sure if they were there before the upgrade.
> 
> Does this ring a bell with anyone? I've checked the archives and found
> some mention of possible deadlock related problems,
> 
>    http://marc.theaimsgroup.com/?l=msql-mysql-modules&m=102026513407236&w=2
> 
> and we're looking into that and other things we have thought of, but we
> would appreciate any leads we can get.
> 
> -- 
> Joel Rees <joel@stripped>
> http://www.alpsgiken.co.jp
> 
> 
> -- 
> MySQL Perl Mailing List
> For list archives: http://lists.mysql.com/perl
> To unsubscribe:    http://lists.mysql.com/perl?unsub=1
> 


__________________________________
Do you Yahoo!?
The New Yahoo! Search - Faster. Easier. Bingo.
http://search.yahoo.com
Thread
HELP: new db slownessJesus M. Arias Jr.21 Apr
  • HELP: new db slownessMichael Widenius21 Apr
  • Re: fetchrow_array() failed: fetch() without execute() ..., with intermittant syntax errorGreg Meckes2 May