[sagemg]

Continuing from last post…

The duplicated event is “Level 1” and has over 25,000 occurrences. When we search for “Level 1” in the dashboard we see all 25k+ listed. Ideas on the best way to clean quickly from the db?

This event can go away completely.

Some screenshots attached.

Please advise,
Jeremy

[sagemg]

Brook:

We started beginning of the year with Events Calendar Pro v4.0.5 and have updated a few times since then. I don’t see the site ever running 4.2.2 or 4.2.2.1 The latest updates took place after the duplicates issue since we weren’t aware of it. Site is currently running v4.2.5

There is more at the bottom of this post, but here is the Sys Info from the Dashboard:

—

Home URL
http://fortcollinsclub.net
Site URL
http://fortcollinsclub.net
Site Language
English
Character Set
UTF-8
WP Permalinks
/%postname%/
Name
The Club
Email
[email protected]
Install keys

events-calendar-pro = 2ada################################b6aa

WordPress version
4.6.1
PHP version
5.6.25-1+deb.sury.org~precise+1
PHP

max_execution_time = 360
memory_limit = 1024M
upload_max_filesize = 300M
post_max_size = 300M
display_errors =
log_errors = 1

Server
Flywheel
SAPI
fpm-fcgi
Plugins

Gravity Forms version 2.0.6 by rocketgenius(http://www.rocketgenius.com)
LayerSlider WP version 5.6.3 by Kreatura Media(http://kreaturamedia.com/)
Ninja Kick: Sliding Panel version 3.0.0 by Looks Awesome(http://looks-awesome.com/)
Advanced Post Manager version 4.2.2 by Modern Tribe, Inc.(http://m.tri.be/4n)
Envato WordPress Toolkit version 1.7.3 by Envato(http://envato.com)
The Events Calendar PRO version 4.2.5 by Modern Tribe, Inc.(http://m.tri.be/20)
WPBakery Visual Composer (Artbees Modified Version) version 4.12.1 by Michael M – WPBakery.com(http://wpbakery.com)
Shortcoder version 3.4.1 by Aakash Chakravarthy(http://www.aakashweb.com/)
The Events Calendar version 4.2.6 by Modern Tribe, Inc.(http://m.tri.be/1x)
Yoast SEO version 3.4.2 by Team Yoast(https://yoast.com/)
WP Google Map Plugin version 3.1.3 by flippercode(http://www.flippercode.com/)
WP Smush Pro version 2.4.5 by WPMU DEV(http://premium.wpmudev.org/)
WPMU DEV Dashboard version 4.1.2 by WPMU DEV(https://premium.wpmudev.org/)

Network Plugins
–
MU Plugins
–
Theme
Jupiter Child Theme
Multisite
–
Settings

schema-version = 4.2.6
recurring_events_are_hidden = exposed
previous_ecp_versions =

Array
(
[0] => 0
[1] => 4.0.5
[2] => 4.0.6
[3] => 4.0.7
[4] => 4.1.1.1
[5] => 4.1.3
[6] => 4.2.1
[7] => 4.2.3
[8] => 4.2.5
)

latest_ecp_version = 4.2.6
last-update-message = 4.0.5
disable_metabox_custom_fields = hide
pro-schema-version = 4.2.5
tribeEnableViews =

Array
(
[0] => month
[1] => week
[2] => day
)

earliest_date = 2016-02-01 08:00:00
latest_date = 2016-12-31 22:30:00
donate-link =
postsPerPage = 30
liveFiltersUpdate =
hideSubsequentRecurrencesDefault =
userToggleSubsequentRecurrences =
recurrenceMaxMonthsBefore = 1
recurrenceMaxMonthsAfter = 3
showComments =
showEventsInMainLoop =
eventsSlug = calendar
singleEventSlug = calendar
multiDayCutoff = 00:00
defaultCurrencySymbol = $
reverseCurrencyPosition =
embedGoogleMaps =
geoloc_default_geofence = 25
geoloc_default_unit = miles
embedGoogleMapsZoom = 10
debugEvents =
tribe_events_timezone_mode = site
tribe_events_timezones_show_zone = 1
stylesheetOption = tribe
tribeEventsTemplate = default
viewOption = month
tribeDisableTribeBar = 1
hideLocationSearch = 1
hideRelatedEvents = 1
week_view_hide_weekends =
monthEventAmount = 15
enable_month_view_cache = 1
dateWithYearFormat = F j, Y
dateWithoutYearFormat =
monthAndYearFormat = F Y
weekDayFormat = D
dateTimeSeparator = @
timeRangeSeparator = –
datepickerFormat = 1
tribeEventsBeforeHTML =
tribeEventsAfterHTML =
pue_install_key_events_calendar_pro = 2ada################################b6aa
custom-fields =

Array
(
)

custom-fields-max-index = 4
earliest_date_markers =

Array
(
[0] => 1051
[1] => 1236
)

latest_date_markers =

Array
(
[0] => 3958
[1] => 8905
)

WP Timezone
America/Denver
WP GMT Offset
-6
Server Timezone
UTC
WP Date Format
F j, Y
WP Time Format
g:i a
Week Starts On
1
Common Library Dir
/www/wp-content/plugins/the-events-calendar/common/src/Tribe
Common Library Version
4.2.6

—

I ran the SQL again with the correct, custom prefix and attached the first dozen or so results – looks like the first may be a problem? Event ID 37993 = 25997 Recurrences… please see attached.

Thoughts?

Thanks Brook!

Jeremy

[sagemg]

Brook,

I’m not sure when the duplicates started showing – the original recurring events were created months ago. Did the upgrade to the 4.2.2 generate duplicates when it was upgraded (later on then the events were created.) In-other-words, these recurring events were not created in 4.2.2 – they were created in 4.0.5 or a version shortly after that…

I can’t run the SQL commands successfully, I get the error Attached. (Error in querry (1146): Table ‘db3929526080.wp_posts’ doesn’t exist)

We host at Flywheel in NGINX and there is no phpMyAdmin, just Flywheels database tool.

I’m currently deleting events in batches of 50-60 since I get a time out request beyond that – Flywheel has already increased the memory and time out limit on the space.

When I delete these events manually (one-by-one) do they end up in Trash? I ask because I then have to spend a long time deleting again from trash? When I select ‘Edit All’ on several of the recurring events it only edits that one event where as the first series of events I edited all and deleted removed whole series and gave the yellow status bar that took a while, but deleted everything?

I’m running versions 4.2.6 and 4.2.5 of the two plugins (4.2.5 is pro plugin).

If I end up deleting all the duplicates manually, what is the best way to guarantee recurring events don’t get duplicated – what are the best practices? I currently have 35,000 events (down from original 60k when I started dup clean-up).

Regards,
Jeremy

[sagemg]

That did it. Thanks for your help and speedy response, Brian.

Any update as to when individual PDF attachments can be provided with the ticket email sent to customers? Know this has been in the works and we voted YES for this feature already.

[Author]

Posts