Hi gagarin42,
Is there any change you’ve made to the site (e.g. update, or adding a plug-in/theme) which corresponds to the fact your events are no longer visible?
Hi Stephen,
Thank you for your repley.
So far as I´m aware, no further updates or plug-in installations has been made. It was out of the nowhere that the events where empty. A user informed me about this issue.
All Plug-ins are update aswell the WP-Installation.
Today I have deleted the event organiser plug-in (an all not vital plug-ins) and hoped that a new installation would be a solution. Unfortunatly the situation is the same. I can still see numbers like “Alle (49) | Meine Beiträge: (46) | Veröffentlichte (49) | Papierkorb (1)” in the main section but no events showing up. Also the static links to single events are broken.
Is there anyway for a reload or flush of the event organiser data?
One thing to check is whether the wp_eo_events table exists and has data in it.
The next thing to try would be to investigate what SQL query is being run, which might indicate why no results are being found. Query Monitor is a very good plugin for this.
It will tell you all the queries that are run on that page. The one you are looking for should be for events and will typically be the longest. It should be SELECTing records from wp_posts joined to wp_do_events.
I was able to identify the Tables in question.
eo_events and eo_venuemeta are existing and have a sort of data in it but not really much (eo_events has only the columns event_id, post_id, StartDate,EndDate, StartTime, FinishTime and event-occurence).
When using SQL Monitor it shows me the following error:
Query: SELECT SQL_CALC_FOUND_ROWS DETtwUVoposts.*, DETtwUVoeo_events.event_id, DETtwUVoeo_events.event_id AS occurrence_id, DETtwUVoeo_events.StartDate, DETtwUVoeo_events.StartTime, DETtwUVoeo_events.EndDate, DETtwUVoeo_events.FinishTime, DETtwUVoeo_events.event_occurrence
FROM DETtwUVoposts
WHERE 1=1
AND DETtwUVoposts.post_type = ‘event’
AND (DETtwUVoposts.post_status = ‘publish’
OR DETtwUVoposts.post_status = ‘future’
OR DETtwUVoposts.post_status = ‘draft’
OR DETtwUVoposts.post_status = ‘pending’
OR DETtwUVoposts.post_status = ‘private’)
GROUP BY DETtwUVoposts.ID
ORDER BY DETtwUVoeo_events.StartDate ASC, DETtwUVoeo_events.StartTime ASC
LIMIT 0, 20
“Unknown column ‘DETtwUVoeo_events.event_id’ in ‘field list'”
Could you suggest any next steps to solve the problem or should I simply delete the tables an re-install EO?
The tables are fine. The issue is that there’s a JOIN statement missing.
That should be added here: https://github.com/stephenharris/Event-Organiser/blob/c87053a059089cce1220a501d70dae5ca90f5bb6/includes/event-organiser-archives.php#L322.
Given that the rest of the SQL statement seems well formatted, it seems to me that that function is executing (you can check by making writing to the log). What is possible is that another function is hooked onto posts_join hook and is over-riding the changes made by the plug-in.
Query Monitor has a ‘hooks’ option. On the same page, check to see if there are callbacks for ‘posts_join’. Are there any?
There are other hooks a plugin can alter the SQL query. For example posts_clauses – are there any callbacks for that hook?
