|
ndaniel
|
February 21, 2013 at 9:59 am
Hello,
I had posted this before but had not had time to research further.
When I activate MER, the event calendar does not display on the page. The event_list shows up fine.
I have both the calendar and the list used on the same page.
Josh had suggested this may be a memory issue on the server, but I have traced the utilization and there is no indication of this.
I suspect there is a conflict in the code causing this, but am not sure how to trace it down. Please advise as the MER feature would be nice to use, but the calendar is required.
|
|
ndaniel
|
February 21, 2013 at 10:00 am
Further info: I am running the latest versions of EE.
|
|
Dean
|
February 22, 2013 at 12:16 am
Hi,
Is there a page where we can see the issue please?
|
|
ndaniel
|
February 22, 2013 at 10:16 am
Hi Dean,
Unfortunately not unless it is after midnight MST.
Our website is almost entirely calendar driven with multiple pages using category calendars. Enabling this feature effectively renders our site unusable.
This is the only feature that I am having a problem with at this time.
I do have a ticket open to our hosting service asking for any additional insight into resource allocation, but even if this is a memory issue, I have to think the feature can be improved to handle the load collection that would be at the heart of the problem…
Glad to work with you after hours if needed.
Here is a URL to an active page:
https://denverartcenter.com/art-parties/canvas-corkscrews/
The event_list display renders rapidly under either condition, it is only the calendar that has a conflict.
Cheers,
Bill
|
|
Josh
|
February 22, 2013 at 2:09 pm
Hi Bill,
I did some checking on my site and set up a page with a calendar and the event list. With Multi Event Registration off, there were 185 db queries. With Multi Event Registration on 197 queries. Either way the calendar displays, but there are more db queries when Mer is active. (It does check to see if an event can be registered for before it displays an add to cart link)
With the page you linked to, it’s showing 536 db queries, which might be close to the limit.
Can you try setting up a page where you have a calendar and event list that is displaying a category that only has a few events and check how many queries it’s running? (If you view source it’s in the footer) You could even try activating Multi Event Registration and see what affect it has on that page.
|
|
ndaniel
|
February 22, 2013 at 2:33 pm
Thanks Josh.
We’ll continue to work the site without this feature.
Please suggest changes to this as a development enhancement. As EE continues to grow, this will be a feature desired by future customers as well.
Cheers,
Bill
|
|
Josh
|
February 22, 2013 at 3:34 pm
Hi Bill,
I’m not certain that something needs to be changed in Multi Event Registration when it comes to loading up an event list on a calendar page. The calendar displays when Multi Event Registration is active on all my test sites.
We are working on adding a feature that will limit the number of queries that the calendar page uses. You could try this out on your site by changing the SQL on line 259 of the current calendar add-ons espresso-calendar.php to:
$sql .= " GROUP BY e.id ORDER BY e.start_date = '0000-00-00' ASC LIMIT 100 ";
You might need to adjust the limit up or down.
|
