Title: minterrors's Replies | WordPress.org --- # minterrors [ ](https://wordpress.org/support/users/minterrors/) * [Profile](https://wordpress.org/support/users/minterrors/) * [Topics Started](https://wordpress.org/support/users/minterrors/topics/) * [Replies Created](https://wordpress.org/support/users/minterrors/replies/) * [Reviews Written](https://wordpress.org/support/users/minterrors/reviews/) * [Topics Replied To](https://wordpress.org/support/users/minterrors/replied-to/) * [Engagements](https://wordpress.org/support/users/minterrors/engagements/) * [Favorites](https://wordpress.org/support/users/minterrors/favorites/) Search replies: ## Forum Replies Created Viewing 15 replies - 1 through 15 (of 17 total) 1 [2](https://wordpress.org/support/users/minterrors/replies/page/2/?output_format=md) [→](https://wordpress.org/support/users/minterrors/replies/page/2/?output_format=md) * Forum: [Plugins](https://wordpress.org/support/forum/plugins-and-hacks/) In reply to: [[Wordfence Security - Firewall, Malware Scan, and Login Security] Table wp_wffilemods](https://wordpress.org/support/topic/table-wp_wffilemods/) * Thread Starter [minterrors](https://wordpress.org/support/users/minterrors/) * (@minterrors) * [1 year, 5 months ago](https://wordpress.org/support/topic/table-wp_wffilemods/#post-18198896) * [@wfmargaret](https://wordpress.org/support/users/wfmargaret/) * 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. * Forum: [Plugins](https://wordpress.org/support/forum/plugins-and-hacks/) In reply to: [[Wordfence Security - Firewall, Malware Scan, and Login Security] Table wp_wffilemods](https://wordpress.org/support/topic/table-wp_wffilemods/) * Thread Starter [minterrors](https://wordpress.org/support/users/minterrors/) * (@minterrors) * [1 year, 7 months ago](https://wordpress.org/support/topic/table-wp_wffilemods/#post-18110850) * [@wfmargaret](https://wordpress.org/support/users/wfmargaret/) * 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. * Forum: [Plugins](https://wordpress.org/support/forum/plugins-and-hacks/) In reply to: [[Wordfence Security - Firewall, Malware Scan, and Login Security] Table wp_wffilemods](https://wordpress.org/support/topic/table-wp_wffilemods/) * Thread Starter [minterrors](https://wordpress.org/support/users/minterrors/) * (@minterrors) * [1 year, 7 months ago](https://wordpress.org/support/topic/table-wp_wffilemods/#post-18092250) * [@wfmargaret](https://wordpress.org/support/users/wfmargaret/) , * 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. * Forum: [Plugins](https://wordpress.org/support/forum/plugins-and-hacks/) In reply to: [[Wordfence Security - Firewall, Malware Scan, and Login Security] Table wp_wffilemods](https://wordpress.org/support/topic/table-wp_wffilemods/) * Thread Starter [minterrors](https://wordpress.org/support/users/minterrors/) * (@minterrors) * [1 year, 7 months ago](https://wordpress.org/support/topic/table-wp_wffilemods/#post-18083623) * 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 TABLE` command: 1. Open your MySQL client 2. Select the database that contains the table you want to empty: 3. - `USE database_name;` 4. Truncate the table: 5. - `TRUNCATE TABLE table_name;` 6. Press Enter to execute the command  * You can also use the MySQL Command Line Interface (MySQL CLI) to truncate a table: 1. Open a command prompt or terminal window 2. Connect to your MySQL server: 3. - `mysql.exe -u[username] -p` 4. Select the database that contains the table you want to truncate: 5. - `USE db_name` 6. Truncate the table: 7. - `TRUNCATE TABLE table_name;` 8. Press Enter to execute the command  * - This reply was modified 1 year, 7 months ago by [minterrors](https://wordpress.org/support/users/minterrors/). - This reply was modified 1 year, 7 months ago by [minterrors](https://wordpress.org/support/users/minterrors/). * Forum: [Plugins](https://wordpress.org/support/forum/plugins-and-hacks/) In reply to: [[Wordfence Security - Firewall, Malware Scan, and Login Security] Table wp_wffilemods](https://wordpress.org/support/topic/table-wp_wffilemods/) * Thread Starter [minterrors](https://wordpress.org/support/users/minterrors/) * (@minterrors) * [1 year, 7 months ago](https://wordpress.org/support/topic/table-wp_wffilemods/#post-18080146) * 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](https://wordpress.org/support/users/minterrors/). * Forum: [Plugins](https://wordpress.org/support/forum/plugins-and-hacks/) In reply to: [[Wordfence Security - Firewall, Malware Scan, and Login Security] Table wp_wffilemods](https://wordpress.org/support/topic/table-wp_wffilemods/) * Thread Starter [minterrors](https://wordpress.org/support/users/minterrors/) * (@minterrors) * [1 year, 7 months ago](https://wordpress.org/support/topic/table-wp_wffilemods/#post-18080127) * [@wfmargaret](https://wordpress.org/support/users/wfmargaret/) * 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 `wfknownfilelist` and `wffilemods` tables? Or is there an option within WordFence iteself?**_ * Forum: [Plugins](https://wordpress.org/support/forum/plugins-and-hacks/) In reply to: [[WooPayments: Integrated WooCommerce Payments] woocommerce throwing errors](https://wordpress.org/support/topic/woocommerce-throwing-errors/) * Thread Starter [minterrors](https://wordpress.org/support/users/minterrors/) * (@minterrors) * [2 years, 4 months ago](https://wordpress.org/support/topic/woocommerce-throwing-errors/#post-17360527) * closing post thanks for the quick reply * Forum: [Plugins](https://wordpress.org/support/forum/plugins-and-hacks/) In reply to: [[WooPayments: Integrated WooCommerce Payments] woocommerce throwing errors](https://wordpress.org/support/topic/woocommerce-throwing-errors/) * Thread Starter [minterrors](https://wordpress.org/support/users/minterrors/) * (@minterrors) * [2 years, 4 months ago](https://wordpress.org/support/topic/woocommerce-throwing-errors/#post-17345217) * Thanks 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](https://wordpress.org/support/forum/how-to-and-troubleshooting/) In reply to: [Critical Error loading first plugin](https://wordpress.org/support/topic/critical-error-loading-first-plugin/) * Thread Starter [minterrors](https://wordpress.org/support/users/minterrors/) * (@minterrors) * [2 years, 6 months ago](https://wordpress.org/support/topic/critical-error-loading-first-plugin/#post-17212156) * Hello, * 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](https://wordpress.org/support/forum/how-to-and-troubleshooting/) In reply to: [Critical Error loading first plugin](https://wordpress.org/support/topic/critical-error-loading-first-plugin/) * Thread Starter [minterrors](https://wordpress.org/support/users/minterrors/) * (@minterrors) * [2 years, 6 months ago](https://wordpress.org/support/topic/critical-error-loading-first-plugin/#post-17212039) * Thanks 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](https://wordpress.org/support/forum/installation/) In reply to: [New WordPress Server and 2022 server](https://wordpress.org/support/topic/new-wordpress-server-and-2022-server/) * Thread Starter [minterrors](https://wordpress.org/support/users/minterrors/) * (@minterrors) * [2 years, 6 months ago](https://wordpress.org/support/topic/new-wordpress-server-and-2022-server/#post-17189967) * [@jluizsouzadev](https://wordpress.org/support/users/jluizsouzadev/) * Well…. 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](https://wordpress.org/support/forum/installation/) In reply to: [New WordPress Server and 2022 server](https://wordpress.org/support/topic/new-wordpress-server-and-2022-server/) * Thread Starter [minterrors](https://wordpress.org/support/users/minterrors/) * (@minterrors) * [2 years, 7 months ago](https://wordpress.org/support/topic/new-wordpress-server-and-2022-server/#post-17176626) * WinAcme / 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](https://wordpress.org/support/users/minterrors/). * Forum: [Installing WordPress](https://wordpress.org/support/forum/installation/) In reply to: [New WordPress Server and 2022 server](https://wordpress.org/support/topic/new-wordpress-server-and-2022-server/) * Thread Starter [minterrors](https://wordpress.org/support/users/minterrors/) * (@minterrors) * [2 years, 7 months ago](https://wordpress.org/support/topic/new-wordpress-server-and-2022-server/#post-17175389) * WordPress 6.4 is out soon, like 07Nov23? I will try that from scratch as well. * Forum: [Installing WordPress](https://wordpress.org/support/forum/installation/) In reply to: [New WordPress Server and 2022 server](https://wordpress.org/support/topic/new-wordpress-server-and-2022-server/) * Thread Starter [minterrors](https://wordpress.org/support/users/minterrors/) * (@minterrors) * [2 years, 7 months ago](https://wordpress.org/support/topic/new-wordpress-server-and-2022-server/#post-17175387) * [@jluizsouzadev](https://wordpress.org/support/users/jluizsouzadev/) * Yes, I am able to log in to the MYSQL server by command line and by the workbench app as well. * Forum: [Installing WordPress](https://wordpress.org/support/forum/installation/) In reply to: [New WordPress Server and 2022 server](https://wordpress.org/support/topic/new-wordpress-server-and-2022-server/) * Thread Starter [minterrors](https://wordpress.org/support/users/minterrors/) * (@minterrors) * [2 years, 7 months ago](https://wordpress.org/support/topic/new-wordpress-server-and-2022-server/#post-17171336) * OK, 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. Viewing 15 replies - 1 through 15 (of 17 total) 1 [2](https://wordpress.org/support/users/minterrors/replies/page/2/?output_format=md) [→](https://wordpress.org/support/users/minterrors/replies/page/2/?output_format=md)