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?
--- 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,
> 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>
> 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.