Need help - just restored sql database = BONK

timotides

Hi Guys,

I recently setup and had running a brand new vanilla 2.0.18.8 forum BUT I was suffering with v.slow load times so decided to try making a few changes.

In the process I deleted my original SQL database and restored it to its original location. Immediately after, the forum just displays the BONK page with no error messages.

I stupidly thought the SQL backup I used was a very recent one but turns out my host only provides daily backups which I failed to check. Obviously the forum has had a few plugins added since the backup which was made around 24hrs ago which show up in the config.php script.

I'm at a bit of a loss as I don't want to have to start with a fresh vanilla install and start from scratch having spent quite some time on it now.

I just can't see why it's not working but assume it's due to changes made to the forum files (adding plugins etc) since the SQL database backup 24hrs ago.

Would be so greatful if anyone has any idea what might be going wrong?

Thanks and sorry for the lame 1st post!

Shadowdare

Welcome to the community.

Click this link to find out what the actual error is: http://vanillawiki.homebrewforums.net/index.php/Bonk_Errors

timotides

Thanks so much dude... I don't know what it was but I tried restoring again and changing a few things and it's working just this second ago. Might have been the fact I started playing with SMF in the meantime sent fear into it's heart! lol

BTW do you know how to get this nice thread theme with the row of thanks at the bottom for 2.0.18.8 ?

Thks again!

Shadowdare

No problem.

Do you mean the "insightful," "awesome," and "LOL" links? Those are reactions and this particular one only comes with the official Vanilla hosted plans.

timotides

Ah ok that's a shame because they're pretty awesome! BTW, with rgds my slow loading issue, my host pinned the blame on me saying that I was having CPU throttling issues which led me to doing these adjustments.

Have you ever heard of CPU throttling issues ? Host is justhost and TBH I think they're full of cr$p and probably just passing the buck.

Website is running wordpress.org for the main part with a side shoot to a vanilla forum....

I was getting a " PHP Fatal error: Class 'Gdn' not found bootstrap.php line 47" but think I've resolved that now so that shouldn't be a problem.

timotides

Thanks so much Shadowdare and sorry for all the questions I just really want to make this work!

I've started new topics at the links below for other issues I'm having and would so appreciate if you had any more insights:

http://vanillaforums.org/discussion/25336/does-anyone-with-vanilla-forum-on-a-wordpress-org-domain-find-slow-loading?new=1

http://vanillaforums.org/discussion/25335/remove-tags-in-side-bar?new=1

whu606

@timotides

CPU Throttling is a technique hosts use on shared servers to limit the amount of resources any one domain can use in a given period.

I am on BlueHost, which offers free, easy sign up to CloudFlare, a CDN.

After I signed up, I found that reduced my 'throttling' to practically 0.

timotides

Thanks for the tip Whu606, but my host doesn't offer that service unfortunately. Maybe time to move!

timotides

EDIT ON LAST COMMENT: Actually turns out my host does have Cloudfare - now time to experiment!

timotides

As your suggestion whu606 I went with Cloudfare and haven't had a throttling issue since - only been a few hours but fingers crossed! Thanks again!

whu606

It would also make sense to check if your host provides access to a MySQL slow queries log.

This could indicate plugins that are tying up resources.

For example, I don't need Vanilla statistics, and found that it was slowing things down, so turned it off.

Another thing to try would be to use Page Speed from Google to see what else could be speeded up.

timotides

Thanks whu - I see in the queries log that 'who's online' plugin is mentioned - I'll try disabling that to see if it helps. Update on Cloudfare: it worked initially, but throttling issues are back again, although I think it's helped a bit.

whu606

@timotides

CloudFlare will not have any effect where your site is slowed down by MySQL queries.

What it is good at doing is caching commonly used resources, and optimising them for quicker page load speeds.

peregrine

@timotides

if you list your plugins that you use (besides whosonline) maybe some of them create some performance issues as well.

and maybe some stats on sizes or number of records in your tables, maybe you could more suggestions on what to do.