member.php,usercp.php,private.php Database Errors.

[K!nG]

Hi Everyone,

Please help me out in this one ... Earlier this morning i wasn't able to access my forum and was getting 403 error & also u don't have permission to access this server error. I contacted my hosting and they said it was files/folders permission issue and they fixed it which i didn't change at all and don't know how it got changed not sure if someone hacked in or what... now when i logged in and try to read my private messages i got databse errors and then found 2 more database errors (these are 3 database errors that i found as of now). If someone can please help me out on this one i will really appreciate that.

Thanks



MEMEBER.PHP DATABASE ERROR

Database error in vBulletin 4.2.0:

Invalid SQL:


SELECT user.*, (user.options & 512) AS invisible , avatar.avatarpath, NOT ISNULL(customavatar.userid) AS hascustom, customavatar.dateline AS avatardateline, customavatar.filedata_thumb, customavatar.height AS avheight, customavatar.width AS avwidth, customavatar.width_thumb AS avwidth_thumb, customavatar.height_thumb AS avheight_thumb

FROM userlist AS userlist
INNER JOIN user AS user ON (user.userid = userlist.relationid)
LEFT JOIN avatar AS avatar ON (avatar.avatarid = user.avatarid)
LEFT JOIN customavatar AS customavatar ON (customavatar.userid = user.userid)

WHERE userlist.userid = 1
AND userlist.type = 'buddy'
AND userlist.friend = 'yes'

ORDER BY RAND()
LIMIT 0, 6;


MySQL Error : Got error 28 from storage engine
Error Number : 1030
Request Date : Tuesday, June 5th 2012 @ 08:54:03 PM
Error Date : Tuesday, June 5th 2012 @ 08:54:03 PM
Script : http://www.myysitee.com/member.php?1-MY USER NAME HERE
Referrer : http://www.myyysitee.com/forum.php
IP Address : xx.xx.xxx.xxx
Username : MY USER NAME
Classname : vB_Database
MySQL Version : 5.0.92-community

PRIVATE.PHP DATEBASE ERROR.

Database error in vBulletin 4.2.0:

Invalid SQL:


SELECT pm.*, pmtext.*
, icon.title AS icontitle, icon.iconpath

FROM pm AS pm
LEFT JOIN pmtext AS pmtext ON(pmtext.pmtextid = pm.pmtextid)
LEFT JOIN icon AS icon ON(icon.iconid = pmtext.iconid)

WHERE pm.userid=1 AND pm.folderid=0


ORDER BY pmtext.dateline DESC
LIMIT 0, 50;


MySQL Error : Got error 28 from storage engine
Error Number : 1030
Request Date : Tuesday, June 5th 2012 @ 08:56:17 PM
Error Date : Tuesday, June 5th 2012 @ 08:56:17 PM
Script : http://www.myysitee.com/private.php
Referrer : http://www.myysitee.com/forum.php
IP Address : xx.xx.xxx.xxx
Username : my user name
Classname : vB_Database
MySQL Version : 5.0.92-community

USERCP.PHP DATABASE ERROR

Database error in vBulletin 4.2.0:

Invalid SQL:


SELECT pm.*, pmtext.*, userlist_ignore.userid AS ignored
,icon.iconpath, icon.title AS icontitle
FROM pm AS pm
INNER JOIN pmtext AS pmtext ON(pmtext.pmtextid = pm.pmtextid)
LEFT JOIN userlist AS userlist_ignore ON
(userlist_ignore.userid = 1 AND userlist_ignore.relationid = pmtext.fromuserid AND userlist_ignore.type = 'ignore')
LEFT JOIN icon AS icon ON(icon.iconid = pmtext.iconid)
WHERE pm.userid = 1
AND pm.messageread = 0
ORDER BY pmtext.dateline DESC
LIMIT 5;


MySQL Error : Got error 28 from storage engine
Error Number : 1030
Request Date : Tuesday, June 5th 2012 @ 08:57:54 PM
Error Date : Tuesday, June 5th 2012 @ 08:57:54 PM
Script : http://www.myysitee.com/usercp.php
Referrer : http://www.myysitee.com/forum.php
IP Address : xx.xx.xxx.xxx
Username : my user name
Classname : vB_Database
MySQL Version : 5.0.92-community

[Simon Lloyd]

Thos show you got error 28 from storage engine, this means your hard disk is full or your allotted space is full, contact your hosts to increase the size of your storage space!

[K!nG]

Can u or anyone tell me how to close my forum from forum.php or index.php since i can't access it via admincp ?/ Thanks in advance.

[Simon Lloyd]

I dont think you can, you need to look at the tmp folder on your server, that may be full. What you could do, if your forum is in a folder, is just create a simple html file, call it index.html, create a new folder at the same level as your forum, rename you forum folder and name the new folder as your forum, drop in the index file you just made (of course this will have an apology on it to your members while you sort things out) and then you can try accessing www.mysite.com/myrenamedfolder/admincp and see if you can get on but really you need to get your host working on this if you dont have a dedicated box!

[K!nG]

Thanks for all ur help ... I contacted hosting at the same time and they fixed the problem right away forgot to update on this thread.. thanks