Skip to main content

This site requires you to update your browser. Your browsing experience maybe affected by not having the most up to date version.

Blog Module /

Discuss the Blog Module.

Moderators: martimiz, Sean, biapar, Willr, Ingo, swaiba, simon_w

Blog Archive List - link error


Reply


895 Views

Avatar
boombox

Community Member, 44 Posts

17 March 2009 at 4:40pm

Hi - Just picking up on the blog post http://www.silverstripe.org/archive/show/221139#post221139
Issue is the monthly archive links didn't work. The error was:
"Column 'Date' in where clause is ambiguous"

Fix is to change Date to `BlogEntry`.Date to identify the relevant posts.

Line 43 of BlogHolder.php

   if(is_numeric($month) && is_numeric($month)){
      $dateCheck = "AND `BlogEntry`.Date BETWEEN '$year-$month-1' AND '$year-$month-31'";
   }
   else if(isset($year)){
         $dateCheck = "AND `BlogEntry`.Date BETWEEN '$year-1-1' AND '$year-12-31'";         
   }

Can thi sbe added to SVN release by someone