Can anyone out there help this "programming challenged" amember user When someone tries to sign up, they enter their info on the "sign up page", but once they press error, they get this error message: MYSQL ERROR: Can't create/write to file '/tmp/mysqltmp/#sql_18b7_0.MYI' (Errcode: 2) 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 amember_members u LEFT JOIN amember_payments p ON (p.member_id=u.member_id) WHERE 1 AND (u.email LIKE 'onipaa11@yahoo.com') GROUP BY u.member_id ORDER BY u.login Any help is greatly appreciated.
Send a tech support ticket- sounds like some sort of problem with the database settings or amember code. David