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

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

DBD:: mysql $VERSION = '2.0902';

[db_info main]
db_owner      =
username      = xxxxxxxxxx
password      = xxxxxxxxxx
dsn           = database=
db_name       = commerceDB
driver_name   = mysql
sql_install   =
long_read_len = 65536
long_trunc_ok = 0

The other children seem to be OK, and usually just refreshing fixes it for a
while - it doesn't happen too often, and almost never when I'm looking for
it.  I have 5 apache children running around by default, and the site is not
launched, so I don't see much traffic to it yet either.

Thanks,

Chris

-----Original Message-----
From: Chris Winters [mailto:ch...@cw...]
Sent: December 11, 2002 8:37 AM
To: Chris McDaniel
Cc: 'ope...@li...'; BgTA Hotpop
Subject: RE: [Openinteract-help] error message at random moments...


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.