vb.org Archive

vb.org Archive (https://vborg.vbsupport.ru/index.php)
-   vB3 General Discussions (https://vborg.vbsupport.ru/forumdisplay.php?f=111)
-   -   All my vBulletin/vBadvanced sites Homes Suddenly Down. MySQL Problems (https://vborg.vbsupport.ru/showthread.php?t=134355)

sublo 12-19-2006 03:09 PM
All my vBulletin/vBadvanced sites Homes Suddenly Down. MySQL Problems
 
Hi All. I need help desperately. My sites are on one colocated virtual server. They were working yesterday. I made no changes. All the vBulletin/vBadvanced Home pages are suddenly down! the http://blaablaablaa.blaa/forums are still up. What happened????

Here are the sites: http://www.camillegerard.com, http://www.stjosephforums.org

Please, please help. MySQL is indeed up and running. I tried restarting the daemon as well as rebooting the server. No luck.

Help!

Here is the error:

Quote:
Database error in vBulletin 3.6.3:

Invalid SQL:

SELECT 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 = 1 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(2,5)


GROUP BY post.postid
ORDER BY sticky DESC,thread.dateline ASC
LIMIT 10;

MySQL Error : Got error 28 from storage engine
Error Number : 1030
Date : Tuesday, December 19th 2006 @ 12:15:37 PM
Script : http://www.camillegerard.com/
Referrer :
IP Address : 67.154.66.228
Username : Freddy
Classname : vb_database

KW802 12-19-2006 07:20 PM
Have you checked yet to see how much free space you have left on your server? Error 28 with MySQL is usually no space left.

sublo 12-19-2006 07:50 PM
Crap! I'm an idiot! Should have first checked. I'm an idiot today!

/dev/hda1 is partitioned for only 500MB and is 100% full! I'm guessing this is be causing the problem but it's the boot directory I thinks. Thank you, thank you thank you. :confused:

There doesn't seem to be any directories on /dev/hda1 (this is a Fedora box). Everything else has plenty of room and each vhost is limitless. I don't get it.

Hmm....

Anyone else run into this problem with a 1and1 root server?

Quote:
Filesystem 1K-blocks Used Available Use% Mounted on
/dev/hda1 507848 507832 0 100% /
none 254016 0 254016 0% /dev/shm
/dev/hda7 27391096 1039928 26351168 4% /home
/dev/hda5 5115304 1066176 4049128 21% /usr
/dev/hda6 5115304 382152 4733152 8% /var
/dev/hda6 has: /var/lib/mysql, /var/qmail/mailnames, and /var/named/run-root. As you can see, there is tons of space.

I'm back to square one - don't understand the problem. Sigh...

da420 12-19-2006 08:19 PM
Quote:
Originally Posted by sublo (Post 1141816)
Anyone else run into this problem with a 1and1 root server?
I wouldn't allow 1and1 to host any of my sites. Heard lots of bad things, and their 100MB database restriction is rediculous. I personally aviod 1and1 like the plague.

sublo 12-19-2006 08:41 PM
Quote:
Originally Posted by da420 (Post 1141825)
I wouldn't allow 1and1 to host any of my sites. Heard lots of bad things, and their 100MB database restriction is rediculous. I personally aviod 1and1 like the plague.
I hear you. But in over a year, I have no complaints about 1and1. I've previously used Pair.com and another I can't remember. 1and1 has had the most value.

As far as the 100MB restriction, I don't have that problem. It's my rented server. I control the whole thing. I can do anything I want on it - reimage whatever.

Anybody have any other ideas about this MySQL error 28? My disk is not full.


All times are GMT. The time now is 07:12 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.01307 seconds
  • Memory Usage 1,729KB
  • 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
  • (4)bbcode_quote_printable
  • (1)footer
  • (1)gobutton
  • (1)header
  • (1)headinclude
  • (6)option
  • (1)post_thanks_navbar_search
  • (1)printthread
  • (5)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