PDA

View Full Version : SQL error


chriz
20th of February 2004 (Fri), 03:49
Hello,

I suspect my server to be the cause (I already emailed them) but maybe someone knows what's happening by looking at the error code below:

Exhibit Engine MySQL error!
ERROR FROM QUERY group_links in page 'index':

------------------------------
Can't create/write to file '/tmp/#sql_2b41_0.MYI' (Errcode: 13)

Thanks,
Chriz

Pekka
20th of February 2004 (Fri), 04:35
Error code 13 means: Permission denied.

Perhaps some admin messed with disk permissions.
Because this is not query error but mysql internal error only one who can fix it is your server admin.

See http://www.mysql.com/doc/en/perror.html

chriz
20th of February 2004 (Fri), 04:42
I have to wait until the guys in Philadelphia wake up.
I'll post when I know more.

Thanks,
Chriz

chriz
20th of February 2004 (Fri), 05:52
PROBLEM SOLVED.

Hey,

I apologize. It should be working now. Please let me know if it is
not. There was a new kernel exploit released so we had to recompile
the kernel to keep the servers safe. When we rebooted, the /tmp
directory lost its correct permissions therefore none of your scripts
could write to the /tmp directory, thus the error. Please let me know
if you have any other issues. Thanks.

Chriz

Pekka
20th of February 2004 (Fri), 06:01
Knew it! :twisted:

good to hear it's ok now.