mysql err 1140_Mysql错误#1140如何解决

网站换了个服务器，本来运行很正常的，不知怎么回事页面打开后出现MySQLQuery:Selectmin(yf_game11.id)asid,sum(yf_game11_users_tz.hdpoints)ashdpoints,sum(yf_game11_users_tz.poi...

网站换了个服务器，本来运行很正常的，不知怎么回事页面打开后出现

MySQL Query:Select min(yf_game11.id) as id,sum(yf_game11_users_tz.hdpoints) as hdpoints,sum(yf_game11_users_tz.points) as tzpoints,yf_game11_users_tz.time from yf_game11,yf_game11_users_tz where yf_game11.id=yf_game11_users_tz.NO and uid=10001 and STR_TO_DATE(yf_game11_users_tz.time,'%Y-%m-%d')='2010-06-03'

Message:MySQL Query Error

的错误提示，执行此SQL命令后提示如下

#1140 - Mixing of GROUP columns (MIN(),MAX(),COUNT(),...) with no GROUP columns is illegal if there is no GROUP BY clause

似乎是分组问题

希望有人能够告诉我问题出现的原因和解决方法。

Select min(yf_game11.id) as id,sum(yf_game11_users_tz.hdpoints) as hdpoints,sum(yf_game11_users_tz.points) as tzpoints,yf_game11_users_tz.time from yf_game11,yf_game11_users_tz where yf_game11.id=yf_game11_users_tz.NO and uid=".intval( $_COOKIE['usersid'])." and STR_TO_DATE(yf_game11_users_tz.time,'%Y-%m-%d')='".date( "Y-m-d" )."'"

uid是yf_game11_users_tz这个表的，之前是同样的代码也运行的好好的，我也试过把表名加上去，但问题依旧。

展开