Support

Home Forums Event Espresso Premium UPDATE TO 3.1.30.2 HAS BROKEN MY EVENT LISTINGS

UPDATE TO 3.1.30.2 HAS BROKEN MY EVENT LISTINGS

Posted: February 2, 2013 at 7:02 am


Roger

February 2, 2013 at 7:02 am

I just updated from 3.1.29.1 to 3.1.30.2, and the update has broken my event listing displays.

My two major EE event categories are “event-public” and “event-member”, which I list via EE shortcode in separate columns on one of my web pages. After the update to 3.1.30.2, my EE shortcodes:
[EVENT_LIST category_identifier=”event-public”]

[EVENT_LIST category_identifier=”event-member”]

both return the message “No events available…” rather than a list of events in each category.

I have tried the following variations for the “event-public” category with the following results:

Shortcode: [EVENT_ESPRESSO_CATEGORY event_category_id=”event-public”]

Result: “No events available…”

Shortcode: [EVENT_LIST event_category_id=”event-public”]

Result: Lists ALL events from BOTH categories

If I don’t get this resolved by the end of the day (2 February), I will need to revert to 3.1.29.1 so that the event lists display correctly.

Please advise.

And thanks in advance. I’m still a fan of EE… but this is a bit frustrating.


ndaniel

February 2, 2013 at 7:12 am

Same issue for me.


ndaniel

February 2, 2013 at 7:45 am

Please send me a link to download 3.1.29.1 so I can rollback. Without event_list working, my mobile website is completely useless. I have hundreds of visitors a week via mobile and can’t operate like this. Very frustrated!


ndaniel

February 2, 2013 at 8:23 am

I have fixed the issue for now by replacing the event_list.php with the one from 3.1.29.1. Glad I had a copy. This is the 3rd time I’ve upgraded and had to go in and edit fixes into place. Each time I restore to original before upgrade. I hope this trend doesn’t continue.

I don’t have time to review the code in detail, but it looks like the change to using the events_detail category_id to pass into the query builder is being broken somewhere in “if using ” checks.


Seth Shoultes

  • Support Staff

February 2, 2013 at 8:28 am

We made change to the event list templates that will allow you to display multiple categories, but it shouldn’t affect existing templates, if you have moved them to your templates folder. You can try doing a comparison of the old and new templates.

I will post the download to 3.1.29.1 here in just a few minutes.


ndaniel

February 2, 2013 at 8:36 am

No need on my account now, Seth. The previous version of the event_list.php file is working for our site. As you know, the change to the event_list template is rather significant in the way it builds the queries. The conditional checks are returning a no results found in the query that gets built.

Roger – if you can replace the event_list.php file on your site with the previous, it sounds like your issue would also be fixed based on your description.

Cheers,
Bill


Roger

February 2, 2013 at 8:38 am

Thanks, ndaniel. I had saved a copy of event_list.php from 3.1.29.1.P, so I was able to restore it… then change my shortcodes back from the new “event_category_id” back to the old “category_identifier”. And that gets me back to my previous display.
Seth, I’m not sure how the multiple-category feature broke the existing display, but it clearly did.


Seth Shoultes

  • Support Staff

February 2, 2013 at 8:50 am

Thanks for the info guys. I will take a look. I thought I just added the fix to the query and didn’t change the category identifier codes.

Here is a (corrected) link to 3.1.29.1 in case anyone else needs it: http://ee-updates.s3.amazonaws.com/tags/event-espresso-3.1.29.1.zip


jfedpgh

February 2, 2013 at 8:42 pm

this also happened to me. Had to use event_category_id to get the list to show, but it didn’t ACTUALLY sort by category, it just shows all events. But without that in place, it shows nothing. Something is definitely off in the event_list shortcode display. I’m going to re-upload 3.1.29.1 and see if that fixes me. All was good before the upgrade to 3.1.30.2.


jfedpgh

February 2, 2013 at 9:24 pm

