What does this database error mean.

[thizzladen]

I got this in my email about 4 of them mailed to me from my website:

Database error in vBulletin 3.8.4:

Invalid SQL:
SHOW COLUMNS FROM user LIKE 'username';

MySQL Error : Can't create/write to file '/tmp/#sql_7a78_0.MYI' (Errcode: 28)
Error Number : 1
Request Date : Friday, September 25th 2009 @ 03:32:35 PM
Error Date : Friday, September 25th 2009 @ 03:32:35 PM
Script : http://www.rapidsharee.org/register.php?do=addmember
Referrer : http://www.rapidsharee.org/register.php?do=register
IP Address : 66.15.201.250
Username : DDD
Classname : vB_Database
MySQL Version :


And recently my forums keep going back in forth in time. It's like everything I did disappears (threads, any changes, etc.) and then comes back randomly, but mostly is gone .

And most of my katz traffic is showing up error pages because the threads I submitted yesterday don't exist no more .

It's suppose to show 290 threads and 9 members but it only shows 22 threads and 7 members and it switches back in forth .

thizzladen Reviewed by thizzladen on 26th Sep 2009. What does this database error mean. I got this in my email about 4 of them mailed to me from my website: Database error in vBulletin 3.8.4: Invalid SQL: SHOW COLUMNS FROM user LIKE 'username'; MySQL Error : Can't create/write to file '/tmp/#sql_7a78_0.MYI' (Errcode: 28) Error Number : 1 Request Date : Friday, September 25th 2009 @ 03:32:35 PM Rating: 5

[r0ck]

whos your host

[William Palmer]

Hi this error is coming from your hosting provider where it states this

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

does not have proper chmod in that folder so it cant do anything you will need to contact your host and get them to fix this this is a very easy fix

[GrandMaster]

Sounds like there is not enough space on the partition you are hosted on.

[Danny.M]

Ask your host to increase /tmp, 1gb should do

First, Make sure MySQL/Apache/
service httpd stop; service mysql stop

cd /var
dd if=/dev/zero of=tmpMnt bs=1024 count=1000000
mke2fs /var/tmpMnt
cd /
cp -R /tmp /tmp_old
mount -o loop,noexec,nosuid,rw /var/tmpMnt /tmp
chmod 0777 /tmp
cp -R /tmp_old/* /tmp/
rm -rf /tmp_old

Then add the entrys into fstab
nano -w /etc/fstab

add:
/var/tmpMnt             /tmp                    ext2    loop,noexec,nosuid,rw  0 0

restart apache/mysql
service mysql start; service apache start

(give this to your host)
(if you rip this gimme credit!)