You need to group by event_text, not obj_text:
select source_id ,event_text,count(*) from event_loc
group by source_id,event_text;
> Date: Tue, 8 Feb 2011 16:31:39 +0530
> From: adarsh.sha...@orkash.com
> To: mysql@lists.mysql.com
> Subject: Group By Problem
>
> Dear all,
>
> I stuck arou
Are you using the strict SQL mode? Check your my.cnf file.
Peter
> Date: Fri, 4 Feb 2011 14:08:01 -0800
> From: awall...@ihouseweb.com
> To: mysql@lists.mysql.com
> Subject: Question about database value checking
>
> So, a problem popped up today that has caused us no end of hair-pulling, an
