how to handle this problem with version 1.2.10
Posted: 08 Jun 2012, 06:13
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!
数据库查询失败。数据库返回的错误信息是：#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!