Sorry it's late and I'm just posting this before bed. I've just started to receive this error when accessing members details. Got error 127 from table handler in query: SELECT u.*, SUM(if(p.completed, 1, 0)) AS count_of_completed, SUM(if(p.completed, p.amount,0)) as summa_of_completed FROM membership_members u LEFT JOIN membership_payments p ON (p.member_id=u.member_id) WHERE 1 GROUP BY u.member_id HAVING 1 ORDER BY u.login LIMIT 0, 20 I've had a quick look but cannot see it anywhere Regards John
Please run http://www.yoursite.com/amember/admin/repair_tables.php It happens because MySQL tables are broken in MySQL database.