[Tony Bell]

Thank you Patricia,

I have done as you suggested and TEC date selection now works as expected. Thank you for your help it is much appreciated.

Tony

[Tony Bell]

Thank you Patricia,

I have updated all the plugins (there were 5 outstanding including TEC and TEC Community Events) switched to 2017 Theme and ran the conflict checker. This came back:

dependency.min.js?ver=4.7.10:1 Uncaught TypeError: a.dependencyVerified.className is not a function
at HTMLSelectElement.i (dependency.min.js?ver=4.7.10:1)
at HTMLDocument.dispatch (load-scripts.php?c=0…3f06f4e9393c6f7cb:3)
at HTMLDocument.r.handle (load-scripts.php?c=0…3f06f4e9393c6f7cb:3)
at Object.trigger (load-scripts.php?c=0…3f06f4e9393c6f7cb:3)
at Object.a.event.trigger (load-scripts.php?c=0…3f06f4e9393c6f7cb:9)
at HTMLSelectElement.<anonymous> (load-scripts.php?c=0…3f06f4e9393c6f7cb:3)
at Function.each (load-scripts.php?c=0…3f06f4e9393c6f7cb:2)
at a.fn.init.each (load-scripts.php?c=0…3f06f4e9393c6f7cb:2)
at a.fn.init.trigger (load-scripts.php?c=0…3f06f4e9393c6f7cb:3)
at HTMLSpanElement.<anonymous> (dependency.min.js?ver=4.7.10:1)

Alas understanding this is beyond my experience – can you see anything that I should be looking at?

Thanks in advance.

Tony

[Tony Bell]

Thank you Nico – sorry for he late reply. As you might gather I was a little concerned about loading this but so far so good. The update went live this morning and so far we have not experienced any ill effect!! 🙂

We will monitor the site as always and let you know once we are comfortable that all is well.

Thank you for your help

Tony

[Tony Bell]

An update on where we are. Since downgrading to 4.4.18 (not 81 as I mis-typed previously), we have not experienced any performance issues or site crashes. On checking the debug log I also notice that the PHP ‘too many database connections’ errors have also stopped happening.

I notice that 4.4.20 is now available but, as you might suspect, I am reluctant to apply the upgrade. Can you confirm that 4.4.20 has addressed the performance issues you referred to: “Events Calendar PRO 4.4.19 included some changes in the code that we later found that still need some improvements in terms of performance.”

Thank you in advance for your help.

Tony

[Tony Bell]

I have downgrade to TEC Pro 4.4.81

I am also running TEC 46.6
Community Events 4.5.8
TEC Filter Bar 4.5.1

Can you confirm that these four versions are compatible please, thanks in advance.
I will lave the site running and let you know if we have any further crashes.

Thank you for your help.

Tony

[Tony Bell]

Thank you Victor, will attempt to attach a zip file it is an extract of the whole 18Mb file showing only today’s events, if you need more please ask. I will also downgrade the PRO version and let you know the result.

Tony

[Tony Bell]

Our site crashed out about 7:20am this morning. I had our host reboot the server and carried on adding events, once again it crashed out at about 9:20am.

I have deactivated TEC Pro and Community Events – whilst not having any detailed proof that these are the cause, from experience by de-activating the site remains stable. It may of course be that TEC is merely exacerbating another issue and is merely a symptom and not the problem!

I attache the DEBUG.log file from the period during which we experienced the server crashes. Your comments would be appreciated in our attempt to resolve these issues.

Thanks in advance

[Tony Bell]

Hi there,

Sorry for the delay in following up on this. I have taken some time to investigate the DEBUG.log file and removed some plugins that were causing minor issues. We also had a database table in need of repair, this has been done. I have re-enabled TEC Pro and Community Events as of 8pm last night and left the site running with debug set on.

The debug file is attached – system wouldn’t allow me to upload .log or .txt files so you should be able to read the attached .jpg (!) file if you rename it to .log (If that doesn’t work let me know and we’ll find another way of doing it!)

To my untrained eye there seems to be an Events Calendar related recurring error “WordPress database error Unknown column….” but I will let you confirm if this may be relevant.

That our site has remained up since re enabling TEC Pro is encouraging, but the real test will come later this morning when users start to access it. Any help in interpreting the log file would be much appreciated.

Thanks in advance.

Tony

[Tony Bell]

Thank you for your response Victor.

We have 2,670 venues and 2,845 organisers. We use organisers as performers/bands hence the high number and our venues were imported from a legacy system – approximately 1,000 would be current active venues.

Whilst I fully understand your need to see the debug logs in order to help evaluate the issue. From a practical point of view my doing so AND activating the deactivated plugins will crash my site. I will have to attempt to do this when it will have the least impact on our users. Because our site is a key part of our printed magazine’s production cycle (and this is our December deadline week) I will have to choose my moments carefully. This may take time.

Although I do now have a test site, it sits on the same server as the original so crashing that is an equally bad idea!

If OK with you, I will leave this thread open and keep you updated once I can get you some usable data which may help resolve this issue.

