Go Back   vb.org Archive > vBulletin 3 Discussion > vB3 General Discussions
FAQ Community Calendar Today's Posts Search

Reply
 
Thread Tools Display Modes
  #1  
Old 06-13-2004, 07:00 PM
slothy slothy is offline
 
Join Date: May 2004
Posts: 4
Благодарил(а): 0 раз(а)
Поблагодарили: 0 раз(а) в 0 сообщениях
Default vbcron - repair/optimize script ?

Hi, new guy here, i have a problem, until our host figures out wtf is going on our server drops everday or so (have 2 other forums on the same server no probs though). I wanted to just set up a repair/optimize vbcron job, but i don’t know the command line (if there even is) to set up in the scheduler in vb 3.01. I not around all the time and kind of getting tired of peeps calling me telling me the board is down..

So in short, im just looking for a script or hack or something to be able to have it run every hour or something and repair/optimize tables .. (small forum, so im not worried about server load)
Reply With Quote
  #2  
Old 06-13-2004, 10:25 PM
Zachery's Avatar
Zachery Zachery is offline
 
Join Date: Jul 2002
Location: Ontario, Canada
Posts: 11,440
Благодарил(а): 0 раз(а)
Поблагодарили: 0 раз(а) в 0 сообщениях
Default

Quote:
Originally Posted by slothy
Hi, new guy here, i have a problem, until our host figures out wtf is going on our server drops everday or so (have 2 other forums on the same server no probs though). I wanted to just set up a repair/optimize vbcron job, but i don?t know the command line (if there even is) to set up in the scheduler in vb 3.01. I not around all the time and kind of getting tired of peeps calling me telling me the board is down..


So in short, im just looking for a script or hack or something to be able to have it run every hour or something and repair/optimize tables .. (small forum, so im not worried about server load)
Well, the forums crash on a daily basis? what hacks have you put on the forum? what version of vBulletin are you running 2.x 3.0.x ? beta 3?
Reply With Quote
  #3  
Old 06-14-2004, 12:05 AM
slothy slothy is offline
 
Join Date: May 2004
Posts: 4
Благодарил(а): 0 раз(а)
Поблагодарили: 0 раз(а) в 0 сообщениях
Default

vb 3.01 just arcade is the only hack (but it was doing it before then) , this was doing it with phpboard and invisionboard too. But the 3 other boards have no probs with crashing and they are on the same server, using the same mysql and php version.. So i fiqured the quick solution would be stetting up a vbcron job ever hour or so, so if im not around its sorta fixes it self (repair fixes the prob everytime)
Reply With Quote
  #4  
Old 06-14-2004, 12:06 AM
Zachery's Avatar
Zachery Zachery is offline
 
Join Date: Jul 2002
Location: Ontario, Canada
Posts: 11,440
Благодарил(а): 0 раз(а)
Поблагодарили: 0 раз(а) в 0 сообщениях
Default

What version of mysql are you running right now?
Reply With Quote
  #5  
Old 06-14-2004, 01:35 PM
slothy slothy is offline
 
Join Date: May 2004
Posts: 4
Благодарил(а): 0 раз(а)
Поблагодарили: 0 раз(а) в 0 сообщениях
Default

my versions

mysql 4.0.12

php 4.3.4
Reply With Quote
  #6  
Old 06-14-2004, 04:13 PM
Zachery's Avatar
Zachery Zachery is offline
 
Join Date: Jul 2002
Location: Ontario, Canada
Posts: 11,440
Благодарил(а): 0 раз(а)
Поблагодарили: 0 раз(а) в 0 сообщениях
Default

Quote:
Originally Posted by slothy
my versions


mysql 4.0.12

php 4.3.4
upgrade mysql to 4.0.16 or 4.0.20 and you wont have a problem anymore, older verisons (before .16 i think) had table crashing problems, it has since been resolved.
Reply With Quote
  #7  
Old 06-16-2004, 02:38 PM
slothy slothy is offline
 
Join Date: May 2004
Posts: 4
Благодарил(а): 0 раз(а)
Поблагодарили: 0 раз(а) в 0 сообщениях
Default

if thats the case, then why dont the other boards (same server/php/mysql version) crash ? thats why im like durrh wtf is going on ehhhe..
Reply With Quote
Reply


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 09:48 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.03715 seconds
  • Memory Usage 2,214KB
  • 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
  • (2)bbcode_quote
  • (1)footer
  • (1)forumjump
  • (1)forumrules
  • (1)gobutton
  • (1)header
  • (1)headinclude
  • (1)navbar
  • (3)navbar_link
  • (120)option
  • (7)post_thanks_box
  • (7)post_thanks_button
  • (1)post_thanks_javascript
  • (1)post_thanks_navbar_search
  • (7)post_thanks_postbit_info
  • (7)postbit
  • (7)postbit_onlinestatus
  • (7)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
  • 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