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

To make sure that there is no permissions problem etc, I even let DBI log on the MySQL server as root.

Even without seeing the code which fails (which you should indeed have shown - please do) it is obvious that it is not a permissions problem but rather a syntax problem because that is what the error message helpfully tells you. :-)

See also: SSCCE.

🦛

  • Comment on Re: Need advice how to diagnose the problem when syntax using MAX() is correct according to MySQL monitor, but errors out in DBI

In Section Seekers of Perl Wisdom