I have been struggling with this error from a very long time. I have niticed this when I run queries that uses group by.

These queries are simple queries that work on the local server and were working on the online server as well, now suddenly they are returning these errors.

one such query is:

SELECT id, username, fname, email
FROM table
group by email

I get the error from my php scripts, mysql front and even phpmyadmin.

I am running mysql 4.1.18 on a linux server with cpanel on a Pentium 4 2.4 Ghz server with 1 GB ram.

I have the root access to the server.

Kindly give some suggestion.
Thanks
Jaunty Edward