Thank you
Tony

[Tony Bell]

Thank you for your help Victor, much appreciated.

Tony

[Tony Bell]

UPDATE – over the weekend I re-enabled the basic (free) version of TEC and The Filter Bar and now seem to have a working website. Our site is used to gather event data for our monthly printed magazine and relies on users using the pro aspects and Community Events functionality.

I have created a workaround to enable user to add data to a table from which our admins can add the data to TEC because this week is our print deadline for December. Obviously this cannot continue. Below is shown the state of TEC plugins when we were experiencing problems and the current setup:

Plugins active when experiencing performance issues and site crashing:
ACTIVE – The Events Calendar
ACTIVE – The Events Calendar PRO
ACTIVE – The Events Calendar: Community Events
ACTIVE – The Events Calendar: Facebook Events
ACTIVE – The Events Calendar: Filter Bar
ACTIVE – The Events Calendar: List Venues/Organizers Shortcodes
NOT ACTIVE – The Events Calendar Category Colors
NOT ACTIVE – The Events Calendar: Month View GigPress Integration

Current situation, site not crashing:
ACTIVE – The Events Calendar
ACTIVE – The Events Calendar: Filter Bar
NOT ACTIVE – The Events Calendar PRO
NOT ACTIVE – The Events Calendar: Community Events
NOT ACTIVE – The Events Calendar: Facebook Events
NOT ACTIVE – The Events Calendar: List Venues/Organizers Shortcodes
NOT ACTIVE – The Events Calendar Category Colors
NOT ACTIVE – The Events Calendar: Month View GigPress Integration

[Tony Bell]

Thanks for the prompt response Courtney. I have done as you suggested and taken one venue which I changed to scheduled, daily at 3:30pm. By 3:42 nothing had happened – not even a failure – no record of anything. I attempted to force the import by clicking on ‘import’. This resulted in a failure as we had experienced this morning.

I then created a NEW import (same FB URL) and four new events were imported for that venue.

So I have a somewhat messy workaround for the time being. Best of luck finding a solution.

Tony

[Tony Bell]

Hi Cliff – I am beginning to think that it is my logic that is at fault here! On the basis that our SQL script wasn’t picking up some events and that these events seemed to be those having a venue the same as the organiser I assumed that this was the issue.

To answer your question the organiser of this event: https://www.facebook.com/events/1118053984982064/ is The Wild Man. A lot of our venues organiser their own events – equally we get organisations who run events at venues. If I look at Ipswich Jazz Festival FB imports the organiser is Ipswich Jazz Festival, the venues are as they should be – so the answer to question 1 is yes, that imports correctly.

Question 2 – I cannot test this one because all of my events have either one or the other.
Question 3 – As with The Wild Man the venue is the organiser so this is in fact correct.

I seem to have set a hare running that need not have been raised for which I apologies. It was my internal flawed logic rather than your software!

[Tony Bell]

Update – my SQL man has solved that problem for me. The price field is non existent in the FB import so by making it an optional field we are now seeing all of the data in the extract.

Thank you.

[Tony Bell]

Thank you for looking at this Cliff. In your result you show the VENUE as ‘Incorrect’ – that in fact is correct, the venue is The Wild Man Pub.

The SQL script we run is as follows:

— Set the start of the month here in reverse format ie. 2015-12-01
SET @start_date = cast(‘2017-04-01’ AS datetime);

— Main SQL statement
SELECT
post_event.post_title AS event_name,
post_event.post_content AS event_description,
post_venue.post_title AS venue_name,
meta_town.meta_value AS venue_town,
meta_county.meta_value AS venue_county,
meta_start.meta_value AS event_start,
meta_price.meta_value AS event_price
FROM
wp_posts AS post_event,
wp_posts AS post_venue,
wp_postmeta AS event_venue_join,
wp_postmeta AS meta_town,
wp_postmeta AS meta_county,
wp_postmeta AS meta_start,
wp_postmeta AS meta_price
WHERE post_event.post_type = ‘tribe_events’
AND post_venue.post_type = ‘tribe_venue’
— Join events to venues
AND event_venue_join.post_id = post_event.id
AND event_venue_join.meta_key = ‘_EventVenueID’
AND event_venue_join.meta_value = post_venue.id
— Venue Town
AND meta_town.post_id = post_venue.id
AND meta_town.meta_key = ‘_VenueCity’
— Venue County
AND meta_county.post_id = post_venue.id
AND meta_county.meta_key = ‘_VenueStateProvince’
— Event Start Date
AND meta_start.post_id = post_event.id
AND meta_start.meta_key = ‘_EventStartDate’
— Event Price
AND meta_price.post_id = post_event.id
AND meta_price.meta_key = ‘_EventCost’
— Date filter
AND cast(meta_start.meta_value AS datetime) >= @start_date
AND cast(meta_start.meta_value AS datetime) < DATE_ADD(@start_date, INTERVAL 1 MONTH)
ORDER BY meta_start.meta_value

[Author]

Posts