in reply to Re: MySQL Errors
in thread MySQL Errors

I agree with rob_au, more code would be helpful.

Page 117-8 of the _Programming the Perl DBI_...if your error says your disconnect invalidates an active statement handle, you probably have a statement handle that still has valid data that can be fetched from it. The purpose is to help you find places when a fetch loop might have been terminated *before* all the possible data was retrieved and the ACTIVE flag reset. You should read the section I mentioned for more understanding. Still, it probalby doesn't affect your program too much. If it bothers you, use the finish method to clean up. I've found that I have to call $sth_finish() for each statement handle I use in this table-filling script I'm working on. Some one with more expertise could probably point out where I'm causing the warning, but it doesn't seem to affect the output at all.

I'd like to also point out that this would be a DBI error rather than a MySQL error, if I guessed correctly about which one it was.