Large events database conflicts with theme

[irishrunner16]

Hi,
It seems that just as our database of events surpassed 5,000, an issue has presented itself: we are no longer able to access the Settings or Help sections of The Events Calendar. The error we are receiving is:

PHP Fatal error: Allowed memory size of 268435456 bytes exhausted (tried to allocate 71 bytes) in /wp-includes/meta.php on line 781

We have the php_value memory_limit set to 1000M and there are no problems accessing the front-end or any other back-end features.

We are running PRO, Community Events, and Filters Bar. We’ve been using the plugins for many months now and did not experience this issue until this past week (when our events database passed 5,000). After troubleshooting to pinpoint the source of the issue, we’ve determined that the issue is the combination of the number of events and our theme, Dynamik Website Builder (as opposed to another plugin or something in our functions file).

Given the fact that this issue did not present itself until we reached a certain number of events, I’m hoping that you guys might be able to offer some assistance for how we could resolve this issue (deleting events is not an option.

Thanks,
Sean

[Casey]

irishrunner16,
sorry to hear you’re having trouble here, but hopefully I can help. Just to confirm, did you also increase the memory limit available to WordPress by adding a line similar to this to your wp-config.php?


define( 'WP_MEMORY_LIMIT', '96M' );


If not, try that and let me know if that does the trick. Thanks! 🙂

-Casey-

[irishrunner16]

Hey Casey,
I had previously added the following to my htaccess file:
php_value memory_limit 1000M

I did try adding the WP_MEMORY_LIMIT to my wp-config.php (also setting it to 1000), but that unfortunately didn’t have any effect. Still unable to access the settings of TEC…weird, because the byte limit referenced in the error would be 256MB (I have the limit set to 1000)…but in either case I’d think that should be more than enough?

Sean

[Casey]

Sean,
Often times the hosting provider will put a hard limit on your account’s memory that can’t be overridden by the customer. I would recommend reaching out to your host to see if they can increase the memory limit further to see if that resolves the issue.

It’s also possible that this is a MySQL-related issue, which could be resolved by adding the following snippet to your functions.php file: https://gist.github.com/jazbek/6585714

Give those suggestions a try and let me know what you discover. Thanks! 🙂

-Casey-

[irishrunner16]

Hey Casey,
Thank you very much for the suggestions and advice. It did turn out that our host had a hard limit on the memory, which is why the changes we had tried implementing in the htaccess and wp-config files was not working. Everything appears to be fine now with the increased memory limit.

Thanks again!
Sean

[Casey]

Awesome! Glad to hear you sorted it out. As such, I’ll go ahead and close out this thread. Thanks again! 🙂

-Casey-

[Author]

Posts