Title: PHP error in wfActivityReport Last modified: February 21, 2019 --- # PHP error in wfActivityReport * [WP4TeePee](https://wordpress.org/support/users/wp4teepee/) * (@wp4teepee) * [7 years, 3 months ago](https://wordpress.org/support/topic/php-error-in-wfactivityreport/) * Hello, I get the following error and was wondering how I might go about resolving it. * PHP Notice: Undefined offset: 2 in /home/orgchang/public_html/wp-content/plugins/ wordfence/lib/wfActivityReport.php on line 601 [Feb 21, 16:21:11] * I’d appreciate input. * Thank you. Viewing 7 replies - 1 through 7 (of 7 total) * [wfdave](https://wordpress.org/support/users/wfdave/) * (@wfdave) * [7 years, 3 months ago](https://wordpress.org/support/topic/php-error-in-wfactivityreport/#post-11231722) * Hi [@wp4teepee](https://wordpress.org/support/users/wp4teepee/), * Can you run the following query and let me know what it returns? * `SELECT SUBSTR(actionData,49,100) FROM wp_wfhits WHERE actionData IS NOT NULL ORDER BY attackLogTime DESC LIMIT 20;` * In order to fix that error, you will need to flush the table by running this query: * `DELETE FROM wp_wfhits;` * Dave * Thread Starter [WP4TeePee](https://wordpress.org/support/users/wp4teepee/) * (@wp4teepee) * [7 years, 3 months ago](https://wordpress.org/support/topic/php-error-in-wfactivityreport/#post-11234160) * Thanks for the note, friend. Your suggestion, though, is beyond my skill set - This reply was modified 7 years, 3 months ago by [WP4TeePee](https://wordpress.org/support/users/wp4teepee/). * [wfdave](https://wordpress.org/support/users/wfdave/) * (@wfdave) * [7 years, 3 months ago](https://wordpress.org/support/topic/php-error-in-wfactivityreport/#post-11235365) * Hi again! * Do you have something like PHPMyAdmin installed? * [https://wordpress.org/plugins/wp-phpmyadmin-extension/](https://wordpress.org/plugins/wp-phpmyadmin-extension/) * From this plugin, you run queries from the SQL tab: [https://i.stack.imgur.com/BcsLv.png](https://i.stack.imgur.com/BcsLv.png) * Dave * Thread Starter [WP4TeePee](https://wordpress.org/support/users/wp4teepee/) * (@wp4teepee) * [7 years, 3 months ago](https://wordpress.org/support/topic/php-error-in-wfactivityreport/#post-11237952) * Thank you Dave, that was a very helpful tip. * The returned data is: —– Showing rows 0 – 19 (20 total, Query took 0.0012 seconds.) * SELECT SUBSTR(actionData,49,100) FROM `wp_wfHits` WHERE actionData IS NOT NULL ORDER BY attackLogTime DESC LIMIT 20 * SUBSTR(actionData,49,100) “cmVxdWVzdC5xdWVyeVN0cmluZ1twaWNd”,”paramValue”:”L…“ cmVxdWVzdC5xdWVyeVN0cmluZ1twYXRoXQ==”,”paramValue… :”cmVxdWVzdC5xdWVyeVN0cmluZ1t1cF9hdXRvX2xvZ10 =”,”p… cmVxdWVzdC5ib2R5Wy0tNDcyMmQzMGM0MGNlMzNiY2E3NTA0Mz… cmVxdWVzdC5ib2R5Wy0tZDZjYmIzNTljNGZjOTczMWIwYjMwNW…“ c2VydmVyLmVtcHR5″,”paramValue”:””,”path”:”L3dwLWF… “cmVxdWVzdC5xdWVyeVN0cmluZ1twaWNd”,” paramValue”:”L… “cmVxdWVzdC5xdWVyeVN0cmluZ1twYXRoXQ==”,”paramValue… :”cmVxdWVzdC5xdWVyeVN0cmluZ1t1cF9hdXRvX2xvZ10 =”,”p… cmVxdWVzdC5ib2R5Wy0tM2FmMzdkM2IyNmQ3NWZiODI3OWQ5NT… cmVxdWVzdC5ib2R5Wy0tNDUxMGJiMTQyNjJkODFiZDlmOTVhYj…“ c2VydmVyLmVtcHR5″,”paramValue”:””,”path”:”L3dwLWF… ,”paramValue”:””,”path”:”L3htbC5waHA =”} ,”paramValue”:””,”path”:”L3dzbzkucGhw”} ,”paramValue”:””,”path”:”L3dzby5waHA =”} ,”paramValue”:””,”path”:”L3dwLXN5c3RlbS5waHA=”} ,”paramValue”:””,”path”:” L3dwLXNlY3VyaXR5LnBocA==”… ,”paramValue”:””,”path”:”L3dwLXNlYXJjaGVzLnBocA==”…,” paramValue”:””,”path”:”L3dwLXBhZ2UucGhw”} ,”paramValue”:””,”path”:”L3dwLW5ldHdvcmsucGhw”} * Now, I have not run the delete query yet as on my read you are saying delete everything? so DELETE * FROM wp_wfhits; * Or is there something more specific to delete? * [wfdave](https://wordpress.org/support/users/wfdave/) * (@wfdave) * [7 years, 3 months ago](https://wordpress.org/support/topic/php-error-in-wfactivityreport/#post-11237985) * Hi again, * There seems to be some bad rows in the traffic data (which was caused by Wordfence). * Can you run `DELETE * FROM wp_wfhits;` now to clear the data? * Dave * Thread Starter [WP4TeePee](https://wordpress.org/support/users/wp4teepee/) * (@wp4teepee) * [7 years, 3 months ago](https://wordpress.org/support/topic/php-error-in-wfactivityreport/#post-11240654) * Ok, I’ve done that Dave. Will wait and see if I get more PHP errors * Thanks for your help * PS, just for your info, VaultPress deactivated PHPMyAdmin because “Unsanitized PHP global variables are being used to include or require other files.” * Thread Starter [WP4TeePee](https://wordpress.org/support/users/wp4teepee/) * (@wp4teepee) * [7 years, 3 months ago](https://wordpress.org/support/topic/php-error-in-wfactivityreport/#post-11252478) * David, unfortunately I am still getting the same errors. * [Feb 26, 16:01:36] PHP Notice: Undefined offset: 2 in /home/../public_html/wp- content/plugins/wordfence/lib/wfActivityReport.php on line 601 [Feb 26, 16:01: 36] PHP Notice: Undefined offset: 2 in /home/../public_html/wp-content/plugins/ wordfence/lib/wfActivityReport.php on line 601 [Feb 26, 16:01:36] PHP Notice: Undefined offset: 2 in /home/../public_html/wp-content/plugins/wordfence/lib/ wfActivityReport.php on line 601 [Feb 26, 16:01:36] PHP Notice: Undefined offset: 2 in /home/../public_html/wp-content/plugins/wordfence/lib/wfActivityReport.php on line 601 * I’m thinking that I need to remove the plugin, your thoughts? * Thank you. Viewing 7 replies - 1 through 7 (of 7 total) The topic ‘PHP error in wfActivityReport’ is closed to new replies. * ![](https://ps.w.org/wordfence/assets/icon.svg?rev=2070865) * [Wordfence Security - Firewall, Malware Scan, and Login Security](https://wordpress.org/plugins/wordfence/) * [Frequently Asked Questions](https://wordpress.org/plugins/wordfence/#faq) * [Support Threads](https://wordpress.org/support/plugin/wordfence/) * [Active Topics](https://wordpress.org/support/plugin/wordfence/active/) * [Unresolved Topics](https://wordpress.org/support/plugin/wordfence/unresolved/) * [Reviews](https://wordpress.org/support/plugin/wordfence/reviews/) ## Tags * [php](https://wordpress.org/support/topic-tag/php/) * 7 replies * 2 participants * Last reply from: [WP4TeePee](https://wordpress.org/support/users/wp4teepee/) * Last activity: [7 years, 3 months ago](https://wordpress.org/support/topic/php-error-in-wfactivityreport/#post-11252478) * Status: not resolved