Just an update – backpeddled a version and it’s still not working. I’m using the shortcode [EVENT_LIST event_category_id=gdd] on http://jvcpittsburgh.org/good-deeds-day-events-alpha-order/ and it seems to be showing all events that are NOT in the gdd category. It’s like it’s EXCLUDING it instead. Can you look into this? Or send me a shortcode that is guaranteed to work?

When I try the “category_identifier=” shortcode, I just get a “No events available” error. I feel like I’ve tried everything. Please let me know if you have any ideas. I’m just trying to show an alphabetical list of everything in the gdd category.

thanks.


Arry Ardhiana

February 3, 2013 at 12:21 am

same problem with me, but do you guys noticing when using 3.1.30.2 every submit new attendees and checked in admin list of attendees it always get overwritten with recent submitted data and the previous one missing, i try the option retrieve all database rows from the db at a time, same result the previous attendees data cannot be found..!! only the recent one, then i rolled it back to 3.1.29.1 and work fine… i hope next update can fixed my problem


themakeden

February 3, 2013 at 1:58 pm

Hi all,

I’ve just attempted to update, and have had the same issue (shows “no events available” in my category pages). I’m not sure I can find / figure out how to restore to a previous version of my event_list.php, and when I tried to download Seth’s link to 3.1.29, it seems to have given me version 3.1.30.1 instead (tried to upload twice, and this is what I got), which has the same problem?

I’ve just activated version 3.1.28.5, as this is the most recent version I have available, but I’m concerned about compatibility with my addons, as I’ve updated all of my addons to the most recent versions, and I know there can be issues with conflicting versions of addons, etc.

Either detailed instructions on how to restore the php, or a valid link to the most 3.1.29 would be helpful…

Please advise the best way to proceed, thanks very much!


jfedpgh

February 3, 2013 at 2:36 pm

I had the same problem. the l ink gave me .30 instead. I’m glad it wasn’t just me.


Seth Shoultes

  • Support Staff

February 3, 2013 at 6:05 pm

Sorry everyone!! Not sure how I got the wrong link and version. Was trying to help out while the kids were running amok.

Here is the corrected link:
http://ee-updates.s3.amazonaws.com/tags/event-espresso-3.1.29.1.zip


themakeden

February 3, 2013 at 6:35 pm

Hi Seth, thanks for responding, Unfortunately, I got an error message when I clicked on your latest link:

<Code>AccessDenied</Code>Access Denied5CD738DBF7AE1671JIBm0n5wv5fOe2BKmo451oMlWiA64PoluvI4RkKpmqj+NMv4ija88SFr545qrMZR

Can we ask you to post that one more time?
thanks so much!


Seth Shoultes

  • Support Staff

February 3, 2013 at 6:43 pm

Oh man! Not sure why this link is causing so many issues. Please try it now.


Seth Shoultes

  • Support Staff

February 3, 2013 at 8:31 pm

Hi Everyone,

I have been trying to reproduce this error for a couple of hours. I can’t seem to find anything wrong. However, I did find a fix when using the ‘event_category_id’ parameter returning all events.


rshaik

February 3, 2013 at 8:48 pm

I am having issues with my site as well. It used to display number of openings and event price. Now after the update, the site displays event id and gives the price as free.

Please see http://www.techjoynt.org on the right hand side wrapper with event categories.

Thanks,
Ray


Seth Shoultes

  • Support Staff

February 3, 2013 at 9:32 pm

Can everyone please post the shortcodes you are tying to use? Are you using multiple shortcodes on one page? Are you using modified templates?

I am investigating the issue and am coming up empty handed on every combination of shortcode I have used. I just can’t seem to break it.


rshaik

February 3, 2013 at 9:37 pm

[EVENT_LIST limit=2 show_recurrence=true category_identifier="100" order_by="date(start_date), id"]


rshaik

