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 04-01-2007, 08:42 PM
ZomgStuff ZomgStuff is offline
 
Join Date: Feb 2007
Posts: 469
Благодарил(а): 0 раз(а)
Поблагодарили: 0 раз(а) в 0 сообщениях
Default Mad SQL problems!

Well I come home and my co-admin tells me there are SQL errors abroad. DB errors that os.

If I click view PM's I get this

Code:
Database error in vBulletin 3.6.5:

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 table handler
Error Number : 1030
Date         : Sunday, April 1st 2007 @ 02:40:34 PM
Script       : http://www.zomgstuff.net/forum/private.php?
Referrer     : http://www.zomgstuff.net/forum/cindex.php
IP Address   : xxxxxxxxxxxxxx
Username     : xxxxxxxxxxxxxx
Classname    : vb_database

If I try to open my portal

I get this

Code:
Database error in vBulletin 3.6.5:

Invalid SQL:

				SELECT IF(votenum >= 1, votenum, 0) AS numbvote, IF(votenum >= 1 AND votenum != 0, votetotal / votenum, 0) AS voteavg, thread.threadid, post.title, thread.replycount, postusername, postuserid, thread.dateline AS postdateline, thread.lastpostid, thread.lastposter, thread.lastpost, IF(views<=thread.replycount, thread.replycount+1, views) AS views, thread.forumid, post.postid, pagetext, allowsmilie,
					thread.iconid AS threadiconid, iconpath AS threadiconpath, 
					avatarpath, NOT ISNULL(customavatar.filedata) AS hascustom, customavatar.dateline AS avatardateline, avatarrevision, 
					NOT ISNULL(subscribethread.subscribethreadid) AS subscribed 

				FROM thread AS thread
				LEFT JOIN post AS post ON (post.postid = thread.firstpostid)
				LEFT JOIN postparsed AS postparsed ON (postparsed.postid = post.postid AND postparsed.styleid = 31 AND postparsed.languageid = 1)
					LEFT JOIN icon AS icon ON (icon.iconid = thread.iconid)
					LEFT JOIN user AS user ON (user.userid = post.userid)
					LEFT JOIN avatar as avatar ON (avatar.avatarid = user.avatarid)
					LEFT JOIN customavatar as customavatar ON (customavatar.userid = user.userid)
					LEFT JOIN subscribethread AS subscribethread ON (subscribethread.threadid = thread.threadid AND subscribethread.userid = '1')
				WHERE thread.threadid IN(5238,5153)
				
				
				GROUP BY post.postid
				ORDER BY sticky DESC,thread.dateline DESC
				LIMIT 100;

MySQL Error  : Got error 28 from table handler
Error Number : 1030
Date         : Sunday, April 1st 2007 @ 02:42:07 PM
Script       : http://zomgstuff.net/forum/
Referrer     : 
IP Address   : xxxxxxxxxxxxxx
Username     :xxxxxxxxxxxxxx
Classname    : vb_database
Also when i try to visit options in admin cp I get this

Code:
Database error in vBulletin 3.6.5:

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 -1 from table handler
Error Number : 1030
Date         : Sunday, April 1st 2007 @ 02:44:00 PM
Script       : http://zomgstuff.net/forum/admincp/options.php?null=0
Referrer     : http://zomgstuff.net/forum/admincp/index.php?do=nav
IP Address   : xxxxxxxxxxx
Username     :xxxxxxxxxxx
Classname    : vb_database

Latest mod that we installed would be write-in poll.
Reply With Quote
  #2  
Old 04-01-2007, 08:45 PM
MarkPW MarkPW is offline
 
Join Date: Apr 2006
Posts: 65
Благодарил(а): 0 раз(а)
Поблагодарили: 0 раз(а) в 0 сообщениях
Default

Error code 28: No space left on device

One or more partitions on your server is out of space or doesn't have enough space to complete this operation. Shutdown your forums (if you can) and contact your host immediately. You or your host will need to find out which partition is low on space and free up some more space.
Reply With Quote
  #3  
Old 04-02-2007, 12:24 AM
ZomgStuff ZomgStuff is offline
 
Join Date: Feb 2007
Posts: 469
Благодарил(а): 0 раз(а)
Поблагодарили: 0 раз(а) в 0 сообщениях
Default

Thanks, another reason why dot5hosting blows. NEVER buy from them. Site is down all the time.
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 05:02 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.13338 seconds
  • Memory Usage 2,178KB
  • 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