[Answered] 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

[Thunderbird]

According to a couple places I looked at, error 28 means that the server has no space to write to.

[Zachery]

MySQL Error : Got error 28 from table handler
Error Code 28 (No space left on device):
Got error 28 from table handler means your server's mysql partition for your mysql database ran out of disk space or that the /tmp directory ( http://www.mysql.com/doc/T/e/Temporary_files.html )on your server doesn't have enough space, you need to
1. close your forum to prevent further posting or writing to the database
2. contact your web host
3. or if your host yourself on a dedicated server, you need to move your mysql partition to a larger disk or change the /tmp directory location via your servers my.cnf file

[K!nG]

Can someone tell me how can i close my forum from forum.php or index.php because now my admincp isn't even working Thanks in advance.

[TheLastSuperman]

Upload tools.php to the admincp folder and close the forum using this script, you can find this in the do_not_upload upload folder in the vBulletin .zip file when extracted.

[K!nG]

Thanks "TheLastSuperMan" So once its close i should delete tools.php ?? am i right ? Once my issue is resolved can i turn it back on from admincp or something has to be done via index.php ?? Thanks for ur help.

- - - Updated - - -

Hey "Thelastsuperman" sorry i have never used tools.php before so if u don't mind can u tell me what exactly i should do after uploading tools.php via ftp. Thanks

[TheLastSuperman]

After you upload tools.php to the admincp folder visit the URL: http://www.yoursite.com/admincp/tools.php then close the forum using this script.

After you close the site delete tools.php from the server. Once your host resolves the issue you can then access the site normally and re-enable normally.

[K!nG]

Thanks "Thelastsuperman" my hosting already resolved the issue.. appreciate all ur help.
Thanks everyone for da help ... Issue resolved