[snip] Our box recently went down and after reconfiguring it we're left with a semi-operation mySQL. One error I'm getting is this:
mysql> select region from clip_art where region is not null and released = 'yes' group by region; ERROR 1: Can't create/write to file '/tmp/#sqld0e_76_1.MYI' (Errcode: 13) Removing the "group by" clause prevents the error. [/snip] Using perror 13 I get; root@myserver:/var/www/htdocs# perror 13 Error code 13: Permission denied So perhaps /tmp/ or #sqld0e_76_1.MYI has the wrong permissions HTH! Jay -- PHP General Mailing List (http://www.php.net/) To unsubscribe, visit: http://www.php.net/unsub.php