minterrors
Forum Replies Created
-
Well, with an upgrade to WordPress, the updates to several applications as well as upgrading the PHP version for the most part, the errors have ceased. I do backups at planned intervals and the have not failed as of yet. I really didn’t do much except normal routine items. I appreciate your time and effort assisting in this issue. Should anything else arise I will create a new ticket.
Hope your weekend was long and relaxing.
I have left the server be for a few days busy with other projects.
I did see the following in the PHP error log:
PHP Fatal error: Allowed memory size of 134217728 bytes exhausted (tried to allocate 2521808 bytes) in (redacted path)\wp-content\wflogs\rules.php on line 5211.
Thank you very much for all your knowledge and help.
Apologize for the delay. Its been pretty busy around here with other projects.
I truncated the two tables, wffilemods and wfknownfilelist. These were over 200K in rows on each table. they grow in size of each Wordfence scan. The backup would then complete without any time out errors. You are correct, the tables have to be cleared prior to each backup.
Do the wffilemods and wfknownfilelist tables have an approximate maximum size? That seems like a lot of rows…. OR,
Is there a setting within Wordfence to limit or remove the huge amount of rows via a setting in Wordfence after a scan is complete?
I will read your advanced options URL above. I hope that helps. It may take me a bit to get that done.
I do have a caching app on the wordpress environment, but this site isn’t very large.
I added wp-content/cache/* to the exclusion list. I will also say the path to the exclusion list on this version of windows was under the “all settings” vice Wordfence > Scan > Scan Options and Scheduling > Advanced Scan Options Exclude files from scan.
I will admit, its pretty easy to truncate these tables prior to a backup but, I am concerned about the number of rows. Over time, this may slow down the server. I moved the backup from weekly to monthly.
I don’t want to remove WordFence, it does off another layer of protection but if there isn’t a good solution to this, I sadly may have to consider it.
The server is mine and it sits close to my location.
I am not well versed on MYSQL commands, so I like to make sure what I read on the web is true and accurate.
so I can Truncate the table and it should do the trick?
To empty a table file in MySQL, you can use the
TRUNCATE TABLEcommand:- Open your MySQL client
- Select the database that contains the table you want to empty:
USE database_name;
- Truncate the table:
TRUNCATE TABLE table_name;
- Press Enter to execute the command
You can also use the MySQL Command Line Interface (MySQL CLI) to truncate a table:
- Open a command prompt or terminal window
- Connect to your MySQL server:
mysql.exe -u[username] -p
- Select the database that contains the table you want to truncate:
USE db_name
- Truncate the table:
TRUNCATE TABLE table_name;
- Press Enter to execute the command
- This reply was modified 1 year, 7 months ago by minterrors.
- This reply was modified 1 year, 7 months ago by minterrors.
The Database permission area was all green.
A backup warning came up as I attempt another backup. I lowered the amount of rows to keep data to 500(vice 2000) and the number of days to keep to 15 (vice 30 days).
The warning was:
Thu, October 17, 2024 15:39
- Warning: Table wp_wffilemods has very many rows (177180) – we hope your web hosting company gives you enough resources to dump out that table in the backup. If not, you will need to either remove data from this table, or contact your hosting company to request more resources.
- This reply was modified 1 year, 7 months ago by minterrors.
Thank you for the reply.
The only other installation of WordFence is on another domain which is not on a subdirectory, its in a separate folder on the same hard drive.
Later today I will check the permissions.
I did see the WordFence IP was being blocked by the local antivirus and that has been fixed.
What is the MYSQL command to safely clear the
wfknownfilelistandwffilemodstables? Or is there an option within WordFence iteself?Forum: Plugins
In reply to: [WooPayments: Integrated WooCommerce Payments] woocommerce throwing errorsclosing post thanks for the quick reply
Forum: Plugins
In reply to: [WooPayments: Integrated WooCommerce Payments] woocommerce throwing errorsThanks for your quick reply.
I rebooted the server and I was able to see the posts after Product Feed PRO for WooCommerce updated. The Product Feed PRO for WooCommerce was the only one that was not on “enable updates”. I have now assigned that to update automatically.
The PHP and MySQL are among the newer versions.
I will get back to the server here in a day or so and be able to perform the download for support link.
I will leave this open for a day or two to see if there are any issues. If none, I will close the post.
Forum: Fixing WordPress
In reply to: Critical Error loading first pluginHello,
One of the plugins I attempted next was a email related plugin. It said that OpenSSL wasnt activated. So I activated it in PHP and the plugin finished successfully. I deleted the Wordfence and JetPack folders. I tried the Wordfence plugin once again and it successfully loaded.
I will close this ticket. In the case some other error pops up, I do another ticket.
Again, I appreciate your assistance and I will try to see if DEBUG will assist in any other errors that might occur.
Forum: Fixing WordPress
In reply to: Critical Error loading first pluginThanks for the quick reply.
What is the name of the WordPress error log? I run my own server, which is within close proximity. I will search for the file name and see if it offers any decent info.
I have been attempting several plugins. The two security plugins are not loading, Wordfence and Jetpack. What I was successful so far was:
W3 Total cache
WordPress Importer
WP Crontrol.
Updraft Backup
I DO have an inline firewall, and I do not know at this point whether the inline firewall is refusing to load Wordfence and Jetpack or if it is something else. I will bypass the firewall when I have an opportunity to do so.
Forum: Installing WordPress
In reply to: New WordPress Server and 2022 serverWell…. I deleted the WP files on the website. I loaded up 6.4.1 and I was honestly shocked to see the setup screen – I have not done anything else to the server or the website. The site went through the installation hoops and the skeletal website is up and running as I type. I shut the server down so I can work on several other items before I get the website restored. I have two more websites to install from scratch, but the main site should be back up and fully functional soon.
Should there be any other issues, I will open up a new ticket.
Forum: Installing WordPress
In reply to: New WordPress Server and 2022 serverWinAcme / Let’s Encrypt certificates for HTTPS:// installed successfully. Tried the website and it still gives the critical error upon trying to start a new WordPress website. I will dig into permissions within a few days.
- This reply was modified 2 years, 7 months ago by minterrors.
Forum: Installing WordPress
In reply to: New WordPress Server and 2022 serverWordPress 6.4 is out soon, like 07Nov23? I will try that from scratch as well.
Forum: Installing WordPress
In reply to: New WordPress Server and 2022 serverYes, I am able to log in to the MYSQL server by command line and by the workbench app as well.
Forum: Installing WordPress
In reply to: New WordPress Server and 2022 serverOK, I inserted a test wp-config-sample.php file and got the same error:
A critical error has occurred.
There was no debug.log file in the wp-content folder. A search produced no results.
When I simply renamed the wp-config-sample.php file to wp-config.php , I get the expected error Database Error – Error establishing database connection.
Please remember, this is a brand new installation attempt on a reloaded Windows 2022, IIS, MySQL and PHP load.
I appreciate all suggestions and troubleshooting tips.