[haiku-web] Re: Interested in helping out...
- From: "Urias McCullough" <umccullough@xxxxxxxxx>
- To: haiku-web@xxxxxxxxxxxxx
- Date: Sat, 19 Aug 2006 13:45:50 -0700
On 8/19/06, Urias McCullough <umccullough@xxxxxxxxx> wrote:
On 8/19/06, Waldemar Kornewald <wkornew@xxxxxxx> wrote:
> > Waldemar Kornewald wrote:
> > > A little PHP+MySQL task:
> > > Could you please have a look at this bug in the "Similar entries" Drupal
> > > module:
> > > http://drupal.org/node/69822
> > > The module's project page is here:
> > > http://drupal.org/node/25974
> >
> > OK, I've taken a look, and it seems very simple, just need to perform an
> > inner join on n.vid = r.vid so that it only selects the active revision
> > (n.vid) from the revisions table.
> >
> > As it happens there's also a patch for this at the bug page you gave me
> > (above). It's been there since about July 4th and has been set to "code
> > needs review".
> >
> > I'd recommend we apply this patch and see how things go from there. If
> > this does indeed solve the problem completely then we can pass that
> > message back on to the module developer and hopefully get the patch
> > included in the next release.
>
> Thanks! I just wanted someone with real SQL experience to have a look
> if the patch is good (I don't want to use something that might fail
> some day). It looks like it's working correctly, but we should wait a
> few days before writing the report.
>
> Bye,
> Waldemar Kornewald
> -----------------------------------------------------------------------
> haiku-web@xxxxxxxxxxxxx - Haiku Web & Developer Support Discussion List
>
>
Despite having no knowlege of Drupal and very little web development
knowledge - I have actually been working with SQL for 12 years now :)
Sorry I didn't catch the conversation before - if any more
database-related issues pop up, you'll have at least 2 people that can
look at it now. I'll review the above patch in a few and throw in my
2 cents if I can.
LOL, nevermind - I think I better get Drupal successfully running here
at home before I offer any more of my help ;)
-----------------------------------------------------------------------
haiku-web@xxxxxxxxxxxxx - Haiku Web & Developer Support Discussion List
- References:
- [haiku-web] Interested in helping out...
- From: Gavin James
- [haiku-web] Re: Interested in helping out...
- From: Waldemar Kornewald
- [haiku-web] Re: Interested in helping out...
- From: Gavin James
- [haiku-web] Re: Interested in helping out...
- From: Waldemar Kornewald
- [haiku-web] Re: Interested in helping out...
- From: Urias McCullough
Other related posts:
- » [haiku-web] Interested in helping out...
- » [haiku-web] Re: Interested in helping out...
- » [haiku-web] Re: Interested in helping out...
- » [haiku-web] Re: Interested in helping out...
- » [haiku-web] Re: Interested in helping out...
- » [haiku-web] Re: Interested in helping out...
- » [haiku-web] Re: Interested in helping out...
On 8/19/06, Waldemar Kornewald <wkornew@xxxxxxx> wrote: > > Waldemar Kornewald wrote: > > > A little PHP+MySQL task: > > > Could you please have a look at this bug in the "Similar entries" Drupal > > > module: > > > http://drupal.org/node/69822 > > > The module's project page is here: > > > http://drupal.org/node/25974 > > > > OK, I've taken a look, and it seems very simple, just need to perform an > > inner join on n.vid = r.vid so that it only selects the active revision > > (n.vid) from the revisions table. > > > > As it happens there's also a patch for this at the bug page you gave me > > (above). It's been there since about July 4th and has been set to "code > > needs review". > > > > I'd recommend we apply this patch and see how things go from there. If > > this does indeed solve the problem completely then we can pass that > > message back on to the module developer and hopefully get the patch > > included in the next release. > > Thanks! I just wanted someone with real SQL experience to have a look > if the patch is good (I don't want to use something that might fail > some day). It looks like it's working correctly, but we should wait a > few days before writing the report. > > Bye, > Waldemar Kornewald > ----------------------------------------------------------------------- > haiku-web@xxxxxxxxxxxxx - Haiku Web & Developer Support Discussion List > >
Despite having no knowlege of Drupal and very little web development knowledge - I have actually been working with SQL for 12 years now :)
Sorry I didn't catch the conversation before - if any more database-related issues pop up, you'll have at least 2 people that can look at it now. I'll review the above patch in a few and throw in my 2 cents if I can.
LOL, nevermind - I think I better get Drupal successfully running here at home before I offer any more of my help ;) ----------------------------------------------------------------------- haiku-web@xxxxxxxxxxxxx - Haiku Web & Developer Support Discussion List
- [haiku-web] Interested in helping out...
- From: Gavin James
- [haiku-web] Re: Interested in helping out...
- From: Waldemar Kornewald
- [haiku-web] Re: Interested in helping out...
- From: Gavin James
- [haiku-web] Re: Interested in helping out...
- From: Waldemar Kornewald
- [haiku-web] Re: Interested in helping out...
- From: Urias McCullough