MySQL Error No : 1

[sachinthakkar25]

Hello all!

Anyone can help me in my problem??? From last few days i am getting this error...


Could not make the Query.


SELECT cat.*, f.*, fp.*, t.*, p.*, u.username , th.th_folder FROM aef_categories cat LEFT JOIN aef_forums f ON (cat.cid = f.cat_id) LEFT JOIN aef_forumpermissions fp ON (fp.fpfid = f.fid AND fp.fpugid = -1) LEFT JOIN aef_posts p ON (p.post_fid = f.fid AND p.pid = f.f_last_pid) LEFT JOIN aef_topics t ON (p.post_tid = t.tid) LEFT JOIN aef_users u ON (p.poster_id = u.id) LEFT JOIN aef_themes th ON (th.thid = f.id_skin) ORDER BY cat.order ASC , f.par_board_id ASC , f.forum_order ASC

MySQL Error No : 1

MySQL Error : Can't create/write to file '/tmp/#sql_e60_0.MYI' (Errcode: 30)


Try to search for this but cant get any solution. Please someone help me to solve this.. Thanking you in advance for any further help.

[sachinthakkar25]

hey all,,

still there is no responce. please help me to solve this unwanted issue...

[cPanelTristan]

What online posts did you find? This one has a good discussion:

Can't create/write to file '/tmp/#sql_b9c_0.MYI' (Errcode: 30) | Virtualmin

The issue is /tmp can't be written to. It is likely either full, has the wrong file permissions or is mounted noexec, which can be discovered by checking it:

df -kh /tmp
ls -ld /tmp
mount | grep tmp
grep tmp /etc/fstab

Please post the output for all 4 commands.

Thanks!

[nikosv]

Similar problem here (Can't create/write to file '/tmp/#sql_497_0.MYI' (Errcode: 28))
This prablem occured suddenly in a server that waw working correctly for months.
phpmyadmin also gives the following error: "Cannot start session without errors, please check errors given in your PHP and/or webserver log file and configure your PHP installation properly."

Here is the output of the above commands proposed by Tristran.

root@starlight [/]# df -kh /tmp
Filesystem Size Used Avail Use% Mounted on
/usr/tmpDSK 607M 174M 403M 31% /tmp
root@starlight [/]# ls -ld /tmp
drwxrwxrwt 4 root root 2813952 Sep 30 10:10 /tmp/
root@starlight [/]# mount | grep tmp
tmpfs on /dev/shm type tmpfs (rw)
/usr/tmpDSK on /tmp type ext3 (rw,noexec,nosuid,loop=/dev/loop0)
/tmp on /var/tmp type none (rw,noexec,nosuid,bind)
root@starlight [/]# grep tmp /etc/fstab
tmpfs /dev/shm tmpfs defaults 0 0
/usr/tmpDSK /tmp ext3 defaults,noauto 0 0

any help will be greatly appreciated.

[nikosv]

Fixed my problem recreating /tmp doing the following:

stop everything from going to /tmp:

# /usr/sbin/lsof /tmp

Run the following commands (in that specific order).

# /bin/umount -l /tmp
# /bin/umount -l /var/tmp
# /bin/rm -fv /usr/tmpDSK

and then to create the partition:

# /scripts/securetmp