FreeLists / haiku-web / [haiku-web] Re: Interested in helping out...

["Urias McCullough" <umccullough@xxxxxxxxx>]

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.
-----------------------------------------------------------------------
haiku-web@xxxxxxxxxxxxx - Haiku Web & Developer Support Discussion List