The Community Forums

Interact with an entire community of cPanel & WHM users!
  1. This site uses cookies. By continuing to use this site, you are agreeing to our use of cookies. Learn More.

MySQL Error No : 1

Discussion in 'Database Discussions' started by sachinthakkar25, Aug 17, 2012.

  1. sachinthakkar25

    sachinthakkar25 Registered

    Joined:
    Apr 26, 2012
    Messages:
    4
    Likes Received:
    0
    Trophy Points:
    1
    cPanel Access Level:
    Website Owner
    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.
     
  2. sachinthakkar25

    sachinthakkar25 Registered

    Joined:
    Apr 26, 2012
    Messages:
    4
    Likes Received:
    0
    Trophy Points:
    1
    cPanel Access Level:
    Website Owner
    hey all,,

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

    cPanelTristan Quality Assurance Analyst
    Staff Member

    Joined:
    Oct 2, 2010
    Messages:
    7,623
    Likes Received:
    21
    Trophy Points:
    38
    Location:
    somewhere over the rainbow
    cPanel Access Level:
    Root Administrator
    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:

    Code:
    df -kh /tmp
    ls -ld /tmp
    mount | grep tmp
    grep tmp /etc/fstab
    Please post the output for all 4 commands.

    Thanks!
     
  4. nikosv

    nikosv Registered

    Joined:
    Mar 5, 2012
    Messages:
    3
    Likes Received:
    0
    Trophy Points:
    1
    cPanel Access Level:
    Root Administrator
    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.
     
    #4 nikosv, Sep 30, 2012
    Last edited: Sep 30, 2012
  5. nikosv

    nikosv Registered

    Joined:
    Mar 5, 2012
    Messages:
    3
    Likes Received:
    0
    Trophy Points:
    1
    cPanel Access Level:
    Root Administrator
    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
     
Loading...

Share This Page