UNFLUX.net

http://www.visualdesigncore.com/tutorials/

Database error in vBulletin 3.5.1:

Code: Select all

Invalid SQL:
SELECT DISTINCT category FROM tutorial;

MySQL Error  : Got error 28 from storage engine
Error Number : 1030
Date         : Thursday, November 24th 2005 @ 01:06:42 PM
Script       : http://www.visualdesigncore.com/tutorials/
Referrer     : http://www.visualdesigncore.com/
IP Address   : 24.18.53.237
Username     : Sicloan
Classname    : vb_database


Seems that you are having some storate issues. Please resolve soon!!!

Quote from vbulletin.org

Error code 28: No space left on device

One or more partitions on your server is out of space or doesn't have enough space to complete this operation. Shutdown your forums and contact your host immediately. You or your host will need to find out which partition is low on space and free up some more space.

http://www.vbulletin.com/forum/showpost ... stcount=11

I am loosing alot of revenue and traffic because of this.

edit:

I have removed all "select distinct" queries which has hurt my site, but i am still able to server a majority of my content.

Okay I believe this problem is now resolved (it was related to tmp space that mysql needs for functions such as distinct). I have increased tmp space from 100 MB to 800 MB. Can you please test for me and let me know if everything is fine now?

Also in the future whenever you have an emergency such as this (I would consider this one) the best way to get us working on the problem is to send an email to our support department. I am extremely sorry for the inconvience you had.

Thanks,
Brian

Thank you for your response. Next time i will send an email. The problem is fixed and working fine now. Plus I will try to cut down on the DISINCT queries because they are quite slow.