[bbDev] tag error fixed up

[Brian Crouch]

With 3.23 00 this is the only problem I have.

Brian

On 5/4/05, Luc Saint-Elie <lstelie at gmail.com> wrote:
> Brian,
> 
> As far as I have tested bbpress requires Mysql 4.x
> 
> Luc
> 
> On 5/4/05, Brian Crouch <dr.brian.crouch at gmail.com> wrote:
> > I fixed my obvious tag error with this change (the original 2005-05-04
> > code is commented out):
> >
> > function get_topic_tags ( $topic_id ) {
> >         global $topic_tag_cache, $bbdb;
> >
> >         if ( isset ($topic_tag_cache[$topic_id] ) )
> >                 return $topic_tag_cache[$topic_id];
> >
> >         /*$topic_tag_cache[$topic_id] = $bbdb->get_results("SELECT *
> > FROM $bbdb->tagged JOIN $bbdb->tags ON ($bbdb->tags.tag_id =
> > $bbdb->tagged.tag_id) WHERE topic_id = '$topic_id'");*/
> >
> >         $topic_tag_cache[$topic_id] = $bbdb->get_results("SELECT *
> > FROM $bbdb->tagged,$bbdb->tags WHERE $bbdb->tags.tag_id =
> > $bbdb->tagged.tag_id AND topic_id = '$topic_id'");
> >
> >         return $topic_tag_cache[$topic_id];
> > }
> >
> > I don't know if any of you where getting errors... but mine was
> > barfing up some. It was the JOIN ... ON ... WHERE clause.
> >
> > I got MySQL 3.23.58 for reference.
> >
> > --
> > Brian
> 


-- 
Brian