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.

In reply to Re: Re: MySQL Errors by biograd
in thread MySQL Errors by Anonymous Monk

Title:
Use:  <p> text here (a paragraph) </p>
and:  <code> code here </code>
to format your post, it's "PerlMonks-approved HTML":


  • Posts are HTML formatted. Put <p> </p> tags around your paragraphs. Put <code> </code> tags around your code and data!
  • Titles consisting of a single word are discouraged, and in most cases are disallowed outright.
  • Read Where should I post X? if you're not absolutely sure you're posting in the right place.
  • Please read these before you post! —
  • Posts may use any of the Perl Monks Approved HTML tags:
    a, abbr, b, big, blockquote, br, caption, center, col, colgroup, dd, del, details, div, dl, dt, em, font, h1, h2, h3, h4, h5, h6, hr, i, ins, li, ol, p, pre, readmore, small, span, spoiler, strike, strong, sub, summary, sup, table, tbody, td, tfoot, th, thead, tr, tt, u, ul, wbr
  • You may need to use entities for some characters, as follows. (Exception: Within code tags, you can put the characters literally.)
            For:     Use:
    & &amp;
    < &lt;
    > &gt;
    [ &#91;
    ] &#93;
  • Link using PerlMonks shortcuts! What shortcuts can I use for linking?
  • See Writeup Formatting Tips and other pages linked from there for more info.