Hello,<\/p>\n
Something has completely tainted all of my events calendar data not only on my live site, but on my dev site and local copy of that same site running the same plugin versions, my dev and local copies each containing various snapshots of the live data. This is really, really bizarre…<\/p>\n
Basically, it seems like my data on all three sites (specifically, the postmeta data) has completely corrupted itself. On one WPMU site it is showing all events as reoccurring on the Events index page when they aren’t, on each of these the Start Date sorting does not work. I can’t make any sense of what is going on in the backend GUI. On the front end the mini calendar (http:\/\/canadianbrass.com) is showing different dates for this month than the full events page (http:\/\/canadianbrass.com\/events). I’ve also gotten infinite loops, and a ton of duplicate events appearing on the same day, although I managed to do something to make this problem stop. Given that this makes zero sense to me and no doubt to you either, I decided to trace this further by looking at the actual post and postmeta data…<\/p>\n
Are you prepared for more confusion?<\/p>\n
This event was created in April 2012. From my wp_posts table:<\/p>\n
*************************** 1. row ***************************
\n ID: 7979
\n post_author: 1
\n post_date: 2012-04-25 13:18:26
\n post_date_gmt: 2012-04-25 17:18:26
\n post_content: Canadian Brass Masterclass\/Lecture in Regina, SK – TBD
\n post_title: Canadian Brass Masterclass\/Lecture in Regina, SK
\n post_excerpt:
\n post_status: publish
\n comment_status: closed
\n ping_status: closed
\n post_password:
\n post_name: canadian-brass-masterclasslecture-in-regina-sk
\n to_ping:
\n pinged:
\n post_modified: 2012-04-25 13:18:26
\n post_modified_gmt: 2012-04-25 17:18:26
\npost_content_filtered:
\n post_parent: 0
\n guid: http:\/\/www.canadianbrass.com\/?post_type=tribe_events&p=4979
\n menu_order: 0
\n post_type: tribe_events
\n post_mime_type:
\n comment_count: 0<\/p>\n
It is showing up as Jan 11, 2013 on both mini calendar and full calendar listing. The postmeta data:<\/p>\n
mysql> SELECT * FROM `wp_3_postmeta` WHERE meta_key like ‘%EventStart%’ and post_id = ‘7979’\\G
\n*************************** 1. row ***************************
\n meta_id: 1885
\n post_id: 7979
\n meta_key: _EventStartDate
\nmeta_value: 2013-01-11 14:00:00<\/p>\n
So, the postmeta data appears to be what is corrupt here. I have no idea what set the meta_value to this incorrect date. I mentioned that the mini calendar and full calendar listing were showing different results, so:<\/p>\n
mysql> SELECT * FROM `wp_3_postmeta` WHERE meta_key like ‘%EventStart%’ and meta_value like ‘2013-01-%’\\G
\n*************************** 1. row ***************************
\n meta_id: 1870
\n post_id: 7976
\n meta_key: _EventStartDate
\nmeta_value: 2013-01-09 20:00:00
\n*************************** 2. row ***************************
\n meta_id: 1885
\n post_id: 7979
\n meta_key: _EventStartDate
\nmeta_value: 2013-01-11 14:00:00
\n*************************** 3. row ***************************
\n meta_id: 1903
\n post_id: 7980
\n meta_key: _EventStartDate
\nmeta_value: 2013-01-12 20:00:00
\n*************************** 4. row ***************************
\n meta_id: 1912
\n post_id: 7983
\n meta_key: _EventStartDate
\nmeta_value: 2013-01-22 20:00:00
\n*************************** 5. row ***************************
\n meta_id: 1926
\n post_id: 7987
\n meta_key: _EventStartDate
\nmeta_value: 2013-01-13 19:30:00
\n*************************** 6. row ***************************
\n meta_id: 1941
\n post_id: 7990
\n meta_key: _EventStartDate
\nmeta_value: 2013-01-26 20:00:00
\n*************************** 7. row ***************************
\n meta_id: 2099
\n post_id: 7994
\n meta_key: _EventStartDate
\nmeta_value: 2013-01-27 20:00:00
\n*************************** 8. row ***************************
\n meta_id: 3284
\n post_id: 8394
\n meta_key: _EventStartDate
\nmeta_value: 2013-01-25 19:30:00
\n*************************** 9. row ***************************
\n meta_id: 3303
\n post_id: 8396
\n meta_key: _EventStartDate
\nmeta_value: 2013-01-24 00:00:00
\n*************************** 10. row ***************************
\n meta_id: 4063
\n post_id: 8483
\n meta_key: _EventStartDate
\nmeta_value: 2013-01-15 00:00:00
\n10 rows in set (0.00 sec)<\/p>\n
So, while I have no idea what set all of those bogus meta_value dates, what is displaying in the mini calendar is “right”, at least according to the data I have. Yet, the full calendar is only showing two of these events.<\/p>\n
In short, I have absolutely no idea what could have corrupt all of this postmeta data, and why the current mini and full calendar views disagree with each other. I also have no idea why the admin pages are completely messed up on all three of these sites. <\/p>\n
It seems like there are a number of possible causes here (e.g. bad SQL query in the plugin, template glitches) but if this was the case I’m sure this problem would be pretty widespread. Again, this has occurred on 3 versions of this site containing different snapshots of data, and everything seemed fine until earlier this month when everything just sort of exploded.<\/p>\n
Please help!<\/p>\n","protected":false},"template":"","class_list":["post-31089","topic","type-topic","status-closed","hentry"],"yoast_head":"\n