[Catalyst] errors under mod_perl

[August R. Wohlt]

Hi All,

I'm relatively new to catalyst and have an application I just rolled out to
a large user base. While developing, it was run as a stand-alone CGI so that
I could edit the code and see changes live. When I rolled it out, I switched
to mod_perl, and now I get crazy intermittent Class:DBI /
DBIx/ContextualFetch.pm errors. The app runs for a little while with no
problem. Users can log in and out and use it, but then suddenly the errors
start popping up all over the place: in the session logic, when searching
objects in the database, but never in the same place. Here's a sample.
Hoping someone knows off-hand what this is and that I'm doing something
simply wrong:

[Mon Jan 23 13:25:26 2006] [catalyst] [error] Caught exception in
BioScribe::C::Admin->importer "BioScribe::M::CDBI::PacSoftEventLog can't
SELECT id
FROM   PacSoftEventLog
WHERE  project_id = ? AND serinstid = ?
: DBD::mysql::st fetchrow_arrayref failed: fetch() without execute() [for
Statement "SELECT id
FROM   PacSoftEventLog
WHERE  project_id = ? AND serinstid = ?
"] at /usr/lib/perl5/site_perl/5.8.5/DBIx/ContextualFetch.pm line 60.
 at /usr/lib/perl5/site_perl/5.8.5/Class/DBI/Search/Basic.pm line 169"

[Mon Jan 23 13:25:02 2006] [catalyst] [error] Caught exception in
BioScribe::V::Mason->process "Couldn't render component "/mc/projects.mc" -
error was "BioScribe::M::CDBI::Subject can't SELECT id
FROM   Subject
WHERE  project = ?
: Can't use an undefined value as an ARRAY reference at
/usr/lib/perl5/site_perl/5.8.5/Class/DBI.pm line 1113.

Thanks,
:goose



On 1/23/06, Duncan Ferguson <duncan_j_ferguson at yahoo.co.uk> wrote:
>
> Thanks for your help, all.  Classic case of PEBKAC*
>
> Since I have set up some frames on the main page, I hadn't included the
> "use Prototype" in the correct controller.  Also, I hadn't twigged I needed
> a controller called "AutoComplete" to get everything working properly.
>
> In the end, to prove everything worked OK, I followed the transcript of
> the demo exactly (incidentally, I think there is a mistake in it for the
> current module versions; the template should have been defined in the stash
> in Catacolous.pm rather than the AutoComplete.pm - I had errors about not
> finding the default template until I moved the assignment) and got it
> working.
>
> Anyhow, thanks
>
>   Duncs
>
> *Duncan Ferguson <duncan_j_ferguson at yahoo.co.uk>* wrote:
>
> I am a bit stuck using the above module when trying to set up an
> autocomplete field, just the same as in the movie demo.
>
> * PEBKAC - Problem Exists Between Keyboard And Chair (from "User Friendly"
> by Illiad)
>
> ------------------------------
> To help you stay safe and secure online, we've developed the all new *Yahoo!
> Security Centre*<http://us.rd.yahoo.com/mail/uk/taglines/default/security_centre/*http://uk.security.yahoo.com/>
> .
>
>
> _______________________________________________
> Catalyst mailing list
> Catalyst at lists.rawmode.org
> http://lists.rawmode.org/mailman/listinfo/catalyst
>
>
>
-------------- next part --------------
An HTML attachment was scrubbed...
URL: http://lists.rawmode.org/pipermail/catalyst/attachments/20060123/36d00f5d/attachment-0003.htm