Entire site crashes when new event created

[echristoperj]

When I try to add an event, and click Publish, the entire site crashes. I enter the title, description, date, tags and categories. Once I click Publish, the site gets reset. Any attempts to access the site http://www.pairadicetravel.com redirects to http://www.pairadicetravel.com/wp-admin/install.php

I was able to repeat this five times over the past four days, doing the same steps. Also once the site crashes, the database for the site is not accessible via myphpadmin. To restore the site I have to reinstall wordpress and run the install.php. Then copy over the wordpress files.

I have re-installed wordpress five times, removed all other plugins, re-installed the EC Pro, and a few other things. Below is my server info if that helps. Thanks.

Platform Type: Debian
MySQL Version: 5.5.32
Perl Version: 5.8.8
PHP Version: 5.3.13

[Barry]

Hi echristoperj,

That’s very odd and I’m worried there’s a deeper problem than something at WordPress/plugin level. That said, let’s stop and take a look at things.

It sounds like you’ve tried most of our basic troubleshooting steps, but I’d like to be certain – have you tried deactivating all other plugins and at the same time did you switch to a default, unmodified theme such as Twenty Twelve? If so did this impact on the problem?

Above and beyond that can you visit the Events → Help admin screen and copy the contents of the System Information box and post it here?

Thanks!

[echristoperj]

Sorry for the late repsonse. Yes, I’ve tried the default theme and still the same issue. Below is the Sys info. Thanks.

http://www.mycasinotravel.com
INSTALL KEYS
events-calendar-pro = b40ca918c14db8f97ddf98148a6bec3710e26ac5
WORDPRESS VERSION
3.7.1
PHP VERSION
5.3.13
PLUGINS
BulletProof Security version .49.6 by AITpro | Edward Alexander(http://forum.ait-pro.com/read-me-first/)
Easy WP SMTP version 1.0.6 by wpecommerce(http://wp-ecommerce.net/)
The Events Calendar PRO version 3.2 by Modern Tribe, Inc.(http://m.tri.be/20)
Fix Rss Feeds version 3.1 by flyaga li(http://www.gofunnow.com/)
Google Analytics version 1.0.5 by Kevin Sylvestre(http://ksylvest.com/)
Gravity Forms Data Persistence Add-On version 3.0 by Astha Team(http://asthait.com)
Gravity Forms version 1.7.12 by rocketgenius(http://www.rocketgenius.com)
Gravity Forms User Registration Add-On version 1.7 by rocketgenius(http://www.rocketgenius.com)
Intuitive Custom Post Order version 2.0.6 by hijiri(http://hijiriworld.com/web/)
Page Links To version 2.9.3 by Mark Jaquith(http://coveredwebservices.com/)
The Events Calendar version 3.2 by Modern Tribe, Inc.(http://m.tri.be/1x)
NETWORK PLUGINS
–
MU PLUGINS
–
THEME
Smoke & Mirrors
MULTISITE
–
SETTINGS
disable_metabox_custom_fields = show
welcome_notice = 1
previous_ecp_versions =
Array
(
[0] => 0
[1] => 2.0.11
[2] => 3.0.3
[3] => 3.1
)
latest_ecp_version = 3.2
displayedPressTrendsDialogue = 1
donate-link = 1
viewOption = month
eventsSlug = events
singleEventSlug = event
postsPerPage = 20
showComments =
multiDayCutoff = 12:00
embedGoogleMaps = 1
embedGoogleMapsHeight = 350
embedGoogleMapsWidth = 100%
embedGoogleMapsZoom = 15
sendPressTrendsData = 1
debugEvents =
tribeEventsTemplate = template_fullwidth.php
tribeEventsBeforeHTML =
tribeEventsAfterHTML =
defaultValueReplace = 1
eventsDefaultOrganizerID =
eventsDefaultVenueID = 0
eventsDefaultAddress =
eventsDefaultCity =
eventsDefaultState =
eventsDefaultProvince =
eventsDefaultZip =
defaultCountry =
eventsDefaultPhone =
tribeEventsCountries =
recurring_events_are_hidden = exposed
organizer_venue_amalgamation = 1
liveFiltersUpdate = 1
hideSubsequentRecurrencesDefault =
userToggleSubsequentRecurrences =
showEventsInMainLoop =
defaultCurrencySymbol = $
geoloc_default_geofence = 25
geoloc_default_unit = miles
stylesheetOption = full
tribeEnableViews =
Array
(
[0] => upcoming
[1] => month
[2] => week
[3] => day
[4] => map
[5] => photo
)
tribeDisableTribeBar =
hideLocationSearch =
monthEventAmount = 3
hideRelatedEvents =

[Barry]

OK. I think for this one it sounds like there may be particular issues within the context of your hosting environment and there may not be much we can do to help, regrettably.

Can you provide any information about the sort of hosting you are using?

[echristoperj]

I’m using Fatcow on a shared hosting plan. After speaking to Fatcow Tech Support, they informed me that the plug-in is causing a high datbase usage. Which is causing the site to exceed the “max-questions” limit per hour limit. Which is currently 50,000. My site alone isn’t that busy to cause that much usage, I wish it was. Is there a reason why the plug-in would cause that much usage?

[Barry]

We’re certainly looking to improve the performance and efficiency of our plugin, particularly with regards to database queries. That’s being progressed incrementally over time, though, we don’t unfortunately have a quick fix we can drop in. Also, the reality is that some hosting environments simply don’t have enough “power” to handle certain stacks of plugins and certain quantities of data.

The fact that the primary problem – the site crashing – happens when you publish an event stands out as highly unusual and I don’t recall any other reports of this. Additionally, this stands out as some pretty extreme and unusual behaviour:

Also once the site crashes, the database for the site is not accessible via myphpadmin. To restore the site I have to reinstall wordpress and run the install.php. Then copy over the wordpress files.

Is the entire database actually wiped out on each occasion? If so, max_questions limit or not, I think there are more serious issues here than our queries and at a level we can’t address. Is migrating to a different hosting plan an option at all?

[echristoperj]

I’m able to recover after a crash much quicker now. It doesn’t take all those steps mentioned previously. Now I just change the user name in the wordpress config.php file and the site is back up. Which reenforces the max_question limit per user issue. So I just change the username when it crashes and carry on. Not a good fix at all. I have 4 other sites with the same plugins, but they lack EC and have issues. It’s just this site with EC that has the high database usage.

After a search, this thread https://theeventscalendar.com/support/forums/topic/pro-3-1-crashes-my-site/#post-76364 issue is very similar to mine.

[echristoperj]

Oh I forgot. No, the database is not erased after a crash. It’s kept intact.

[Barry]

This is definitely a frustrating issue.

Right at this time, however, I don’t think there is anything else we can do to help you. The majority of our users experience no such thing and even the thread you linked to – which certainly relates to query performance – misses this distinct feature of requiring a new database user to be specified in order to work around hosting limitations after each event is published.

Though we do have plans to make improvements, as outlined in my last response, if there was a general problem here I think we would see a far greater number of reports: not to say it isn’t an important issue (particularly so for you) but just that it only seems to crop up in a limited number of cases.

If a move to a different hosting plan with your current or some other provider is a possibility then I’d encourage you to investigate that course of action.

[Author]

Posts