Modmacro

Dude! I think you got it. With each successive sync there are (so far) no duplicates being created – data looks clean. Nice job!

One thing to note for anyone else who runs into this issue. After updating to plugin version 1.0.5, it DOES NOT clean up the previous duplicates in the database. So I removed all events, then did a sync. Seems to be good after that.

I’ll keep an eye on it for a week or so to ensure no issues, but all signs are positive.

Thanks for killer plugin support, Jared! I usually just write my own plugins as support tends to be poor, or none. But you’re doing a great job!

thanks,
Matt-

Hi Jared,

Thanks so much for the quick reply. Here’s the status on the tests you suggested …

Looking directly at the XML from the API, using the method you outlined above, there are NOT any duplicates coming through. I then confirmed that there are still duplicates (for the same date range) in the database after doing a sync with the plugin.

Next, yes, I understand that recurring events (of which we have many) come through with the same title, but in SOME cases, we are also seeing them with the same title and date in the database (a duplicate).

Next, yes, I had previously confirmed that these duplicates are all marked with a post_status of “publish”.

Lastly, I went through and killed all events in the database, confirmed they were all gone and did a sync. NO DUPLICATES.

Then I waited a little bit and did another sync, DUPLICATES ARE BACK. So back to square one. At this point there were 278 events in the DB with “publish” status.

Did another sync, now 291 events in the DB with “publish” status. More duplicates obviously.

Did another sync, now 305 events in the DB with “publish” status.
Did another sync, now 315 events in the DB with “publish” status.

… you get the idea. We are accumulating a larger and large number of dups with each sync. Interestingly, there are zero events with a status other than publish. Should there be some with a different status, like revision?

Man, any help you can offer is greatly appreciated. We’ve hit a wall.

thanks!
Matt-

Good question, and this is happening on multiple sites, all running the latest Wordfence and the latest WP.