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

[hippo]

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.