[dtcaldwell]

Thanks, George. That works perfectly.

[dtcaldwell]

Thank you. I’m looking forward to the release.

[dtcaldwell]

This reply is private.

[dtcaldwell]

Tim,
Thanks for looking at this. One more detail, though I doubt it’s relevant: I’m running a network install (a subdirectory install) of WordPress. I can reproduce this behavior in the root blog and, as in this dump, in another blog.

There are two dumps, one of the post meta before editing and updating the event, and one after. (If there’s a better way to send these dumps, let me know.)

Event start and end date is Aug 11, recurring 8a-5p daily through Aug 15. Before updating the event:
— phpMyAdmin SQL Dump
— version 3.2.5
— http://www.phpmyadmin.net
—
— Host: localhost
— Generation Time: Jul 25, 2013 at 08:01 AM
— Server version: 5.1.44
— PHP Version: 5.3.2

SET SQL_MODE=”NO_AUTO_VALUE_ON_ZERO”;

—
— Database: `wordpress`
—

— ——————————————————–

—
— Table structure for table `wp_3_postmeta`
—

CREATE TABLE `wp_3_postmeta` (
`meta_id` bigint(20) unsigned NOT NULL AUTO_INCREMENT,
`post_id` bigint(20) unsigned NOT NULL DEFAULT ‘0’,
`meta_key` varchar(255) DEFAULT NULL,
`meta_value` longtext,
PRIMARY KEY (`meta_id`),
KEY `post_id` (`post_id`),
KEY `meta_key` (`meta_key`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8 AUTO_INCREMENT=1709 ;

—
— Dumping data for table `wp_3_postmeta`
—

INSERT INTO `wp_3_postmeta` VALUES(1, 2, ‘_wp_page_template’, ‘default’);
INSERT INTO `wp_3_postmeta` VALUES(2, 4, ‘_edit_last’, ‘1’);
INSERT INTO `wp_3_postmeta` VALUES(3, 4, ‘_edit_lock’, ‘1373374700:1’);
INSERT INTO `wp_3_postmeta` VALUES(4, 4, ‘_wp_page_template’, ‘default’);
INSERT INTO `wp_3_postmeta` VALUES(5, 2, ‘_edit_lock’, ‘1374147954:1’);
INSERT INTO `wp_3_postmeta` VALUES(6, 2, ‘_edit_last’, ‘1’);
INSERT INTO `wp_3_postmeta` VALUES(1235, 1, ‘_edit_lock’, ‘1374242658:1’);
INSERT INTO `wp_3_postmeta` VALUES(1652, 60, ‘_EventAuditTrail’, ‘a:8:{i:0;a:2:{i:0;s:15:”events-calendar”;i:1;i:1374516956;}i:1;a:2:{i:0;s:15:”events-calendar”;i:1;i:1374516976;}i:2;a:2:{i:0;s:15:”events-calendar”;i:1;i:1374517020;}i:3;a:2:{i:0;s:15:”events-calendar”;i:1;i:1374517080;}i:4;a:2:{i:0;s:15:”events-calendar”;i:1;i:1374517122;}i:5;a:2:{i:0;s:15:”events-calendar”;i:1;i:1374517163;}i:6;a:2:{i:0;s:15:”events-calendar”;i:1;i:1374517189;}i:7;a:2:{i:0;s:15:”events-calendar”;i:1;i:1374590917;}}’);
INSERT INTO `wp_3_postmeta` VALUES(1653, 60, ‘_EventOrigin’, ‘events-calendar’);
INSERT INTO `wp_3_postmeta` VALUES(1654, 60, ‘_edit_last’, ‘1’);
INSERT INTO `wp_3_postmeta` VALUES(1655, 60, ‘_edit_lock’, ‘1374590811:1’);
INSERT INTO `wp_3_postmeta` VALUES(1656, 60, ‘_EventShowMapLink’, ‘1’);
INSERT INTO `wp_3_postmeta` VALUES(1657, 60, ‘_EventShowMap’, ‘1’);
INSERT INTO `wp_3_postmeta` VALUES(1706, 60, ‘_EventStartDate’, ‘2013-08-13 08:00:00’);
INSERT INTO `wp_3_postmeta` VALUES(1708, 60, ‘_EventStartDate’, ‘2013-08-15 08:00:00’);
INSERT INTO `wp_3_postmeta` VALUES(1707, 60, ‘_EventStartDate’, ‘2013-08-14 08:00:00’);
INSERT INTO `wp_3_postmeta` VALUES(1661, 60, ‘_EventVenueID’, ‘0’);
INSERT INTO `wp_3_postmeta` VALUES(1662, 60, ‘_EventCurrencySymbol’, ‘$’);
INSERT INTO `wp_3_postmeta` VALUES(1663, 60, ‘_EventCost’, ”);
INSERT INTO `wp_3_postmeta` VALUES(1664, 60, ‘_EventURL’, ”);
INSERT INTO `wp_3_postmeta` VALUES(1665, 60, ‘_EventOrganizerID’, ‘0’);
INSERT INTO `wp_3_postmeta` VALUES(1666, 60, ‘_EventRecurrence’, ‘a:13:{s:4:”type”;s:9:”Every Day”;s:8:”end-type”;s:2:”On”;s:3:”end”;s:10:”2013-08-15″;s:9:”end-count”;s:1:”1″;s:11:”custom-type”;s:5:”Daily”;s:15:”custom-interval”;s:0:””;s:16:”custom-type-text”;s:0:””;s:21:”occurrence-count-text”;s:3:”day”;s:19:”custom-month-number”;s:5:”First”;s:16:”custom-month-day”;s:1:”1″;s:24:”custom-year-month-number”;s:1:”1″;s:21:”custom-year-month-day”;s:1:”1″;s:22:”recurrence-description”;s:0:””;}’);
INSERT INTO `wp_3_postmeta` VALUES(1705, 60, ‘_EventStartDate’, ‘2013-08-12 08:00:00’);
INSERT INTO `wp_3_postmeta` VALUES(1702, 60, ‘_EventStartDate’, ‘2013-08-11 08:00:00’);
INSERT INTO `wp_3_postmeta` VALUES(1703, 60, ‘_EventEndDate’, ‘2013-08-11 17:00:00’);
INSERT INTO `wp_3_postmeta` VALUES(1704, 60, ‘_EventDuration’, ‘32400’);

*******************
After editing and updating (all future) the occurrence on Aug 11 (the initial date). The instance on Aug 13 was not rewritten:
— phpMyAdmin SQL Dump
— version 3.2.5
— http://www.phpmyadmin.net
—
— Host: localhost
— Generation Time: Jul 25, 2013 at 08:01 AM
— Server version: 5.1.44
— PHP Version: 5.3.2

SET SQL_MODE=”NO_AUTO_VALUE_ON_ZERO”;

—
— Database: `wordpress`
—

— ——————————————————–

—
— Table structure for table `wp_3_postmeta`
—

CREATE TABLE `wp_3_postmeta` (
`meta_id` bigint(20) unsigned NOT NULL AUTO_INCREMENT,
`post_id` bigint(20) unsigned NOT NULL DEFAULT ‘0’,
`meta_key` varchar(255) DEFAULT NULL,
`meta_value` longtext,
PRIMARY KEY (`meta_id`),
KEY `post_id` (`post_id`),
KEY `meta_key` (`meta_key`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8 AUTO_INCREMENT=1709 ;

—
— Dumping data for table `wp_3_postmeta`
—

INSERT INTO `wp_3_postmeta` VALUES(1, 2, ‘_wp_page_template’, ‘default’);
INSERT INTO `wp_3_postmeta` VALUES(2, 4, ‘_edit_last’, ‘1’);
INSERT INTO `wp_3_postmeta` VALUES(3, 4, ‘_edit_lock’, ‘1373374700:1’);
INSERT INTO `wp_3_postmeta` VALUES(4, 4, ‘_wp_page_template’, ‘default’);
INSERT INTO `wp_3_postmeta` VALUES(5, 2, ‘_edit_lock’, ‘1374147954:1’);
INSERT INTO `wp_3_postmeta` VALUES(6, 2, ‘_edit_last’, ‘1’);
INSERT INTO `wp_3_postmeta` VALUES(1235, 1, ‘_edit_lock’, ‘1374242658:1’);
INSERT INTO `wp_3_postmeta` VALUES(1652, 60, ‘_EventAuditTrail’, ‘a:8:{i:0;a:2:{i:0;s:15:”events-calendar”;i:1;i:1374516956;}i:1;a:2:{i:0;s:15:”events-calendar”;i:1;i:1374516976;}i:2;a:2:{i:0;s:15:”events-calendar”;i:1;i:1374517020;}i:3;a:2:{i:0;s:15:”events-calendar”;i:1;i:1374517080;}i:4;a:2:{i:0;s:15:”events-calendar”;i:1;i:1374517122;}i:5;a:2:{i:0;s:15:”events-calendar”;i:1;i:1374517163;}i:6;a:2:{i:0;s:15:”events-calendar”;i:1;i:1374517189;}i:7;a:2:{i:0;s:15:”events-calendar”;i:1;i:1374590917;}}’);
INSERT INTO `wp_3_postmeta` VALUES(1653, 60, ‘_EventOrigin’, ‘events-calendar’);
INSERT INTO `wp_3_postmeta` VALUES(1654, 60, ‘_edit_last’, ‘1’);
INSERT INTO `wp_3_postmeta` VALUES(1655, 60, ‘_edit_lock’, ‘1374590811:1’);
INSERT INTO `wp_3_postmeta` VALUES(1656, 60, ‘_EventShowMapLink’, ‘1’);
INSERT INTO `wp_3_postmeta` VALUES(1657, 60, ‘_EventShowMap’, ‘1’);
INSERT INTO `wp_3_postmeta` VALUES(1706, 60, ‘_EventStartDate’, ‘2013-08-13 08:00:00’);
INSERT INTO `wp_3_postmeta` VALUES(1708, 60, ‘_EventStartDate’, ‘2013-08-15 08:00:00’);
INSERT INTO `wp_3_postmeta` VALUES(1707, 60, ‘_EventStartDate’, ‘2013-08-14 08:00:00’);
INSERT INTO `wp_3_postmeta` VALUES(1661, 60, ‘_EventVenueID’, ‘0’);
INSERT INTO `wp_3_postmeta` VALUES(1662, 60, ‘_EventCurrencySymbol’, ‘$’);
INSERT INTO `wp_3_postmeta` VALUES(1663, 60, ‘_EventCost’, ”);
INSERT INTO `wp_3_postmeta` VALUES(1664, 60, ‘_EventURL’, ”);
INSERT INTO `wp_3_postmeta` VALUES(1665, 60, ‘_EventOrganizerID’, ‘0’);
INSERT INTO `wp_3_postmeta` VALUES(1666, 60, ‘_EventRecurrence’, ‘a:13:{s:4:”type”;s:9:”Every Day”;s:8:”end-type”;s:2:”On”;s:3:”end”;s:10:”2013-08-15″;s:9:”end-count”;s:1:”1″;s:11:”custom-type”;s:5:”Daily”;s:15:”custom-interval”;s:0:””;s:16:”custom-type-text”;s:0:””;s:21:”occurrence-count-text”;s:3:”day”;s:19:”custom-month-number”;s:5:”First”;s:16:”custom-month-day”;s:1:”1″;s:24:”custom-year-month-number”;s:1:”1″;s:21:”custom-year-month-day”;s:1:”1″;s:22:”recurrence-description”;s:0:””;}’);
INSERT INTO `wp_3_postmeta` VALUES(1705, 60, ‘_EventStartDate’, ‘2013-08-12 08:00:00’);
INSERT INTO `wp_3_postmeta` VALUES(1702, 60, ‘_EventStartDate’, ‘2013-08-11 08:00:00’);
INSERT INTO `wp_3_postmeta` VALUES(1703, 60, ‘_EventEndDate’, ‘2013-08-11 17:00:00’);
INSERT INTO `wp_3_postmeta` VALUES(1704, 60, ‘_EventDuration’, ‘32400’);

[dtcaldwell]

Always updating all future events. The choosing of an event category is important, as is editing the event by using an Edit Event link–not by using the browser’s Back button.

[Author]

Posts