Log in

View Full Version : vbcron - repair/optimize script ?

slothy
06-13-2004, 07:00 PM
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)
Zachery
06-13-2004, 10:25 PM
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?
slothy
06-14-2004, 12:05 AM
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)
Zachery
06-14-2004, 12:06 AM
What version of mysql are you running right now?
slothy
06-14-2004, 01:35 PM
my versions

mysql 4.0.12

php 4.3.4
Zachery
06-14-2004, 04:13 PM
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.
slothy
06-16-2004, 02:38 PM
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..