• Resolved rad1964

    (@rad1964)


    Hello,
    We are running Events Manager 5.5.3.1 on a multisite and are getting excessive log files that are using up too much resources as I hear we have to purge the files every two days, which means important errors may be getting deleted.

    I have narrowed down the site in question and the plugin generating these files to your plugin. The site itself as far as I can see, has NO EVENTS listed. Which befuddles me even more!

    Here is a sample of whats filling our log files:

    # User@Host: wp_owner[wp_owner] @ xyz.com [1.2.3.4]  Id: 1245307
    # Query_time: 0.005591  Lock_time: 0.000064 Rows_sent: 233  Rows_examined: 283
    SET timestamp=1431875751;
    SELECT option_name, option_value FROM wp_options WHERE autoload = 'yes';
    # User@Host: wp_owner[wp_owner] @ xyz.com [1.2.3.4]  Id: 1245306
    # Query_time: 0.004136  Lock_time: 0.000058 Rows_sent: 233  Rows_examined: 283
    SET timestamp=1431875751;
    SELECT option_name, option_value FROM wp_options WHERE autoload = 'yes';
    # User@Host: wp_owner[wp_owner] @ xyz.com [1.2.3.4]  Id: 1245310
    # Query_time: 0.005772  Lock_time: 0.000070 Rows_sent: 593  Rows_examined: 643
    SET timestamp=1431875751;
    SELECT option_name, option_value FROM wp_69_options WHERE autoload = 'yes';
    # User@Host: wp_owner[wp_owner] @ xyz.com [1.2.3.4]  Id: 1245307
    # Query_time: 0.000452  Lock_time: 0.000221 Rows_sent: 0  Rows_examined: 6
    SET timestamp=1431875751;
    SELECT wp_69_em_events.event_id,wp_69_em_events.post_id,wp_69_em_events.event_slug,wp_69_em_events.event_owner,wp_69_em_events.event_name,wp_69_em_events.event_start_time,wp_69_em_events.event_end_time,wp_69_em_events.event_all_day,wp_69_em_events.event_start_date,wp_69_em_events.event_end_date,wp_69_em_events.post_content,wp_69_em_events.event_rsvp,wp_69_em_events.event_rsvp_date,wp_69_em_events.event_rsvp_time,wp_69_em_events.event_rsvp_spaces,wp_69_em_events.event_spaces,wp_69_em_events.location_id,wp_69_em_events.recurrence_id,wp_69_em_events.event_status,wp_69_em_events.event_private,wp_69_em_events.event_date_created,wp_69_em_events.event_date_modified,wp_69_em_events.event_attributes,wp_69_em_events.blog_id,wp_69_em_events.group_id,wp_69_em_events.recurrence,wp_69_em_events.recurrence_interval,wp_69_em_events.recurrence_freq,wp_69_em_events.recurrence_days,wp_69_em_events.recurrence_byday,wp_69_em_events.recurrence_byweekno FROM wp_69_em_events
    
    			LEFT JOIN wp_69_em_locations ON wp_69_em_locations.location_id=wp_69_em_events.location_id
    
    			 WHERE (<code>recurrence</code>!=1 OR <code>recurrence</code> IS NULL) AND ( event_start_date <= CAST('1755-04-06' AS DATE) AND event_end_date >= CAST('1755-02-24' AS DATE) ) AND (<code>event_status</code>=1) AND (<code>event_private</code>=0)
    
    			 ORDER BY event_name ASC, event_start_time ASC;

    We intend on updating to WordPress 4.1.1 shortly, which hopefully means we will also update our plugins.

    Any help would be greatly appreciated.

    rad1964

    https://ww.wp.xz.cn/plugins/events-manager/

Viewing 3 replies - 1 through 3 (of 3 total)
  • Thread Starter rad1964

    (@rad1964)

    ADMIN, I need to edit my original post to scrub IP addresses!~!!!!! please delete the code in the above post ASAP… why isn’t there an edit button that sticks around!!!

    Moderator Jan Dembowski

    (@jdembowski)

    Forum Moderator and Brute Squad

    @rad1964 Deep breath: IP addresses are 100% not a security concern. Even RFC1918 private address space.

    That said, I’ll edit in a minute.

    Plugin Support angelo_nwl

    (@angelo_nwl)

    sorry not getting this error log; maybe you can try to upgrade your current EM version instead.

Viewing 3 replies - 1 through 3 (of 3 total)

The topic ‘Excessive log files’ is closed to new replies.