Sorry for late reply. It needs some luck and time to load the reply form without timing out and then successfully submit it.

Apparently people are so focused on code examples so that only @LanX and @ysth's replies did not completely miss the question. Actually I regret having edited the original post to add the suspected code, because it distracted from the question. But when some of the most respected forum users all demand to see code, it is sometimes not easy not to cave in.


The answer turned out to be this:

First I tried to find a method to log all DBI requests.

So I found the DBI::Log module, which unfortunately turned out dysfunctional (exiting the application after logging the first USE). However, its documentation hinted at an alternative: DBI Trace.

With DBI Trace it was easy as snap to find the actual offending command and its precise location, which was a different one than originally suspected.

Thank you all!

In reply to Re: Need advice how to diagnose the problem when syntax using MAX() is correct according to MySQL monitor, but errors out in DBI by dissident
in thread [SOLVED] Need advice how to diagnose the problem when syntax using MAX() is correct according to MySQL monitor, but errors out in DBI by dissident

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.