APPLICATION ERROR #401
数据库查询失败。数据库返回的错误信息是：#1064: You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near ') GROUP BY bug_id' at line 1 查询语句：SELECT DISTINCT bug_id,MAX(last_modified) as last_modified, COUNT(last_modified) as count FROM mantis_bugnote_table WHERE mantis_bugnote_table.bug_id in () GROUP BY bug_id
Could anybody kindly give me a clue about how to solve the problem? Thanks!
how to handle this problem with version 1.2.10
Moderators: Developer, Contributor
Re: how to handle this problem with version 1.2.10
The problem was solved. It's originated by "order by" bug in mysql 6 alpha version.