[Karen Newman]

I should also mention that my site is cached using WP Super Cache, so the fact that my DB is macing out is strange.

[Karen Newman]

Makes sense and it looks like there are only two crons from your plugin running. I have my SQL logs on and there are a lot of read queries happening at this time. A lot of them are queries to posts from tribe events. For example here are a ton of queries that run all at the same time. Not saying all of these are by your plugin, but some seem like they are:

2016-07-19 17:55:20 Canal_DB[Canal_DB] @ [172.30.3.98] 87 655433897 Query SELECT option_value FROM wp_options WHERE option_name = ‘itsec_message_queue’ LIMIT 1
2016-07-19 17:55:20 Canal_DB[Canal_DB] @ [172.30.3.98] 87 655433897 Query SELECT option_value FROM wp_options WHERE option_name = ‘jetpack_active_modules’ LIMIT 1
2016-07-19 17:55:20 Canal_DB[Canal_DB] @ [172.30.3.98] 87 655433897 Query SELECT option_value FROM wp_options WHERE option_name = ‘uninstall_plugins’ LIMIT 1
2016-07-19 17:55:20 Canal_DB[Canal_DB] @ [172.30.3.98] 87 655433897 Query SELECT option_value FROM wp_options WHERE option_name = ‘bit51_bwps’ LIMIT 1
2016-07-19 17:55:20 Canal_DB[Canal_DB] @ [172.30.3.98] 87 655433897 Query SELECT option_value FROM wp_options WHERE option_name = ‘ithemes-sync-twitter-accounts’ LIMIT 1
2016-07-19 17:55:20 Canal_DB[Canal_DB] @ [172.30.3.98] 87 655433897 Query SELECT option_value FROM wp_options WHERE option_name = ‘ossdl_https’ LIMIT 1
2016-07-19 17:55:20 Canal_DB[Canal_DB] @ [172.30.3.98] 87 655433897 Query SELECT option_value FROM wp_options WHERE option_name = ‘gzipcompression’ LIMIT 1
2016-07-19 17:55:20 Canal_DB[Canal_DB] @ [172.30.3.98] 87 655433897 Query SELECT lockout_host FROM wp_itsec_lockouts WHERE lockout_active=1 AND lockout_expire_gmt > ‘2016-07-19 17:55:27’ AND lockout_host=’64.39.104.110′
2016-07-19 17:55:20 Canal_DB[Canal_DB] @ [172.30.3.98] 87 655433897 Query SELECT option_value FROM wp_options WHERE option_name = ‘preload_cache_counter’ LIMIT 1
2016-07-19 17:55:20 Canal_DB[Canal_DB] @ [172.30.3.98] 87 655433897 Query SELECT ID FROM wp_posts WHERE post_name=’paddle-and-peddle-boat-rentals’ AND post_type=’tribe_events’
2016-07-19 17:55:20 Canal_DB[Canal_DB] @ [172.30.3.98] 87 655433897 Query SELECT post_id, meta_key, meta_value FROM wp_postmeta WHERE post_id IN (12105) ORDER BY meta_id ASC
2016-07-19 17:55:20 Canal_DB[Canal_DB] @ [172.30.3.98] 87 655433897 Query SELECT ID
FROM wp_posts p
INNER JOIN wp_postmeta m ON m.post_id=p.ID AND m.meta_key=’_EventStartDate’
WHERE p.post_parent=12105
AND p.post_type=’tribe_events’
AND LEFT( m.meta_value, 10 ) = ‘2016-08-01’
2016-07-19 17:55:20 Canal_DB[Canal_DB] @ [172.30.3.98] 87 655433897 Query SELECT DISTINCT wp_posts.*, MIN(wp_postmeta.meta_value) as EventStartDate, MIN(tribe_event_end_date.meta_value) as EventEndDate FROM wp_posts INNER JOIN wp_postmeta ON ( wp_posts.ID = wp_postmeta.post_id ) LEFT JOIN wp_postmeta as tribe_event_end_date ON ( wp_posts.ID = tribe_event_end_date.post_id AND tribe_event_end_date.meta_key = ‘_EventEndDate’ ) WHERE 1=1 AND wp_posts.ID = 13757 AND (
wp_postmeta.meta_key = ‘_EventStartDate’
) AND wp_posts.post_type = ‘tribe_events’ GROUP BY wp_posts.ID ORDER BY EventStartDate DESC, wp_posts.post_date DESC
2016-07-19 17:55:20 Canal_DB[Canal_DB] @ [172.30.3.98] 87 655433897 Query SELECT t.*, tt.*, tr.object_id FROM wp_terms AS t INNER JOIN wp_term_taxonomy AS tt ON tt.term_id = t.term_id INNER JOIN wp_term_relationships AS tr ON tr.term_taxonomy_id = tt.term_taxonomy_id WHERE tt.taxonomy IN (‘post_tag’, ‘tribe_events_cat’) AND tr.object_id IN (13757) ORDER BY t.name ASC
2016-07-19 17:55:20 Canal_DB[Canal_DB] @ [172.30.3.98] 87 655433897 Query SELECT post_id, meta_key, meta_value FROM wp_postmeta WHERE post_id IN (13757) ORDER BY meta_id ASC
2016-07-19 17:55:20 Canal_DB[Canal_DB] @ [172.30.3.98] 87 655433897 Query SELECT * FROM wp_posts WHERE ID = 13606 LIMIT 1
2016-07-19 17:55:20 Canal_DB[Canal_DB] @ [172.30.3.98] 87 655433897 Query SELECT post_id, meta_key, meta_value FROM wp_postmeta WHERE post_id IN (13606) ORDER BY meta_id ASC
2016-07-19 17:55:20 Canal_DB[Canal_DB] @ [172.30.3.98] 87 655433897 Query SELECT * FROM wp_posts WHERE ID = 12105 LIMIT 1
2016-07-19 17:55:20 Canal_DB[Canal_DB] @ [172.30.3.98] 87 655433897 Query SELECT option_value FROM wp_options WHERE option_name = ‘_transient_timeout_geoloc_center_point_estimation’ LIMIT 1
2016-07-19 17:55:20 Canal_DB[Canal_DB] @ [172.30.3.98] 85 655433897 Query SELECT FOUND_ROWS()
2016-07-19 17:55:20 Canal_DB[Canal_DB] @ [172.30.3.98] 87 655433897 Query SELECT option_value FROM wp_options WHERE option_name = ‘_transient_geoloc_center_point_estimation’ LIMIT 1
2016-07-19 17:55:20 Canal_DB[Canal_DB] @ [172.30.3.98] 85 655433897 Query SELECT t.*, tt.*, tr.object_id FROM wp_terms AS t INNER JOIN wp_term_taxonomy AS tt ON tt.term_id = t.term_id INNER JOIN wp_term_relationships AS tr ON tr.term_taxonomy_id = tt.term_taxonomy_id WHERE tt.taxonomy IN (‘post_tag’, ‘tribe_events_cat’) AND tr.object_id IN (10125, 10371, 11361, 13744) ORDER BY t.name ASC
2016-07-19 17:55:20 Canal_DB[Canal_DB] @ [172.30.3.98] 87 655433897 Query SELECT p.ID FROM wp_posts AS p WHERE p.post_date < ‘2016-06-22 15:03:39’ AND p.post_type = ‘tribe_events’ AND p.post_status = ‘publish’ ORDER BY p.post_date DESC LIMIT 1
2016-07-19 17:55:20 Canal_DB[Canal_DB] @ [172.30.3.98] 85 655433897 Query SELECT post_id, meta_key, meta_value FROM wp_postmeta WHERE post_id IN (10125,10371,11361,13744) ORDER BY meta_id ASC
2016-07-19 17:55:20 Canal_DB[Canal_DB] @ [172.30.3.98] 87 655433897 Query SELECT * FROM wp_posts WHERE ID = 11449 LIMIT 1
2016-07-19 17:55:20 Canal_DB[Canal_DB] @ [172.30.3.98] 87 655433897 Query SELECT post_id, meta_key, meta_value FROM wp_postmeta WHERE post_id IN (11449) ORDER BY meta_id ASC
2016-07-19 17:55:20 Canal_DB[Canal_DB] @ [172.30.3.98] 85 655433897 Query SELECT option_value FROM wp_options WHERE option_name = ‘_options_ttd_desktop_image’ LIMIT 1
2016-07-19 17:55:20 Canal_DB[Canal_DB] @ [172.30.3.98] 87 655433897 Query SELECT * FROM wp_posts WHERE ID = 11374 LIMIT 1
2016-07-19 17:55:20 Canal_DB[Canal_DB] @ [172.30.3.98] 85 655433897 Query SELECT option_value FROM wp_options WHERE option_name = ‘options_ttd_desktop_image’ LIMIT 1
2016-07-19 17:55:20 Canal_DB[Canal_DB] @ [172.30.3.98] 87 655433897 Query SELECT p.ID FROM wp_posts AS p WHERE p.post_date > ‘2016-06-22 15:03:39’ AND p.post_type = ‘tribe_events’ AND p.post_status = ‘publish’ ORDER BY p.post_date ASC LIMIT 1
2016-07-19 17:55:20 Canal_DB[Canal_DB] @ [172.30.3.98] 85 655433897 Query SELECT * FROM wp_posts WHERE ID = 9823 LIMIT 1
2016-07-19 17:55:20 Canal_DB[Canal_DB] @ [172.30.3.98] 87 655433897 Query SELECT * FROM wp_posts WHERE ID = 12835 LIMIT 1
2016-07-19 17:55:20 Canal_DB[Canal_DB] @ [172.30.3.98] 85 655433897 Query SELECT post_id, meta_key, meta_value FROM wp_postmeta WHERE post_id IN (9823) ORDER BY meta_id ASC
2016-07-19 17:55:20 Canal_DB[Canal_DB] @ [172.30.3.98] 87 655433897 Query SELECT post_id, meta_key, meta_value FROM wp_postmeta WHERE post_id IN (12835) ORDER BY meta_id ASC
2016-07-19 17:55:20 Canal_DB[Canal_DB] @ [172.30.3.98] 85 655433897 Query SELECT t.*, tt.* FROM wp_terms AS t INNER JOIN wp_term_taxonomy AS tt ON t.term_id = tt.term_id WHERE t.slug = ‘desktop-menu’ AND tt.taxonomy = ‘nav_menu’ LIMIT 1
2016-07-19 17:55:20 Canal_DB[Canal_DB] @ [172.30.3.98] 87 655433897 Query SELECT * FROM wp_posts WHERE ID = 6422 LIMIT 1
2016-07-19 17:55:20 Canal_DB[Canal_DB] @ [172.30.3.98] 85 655433897 Query SELECT tr.object_id FROM wp_term_relationships AS tr INNER JOIN wp_term_taxonomy AS tt ON tr.term_taxonomy_id = tt.term_taxonomy_id WHERE tt.taxonomy IN (‘nav_menu’) AND tt.term_id IN (’10’) ORDER BY tr.object_id ASC
2016-07-19 17:55:20 Canal_DB[Canal_DB] @ [172.30.3.98] 87 655433897 Query SELECT post_id, meta_key, meta_value FROM wp_postmeta WHERE post_id IN (6422) ORDER BY meta_id ASC
2016-07-19 17:55:20 Canal_DB[Canal_DB] @ [172.30.3.98] 85 655433897 Query SELECT wp_posts.* FROM wp_posts WHERE 1=1 AND wp_posts.ID IN (360,361,362,363,364,4276) AND wp_posts.post_type = ‘nav_menu_item’ AND ((wp_posts.post_status = ‘publish’)) ORDER BY wp_posts.menu_order ASC
2016-07-19 17:55:20 Canal_DB[Canal_DB] @ [172.30.3.98] 87 655433897 Query SELECT SQL_CALC_FOUND_ROWS DISTINCT wp_posts.*, MIN(wp_postmeta.meta_value) as EventStartDate, MIN(tribe_event_end_date.meta_value) as EventEndDate FROM wp_posts INNER JOIN wp_postmeta ON ( wp_posts.ID = wp_postmeta.post_id ) LEFT JOIN wp_postmeta as tribe_event_end_date ON ( wp_posts.ID = tribe_event_end_date.post_id AND tribe_event_end_date.meta_key = ‘_EventEndDate’ ) WHERE 1=1 AND (
wp_postmeta.meta_key = ‘_EventStartDate’
) AND wp_posts.post_type = ‘tribe_events’ AND (wp_posts.post_status = ‘publish’ OR wp_posts.post_status = ‘acf-disabled’) AND ((wp_postmeta.meta_value >= ‘2016-07-19 00:00:00’ AND wp_postmeta.meta_value <= ‘2016-07-20 00:00:00’) OR (tribe_event_end_date.meta_value >= ‘2016-07-19 00:00:00’ AND wp_postmeta.meta_value <= ‘2016-07-20 00:00:00’ ) OR (wp_postmeta.meta_value < ‘2016-07-19 00:00:00’ AND tribe_event_end_date.meta_value >= ‘2016-07-20 00:00:00’ )) GROUP BY wp_posts.ID ORDER BY EventStartDate ASC, wp_posts.post_date ASC LIMIT 0, 4
2016-07-19 17:55:20 Canal_DB[Canal_DB] @ [172.30.3.98] 85 655433897 Query SELECT post_id, meta_key, meta_value FROM wp_postmeta WHERE post_id IN (364,363,362,361,4276,360) ORDER BY meta_id ASC
2016-07-19 17:55:20 Canal_DB[Canal_DB] @ [172.30.3.98] 85 655433897 Query SELECT wp_posts.* FROM wp_posts WHERE 1=1 AND wp_posts.ID IN (6,299,303,297,305) AND wp_posts.post_type = ‘page’ AND ((wp_posts.post_status = ‘publish’)) ORDER BY wp_posts.post_date DESC
2016-07-19 17:55:20 Canal_DB[Canal_DB] @ [172.30.3.98] 85 655433897 Query SELECT post_id, meta_key, meta_value FROM wp_postmeta WHERE post_id IN (305,303,299,297,6) ORDER BY meta_id ASC
2016-07-19 17:55:20 Canal_DB[Canal_DB] @ [172.30.3.98] 85 655433897 Query SELECT t.term_id FROM wp_terms AS t INNER JOIN wp_term_taxonomy AS tt ON tt.term_id = t.term_id INNER JOIN wp_term_relationships AS tr ON tr.term_taxonomy_id = tt.term_taxonomy_id WHERE tt.taxonomy IN (‘tribe_events_cat’) AND tr.object_id IN (12867) ORDER BY t.name ASC
2016-07-19 17:55:20 Canal_DB[Canal_DB] @ [172.30.3.98] 85 655433897 Query SELECT t.*, tt.* FROM wp_terms AS t INNER JOIN wp_term_taxonomy AS tt ON t.term_id = tt.term_id WHERE t.slug = ‘mobile-menu’ AND tt.taxonomy = ‘nav_menu’ LIMIT 1
2016-07-19 17:55:20 Canal_DB[Canal_DB] @ [172.30.3.98] 85 655433897 Query SELECT tr.object_id FROM wp_term_relationships AS tr INNER JOIN wp_term_taxonomy AS tt ON tr.term_taxonomy_id = tt.term_taxonomy_id WHERE tt.taxonomy IN (‘nav_menu’) AND tt.term_id IN (’11’) ORDER BY tr.object_id ASC
2016-07-19 17:55:20 Canal_DB[Canal_DB] @ [172.30.3.98] 85 655433897 Query SELECT wp_posts.* FROM wp_posts WHERE 1=1 AND wp_posts.ID IN (367,369,370,371,372,373,374,378,2708,2710,9464,9465,9466,9467,9468,9469,9554,9555) AND wp_posts.post_type = ‘nav_menu_item’ AND ((wp_posts.post_status = ‘publish’)) ORDER BY wp_posts.menu_order ASC
2016-07-19 17:55:20 Canal_DB[Canal_DB] @ [172.30.3.98] 85 655433897 Query SELECT post_id, meta_key, meta_value FROM wp_postmeta WHERE post_id IN (378,367,369,9464,370,372,9465,9466,9467,371,9468,9469,374,2708,2710,9554,9555,373) ORDER BY meta_id ASC
2016-07-19 17:55:20 Canal_DB[Canal_DB] @ [172.30.3.98] 85 655433897 Query SELECT wp_posts.* FROM wp_posts WHERE 1=1 AND wp_posts.ID IN (6,293,2899,295,301,7339,297,4254,299,4267,3964,303,2653,2659,4523,4331,305) AND wp_posts.post_type = ‘page’ AND ((wp_posts.post_status = ‘publish’)) ORDER BY wp_posts.post_date DESC
2016-07-19 17:55:20 Canal_DB[Canal_DB] @ [172.30.3.98] 85 655433897 Query SELECT post_id, meta_key, meta_value FROM wp_postmeta WHERE post_id IN (7339,4523,4331,4267,4254,3964,2899,2653,2659,301,295,293) ORDER BY meta_id ASC
2016-07-19 17:55:20 Canal_DB[Canal_DB] @ [172.30.3.98] 85 655433897 Query SELECT t.term_id FROM wp_terms AS t INNER JOIN wp_term_taxonomy AS tt ON tt.term_id = t.term_id INNER JOIN wp_term_relationships AS tr ON tr.term_taxonomy_id = tt.term_taxonomy_id WHERE tt.taxonomy IN (‘tribe_events_cat’) AND tr.object_id IN (12867) ORDER BY t.name ASC
2016-07-19 17:55:20 Canal_DB[Canal_DB] @ [172.30.3.98] 85 655433897 Query SELECT * FROM wp_users WHERE ID = ‘5’
2016-07-19 17:55:20 Canal_DB[Canal_DB] @ [172.30.3.98] 85 655433897 Query SELECT user_id, meta_key, meta_value FROM wp_usermeta WHERE user_id IN (5) ORDER BY umeta_id ASC
2016-07-19 17:55:20 Canal_DB[Canal_DB] @ [172.30.3.98] 85 655433897 Query SELECT wp_posts.* FROM wp_posts WHERE 1=1 AND wp_posts.ID IN (1570) AND wp_posts.post_type = ‘sponsors’ AND ((wp_posts.post_status <> ‘trash’ AND wp_posts.post_status <> ‘auto-draft’)) ORDER BY FIELD( wp_posts.ID, 1570 )
2016-07-19 17:55:20 Canal_DB[Canal_DB] @ [172.30.3.98] 85 655433897 Query SELECT post_id, meta_key, meta_value FROM wp_postmeta WHERE post_id IN (1570) ORDER BY meta_id ASC
2016-07-19 17:55:20 Canal_DB[Canal_DB] @ [172.30.3.98] 85 655433897 Query SELECT * FROM wp_posts WHERE ID = 3601 LIMIT 1
2016-07-19 17:55:20 Canal_DB[Canal_DB] @ [172.30.3.98] 85 655433897 Query SELECT post_id, meta_key, meta_value FROM wp_postmeta WHERE post_id IN (3601) ORDER BY meta_id ASC
2016-07-19 17:55:20 Canal_DB[Canal_DB] @ [172.30.3.98] 85 655433897 Query SELECT t.*, tt.* FROM wp_terms AS t INNER JOIN wp_term_taxonomy AS tt ON t.term_id = tt.term_id WHERE t.slug = ‘footer-menu’ AND tt.taxonomy = ‘nav_menu’ LIMIT 1
2016-07-19 17:55:20 Canal_DB[Canal_DB] @ [172.30.3.98] 85 655433897 Query SELECT tr.object_id FROM wp_term_relationships AS tr INNER JOIN wp_term_taxonomy AS tt ON tr.term_taxonomy_id = tt.term_taxonomy_id WHERE tt.taxonomy IN (‘nav_menu’) AND tt.term_id IN (’12’) ORDER BY tr.object_id ASC
2016-07-19 17:55:20 Canal_DB[Canal_DB] @ [172.30.3.98] 85 655433897 Query SELECT wp_posts.* FROM wp_posts WHERE 1=1 AND wp_posts.ID IN (4008,4009,4010,4011) AND wp_posts.post_type = ‘nav_menu_item’ AND ((wp_posts.post_status = ‘publish’)) ORDER BY wp_posts.menu_order ASC
2016-07-19 17:55:20 Canal_DB[Canal_DB] @ [172.30.3.98] 85 655433897 Query SELECT post_id, meta_key, meta_value FROM wp_postmeta WHERE post_id IN (4008,4009,4010,4011) ORDER BY meta_id ASC
2016-07-19 17:55:20 Canal_DB[Canal_DB] @ [172.30.3.98] 85 655433897 Query SELECT wp_posts.* FROM wp_posts WHERE 1=1 AND wp_posts.ID IN (305) AND wp_posts.post_type = ‘page’ AND ((wp_posts.post_status = ‘publish’)) ORDER BY wp_posts.post_date DESC
2016-07-19 17:55:20 Canal_DB[Canal_DB] @ [172.30.3.98] 85 655433897 Query SELECT t.term_id FROM wp_terms AS t INNER JOIN wp_term_taxonomy AS tt ON tt.term_id = t.term_id INNER JOIN wp_term_relationships AS tr ON tr.term_taxonomy_id = tt.term_taxonomy_id WHERE tt.taxonomy IN (‘tribe_events_cat’) AND tr.object_id IN (12867) ORDER BY t.name ASC
2016-07-19 17:55:20 Canal_DB[Canal_DB] @ [172.30.3.98] 85 655433897 Query SELECT option_value FROM wp_options WHERE option_name = ‘tribe_events_pro_customizer’ LIMIT 1

