Forum Replies Created
-
Posts
-
Geoff,
I copied your code above and replaced what I had in my functions.php file. Now I get a completely blank home page. 🙁
This may help you. See the modifications you can add to your child-theme’s functions.php file on https://theeventscalendar.com/knowledgebase/customize-rss-feed/ under the heading “Order Event by Publication Date”.
@pagan11460 and @George You do not need a page called Events. The Events Calendar creates that page for you as a ghost page. You don’t need to create a slug. The ghost page will have the URL yoursite.com/events
1. If you have an Events page in your Pages directory, go to Pages and delete your Events page.
2. If you have a navigation menu item at the top, go to Appearance/Menus and delete the Events (or whatever you called it) menu item since that page is no longer there. Then, in the Custom Link box, create a new menu item with a custom link yoursite.com/events using the Events name you had before. It will point to your ghost page.
Yes! The home page came back.
By the way, the number of posts to a ticket in the forum is not updating. There have been five posts to this ticket (this one will be number six) but the number shown in the forum is still at two.
I also checked the error log and it has this error flagged that may be affecting things?
WordPress database error Duplicate column name ‘post_date’ for query
SELECT
SQL_CALC_FOUND_ROWS *
FROM (
SELECT DISTINCT 52sggfg_posts.*, IF (52sggfg_posts.post_type = ‘tribe_events’, 52sggfg_postmeta.meta_value, 52sggfg_posts.post_date) AS post_date FROM 52sggfg_posts LEFT JOIN 52sggfg_postmeta as 52sggfg_postmeta on 52sggfg_posts.ID = 52sggfg_postmeta.post_id AND 52sggfg_postmeta.meta_key = ‘_EventStartDate’ WHERE 1=1 AND 52sggfg_posts.post_type IN (‘post’, ‘tribe_events’) AND (52sggfg_posts.post_status = ‘publish’ OR 52sggfg_posts.post_author = 1 AND 52sggfg_posts.post_status = ‘private’) ORDER BY post_date DESC
) a
GROUP BY IF( post_parent = 0, ID, post_parent )
ORDER BY EventStartDate ASC
LIMIT 0, 6
made by require(‘wp-blog-header.php’), wp, WP->main, WP->query_posts, WP_Query->query, WP_Query->get_postsBrian,
Thanks. I updated the functions.php file in my development site, then upgraded to 3.12.1 to see if that fixed the original problem. It didn’t. The home page still gives me a search result saying Nothing Found instead of the calendar and the posts. The error log still gives
[18-Sep-2015 20:15:15 UTC] WordPress database error Duplicate column name ‘post_date’ for query
SELECT
SQL_CALC_FOUND_ROWS *
FROM (
SELECT DISTINCT 52sggfg_posts.*, IF (52sggfg_posts.post_type = ‘tribe_events’, 52sggfg_postmeta.meta_value, 52sggfg_posts.post_date) AS post_date FROM 52sggfg_posts LEFT JOIN 52sggfg_postmeta as 52sggfg_postmeta on 52sggfg_posts.ID = 52sggfg_postmeta.post_id AND 52sggfg_postmeta.meta_key = ‘_EventStartDate’ WHERE 1=1 AND 52sggfg_posts.post_type IN (‘post’, ‘tribe_events’) AND (52sggfg_posts.post_status = ‘publish’ OR 52sggfg_posts.post_author = 1 AND 52sggfg_posts.post_status = ‘private’) ORDER BY post_date DESC
) a
GROUP BY IF( post_parent = 0, ID, post_parent )
ORDER BY EventStartDate ASC
LIMIT 0, 6
made by require(‘wp-blog-header.php’), wp, WP->main, WP->query_posts, WP_Query->query, WP_Query->get_posts
[18-Sep-2015 20:47:42 UTC] WordPress database error Duplicate column name ‘post_date’ for query
SELECT
SQL_CALC_FOUND_ROWS *
FROM (
SELECT DISTINCT 52sggfg_posts.*, IF (52sggfg_posts.post_type = ‘tribe_events’, 52sggfg_postmeta.meta_value, 52sggfg_posts.post_date) AS post_date FROM 52sggfg_posts LEFT JOIN 52sggfg_postmeta as 52sggfg_postmeta on 52sggfg_posts.ID = 52sggfg_postmeta.post_id AND 52sggfg_postmeta.meta_key = ‘_EventStartDate’ WHERE 1=1 AND 52sggfg_posts.post_type IN (‘post’, ‘tribe_events’) AND (52sggfg_posts.post_status = ‘publish’ OR 52sggfg_posts.post_author = 1 AND 52sggfg_posts.post_status = ‘private’) ORDER BY post_date DESC
) a
GROUP BY IF( post_parent = 0, ID, post_parent )
ORDER BY EventStartDate ASC
LIMIT 0, 6
made by require(‘wp-blog-header.php’), wp, WP->main, WP->query_posts, WP_Query->query, WP_Query->get_postsIt does seem to have fixed the Fatal errors related to top of this thread–no more of those messages in the error log.
The URL for my development site is http://competition.stcwdc.org/
I’ll leave 3.12.1 installed there for now. I am using the earlier 3.11.1 version on my production site at http://events.stcwdc.org/
More info. I just noticed that the errors are also pointing to line 195 in my functions file–looks like it definitely goes with the earlier problem I reported with the start date.
166 <?php
167 //
168 // *************************************
169 // Events Calendar fix
170 // Add Events to RSS Feed
171 // ~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~
172 //
173 function add_events_to_rss_feed( $args ) {
174 if ( isset( $args[‘feed’] ) && !isset( $args[‘post_type’] ) )
175 $args[‘post_type’] = array(‘post’, ‘tribe_events’);
176 return $args;
177 }
178
179 add_filter( ‘request’, ‘add_events_to_rss_feed’ );
180
181 // Add Tribe Event Namespace
182 add_filter( ‘rss2_ns’, ‘events_rss2_namespace’ );
183 function events_rss2_namespace() {
184 echo ‘xmlns:ev=”http://purl.org/rss/2.0/modules/event/”‘;
185 }
186 ?>
187 <?php
188 // Add Event Date to RSS Feeds
189 add_action(‘rss_item’,’tribe_rss_feed_add_eventdate’);
190 add_action(‘rss2_item’,’tribe_rss_feed_add_eventdate’);
191 add_action(‘commentsrss2_item’,’tribe_rss_feed_add_eventdate’);
192 function tribe_rss_feed_add_eventdate() { ?>
193
194 <ev:tribe_event_meta xmlns:ev=”Event”>
195 <?php if (tribe_get_start_date() !== tribe_get_end_date() ) { ?>
196
197 <ev:startdate><?php echo tribe_get_start_date(); ?></ev:startdate>
198 <ev:enddate><?php echo tribe_get_end_date(); ?></ev:enddate>
199
200 <?php } else { ?>
201
202 <ev:startdate><?php echo tribe_get_start_date(); ?></ev:startdate>
203
204 <?php } ?>
205 </ev:tribe_event_meta>
206
207 <?php }
208 ?>Maybe others who are also having the problem with the new version are using this same fix provided by Support a few versions back.
Thanks for letting me know it is a bug in the system. I deleted the update and reinstalled the previous version (3.11+) and I got my home page back with the calendar and list of news and event posts. I’ll wait for your update that fixes these problems before I update the plugins.
I’d like to add that this update has completely messed up my home page. I should at least be able to get my regular posts. It was set up to display the calendar and integrate the event posts with the news posts on the home page. Now when I go there, it acts like I did a search and tells me nothing is found. The other pages are all OK, even the events page for the calendar views. It is just the home page where all my posts are displayed that is not working with the events calendar. I will need to try to drop back to the previous release version to get my home page back.
George,
I had a template override in my tribe-events folder in my child theme in /tribe-events/widgets/. It is very different from the one in the current version. I was sent it by someone in Support as a replacement to fix a problem, which I guess is no longer a problem. I deleted it and now the Upcoming Events widget is working.
I still have the List, Day, Week, Map, and Photo views turned off because of the 404 Not Found problem when there is no event. While looking in the tribe-events folder, I looked at the override template for month/single-day.php. That is another replacement file I was sent by Support to get around the 404 Not Found problem in month view if there were some no-event days in the month in version 3.8 (I think) with some additional functions related to it in my child functions.php. It did fix the problem for month view. A permanent fix was supposed to be worked into the next release but it wasn’t (several others were complaining about the same problem.). Those fixes and the no-event-404s plugin are not fixing the 404 problems for the other views. The code is the same for converting 404s to 200 but they differ above that. I copied the function given to me for the month view and made ones for each of the other views in my child functions.php file but that didn’t help them. Perhaps each of the views need similar modifications as was done for the month view but I’m not a PHP programmer so I can’t tell what that would be. I compared the override file with the 3.10 version of the single-event.php file and it is quite different. Since I’m not getting 404s for month views with empty dates, that override file and related functions seems to be working. Without it, month view generated a huge number of 404 errors and I don’t want to go back to that again. Does this give you any clues as to why the other views are now giving us 404 errors for empty dates?
I looked at your screen capture of your display setup. I am using the default page template. There is no front page template in my list. See my screen captures at
http://www.stcwdc.org/images/display-template-setup.png
http://www.stcwdc.org/images/default-page-template.png
I am using a Twentyeleven child theme. All the plugins are up-to-date. I did not have the Twentythirteen theme installed so I installed it and switched to that one. Doing that trashed all my text widgets in the sidebar–they did not get put in the inactive widgets section–they just disappeared. That did not fix the problem. I turned off all the plugins except the Events Calendar ones. That did not fix the problem. I reverted back to my original theme and had to recreate all my text widgets to restore them. Then I turned on plugins one by one. That did not fix the problem.
Looking back at some of my previous problem posts to the forum, I see that I had this same problem in Nov 2014 after the 3.8 release. See the top of https://theeventscalendar.com/support/forums/topic/upcoming-events-there-are-no-upcoming-events-at-this-time/. That problem was fixed when I was told to delete the widget I was using named Upcoming Events and replace it with a new widget named Events List. It did the same thing but had a different name and had a title area, in which I put “Upcoming Events”.
I am wondering if something similar has happened in this latest release that was unannounced as a change? Has the widget that we use to list upcoming events in the sidebar been changed again or is there a new widget we need to replace the Events List widget with?
I looked into the Theme Override suggestion: Do you have any theme overrides? Try disabling them by renaming your [themename]/tribe-events/ folder to ‘tribe-events-bak’. I did that and the widget worked. Now to try to figure out what is in there that is causing this. Because of all the problems with installing a different theme and having it destroy all the sidebar text widgets I had and having to rebuild the sidebar, I suggest you put this Theme Override test at the top as the first thing to try.
Hello,
I’ve been out of town for a few weeks but I’m back again. After trying everything above, the sidebar still messes up in Day, Week, Map, Photo, and List views if there is no event for that Day, Week, Map, Photo, or List. When there is no event, the page title of the page shows 404 Not Found even though the page is there and this gets recorded in Google Analytics as a 404 missing page. There seems to be no way to stop the 404s even though I installed the 404 fix plugin and have a function from a few years ago in functions.php that does a similar thing. (I tried deleting the function after installing the plugin but there is no difference with or without it–still generates lots of 404s.
I cannot figure out why two of the views that don’t work are picking up a different formatting for the search bar widget and include the sharing buttons when none of the other views do that. (If there is an event there in a view that messes up when there is no event, the search bar widget formatting is normal and the sharing buttons are not included.)
Since there seems to be no way to fix getting 404s when there is no event, I have changed the allowed views to just a Month view in the Display settings. That is the only view that works.
Thank you. I would have never connected the Error 404 with the width of the search bar and the split sidebar in the Day view. I added your revision to the css for .error404 #main .widget to my child theme’s style.css. That helped the split sidebar problem. But why does the Day View have a different styling for the search bar than any of the other views?
The other views do not show the sharing buttons at the bottom of the calendar and have a cleaner, narrower search bar. The Day View has a very different, wider, styled search bar and shows the sharing buttons. The view templates look the same at the end so I can’t figure out where the Day View is getting styled differently.
I searched my entire folder for .error404 #main .widget and discovered that styling for Error404 is in my theme’s style sheet and in the Jetpack style sheet. The only difference between the two is the font size in .error404 .widgettitle. In the Jetpack style sheet, the font-size is 0.769em. In the theme’s style sheet, the font size is 10px.
