Go Back   vb.org Archive > vBulletin 3 Discussion > vB3 General Discussions
FAQ Community Calendar Today's Posts Search

Reply
 
Thread Tools Display Modes
  #1  
Old 07-21-2008, 12:31 AM
veenuisthebest's Avatar
veenuisthebest veenuisthebest is offline
 
Join Date: Mar 2008
Location: India
Posts: 1,416
Благодарил(а): 0 раз(а)
Поблагодарили: 0 раз(а) в 0 сообщениях
Default Why did these DB errors occured ?

I got 3 different database errors today, I had never seen them before !! Just wanted to know why they occured ..

1.

Code:
Database error in vBulletin 3.7.0:

Invalid SQL:

		SELECT poll.*, thread.pollid, open, threadid, replycount, forumid 
		FROM poll AS poll
		INNER JOIN thread AS thread USING (pollid)
		
		WHERE open <> 10 AND visible = 1 AND active = 1
		 AND thread.forumid NOT IN(56)
		ORDER BY RAND() DESC;

MySQL Error   : Got error 28 from storage engine
Error Number  : 1030
Request Date  : Sunday, July 20th 2008 @ 08:03:10 PM
Error Date    : Sunday, July 20th 2008 @ 08:03:10 PM
Script        : http://www.***.com/forum/portal.php
Referrer      : http://www.***.org/forum/portal.php
IP Address    : 99.228.73.66
Username      : Unregistered
Classname     : vB_Database
MySQL Version :

2. (Looks like a hacking attempt, coz I have no such user)

Code:
Database error in vBulletin 3.7.0:

Invalid SQL:
SHOW COLUMNS FROM user LIKE 'username';

MySQL Error   : Got error 28 from storage engine
Error Number  : 1030
Request Date  : Sunday, July 20th 2008 @ 10:44:47 PM
Error Date    : Sunday, July 20th 2008 @ 10:44:48 PM
Script        : http://www.***.com/forum/register.php?do=addmember
Referrer      : http://www.***.com/forum/register.php
IP Address    : 209.67.216.138
Username      : teenmovienude
Classname     : vB_Database
MySQL Version :
3.

Code:
Database error in vBulletin 3.7.0:

Invalid SQL:


    SELECT imageid, images.title, filename, thumbname, originalname, extension, images.catid  ,images.userid, images.username, images.description, images.dateline, images.views, posts ,width, height, originalwidth, originalheight ,filesize, originalfilesize, images.lastpostdateline, images.lastpostuserid, images.lastpostusername, votenum, votetotal

    FROM ppgal_images AS images

    

    WHERE  valid = 1 

AND images.catid IN (4)



AND images.thumbname != ''





    ORDER BY RAND()

    LIMIT 4;

MySQL Error   : Got error -1 from storage engine
Error Number  : 1030
Request Date  : Monday, July 21st 2008 @ 12:24:15 AM
Error Date    : Monday, July 21st 2008 @ 12:24:16 AM
Script        : http://www.***.com/forum/portal.php
Referrer      : 
IP Address    : 74.6.8.88
Username      : Unregistered
Classname     : vB_Database
MySQL Version :

Thanks
Reply With Quote
  #2  
Old 07-21-2008, 12:39 AM
RLShare RLShare is offline
 
Join Date: Jun 2008
Posts: 499
Благодарил(а): 0 раз(а)
Поблагодарили: 0 раз(а) в 0 сообщениях
Default

<a href="http://www.vbulletin.com/forum/showthread.php?t=138463" target="_blank">http://www.vbulletin.com/forum/showthread.php?t=138463</a>
Reply With Quote
  #3  
Old 07-21-2008, 08:32 AM
Marco van Herwaarden Marco van Herwaarden is offline
 
Join Date: Jul 2004
Posts: 25,415
Благодарил(а): 0 раз(а)
Поблагодарили: 0 раз(а) в 0 сообщениях
Default

Please close your board to avoid further data corruption and contact your host.
Reply With Quote
Reply


Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts

BB code is On
Smilies are On
[IMG] code is On
HTML code is Off

Forum Jump


All times are GMT. The time now is 07:41 PM.


Powered by vBulletin® Version 3.8.12 by vBS
Copyright ©2000 - 2024, vBulletin Solutions Inc.
X vBulletin 3.8.12 by vBS Debug Information
  • Page Generation 0.06733 seconds
  • Memory Usage 2,176KB
  • Queries Executed 11 (?)
More Information
Template Usage:
  • (1)SHOWTHREAD
  • (1)ad_footer_end
  • (1)ad_footer_start
  • (1)ad_header_end
  • (1)ad_header_logo
  • (1)ad_navbar_below
  • (1)ad_showthread_beforeqr
  • (1)ad_showthread_firstpost
  • (1)ad_showthread_firstpost_sig
  • (1)ad_showthread_firstpost_start
  • (3)bbcode_code
  • (1)footer
  • (1)forumjump
  • (1)forumrules
  • (1)gobutton
  • (1)header
  • (1)headinclude
  • (1)navbar
  • (3)navbar_link
  • (120)option
  • (3)post_thanks_box
  • (3)post_thanks_button
  • (1)post_thanks_javascript
  • (1)post_thanks_navbar_search
  • (3)post_thanks_postbit_info
  • (3)postbit
  • (3)postbit_onlinestatus
  • (3)postbit_wrapper
  • (1)spacer_close
  • (1)spacer_open
  • (1)tagbit_wrapper 

Phrase Groups Available:
  • global
  • inlinemod
  • postbit
  • posting
  • reputationlevel
  • showthread
Included Files:
  • ./showthread.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_threadinfo_query
  • fetch_threadinfo
  • fetch_foruminfo
  • style_fetch
  • cache_templates
  • global_start
  • parse_templates
  • global_setup_complete
  • showthread_start
  • showthread_getinfo
  • forumjump
  • showthread_post_start
  • showthread_query_postids
  • showthread_query
  • bbcode_fetch_tags
  • bbcode_create
  • showthread_postbit_create
  • postbit_factory
  • 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
  • tag_fetchbit_complete
  • forumrules
  • navbits
  • navbits_complete
  • showthread_complete