View Single Post
  #1  
Old 06-06-2012, 01:33 AM
K!nG K!nG is offline
 
Join Date: Dec 2010
Location: United States
Posts: 477
Благодарил(а): 0 раз(а)
Поблагодарили: 0 раз(а) в 0 сообщениях
Default member.php,usercp.php,private.php Database Errors.

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

Quote:
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.

Quote:
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

Quote:
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
Reply With Quote
 
X vBulletin 3.8.12 by vBS Debug Information
  • Page Generation 0.01332 seconds
  • Memory Usage 1,785KB
  • Queries Executed 11 (?)
More Information
Template Usage:
  • (1)SHOWTHREAD_SHOWPOST
  • (1)ad_footer_end
  • (1)ad_footer_start
  • (1)ad_header_end
  • (1)ad_header_logo
  • (1)ad_navbar_below
  • (3)bbcode_quote
  • (1)footer
  • (1)gobutton
  • (1)header
  • (1)headinclude
  • (6)option
  • (1)post_thanks_box
  • (1)post_thanks_button
  • (1)post_thanks_javascript
  • (1)post_thanks_navbar_search
  • (1)post_thanks_postbit_info
  • (1)postbit
  • (1)postbit_onlinestatus
  • (1)postbit_wrapper
  • (1)spacer_close
  • (1)spacer_open 

Phrase Groups Available:
  • global
  • postbit
  • reputationlevel
  • showthread
Included Files:
  • ./showpost.php
  • ./global.php
  • ./includes/init.php
  • ./includes/class_core.php
  • ./includes/config.php
  • ./includes/functions.php
  • ./includes/class_hook.php
  • ./includes/modsystem_functions.php
  • ./includes/functions_bigthree.php
  • ./includes/class_postbit.php
  • ./includes/class_bbcode.php
  • ./includes/functions_reputation.php
  • ./includes/functions_post_thanks.php 

Hooks Called:
  • init_startup
  • init_startup_session_setup_start
  • init_startup_session_setup_complete
  • cache_permissions
  • fetch_postinfo_query
  • fetch_postinfo
  • fetch_threadinfo_query
  • fetch_threadinfo
  • fetch_foruminfo
  • style_fetch
  • cache_templates
  • global_start
  • parse_templates
  • global_setup_complete
  • showpost_start
  • bbcode_fetch_tags
  • bbcode_create
  • postbit_factory
  • showpost_post
  • postbit_display_start
  • post_thanks_function_post_thanks_off_start
  • post_thanks_function_post_thanks_off_end
  • post_thanks_function_fetch_thanks_start
  • post_thanks_function_fetch_thanks_end
  • post_thanks_function_thanked_already_start
  • post_thanks_function_thanked_already_end
  • fetch_musername
  • postbit_imicons
  • bbcode_parse_start
  • bbcode_parse_complete_precache
  • bbcode_parse_complete
  • postbit_display_complete
  • post_thanks_function_can_thank_this_post_start
  • showpost_complete