[Karen Newman]

Thanks Nico! This solved my issue.

[Karen Newman]

Hi Nico,

I’m using this to be able to apply a class to the container so I can set an opacity on the previous and next days. I could just get the current month and year, then get the days month and year and figure it out that way, but I would like to know if it will be implemented again before I start reprogramming. The main reason is, it will cost my client for me to start reprogramming that part.

Thanks,
Jared

[Karen Newman]

Yup. I am going to continue to monitor it.

[Karen Newman]

This just keeps getting crazier! I applied my fix for the timezone, pushed the site live, and it was fine. Then more events were posted and they were messed up! I removed my fix and it was fine. Maybe I’m just going insane!! Sorry for all of this. I guess I don’t have a problem anymore!

[Karen Newman]

Sorry for the frantic posting on Friday. I was just trying to make sure that I had everything ready for my launch today. The issue with the single recurring event being redirected to the parent event seems to have fixed itself. I’m still concerned about the timezone issue.

Based on what you asked Barry, no the cut off was not set at 4am. It is set at 12 am. Like I said before, I would think the plugin would use the timezone setting from WordPress, but it doesn’t seem like it does. I had to edit the code to include the timezone to get it to work correctly, which I didn’t want to do, since I don’t like editing plugins, but had to this time. I would like to get it back to the code you provide, and be able to set the timezone else where.

Let me know if you need anymore info. Thanks!

[Karen Newman]

Sorry for all the posts! The redirect issue has seemed to resolve itself. I’ll be good for my Monday launch, but it would be nice to figure out the first issue with the recurring events. The cutoff time is set to 12am. When I set the timezone in the script mentioned above it will get the correct times. I’m not sure what is going on.

[Karen Newman]

Right, I understand that, and that is not the issue. I did some digging and found out that it was timezone related. In the tribeeventspro-recurrenceintance.php file, you guys are using the datetime php class. There, it was using the timezone type of 1 when I printed out the $this var. I realized that it was set that way in wordpress, changed it and it still didn’t work. Since I have to launch on Monday, I had to change the code to set the timezone in that files to be America/New_York so the times will save correctly. I would still like to figure this out with you guys thought. I would assume that your plugin is using the WordPress timezone setting, but it doesn’t seem to be working for me.

I know you guys don’t like to jump around with issues in a thread, but I now need to figure out the second issue with the redirects happening with the recurring events.

[Karen Newman]

ok, thanks!

[Author]

Posts