openinteract-help

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

[<ra...@bg...>]

The same thing happens to me exactly.

I'm using OI 1.54 with mysql on FreeBSD 4.7, perl 5.8, modperl_solo confi=
g.

El Lun 09 Dic 2002 18:30, Chris McDaniel escribi=F3:
> Hi,
>
> Sometimes I get the error message
>
> Fundamental part of OpenInteract (themes) not functioning; please conta=
ct
> 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 Sol=
aris
> 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.
>
> Thanks,
>
> Chris McDaniel

--
=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=
=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D

| Ra=FAl Romero=09=09|  ra...@bg...
| FreeDeveloper ;-)=09|  FreeBSD 4.7-STABLE

=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=
=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D

| http://www.bgta.net/=09|  ICQ: 162258467
| Jabber: bg...@ja...=09|  MSN: bgt...@ho...

=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=
=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D

--=20
=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=
=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D
| Ra=FAl Romero=09=09|  ra...@bg...=09=09
| FreeDeveloper ;-)=09|  FreeBSD 4.7-STABLE=09=09=09=09
=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=
=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D
| http://www.bgta.net/=09|  ICQ: 162258467=09
| Jabber: bg...@ja...=09|  MSN: bgt...@ho... =09
=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=
=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D

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.

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.

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.

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

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

Chris McDaniel wrote:
> 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

Just to see what happens, try changing this to:

  dsn           = database=commerceDB
  db_name       =

Chris

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

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

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

That seems to have worked OK - I'll let you know if it happens again.

Thanks for the help!  

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


Chris McDaniel wrote:
> 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

Just to see what happens, try changing this to:

  dsn           = database=commerceDB
  db_name       =

Chris

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