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

[Chris W. <ch...@cw...>]

On Wed, 2002-12-11 at 02:25, Chris McDaniel wrote:
> 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...

You and Raul seem to be having the same problem so I'll just reply to
you both in this message.  Your handle is losing the idea of a database
altogether while Raul's is defaulting to the system 'mysql' database.
This might be the result of different permissions, I'm not sure.

I don't think your database has gone away -- the other Apache children
keep working, right? So something must be getting stale in the database
connection itself. So two questions to see if we can narrow down the
problem:

 - What version of DBD::mysql are you using?
 - What does the database configuration look like? (Just copy/paste the
'[db_info main]' section from your server.ini file, XXXing out the
user/;password of course :-)

Thanks,

Chris

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