Cannot view pending or published events in admin panel

[mrsreeder]

Hi Casey,

So I have deactivated all plugins and am still having the problem from: https://theeventscalendar.com/support/forums/topic/events-not-visible-in-admin-panel/

I was hoping it would have corrected the problem. Only an hour ago I was able to view pending events and approved one that was submitted using the community plugin. Now I have 3 more pending and cannot view them to approve.

I could have lived without seeing the published or trashed, but I obviously need to be able to view pending for approval.

Help please. I left the same login credentials in place for you from last time.

Thank you.

[mrsreeder]

This reply is private.

[mrsreeder]

Another FYI, I tried creating a draft event and could not view/access it from “my events” on the front end or WP admin panel.

[Casey]

Mrsreeder, Since this doesn’t seem to be an issue with Community, I’m going to go ahead and move this thread over to the PRO forum and one of our support team members will help you there shortly. Please stand by.

Thanks!

[Chris]

Hi there,
After looking at your site with a couple tools, I have narrowed what I believe is the cause of your issue down to a single factor. Performance.

Now in your case, what I believe is happening is your server simply isn’t able to handle the load currently on it. It could either be caused by a plugin on your site thats affecting the site, or more likely by simply having an underpowered server for the number of people on it. In shared hosting, users share a server with often dozens of other people. It only takes one bad apple to slow down the entire server.

Now, if you have VPS hosting, the next step might be working with your VPS team to figure out why the speed of the site is low. You might want to have them analyse the usage of resources, in particular CPU and PHP memory.

Basically, what seems to be happening on your site is, when the list of events is called, WordPress runs a query to get all those posts. However, your site seems to do this at a really slow rate. PHP has a limit, known as the PHP Timeout Limit, that was originally designed to stop indefinite loops from going on forever. However, in your case, the server is moving so slowly its probably hitting this limit.

The default timeout limit is 30 seconds. I’ve clocked your server using both computer based tools and my stopwatch going well over this time, in at least one instance, it took about 111.5 seconds, nearly quadruple this limit.

When WordPress runs over this limit, it falls back to no events found, even though, as you can see on the screen, the number of events is correctly counted (it’s not like they aren’t there).

Now you indicated in your ticket “Only an hour ago I was able to view pending events and approved one that was submitted using the community plugin. Now I have 3 more pending and cannot view them to approve.”. So this could tell us that maybe someone who uses alot of resources was moved to your server, and then once they started using the resources your system slowed down.

In any event, I would talk to your host and see if they can give you an indication of how much resources your site is using, particularly CPU and PHP Memory. I would also have them check the server’s PHP error logs for any errors from plugins that might indicate a bad apple plugin on your site. In any instance, I would recommend disabling all the plugins on your site one by one. Maybe you’ll find a plugin causing it.

Hope that helps,
Chris

[mrsreeder]

Thank you for the thorough reply. I ran into a timeout error in a custom script before with this hosting company and resolved it by maxing out the php memory to 128 and the limit to something like 70,000. Since I have already ruled out a plugin conflict, let me play with the php.ini file and see what comes from it.

Can you keep this ticket open for a few days in case I need your help.

Thank you again.

[mrsreeder]

This reply is private.

[mrsreeder]

Hi Again,

My hosting company was actually quite helpful and has come back with this:

The error mentioned above is related to the plugin that is causing the load. The sql call is quite heavy. It might be split into several calls. It is not possible to change the MySQL settings to resolve the errors. Alternatively, You can use this command: SET OPTION SQL_BIG_SELECTS = 1 before running the query you know to return lots of values.

The MAX_JOIN_SIZE gets hit when MySQL calculates the Cartesian product of a join, not the actual expected records back. Therefore, if you’re joining a massive table to another massive table, this will break the tables in the database. Use indexes and views to pare down the possible table hits if it’s really that large.

For details, please refer the wordpress forum at http://wordpress.org/support/topic/plugin-content-aware-sidebars-wordpress-database-error .

Now, in your experience what is the most data that this plugin should be able to handle comfortably. I don’t mind scaling down and keeping content under a certain number, but obviously I need it functional which it currently is not.

[mrsreeder]

This reply is private.

[mrsreeder]

This reply is private.

[Chris]

Hi there,
We’ve developed a fix to this scenario, which we believe should fix your issue. Jessica, one of the other developers here, has made the following gist:
https://gist.github.com/jazbek/6585714

You can paste that, minus the opening <?php into the bottom of your functions.php file for your theme.

We think that should speed up the site and solve the issue, though there is slowness we noticed caused by the server (on non Events pages), so you still might want to have a resources discussion with your host down the road 🙂

Let us know if that works for you and we'll take it from there 🙂
-Chris

[Chris]

Also, if you could, let us know what host you’re on, if you could, so we can spot the same issue with others more easily 🙂

We’d really appreciate it,
Thanks again.
Chris

[mrsreeder]

Thank you Chris (and Jessica)
The host is Netfirms and I am aware of the slowness but don’t have time to look into it just yet. Will more then likely change hosting companies at some point. Too much work to move all the sites and not looking forward to it.

I appreciate you finding a fix for this. It is 1am here, so won’t get to this until sometime tomorrow. I have to say I am looking forward to bring able to keep using thee plugins!

Have a good night,

[Jessica]

Hi mrsreeder,

I just wanted to chime in and say that if your functions.php file happens to be empty, you will need to include the <?php at the beginning of the file. Looking forward to seeing whether this fixes your issue!

Cheers,
Jessica

[mrsreeder]

Yes, works perfect! Thank you to everyone involved. One question. If I need to have this in my child theme file will it still work? I tried copying the functions.php to the child theme folder with the code from above and it threw out a 500 error.

[Author]

Posts