Forum Replies Created

Viewing 15 replies - 1 through 15 (of 55 total)
  • Thread Starter dfcsl

    (@dfcsl)

    OK. Thank you. I will investigate further.

    Thread Starter dfcsl

    (@dfcsl)

    Thank you.

    Thread Starter dfcsl

    (@dfcsl)

    That sorted it, thank you!

    Thread Starter dfcsl

    (@dfcsl)

    Sorted it out.

    Thread Starter dfcsl

    (@dfcsl)

    The hosting company have fixed it, thank you.

    Thread Starter dfcsl

    (@dfcsl)

    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
    
    
    Thread Starter dfcsl

    (@dfcsl)

    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://ww.wp.xz.cn/support/topic/large-sql-file/

    • This reply was modified 3 years, 7 months ago by dfcsl.
    Forum: Fixing WordPress
    In reply to: Huge DB file (SQL)
    Thread Starter dfcsl

    (@dfcsl)

    OK. Thank you.

    Thread Starter dfcsl

    (@dfcsl)

    Thank you, you have been an amazing help.

    Kind regards.

    Thread Starter dfcsl

    (@dfcsl)

    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.

    Thread Starter dfcsl

    (@dfcsl)

    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.

    Thread Starter dfcsl

    (@dfcsl)

    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?

    Thread Starter dfcsl

    (@dfcsl)

    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?

Viewing 15 replies - 1 through 15 (of 55 total)