February 3, 2013 at 9:38 pm

 [ESPRESSO_TABLE limit=8 show_expired=false show_deleted=false show_secondary=false show_recurrence=false category_identifier="400" order_by=date(start_date),id max_days="30"]


Seth Shoultes

  • Support Staff

February 3, 2013 at 9:39 pm

Is “100” the name of the category? Or the category id?

It should look something like this:
[EVENT_LIST category_identifier="event-public-1359942477"]


rshaik

February 3, 2013 at 9:43 pm

This short code displays content of the page http://www.techjoynt.org/learn/middle-school/

Short code:
[ESPRESSO_TABLE limit=8 show_expired=false show_deleted=false show_secondary=false show_recurrence=false category_identifier=”400″ order_by=date(start_date),id max_days=”30″]


Seth Shoultes

  • Support Staff

February 3, 2013 at 9:46 pm

Here are some examples of the shortcodes I have tested:

<strong>Public and Member Events (category_identifier)</strong>
[EVENT_LIST category_identifier="event-public-1359942477,event-member-1359942496"]

<strong>Public Events (category_identifier)</strong>
[EVENT_LIST category_identifier="event-public-1359942477"]

<strong>Member Events (category_identifier)</strong>
[EVENT_LIST category_identifier="event-member-1359942496"]

<strong>Public Events (EVENT_ESPRESSO_CATEGORY)</strong>
[EVENT_ESPRESSO_CATEGORY event_category_id="event-public-1359942477"]

<strong>Valentines Event</strong>
[EVENT_ESPRESSO_CATEGORY event_category_id="valentines-events-1359946576"]

These all seem to work fine for me.


rshaik

February 3, 2013 at 9:49 pm

Categories shortcode


rshaik

February 3, 2013 at 9:52 pm

I do not have problem with category_id. I am curious why the events are priced as free when the register link shows $20/session?

What am I doing wrong. It used to work fine before the upgrade. Do I need to do something with the custom files after the update?


Seth Shoultes

  • Support Staff

February 3, 2013 at 9:57 pm

Can everyone that is having problems please allow us to take a look at your site? Please use this form to send us temporary login credentials to your site:
https://eventespresso.com/send-login-details/

Please include a link the broken page and an explanation of the problem.

Thanks!


rshaik

February 3, 2013 at 10:12 pm

Seth, I just sent the credentials. Promised my customers for an updated schedule for spring and summer camps this weekend. A resolution will be an immense help. Gracias!


Seth Shoultes

  • Support Staff

February 3, 2013 at 10:31 pm

@rshaik your FTP creds aren’t working for me. I need to be able to look at your template files.


Seth Shoultes

  • Support Staff

February 3, 2013 at 10:50 pm

Okay everyone. I have just discovered the issue with the category shortcodes. It seems the change I made didn’t take into account existing events. There are two ways to fix this. Either edit/open and save all existing events or use the following fix by editing the event_list.php file.

Here is the template file fix: Open the event_list.php file, find line #128 and un-comment (removing the double slashes) that line, then comment out (adding double slashes) line #131.

The resulting code should look like this:
http://content.screencast.com/users/sethshoultes/folders/Snagit/media/6784b04c-cfa5-4bde-b8a1-8453c551d6d9/2013-02-03_22-49-38.png


Seth Shoultes

  • Support Staff

February 3, 2013 at 10:53 pm

I will add a fix to the next version (maybe a hotfix) of Event Espresso to resolve this issue for existing events.


Seth Shoultes

  • Support Staff

February 4, 2013 at 12:12 am

When we added the feature to use multiple categories in the EVENT_LIST short code, we lost broke existing categories because they are stored in a different table. With the added support for multiple categories, we started storing a comma separated list of category ids in the events_detail table. So I am adding support for the legacy and new category system.

Here is an updated version of the event_list.php file (that will be in the next version) for those of you that want to use 3.1.30.2:
https://gist.github.com/4705377


themakeden

February 4, 2013 at 9:56 am

