[bbDev] tag error fixed up
Brian Crouch
dr.brian.crouch at gmail.com
Thu May 5 13:50:32 GMT 2005
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
More information about the bbDev
mailing list