vb.org Archive

vb.org Archive (https://vborg.vbsupport.ru/index.php)
-   vB3 Programming Discussions (https://vborg.vbsupport.ru/forumdisplay.php?f=15)
-   -   getting this weird database error with the vbadvanced home page now...? (https://vborg.vbsupport.ru/showthread.php?t=65266)

TheCaver 05-19-2004 01:48 AM
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

Zachery 05-19-2004 01:53 AM
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.

TheCaver 05-19-2004 03:00 AM
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...?


All times are GMT. The time now is 01:40 AM.

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.00966 seconds
  • Memory Usage 1,716KB
  • Queries Executed 10 (?)
More Information
Template Usage:
  • (1)ad_footer_end
  • (1)ad_footer_start
  • (1)ad_header_end
  • (1)ad_header_logo
  • (1)ad_navbar_below
  • (1)bbcode_code_printable
  • (1)footer
  • (1)gobutton
  • (1)header
  • (1)headinclude
  • (6)option
  • (1)post_thanks_navbar_search
  • (1)printthread
  • (3)printthreadbit
  • (1)spacer_close
  • (1)spacer_open 
Phrase Groups Available:
  • global
  • postbit
  • showthread
Included Files:
  • ./printthread.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/class_bbcode_alt.php
  • ./includes/class_bbcode.php
  • ./includes/functions_bigthree.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
  • printthread_start
  • bbcode_fetch_tags
  • bbcode_create
  • bbcode_parse_start
  • bbcode_parse_complete_precache
  • bbcode_parse_complete
  • printthread_post
  • printthread_complete