Issue with display by week (using Reepeat)
Development and Programming
I want to display a list of event’s for the current week.
I’ve done it like this:
{exp:weblog:entries weblog="events" show_current_week="yes" display_by="week" show_future_entries="yes" show_expired="no" sort="asc" dynamic="off"}
<span class="right-col-this-week-day">{entry_date format="%l %d %F"}</span> <span class="right-col-this-week-title"><a href="http://{comment_url_title_auto_path}">{exp:char_limit total="16"}{title}{/exp:char_limit}</a></span> | <span class="right-col-this-week-time">{entry_date format="%g:%i%a"}</span>
{/exp:weblog:entries}This used to work perfectly.
I’ve not changed any code for a few weeks. But for some reason is now displaying events for December and I can’t work out why.
You can see it in action here:
http://www.newlifelincoln.org.uk/index.php/get-connected/whats-on/
Any ideas?
Threads merged by Moderator
Anyone willing to give this a shot? : )
Just having a look at this for you now….
This is strange.
This query:
SELECT DATE_FORMAT(CURDATE(), '%X%V') AS thisWeekreturns 200933, as we’re in the 33rd week of the year I guess,
Yet the next query:
SELECT t.entry_id FROM exp_weblog_titles AS t LEFT JOIN exp_weblogs ON t.weblog_id = exp_weblogs.weblog_id LEFT JOIN exp_members AS m ON m.member_id = t.author_id WHERE t.entry_id !='' AND t.site_id IN ('1') AND (t.expiration_date = 0 OR t.expiration_date > 1250889120) AND exp_weblogs.is_user_blog = 'n' AND t.weblog_id = '7' AND ( DATE_FORMAT(FROM_UNIXTIME(entry_date - 21600), '%X%V') = '200950' )AND t.status = 'open' ORDER BY t.sticky desc, t.entry_date asc, t.entry_id ascuses the date: 200950
So somewhere along the line something has gone wrong. Perhaps it’s do with the offset calculation. Strange that it should have worked before but it doesn’t now.
I’ll post a link to this in tech support and see if one of the support team can help you.
For reference, the installation is version 1.6.7, build 20090320 so might be worth updating to latest version when you get a moment (backup first of course!)
I wonder if a member of the team can take a look at this post in “How to” where “display by week” displays the wrong week. I think it belongs here.
http://ellislab.com/forums/viewthread/126501/
Would really help my friend Matt out. I’ve taken a quick look but can’t get to the bottom of it.
Just posted a link to this over in Tech support - I think that’s the right place for it.
http://ellislab.com/forums/viewthread/126956/
(Maybe a moderator can move this post?)
Merged posts.
Matt, let’s have you upgrade to 1.6.8 so we’re on the same code base.
Righty, I’ve upgraded to the latest version - and it’s (nearly) working!
It’s now displaying an entry from this current week, but only one entry. There should be 4 in total. Am I missing something obvious here?
I’m using Reepeat on the calendar - it’s only entries set to repeat that are missing.
Did this use to work? I seem to recall you’ve not wrapped your weblog entries tag in the “repeet” tags in your “right column” (is that right?). If you don’t do that, it will only show the “one offs”, so perhaps look up the “repeet” docs and wrap your weblog entries tag in that, and include the repeet ids variable you should be away I think.
Matt, we don’t provide direct support for third party offerings, so we’ll need to switch this to Plugins. There are members of the community that have experience in using Reepeat, so I’m sure someone will be able to assist you.