Roger Correia
Forum Replies Created
-
Before issuing the DELETE command, you may wish to check if these are indeed problem records for your site.
In the 2 SQL statements above, replace ‘DELETE’, with ‘SELECT *’ and run the query and check the results to see if those records are in fact broken / orphaned.
I don’t have any errors or erratic behaviour going on and my error.log file is clean.
However, I did find a bunch of un-deletable events and locations and in discussion with Tech Support, the only way to actually delete them is to use phpMyAdmin and run SQL to get rid of those broken / orphaned records.
This is a bit risky since you are going in through the “back door”.
I used the following 2 SQL commands to do that:
DELETE FROM wp_em_locations WHERE location_status = “-1” to get rid of location records.
DELETE FROM wp_em_events WHERE post_id NOT IN (SELECT ID FROM wp_posts WHERE post_type=”event”) to get rid of event records.
You should always back up first when doing this to ensure you have a safe return point in case of failure..
I did some further investigation following the post from @chadamski and I also found that in addition to un-deletable events, I have numerous duplicate/ un-deletable locations as well.
In the Events Manager admin area I can see only 20 valid locations. However, when I run the following shortcode, I get over 45 locations, many duplicates:
[locations_list scope=”all” limit=”100″]#_LOCATIONLINK </br> [/locations_list]
When I click on their link, it just takes me to the home page.
Thanks Angelo…
I have Events Manager Pro, so I will post my query there. Hopefully you can shed some light on how to clean up these bogus events.
Thanks Angelo…
I have a plugin (eZPHP) that allows me to add PHP snippets to a page, so I was able to easily adapt your example to do what I need.
Works like a charm! Thanks
Is it possible to develop a shortcode to achieve this, such as:
[events_delete scope=”all” status=”-1″ [/events_delete] or
[events_delete post_id=”1008, 1009, 1234″ [/events_delete]
OK… thx
Disregard the first part of my previous note.
I just found the missing “=” between Scope and “all”.
But the second part of my question remains: where to find COMPLETE documentation on the shortcodes, parameters and acceptable values.
As a follow on to my previous note, s2Member has it’s own logging function, which was ENABLED in my configuration. This was probably left over from testing we were doing earlier in the year. Normally this function is DISABLED.
Once I DISABLED logging in s2Member, Wordfence was able to complete it’s scan successfully.
I guess both plugins were competing for logging space. You may close this ticket.
Thanks for your support and getting me to take a closer look at my settings.
It does appear that the issue is a conflict between s2Member and Wordfence.
s2Member was last updated on February 11. Wordfence was updated about a week ago. The problem just started happening recently, so I suspect that the issue was introduced with the latest Wordfence update.
I deactivated s2Member and ran a WF scan. It completed successfully with no issues.
Once I re-activate s2Member and run a WF scan, it never completes and the following error shows up in the Activity Log:
Fatal error: Maximum execution time of 30 seconds exceeded in /home/tdpc/public_html/wp-content/plugins/s2member/src/includes/classes/utils-logs.inc.php on line 128
It appears that the module referenced is s2Member’s logging routine
I found the following recent errors in the logs:
[24-Mar-2017 03:21:55 UTC] PHP Fatal error: require(): Failed opening required ‘wfBrowscapCache.php’ (include_path=’.:/opt/cpanel/ea-php56/root/usr/share/pear’) in /home/tdpc/public_html/wp-content/plugins/wordfence/lib/wfBrowscap.php on line 87
[25-Mar-2017 10:24:02 UTC] PHP Fatal error: Allowed memory size of 268435456 bytes exhausted (tried to allocate 2995 bytes) in /home/tdpc/public_html/wp-includes/functions.php on line 435
[28-Mar-2017 05:47:24 UTC] PHP Fatal error: Allowed memory size of 268435456 bytes exhausted (tried to allocate 4352 bytes) in /home/tdpc/public_html/wp-includes/functions.php on line 435
[29-Mar-2017 12:23:14 UTC] PHP Fatal error: Class ‘c_ws_plugin__s2member_utils_logs’ not found in /home/tdpc/public_html/wp-content/plugins/s2member/src/includes/classes/auto-eots.inc.php on line 306
and the other information you requested:
Loaded Configuration File: opt/cpanel/ea-php56/root/etc
PHP Version: 5.6.30
cURL support: enabled
cURL Information: 7.53.1Forum: Plugins
In reply to: [Autoptimize] Fileaway & Autoptimize conflictSorry, that’s what I meant… was thinking FileAway but typing Autoptimize.
I had used the exclusion /plugins/fileaway but when I looked closer at the directory on the server, I should have really typed /plugins/file-away.
Once I fixed the typo, it worked fine. Wasn’t able to get the GTMetrix report back to 88% from 82%, but it now sits at 85%.
Thanks for your prompt response and making me stop and think!
Forum: Plugins
In reply to: [File Away] Unable to list all filesGreat news Thom… I disabled the JS optimization feature in the AutoOptimize plugin and Fileaway and FileUp now work as expected. Both my issues I reported are resolved.
However, my GTMetrix score has dropped from 88% to 82%. Still reasonable.
Thanks for your all your help.
Forum: Plugins
In reply to: [File Away] Unable to list all filesAs a matter of fact I do… I will deactivate it and let you know what happens
Forum: Plugins
In reply to: [File Away] Unable to Upload FilesSent you the info you requested…