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

Other related posts: