dfcsl

That sorted it, thank you!

Sorted it out.

The hosting company have fixed it, thank you.

It’s certainly that Redis plugin causing the issue. There are numerous error messages on the log and they are repetitive. Shown at foot of post..

I tried the WordPress way of deactivating all plugins via PHP
ie: Change the?option_value?field to:?a:0:{}

The problem still persists.

How do I get rid of this Redis?

Repetitive Error Log Message

[01-May-2023 09:55:46 UTC] PHP Fatal error: Uncaught RedisException: Connection refused in /home/brickwork/public_html/wp-content/object-cache.php:726 Stack trace: 

#0 /home/brickwork/public_html/wp-content/object-cache.php(726): Redis->connect('127.0.0.1', 6379, 1, '', 0, 1) 

#1 /home/brickwork/public_html/wp-content/object-cache.php(538): WP_Object_Cache->connect_using_phpredis(Array) 

#2 /home/brickwork/public_html/wp-content/object-cache.php(256): WP_Object_Cache->__construct(false) 

#3 /home/brickwork/public_html/wp-includes/load.php(750): wp_cache_init() 

#4 /home/brickwork/public_html/wp-settings.php(131): wp_start_object_cache() 

#5 /home/brickwork/public_html/wp-config.php(91): require_once('/home/brickwork...’) 

#6 /home/brickwork/public_html/wp-load.php(50): require_once('/home/brickwork...’) 

#7 /home/brickwork/public_html/wp-blog-header.php(13): require_once('/home/brickwork...’) 

#8 /home/brickwork/public_html/index.php(17): require('/home/brickwork...’) 

#9 {main} thrown in /home/brickwork/public_html/wp-content/object-cache.php on line 726

Seems its something to do with the Redis plugin. I manually renamed all plugins so they are no longer active, should that not have resolved this?

Found this in the error log::

[30-Apr-2023 17:36:03 UTC] PHP Fatal error: Uncaught RedisException: Connection refused in /home/brickwork/public_html/wp-content/object-cache.php:726 Stack trace: #0 /home/brickwork/public_html/wp-content/object-cache.php(726): Redis->connect(‘127.0.0.1’, 6379, 1, ”, 0, 1) #1 /home/brickwork/public_html/wp-content/object-cache.php(538): WP_Object_Cache->connect_using_phpredis(Array) #2 /home/brickwork/public_html/wp-content/object-cache.php(256): WP_Object_Cache->__construct(false) #3 /home/brickwork/public_html/wp-includes/load.php(750): wp_cache_init() #4 /home/brickwork/public_html/wp-settings.php(131): wp_start_object_cache() #5 /home/brickwork/public_html/wp-config.php(91): require_once(‘/home/brickwork…’) #6 /home/brickwork/public_html/wp-load.php(50): require_once(‘/home/brickwork…’) #7 /home/brickwork/public_html/wp-blog-header.php(13): require_once(‘/home/brickwork…’) #8 /home/brickwork/public_html/index.php(17): require(‘/home/brickwork…’) #9 {main} thrown in /home/brickwork/public_html/wp-content/object-cache.php on line 726

Hello, I have around 10 WordPress sites. I was in my server and noticed one of the SQL DB files was huge compared to others, it is over 6GB where as most of my SQL files are 10-100mb. Granted, the site relative to the 6GB SQL file is my biggest site, but 6GB?

So, I did some investigation and spoke with my server company who are always very helpful. He tells me that most of the space in the file is taken up by wp_mbp_ping_optimizer

Can the SQL file be cleaned of this data? Should I be worried?

Thanks, in advance.

I have posted an issue I am having. Please see it right next to this post. Thank you.Link>> https://www.ads-software.com/support/topic/large-sql-file/

• This reply was modified 2 years, 5 months ago by dfcsl.

OK. Thank you.

Thank you, you have been an amazing help.

Kind regards.

Also, I have not had any more fake user registrations since I turned off the possibility to register around 6.5 hours ago.

I guess that I do need to address the situation if I want to turn user registration back on, can I read about how to install antispam on new user registrations and do any work better than others?

Thanks.

That’s totally fantastic. Thank you!! That made it quite a quick job as I have been able to do them 999 at a time. Worked up and found 999 to be the maximum but that cleared them in 9 events instead of over 200.

Thanks for your help, awesome.

That’s great, thank you, that code is working to show only the users with zero posts. However, there are still 221 pages….

Is there a way to make each page show more than 20 users?

Firstly, I updated the Blog49 to the newest WP, so it is on v6.0.1.
Secondly, I have turned off the possibility of new subscribers.

I have realised that many of the 9000 users are actually legit as some of them have made autoblogged posts, so I do not want to delete those users.

is there a way to filter to all users with 0 posts maybe, and delete all those in one go?

Awesome. Thank you so much, you nailed it. I totally forgot about that and should have picked up on it, the registrations are indeed coming from the blog49 version, there’s over 9000 users in there and there should be 1, me.

I should be able to sort it now. I will follow up if I have further issues. Thanks.

Thanks for your response.
Should I perhaps try dis-activating all plugins temporarily?