PDA

View Full Version : problem with database error


pbforum
07-25-2012, 08:53 AM
hi
please help me .. i can'taccess my admin panel
why this problem with my forum .. my vbulletin forum version is 4.2.0


Database error in vBulletin 4.2.0:

Invalid SQL:

SELECT setting.*, settinggroup.grouptitle
FROM settinggroup AS settinggroup
LEFT JOIN setting AS setting USING(grouptitle)
WHERE settinggroup.displayorder <> 0
ORDER BY settinggroup.displayorder, setting.displayorder;

MySQL Error : Got error 28 from storage engine
Error Number : 1030
Request Date : Wednesday, July 25th 2012 @ 05:59:13 AM
Error Date : Wednesday, July 25th 2012 @ 05:59:13 AM
Script : http://punjabiforum.in/forum/admincp/options.php?null=0
Referrer : https://punjabiforum.in/forum/admincp/index.php?do=nav
IP Address : 94.59.200.210
Username : pendu
Classname : vB_Database
MySQL Version : 5.5.24-cll

Sarteck
07-25-2012, 09:15 AM
You're out of disk space.

You've got to clean up some files. See if any huge log files need to be deleted. :P

pbforum
07-25-2012, 11:54 AM
which disk space from vbulletin forum or my server space

Sarteck
07-25-2012, 12:10 PM
Your server, which includes your forum. If your forum database is too large, that could be the cause--in that case, your only hope is to upgrade your server to one with more space.

Do you have command-line access? A good way to find out the largest files on your server (if you do) is to run the command
sudo du -a / | sort -n -r | head -n 10
That will give you the ten largest files. If the Logs are filling up your space, you could probably safely delete them.

pbforum
07-25-2012, 12:20 PM
may be i have aa problem with activity stream ..
i have 1 tb space server

and database size is : 27.47 MB

Sarteck
07-25-2012, 12:22 PM
If database is less than 30MB and you have a TB of space, yeah, your problem is elsewhere. Large files, somewhere. Look for 'em, or contact your host if necessary.

pbforum
07-25-2012, 12:25 PM
check this image i have no large file

https://vborg.vbsupport.ru/external/2012/07/15.jpg

kh99
07-25-2012, 12:33 PM
If your disk is partitioned, you could have lots of free space and still be out of space on a partition. Also, the last time someone asked about this it turned out that they had space but the file system had a problem and needed to be repaired.

soniceffect
07-25-2012, 09:09 PM
log into your server via ssh and run the following. This should give you an idea of whether its partitions or not

df -h

pbforum
07-26-2012, 06:26 PM
thankssssssssss