Like i the title, there seems to be a few issues, but the main one is this:
wpForoActivity->get_activities()
Do you know what could be causing this? Let me know what other info you may need that may help 🙂
In the mean time, fix this:
Uncaught TypeError: $percyslider712860104.unslider is not a function
@dimalifragis This is fixed now i think mate, it was the amazon widget
The updates moved my table onto different databases, I have put the right ones back where they are supposed to be. Just leaving likes and visits databases on my sam the rest on innodb.
It has made a little difference but still now where near as fast as it was.... any advice is much appreciated
@percysgrowroom The update moved the tables? What do you mean?
@dimalifragis The databases?
I moved the all over to inno from my sam other than the likes and visits.
After updating all the databases were on mysam again
wpForo doesn't do any manipulations and changes in your database during the update. So I think this is a server side issue. The speed maybe affected if the table engines are changed.
wpForoActivity->get_activities()
This says nothing. However, you could check the wp_wpforo_activity table, make sure it's InnoDB, and maintenance this table:
- Analyze table
- Checksum table
- Defragment table
- Optimize table
@martin Well I didnt move them mate, and it changed when the update happened..... So I think it is doing something? Cant be a coincidence?
I will try what you have suggested, all of the databases are in the right place now, but the load time is still very slow
@dimalifragis The databases?
I moved the all over to inno from my sam other than the likes and visits.
After updating all the databases were on mysam again
Mine are still InnoDB. I don't think an update can do that.
@dimalifragis Yer I thoguht there would have been more issues from other users if it was from the update..... very strange.
I was in my databases looking at who voted in a poll the other day, but i didnt change its location.
Im talking to my hosts now and optimising the data base, Ill keep youll informed 🙂
@dimalifragis after the update i discovered 2 tables mysam thisis the one
I convert them with the use of litespeed cache
@central4allgmail-com See im not crazy 😉 lol
Are all of your databases on InnoDB mate? I though likes and visits should stay on Mysam?
@percysgrowroom all and itseems that they are working, create tables back up and test it
Host said this:
"I've checked in all the available databases and that particular table cannot be found. If you are not sure, you can request the developer to check with the corresponding database name from the below list and can ask which table it is related to. Alternatively, you can provide the knowledge base article that was shared to the developer so that they can check with the site optimization."
Any ideas?
https://www.a2hosting.com/kb/developer-corner/mysql/using-indexes-to-improve-mysql-query-performance
It is getting faster now, but still having issues.
Sometimes it loads much slower than others, I have these as slow queries right now, maybe this pic can help?
