RE: [Openinteract-help] error message at random moments...

[Chris M. <Chr...@te...>]

OK, here's what I found - I'm a little confused...

OpenInteract::setup_theme (340) >> Error! Cannot retrieve theme! ( Class:
commerce::Theme ) with error (DBD::mysql::st execute failed: No Database
Selected at /var/www/localperl/lib/site_perl/5.6.1/SPOPS/DBI/TypeInfo.pm
line 139.
/ DBD::mysql::st execute failed: No Database Selected at
/var/www/localperl/lib/site_perl/5.6.1/SPOPS/SQLInterface.pm line 12
2.) Help!
 --EXITED WITH ERROR from main handler eval block
Error: 0

The only thing I can think of is probably dead wrong - but you know how if
you leave the mysql client alone too long the connection 'goes away' - sould
it be something like that (if you leave OI alone too long)?

Like I said, probably dead wrong...

Chris McDaniel

-----Original Message-----
From: Chris Winters [mailto:ch...@cw...]
Sent: December 10, 2002 1:51 PM
To: Chris McDaniel
Cc: 'ope...@li...'
Subject: Re: [Openinteract-help] error message at random moments...


Chris McDaniel wrote:
> Hi,
> 
> Sometimes I get the error message
>  
> Fundamental part of OpenInteract (themes) not functioning; please contact
> the system administrator 
> 
> and sometimes not - themes are definitely working, so I don't get it.
> Anyone know why this is happening?  I'm using OI 1.54 with mysql on
Solaris
> 8, perl 5.6.1, modperl_solo config.  I have an older OI on the site, so
I'm
> using a local lib directory for the 1.54 install.

Check your error log (in $WEBSITE_DIR/logs) for a message when 
this happens, it should tell you why it cannot retrieve the 
theme. Here is the code that produces the message so you can have 
something to scan for:

if ( $@ ) {
     my $ei = SPOPS::Error->get;
     OpenInteract::Error->set( $ei );
     $R->throw({ code => 404 });
     $R->scrib( 0, "Error! Cannot retrieve theme! ( Class: ",
                   $R->theme, ")",
                   "with error ($@ / $ei->{system_msg}) Help!" );
     ....

-- 
Chris Winters (ch...@cw...)
Building enterprise-capable snack solutions since 1988.