I get the following error when trying to browse users from CP: "An Error has occured -------------------------------------------------------------------------------- MYSQL ERROR: You have an error in your SQL syntax near 'DISTINCT u.member_id) FROM amember_members u LEFT JOIN ' at line 1 in query: SELECT COUNT(DISTINCT u.member_id) FROM amember_members u LEFT JOIN amember_payments p ON (p.member_id=u.member_id) WHERE 1 AND u.login LIKE 'A%' HAVING 1 " Here is my Software version info: aMember 2.1.1PRO PHP 4.0.6 (apache) OS Linux dev62 2.2.19-6.2.16 #1... MySQL 3.22.32 Is there a MySQL incompatibility by chance? -Fred