RE: [Slashcode-development] Enabling Journal searching

[Howell, M. <ho...@ra...>]

From: Brian Aker [mailto:br...@ta...] On: Monday, March 10, 2003 2:37
PM
> On Mon, 2003-03-10 at 12:32, Howell, Mark wrote:
> > Journals.  When I dig around the code, I find places where code exists
to
> > search journals (e.g. in Search plugin), but with strong warnings not to
> That is a very old warning, we have had journal searches for a long time
> now.
>	-Brian

I've bypassed (ignored) the warnings as per your suggestion, and now I'm
trying to get the code to work.  For some reason, when I run a query that
searches the journals table from within Slashcode, it finds nothing, but
running it from the MySQL interpreter, finds several records.  I tried
changing the code in Search.pm to use the more standard-looking
Slash::DB::Utility sqlSelectArrayRef(..) method, but I get similar (empty)
results.  No error is logged.

It doesn't seem to matter whether I'm using a different search_db_user or
not.  Is there something that I should be aware of that the DBIx::Password
may be doing differently than the MySQL interepreter?  I can connect using
the mysql client as the same user that Slash uses, and get positive results.

Other forms of search query (Stories) appear to work fine.  Journals seem to
be the only one that returns nil.

Bizarre.

-Mark

[ALERT] -- Access Manager: This email is intended only for the person or
entity to which it is addressed and may contain information that is
privileged, confidential or otherwise protected from disclosure.
Dissemination, distribution or copying of this e-mail or the information
herein by anyone other than the intended recipient, or an employee or agent
responsible for delivering the message to the intended recipient, is
prohibited. If you have received this e-mail in error, please immediately
notify us by calling our North American Help Desk at (972)506-3939.