Events not Showing in Admin Panel

[myneighborhoodnews]

My events are not showing up in the admin panel. The number of events for All, Published, Pending, and Trash show but when I click any of those there are no events in the list. I have tried disabling all other plugins and that has no solved the problem.

http://www.evernote.com/shard/s1/sh/754ce8b9-41aa-4484-8954-7e804099da0b/333c32ffced6fe129f8b07c89d6a1934

[Barry]

Hi!

Can you try adding this snippet to your theme’s functions.php file in the first instance and see if that resolves the problem?

Note that ordinarily you will not need to opening <?php tag if you are pasting this into an existing functions.php file.

Let me know if it helps/you require further assistance!

[myneighborhoodnews]

That didn’t seem to do the trick. Note that this is a multi-site installation with a child theme. I did add it to the child theme’s functions.php file.

[Andy Fragen]

Barry, I’m seeing the same thing on my Multisite installation. FWIW, TEC is not active in blog_id 1.

[ddcaoregon]

I’m having the same problem. This is not a multisite but wordpress is installed in a sub-folder while the site url is just the root. Not sure if this is causing an issue, since this is a standard wordpress install scenario. I tried adding the snipped to my theme’s functions file and it didn’t resolve anything. However, I am seeing the same behavior where if I deactivate Events Calendar PRO magically the events show up in the edit list, but as soon as I re-activate PRO the events go away. Note, I’m seeing the same behavior that the (counts) next to “All” and “Published” match the events in the system. Just none show up in the grid to be able to click on and edit them. This is a pretty critical issue right now as I’m trying to get this site live with a deadline for a client and we can’t get the calendar plugin working that we purchased. Could someone please find a solution to this problem or I’m going to have to undo all my work with this plugin and find a different one. Thank you.

[Barry]

Thanks everyone – looks like this is cropping up in a number of different scenarios and I just want to discuss with the team so we can think about the best way to move forward here.

Thanks for your patience 🙂

[Barry]

To take up ddcaoregon’s feedback, can anyone else confirm that the issue appears/disappears according to whether PRO is activated or not?

[myneighborhoodnews]

Yes, I just tested and experienced the same thing. Once a deactivate PRO, I can see the events again in the admin panel.

[Andy Fragen]

Yes, with PRO deactivated I see single events and the first instance of a repeating event. With PRO active I see no events.

But I do see the following query


SELECT SQL_CALC_FOUND_ROWS DISTINCT wp_3_posts.*, wp_3_postmeta.meta_value as EventStartDate, IFNULL(DATE_ADD(CAST(wp_3_postmeta.meta_value AS DATETIME), INTERVAL eventDuration.meta_value SECOND), eventEnd.meta_value) as EventEndDate FROM wp_3_posts LEFT JOIN wp_3_postmeta as eventDuration ON( wp_3_posts.ID = eventDuration.post_id AND eventDuration.meta_key = '_EventDuration') LEFT JOIN wp_3_postmeta as eventEnd ON( wp_3_posts.ID = eventEnd.post_id AND eventEnd.meta_key = '_EventEndDate') WHERE 1=1 AND wp_3_posts.post_type = 'tribe_events' AND (wp_3_posts.post_status = 'publish' OR wp_3_posts.post_status = 'future' OR wp_3_posts.post_status = 'draft' OR wp_3_posts.post_status = 'pending' OR wp_3_posts.post_status = 'private') ORDER BY eventStart.meta_value DESC, IFNULL(DATE_ADD(CAST(eventStart.meta_value AS DATETIME), INTERVAL eventDuration.meta_value SECOND), eventEnd.meta_value) DESC LIMIT 0, 20


and the following error


Unknown column 'wp_3_postmeta.meta_value' in 'field list'


[Barry]

Thanks again Andy: something that could be helpful here is if you and anyone else experiencing this could drop the info you see in Events → Settings → Help → System Info in here – we’re actively looking in to this and any further information like that which might be helpful would be much appreciated 🙂

Thanks!

[Andy Fragen]

Barry, I don’t see this menu.

[Andy Fragen]

Barry, interestingly multisite installs are still at TECPro 3.0.5, single installs auto-updated correctly.

[Andy Fragen]

Barry, problem solved here. Updated to 3.1 and everything works. It looks like the issue here is the auto-updater wasn’t seeing the PRO update on a multisite installation.

If anyone over at MT is interested I have a little project on GitHub that deals with autoupdating. 😉

[Barry]

Fantastic news Andy (that the problem is fixed): does that work for anyone else here?

(…and definitely do also drop us a note re your auto-update plugin 🙂 )

[elsie]

I’m having the same problem, I just bought the PRO version and is updated.
What should I do?

[Author]

Posts