Re: php mysql error
| From: | Adam Williams | Date: | Wed, 04 Sep 2002 18:12:54 +0000 |
| Subject: | Re: php mysql error | ||
| References: | 1 | Groups: | php.general |
| Request: | Send a blank email to php-general+get-115204@lists.php.net to get a copy of this message | ||
whats the permissions on /tmp? it should be set to 1777
Adam
On Wed, 4 Sep 2002, ROBERT MCPEAK wrote:
> 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.
>
> Can anybody tell me how to fix this?
>
> Thank you.
>
>
>
>