help with mysql

[sammykay]

does anyone know how to fix this sql error? it's dealing with 4Images Gallery:

DB Error: Bad SQL Query: SELECT c.cat_id, c.cat_name, c.cat_description, c.cat_parent_id, c.cat_hits, c.cat_order, c.auth_viewcat, c.auth_viewimage, c.auth_download, c.auth_upload, c.auth_directupload, c.auth_vote, c.auth_sendpostcard, c.auth_readcomment, c.auth_postcomment, COUNT(i.image_id) AS new_images FROM 4images_categories c LEFT JOIN 4images_images i ON (i.cat_id = c.cat_id AND i.image_date >= 1072666140 AND i.image_active = 1) GROUP BY c.cat_id ORDER BY c.cat_order, c.cat_name ASC
Can't create/write to file '/tmp/#sql_1be7_0.MYI' (Errcode: 13)

Warning: Cannot modify header information - headers already sent by (output started at /home/britneyi/public_html/includes/db_mysql.php:188) in /home/britneyi/public_html/includes/sessions.php on line 85

Warning: Cannot modify header information - headers already sent by (output started at /home/britneyi/public_html/includes/db_mysql.php:188) in /home/britneyi/public_html/includes/sessions.php on line 85

Warning: Cannot modify header information - headers already sent by (output started at /home/britneyi/public_html/includes/db_mysql.php:188) in /home/britneyi/public_html/includes/sessions.php on line 85

 

[TheLinuxGuy]

i know this is an old post but incase anyone else has this problem

chmod 0777 /tmp

from ssh