Go Back   vb.org Archive > vBulletin 4 Discussion > vB4 Programming Discussions
  #1  
Old 07-25-2012, 08:53 AM
pbforum pbforum is offline
 
Join Date: Jan 2012
Location: Home
Posts: 50
Благодарил(а): 0 раз(а)
Поблагодарили: 0 раз(а) в 0 сообщениях
Default problem with database error

hi
please help me .. i can'taccess my admin panel
why this problem with my forum .. my vbulletin forum version is 4.2.0


Database error in vBulletin 4.2.0:

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 28 from storage engine
Error Number : 1030
Request Date : Wednesday, July 25th 2012 @ 05:59:13 AM
Error Date : Wednesday, July 25th 2012 @ 05:59:13 AM
Script : http://punjabiforum.in/forum/admincp/options.php?null=0
Referrer : https://punjabiforum.in/forum/admincp/index.php?do=nav
IP Address : 94.59.200.210
Username : pendu
Classname : vB_Database
MySQL Version : 5.5.24-cll
Reply With Quote
  #2  
Old 07-25-2012, 09:15 AM
Sarteck's Avatar
Sarteck Sarteck is offline
 
Join Date: Mar 2008
Posts: 304
Благодарил(а): 0 раз(а)
Поблагодарили: 0 раз(а) в 0 сообщениях
Default

You're out of disk space.

You've got to clean up some files. See if any huge log files need to be deleted. :P
Reply With Quote
Благодарность от:
pbforum
  #3  
Old 07-25-2012, 11:54 AM
pbforum pbforum is offline
 
Join Date: Jan 2012
Location: Home
Posts: 50
Благодарил(а): 0 раз(а)
Поблагодарили: 0 раз(а) в 0 сообщениях
Default

which disk space from vbulletin forum or my server space
Reply With Quote
  #4  
Old 07-25-2012, 12:10 PM
Sarteck's Avatar
Sarteck Sarteck is offline
 
Join Date: Mar 2008
Posts: 304
Благодарил(а): 0 раз(а)
Поблагодарили: 0 раз(а) в 0 сообщениях
Default

Your server, which includes your forum. If your forum database is too large, that could be the cause--in that case, your only hope is to upgrade your server to one with more space.

Do you have command-line access? A good way to find out the largest files on your server (if you do) is to run the command
sudo du -a / | sort -n -r | head -n 10
That will give you the ten largest files. If the Logs are filling up your space, you could probably safely delete them.
Reply With Quote
  #5  
Old 07-25-2012, 12:20 PM
pbforum pbforum is offline
 
Join Date: Jan 2012
Location: Home
Posts: 50
Благодарил(а): 0 раз(а)
Поблагодарили: 0 раз(а) в 0 сообщениях
Default

may be i have aa problem with activity stream ..
i have 1 tb space server

and database size is : 27.47 MB
Reply With Quote
  #6  
Old 07-25-2012, 12:22 PM
Sarteck's Avatar
Sarteck Sarteck is offline
 
Join Date: Mar 2008
Posts: 304
Благодарил(а): 0 раз(а)
Поблагодарили: 0 раз(а) в 0 сообщениях
Default

If database is less than 30MB and you have a TB of space, yeah, your problem is elsewhere. Large files, somewhere. Look for 'em, or contact your host if necessary.
Reply With Quote
  #7  
Old 07-25-2012, 12:25 PM
pbforum pbforum is offline
 
Join Date: Jan 2012
Location: Home
Posts: 50
Благодарил(а): 0 раз(а)
Поблагодарили: 0 раз(а) в 0 сообщениях
Default

check this image i have no large file

Reply With Quote
  #8  
Old 07-25-2012, 12:33 PM
kh99 kh99 is offline
 
Join Date: Aug 2009
Location: Maine
Posts: 13,185
Благодарил(а): 0 раз(а)
Поблагодарили: 0 раз(а) в 0 сообщениях
Default

If your disk is partitioned, you could have lots of free space and still be out of space on a partition. Also, the last time someone asked about this it turned out that they had space but the file system had a problem and needed to be repaired.
Reply With Quote
Благодарность от:
pbforum
  #9  
Old 07-25-2012, 09:09 PM
soniceffect's Avatar
soniceffect soniceffect is offline
 
Join Date: Feb 2005
Location: UK
Posts: 453
Благодарил(а): 0 раз(а)
Поблагодарили: 0 раз(а) в 0 сообщениях
Default

log into your server via ssh and run the following. This should give you an idea of whether its partitions or not

df -h
Reply With Quote
Благодарность от:
pbforum
  #10  
Old 07-26-2012, 06:26 PM
pbforum pbforum is offline
 
Join Date: Jan 2012
Location: Home
Posts: 50
Благодарил(а): 0 раз(а)
Поблагодарили: 0 раз(а) в 0 сообщениях
Default

thankssssssssss
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 11:51 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.05595 seconds
  • Memory Usage 2,246KB
  • Queries Executed 13 (?)
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)footer
  • (1)forumjump
  • (1)forumrules
  • (1)gobutton
  • (1)header
  • (1)headinclude
  • (1)navbar
  • (3)navbar_link
  • (120)option
  • (10)post_thanks_box
  • (3)post_thanks_box_bit
  • (10)post_thanks_button
  • (1)post_thanks_javascript
  • (1)post_thanks_navbar_search
  • (3)post_thanks_postbit
  • (10)post_thanks_postbit_info
  • (10)postbit
  • (10)postbit_onlinestatus
  • (10)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_postinfo_query
  • fetch_postinfo
  • 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
  • fetch_musername
  • post_thanks_function_fetch_thanks_end
  • post_thanks_function_thanked_already_start
  • post_thanks_function_thanked_already_end
  • postbit_imicons
  • bbcode_parse_start
  • bbcode_parse_complete_precache
  • bbcode_parse_complete
  • postbit_display_complete
  • post_thanks_function_can_thank_this_post_start
  • post_thanks_function_fetch_thanks_bit_start
  • post_thanks_function_show_thanks_date_start
  • post_thanks_function_show_thanks_date_end
  • post_thanks_function_fetch_thanks_bit_end
  • post_thanks_function_fetch_post_thanks_template_start
  • post_thanks_function_fetch_post_thanks_template_end
  • tag_fetchbit_complete
  • forumrules
  • navbits
  • navbits_complete
  • showthread_complete