vb.org Archive

vb.org Archive (https://vborg.vbsupport.ru/index.php)
-   vB4 General Discussions (https://vborg.vbsupport.ru/forumdisplay.php?f=251)
-   -   vBulletin Database Error!‏ (https://vborg.vbsupport.ru/showthread.php?t=309530)

KimK 03-14-2014 07:21 PM
vBulletin Database Error!‏
 
Hello,

Im getting alot of vBulletin Database Error‏ emails, about 60 email daily with the following error:

Code:
Database error in vBulletin 4.2.2:


Invalid SQL:
 
                        SELECT user.*, discussion.discussionid, discussion.groupid, discussion.lastpostid, discussion.lastpost,
                                discussion.lastposter, discussion.lastposterid, discussion.visible,
                                groupmessage.gmid, groupmessage.postuserid, groupmessage.postusername, groupmessage.dateline,
                                groupmessage.title, groupmessage.pagetext as message,
                                socialgroup.name as groupname, socialgroup.description as groupdescription
                                ,avatar.avatarpath, NOT ISNULL(customavatar.userid) AS hascustomavatar,
                                        customavatar.dateline AS avatardateline,customavatar.width AS avwidth,customavatar.height AS avheight
                        FROM discussion AS discussion
                        INNER JOIN socialgroup AS socialgroup ON(discussion.groupid = socialgroup.groupid)
                        INNER JOIN groupmessage AS groupmessage ON (discussion.firstpostid = groupmessage.gmid)
                        LEFT JOIN user AS user ON (groupmessage.postuserid = user.userid)
                        LEFT JOIN avatar AS avatar ON(avatar.avatarid = user.avatarid)
                        LEFT JOIN customavatar AS customavatar ON(customavatar.userid = user.userid)
               
                WHERE 1=1
                       
                       
                        AND ( !(socialgroup.options & 1))
                        AND discussion.visible > 0
                        AND groupmessage.state = 'visible'
                        AND groupmessage.dateline > 130000858
                       
                ORDER BY groupmessage.dateline DESC
                LIMIT 0,5;
 
MySQL Error  : Got error 28 from storage engine
Error Number  : 1030
Referrer      :
Classname    : vB_Database
MySQL Version :
What should I do to fix this error?? I contact my hosting company and they replied with: "The error in question indeed appears when there is not enough free space in the /tmp partition of the server. We have increased the size of the /tmp/ folder and the issue should not reappear.".

But Im still getting the vBulletin Database Error‏ emails. Can any one help me please.

ForceHSS 03-14-2014 07:53 PM
That error means not enough disk space they need to give you a bigger disk

Zachery 03-14-2014 08:11 PM
MySQL Error : Got error 28 from table handler

Error Code 28 (No space left on device):
Got error 28 from table handler means your server's mysql partition for your mysql database ran out of disk space or that the /tmp directory ( http://www.mysql.com/doc/T/e/Temporary_files.html )on your server doesn't have enough space, you need to

1. close your forum to prevent further posting or writing to the database
2. contact your web host
3. or if your host yourself on a dedicated server, you need to move your mysql partition to a larger disk or change the /tmp directory location via your servers my.cnf file


All times are GMT. The time now is 07:35 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.01009 seconds
  • Memory Usage 1,721KB
  • 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