Thanks very much Seth,
I am now running v 3.1.29.1 (thanks for the link!), but all of my addons are the latest version (members, groupon, calendar, etc). It seems to be running okay, but I am worried about the different versions being incompatible.
Do you think I need to worry about compatibility here, or should I attempt to reinstall 30.2 with the fix you posted?


ndaniel

February 4, 2013 at 10:27 am

Addt’l details of how I fixed it, assuming you have a back up of your pre-upgrade files or a download of 3.1.29.x
Copy (not move) the original/working event_list.php into the:
/wordpress/wp-content/plugins/event-espresso/templates folder.

Back-up the 3.1.30.x file first, just in case.
Hope this helps. Disclaimer: I’m not an EE rep, just trying to help out others. I haven’t had other issues from the upgrade, either. If you did, this may not be sound advice.


ndaniel

February 4, 2013 at 10:39 am

Seth,
Your new file post “works” in that it displays both categories I entered, but it excluded a number of events when I add 2 categories.

1 Category: ok
2 Categories: Skips all of February for both events and starts with March events. Interesting behavior…any thoughts on why this may be happening that I can address? Love the idea of this feature!

Cheers,
Bill


Seth Shoultes

  • Support Staff

February 4, 2013 at 10:50 am

Irene if everything is working as expected, then you may be okay for the time being. But I would recommend updating as soon as you can. I am hoping to release this hotfix today.


Seth Shoultes

  • Support Staff

February 4, 2013 at 10:58 am

Bill,

That is happening because if the way we are storing the category data in 3.1.30. Legacy events will not work, with the new multiple categories, until the legacy events are updated/re-saved.


jfedpgh

February 4, 2013 at 1:48 pm

I opened and re-saved all of my events and it’s still not working consistently.


jfedpgh

February 4, 2013 at 1:54 pm

Using this shortcode [EVENT_LIST event_category_id=region-north] is the only way for me to get any events to show at all (without a “no events available” error). and it shows events. All events EXCEPT the ones coded for region-north.

I am going to have to create the signup web page to list over 80 events by hand instead of relying on EE to show me a filtered list, or else this project doesn’t go live tomorrow at 10 AM. Sorely disappointed in this program, and hope, for what I paid for a license, a real fix is up soon.


Seth Shoultes

  • Support Staff

February 4, 2013 at 1:55 pm

jfedpgh are you using the default templates or have you customized theme at all?


ndaniel

February 4, 2013 at 2:18 pm

Thanks Seth.
What flag is set with the same update? I would want to flag this with a MySQL update as there are many events I would need to touch.
Will the multi-category listing work if the events are already in each category to be displayed?

Thanks,
Bill


Seth Shoultes

  • Support Staff

February 4, 2013 at 2:19 pm

@jfedpgh have you tried rolling back to 3.1.29.1?


ndaniel

February 4, 2013 at 2:30 pm

Found it. Thanks.


Seth Shoultes

  • Support Staff

February 4, 2013 at 2:54 pm

Bill, I don’t think this affects the version of MySQL you are using. It just affects the way the categories are stored in the database. With the added support for multiple categories, we started storing a comma separated list of category ids in the events_detail table. But we still store the category relations in a different table, so the existing relationships will still work for legacy events.

Here is what is happening in the event_list.php file: http://www.screencast.com/t/HXQmDqypU


jfedpgh

February 4, 2013 at 5:07 pm

haven’t tried rolling back since the corrected link to 3.1.29 was posted, I’m going to give it a go now. Thanks…hope this all gets straightened out!


Seth Shoultes

  • Support Staff

February 4, 2013 at 8:41 pm

@jfedpgh please let me know what happens. It seems the fix is working for others.

The support post ‘UPDATE TO 3.1.30.2 HAS BROKEN MY EVENT LISTINGS’ is closed to new replies.

Have a question about this support post? Create a new support post in our support forums and include a link to this existing support post so we can help you.

Event Espresso