MySQL Error Occurred

Error Message:
1021: Disk full (/var/mysqltmp/#sql_6b78_22.MAI); waiting for someone to free some space... (errno: 28 "No space left on device")

SQL:
SELECT MATCH (name) AGAINST ('+Cameras Camcorders*' IN BOOLEAN MODE) as score, cubecart_inventory_widget.* FROM cubecart_inventory_widget WHERE MATCH (name) AGAINST ('+Cameras Camcorders*' IN BOOLEAN MODE) order by score DESC