Intermittent issues

[Jeff]

Hi All,

Hopefully the problem has been solved. Certainly a *huge* amount of space has been recovered from the database such that rather than being 95+% full it's now only 25% full.

"So what on earth have you thrown away Jeff? Can there be anything left?"

It seems that the language translation facility was being something of a hog and was permanently keeping translations of pages in perpetuity. In effect what should have been a caching facility was archiving all its work in many, many languages, forever. Having found out what was actually using up all the space (not as simple as it ought to have been) there was just the task of disillusioning that part of the software and making it play more sensibly.

Anyway, vBET options located, cache cleaning enabled (over night), ét voila, space recovered.

Pages should still be translated on demand, that facility hasn't been touched. The translated pages should be cached for 90 days, after which they should (presumably if not accessed again) be deleted during an over-night purge. If required again they can be re-translated and cached again.

Visually and content wise this shouldn't have had any impact on the site. If somebody sees something not right let me know. I did backup everything yesterday afternoon prior to the clean up, just to be safe.

Jeff.

[Jeff]

.... having said the above, this shouldn't have had any impact on why I was seeing the DB refusing connections. I'll keep a watch on things from the side lines for a while.

[Stableblock]

Brilliant, thanks Jeff.

[Stratos Fear]

Tin helmet removed - well done that man !

[Normb666]

Good 'un Jeff, - now you've had a practice and saved us all from ourselves, you can zoom off and Save the World. Get yerself some of those red over-the-tights underpants and send the bill to the Club Treasurer.

[hollytree]

i have not been able to get the member map for weeks
steve

[Jeff]

I'll have a look about, see what I can see...

i have not been able to get the member map for weeks
steve

Edit/

... and I can not see anything. The surrounding vBulletin stuff is there, but where the map stuff should be is bare. I've tried a couple of alternative browsers (though nothing Windows based) and it all looks the same; empty.

I don't believe this has been caused by me (if this has been this way for a few weeks) so initially it feels like some unexpected interaction between the vBulletin/Forum scripts and Googles mapping API. But it's going to take me a while to work this out - never had to look into anything like this before.

Jeff.