Notifications
Clear all

[Solved] Urgent Help, Site is down after update to 2.0

161 Posts
5 Users
28 Reactions
7,343 Views
Posts: 1212
Topic starter
(@percysgrowroom)
Noble Member
Joined: 6 years ago
Posted by: @dimalifragis

Your MAIN issue is the out of memory right now.

I am trying to find the cause of my site being out of memory but having no luck finding it

Posted by: @dimalifragis

DISABLE ONE PLUGIN at a time untilΒ  you find the cause.

The causes is most likely mycred because of the ikes, and wpforo, but i keep being told this isnt the case..... I bet if i got rid of my forum the site would run fast as f**k mate, this IS because of the forum software and the effect it is having on my server.Β 

Posted by: @dimalifragis

And again, your issues don't came in with wpForo 2.

If it isnt wpforo, why does the error log show all these errors that are linked to wpfor?Β 

1 Reply
dimalifragis
(@dimalifragis)
Joined: 5 years ago

Famed Member
Posts: 2611

@percysgrowroom I'm sorry but what you say is not correct.

FIRST you had 100 max connections in your Hosting plan. Nothing to do with wpForo 2. Lazy Hosting company

SECOND you have OUT OF MEMORY ISSUES. At first you did use 1 gb RAM for php. LAZY HOSTING COMPANY. Nothing to do with wpForo2. That issue is still unresolved? I can't tell because for some reason you disabled debug log.

The other warning and notices are NOT FATAL and maybe they do not come from wpForo.

The fact you are the only one reporting such issues, means this is SPECIFIC to your site/hosting.

Posts: 1212
Topic starter
(@percysgrowroom)
Noble Member
Joined: 6 years ago

slow quireis again making my site slow, which are coming from this table: wp_3cy42zznwz_wpforo_reactions

to do with wpforo reactions, aka the likes, and is assoicaited with wpforo, and my cred intergration.Β 

Posts: 1212
Topic starter
(@percysgrowroom)
Noble Member
Joined: 6 years ago

Site took 20 seconds to load, check the queires and there were 16 slow quiries, 14 of which were for the reactions table, the others were post numbers. This IS down to some clash with the mycred, or wpforo software.Β 

I use a s**t loads of wpforo add ons, more than most websites do, so many sites may not get these issues. But i think it is clear that the site being slowed down is due to the reactions

And yes we should be focussing on the out of memory thing, but this also needs addressing.Β 

Posts: 1212
Topic starter
(@percysgrowroom)
Noble Member
Joined: 6 years ago

I deactivated the mycred plug ins, and the problems still occurred as the reactions are part of the wpforo software, so the only way I can stop the slow queries is by disabling the wpfor software, which of course is a no go as i need the forum.....Β 

I have tested most of the plug ins now, and none of them are causing major issues, the issues are coming from wpforo imo, and I dont know what I can do to stop it from happening. I cant just remove likes from my siteΒ 

2 Replies
RealAct
(@realact)
Joined: 7 years ago

Reputable Member
Posts: 238

@percysgrowroom I'm sorry this is happening bud, I'm sure things will get figured out so do not give up. One question: Have you ever optimized up your databases? I do it monthly on my sites, there are several tools for that.

This will help you clean up posts revisions, automatic drafts, transients, Orphan tables old plugins leftovers etc. etc. I use two tools for that; WP-Rocket and also another plugin called Advanced Database Cleaner PRO.Β 

I would also look into converting your WordPress databases from MyISAM to InnoDB if your .dbs are MyISAM. Doing that on my big site a long time ago did help a lot of speeding up WordPress.

Also, perhaps try decreasing WPforo editor revisions threshold, doing that might help a little as well.

If I was you at this time I would disable any not super important WPForo addons that you might have such as polls or smilies for example, also any other plugins on the whole site as whole that might alleviate the issue while a solution is found. Also depending on the type of web server software sometimes is better to use lsapi vs php-fpm etc. Talk to your host about that.

Remember always please back up your databases whenever you are going to do anything with them, VERY important in case something goes wrong.

dimalifragis
(@dimalifragis)
Joined: 5 years ago

Famed Member
Posts: 2611

@realact What DB has to do with Out of Memory issues?

Posts: 1212
Topic starter
(@percysgrowroom)
Noble Member
Joined: 6 years ago
Posted by: @realact

look into converting your WordPress databases from MyISAM to InnoDB if your .dbs are MyISAM. Doing that on my big site a long time ago did help a lot of speeding up WordPress.

I did this before but may th recent update changed them back? is that possible, i will look into

this, thanks man.

There were a couple of databases that needed to be on Innobdb though right? not all of them go onto mysam?Β 

Posted by: @realact

sometimes is better to use lsapi vs php-fpm

I have no idea what this even is mate.....Β 

Β 

Page 11 / 13