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 dont 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)
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?
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)
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.