BuddyPress for Sensei Database ERROR

[Dennis]

I get a memory error when opening the BuddyPress for Sensei admin page. Increasing memory will not fix this issue. It’s timing out because we have over 50,000 members on our development site (many more on our live site). The convert user roles is causing a database error and will not allow the page to load.

[Anonymous]

Hi @kahunaburger, how many user role you are trying to convert at a time? if you will change user roles more than 50 at a time it will create issue based on general PHP configuration of servers.
You can extend your server specific parameters for
max_execution_time
max_input_time
max_input_vars

Regards

[Dennis]

You are not getting what I’m saying. It won’t load the admin page. I can’t even get to where it asks me if I want to convert anyone.

[Anonymous]

Hi @kahunaburger, are you getting specific warning or notice when debug is on, or something inside error log ?

Regards

[Dennis]

Fatal error: Allowed memory size of 262144000 bytes exhausted (tried to allocate 32 bytes) in …/wp-includes/cache.php on line 24

[Dennis]

So what’s going on with this?

[Sol Huebner]

Hi @kahunaburger

Try putting this in your wp-config.php file:

define( ‘WP_MAX_MEMORY_LIMIT’, ‘384M’ );

Or at least 288M

Kind regards

[Dennis]

Seriously? Why don’t you try fixing it.

PS
Our memory is set at 1Gig.

[Sol Huebner]

But the error message days that you have a limit of 256MB…

[Dennis]

You really are going out of your way not to fix anything. I increased it to 1 gig and got the same thing.

[Dennis]

Let me save you some time… I have been coding since the early 80’s when I got my first Texas Instruments PC for X-mas. I have been working with BP when it was in beta. It will save a ton of time when I say something is broken in our code if you just take my word on it. 😉

[Alyssa]

@kahunaburger please speak kindly to other members of the community. They are simply trying to help you resolve your issue from their experience.
Because the issue is the admin interface and cache.php I’m not entirely certain this is a theme/plugin issue. I have found an interesting discussion that may be useful to you here: https://core.trac.wordpress.org/ticket/4045#comment:4
Additional resource: http://sakinshrestha.com/wordpress/fix-php-fatel-error-for-wordpress/

[Dennis]

@rugwarrior Sorry I thought you where a dev. I was upset because they already asked me that. Thanks for trying to help. 🙂

@tjchester It’s an issue with the plugin.

[Alyssa]

@kahunaburger do your server logs have information on the query generating this error?

[Dennis]

I gave you the error. You are trying to query the entire user database. You have not built this plugin for scale.