Go Back   vb.org Archive > vBulletin 3 Discussion > vB3 Programming Discussions
  #1  
Old 05-19-2004, 01:48 AM
TheCaver TheCaver is offline
 
Join Date: Oct 2001
Posts: 79
Благодарил(а): 0 раз(а)
Поблагодарили: 0 раз(а) в 0 сообщениях
Default getting this weird database error with the vbadvanced home page now...?

im getting this error all the time now when people try to access the vbadvanced portal home page. it worked fine for about a week and it started randomly doing this today. Any ideas?

Code:
Database error in vBulletin 3.0.1:

Invalid SQL: SELECT 
				IF(votenum >= 1, votenum, 0) AS votenum, IF(votenum >= 1 AND votenum != 0, votetotal / votenum, 0) AS voteavg,
				thread.threadid, thread.title, replycount, postusername, postuserid, thread.dateline AS postdateline, IF(views<=replycount, replycount+1, views) AS views, forumid, post.postid, pagetext, allowsmilie, showsignature
	  		,thread.iconid AS threadiconid 
				, attachment.filename, attachment.filesize, attachment.visible, attachmentid, counter, thumbnail, LENGTH(thumbnail) AS thumbnailsize
				, avatarpath, NOT ISNULL(avatardata) AS hascustom, customavatar.dateline AS avatardateline
				, NOT ISNULL(subscribethread.subscribethreadid) AS subscribed 
				FROM thread AS thread
				LEFT JOIN post AS post ON (post.postid = thread.firstpostid) 
				LEFT JOIN user AS user ON (user.userid = post.userid) 
				LEFT JOIN attachment AS attachment ON (post.postid = attachment.postid)
				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 forumid IN(16)
				GROUP BY post.postid
				ORDER BY postdateline DESC, attachmentid LIMIT 10
mysql error: Got error 28 from table handler

mysql error number: 1030
Reply With Quote
  #2  
Old 05-19-2004, 01:53 AM
Zachery's Avatar
Zachery Zachery is offline
 
Join Date: Jul 2002
Location: Ontario, Canada
Posts: 11,440
Благодарил(а): 0 раз(а)
Поблагодарили: 0 раз(а) в 0 сообщениях
Default

Its not from vBadvacned

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 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 05-19-2004, 03:00 AM
TheCaver TheCaver is offline
 
Join Date: Oct 2001
Posts: 79
Благодарил(а): 0 раз(а)
Поблагодарили: 0 раз(а) в 0 сообщениях
Default

my vbadvanced page is set to "index.php" and the actual forum index/or forum is "index1.php" if i go to index1, the forums work . i only get that error on the vbadvanced home page...?
Reply With Quote
Reply

Thread Tools
Display Modes

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:50 PM.


Powered by vBulletin® Version 3.8.12 by vBS
Copyright ©2000 - 2025, vBulletin Solutions Inc.
X vBulletin 3.8.12 by vBS Debug Information
  • Page Generation 0.03613 seconds
  • Memory Usage 2,169KB
  • 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
  • (1)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