MDB2 Error: unknown error

_doQuery: [Error message: Could not execute statement]
[Last executed query: SELECT * FROM members, listings 
WHERE listings.category_id =38 
AND listings.member_id = members.member_id 
AND members.verified = '1' 
AND members.active = '1' 
ORDER BY membership_type DESC]
[Native code: 1]
[Native message: Can't create/write to file '/tmp/#sql_708_0.MYI' (Errcode: 122)]