Please whitelist cPanel in your adblocker so that you’re able to see our version release promotions, thanks!

The Community Forums

Interact with an entire community of cPanel & WHM users!

MySQL Error No : 1

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

  1. sachinthakkar25

    sachinthakkar25 Registered

    Joined:
    Apr 26, 2012
    Messages:
    4
    Likes Received:
    0
    Trophy Points:
    51
    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:
    51
    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,608
    Likes Received:
    32
    Trophy Points:
    238
    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!
     
    Stop hovering to collapse... Click to collapse... Hover to expand... Click to expand...
  4. nikosv

    nikosv Registered

    Joined:
    Mar 5, 2012
    Messages:
    3
    Likes Received:
    0
    Trophy Points:
    51
    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:
    51
    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

  1. This site uses cookies to help personalise content, tailor your experience and to keep you logged in if you register.
    By continuing to use this site, you are consenting to our use of cookies.
    Dismiss Notice