Re: [Openinteract-help] OI 1.41 + PgSQL Issue

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

On Mon, 2002-08-19 at 18:30, Eric Reeves wrote:
> I'm attempting to get OI 1.41 up and running w/ PgSQL, and am having a few
> issues.  I have the program working fine with MySQL, but would prefer to
> use PgSQL.

Ah, a man of my own tastes :-)

> I have created an override_spops.perl in my site's conf dir, and have also
> run "oi_manage change_spops_driver --driver=SPOPS::DBI::Pg", just to be
> safe.

The global override is the way to go and it works fine. (I do this all
the time, so if this got broken it would get discovered and fixed in a
hurry.)
 
> Error log entry:
> ...
>  Cannot save error 310: DBD::Pg::st execute failed: ERROR:  value too long
> for type character varying(60) at
> /usr/local/lib/perl5/site_perl/5.6.1/SPOPS/SQLInterface.pm line 288.
>  at /usr/local/lib/perl5/site_perl/5.6.1/OpenInteract/Error/System.pm line
> 394

This is interesting. In all of OI there are only two tables with a
character field of length 60:

./pkg/base_error/struct/sys_error.sql: filename      varchar(60) not
null,
./pkg/base_security/struct/sys_security.sql: class          varchar(60)
not null,

And since this was an error I suspect that it had problems with the
first of these. I'm not sure why it would, but in any case try dropping
the table, changing the table definition to varchar(120) or something in
$WEBSITE_DIR/pkg/base_error-x.xx/struct/sys_error.sql, then running:

 oi_manage install_sql --package=base_error --sql_action=structure

I'm not sure this is the error, though. Session errors (310) should
never be fatal since they can happen fairly often. In the error log we
also have:

>  --EXITED WITH ERROR from main handler eval block
> Error: Can't call method "discover_properties" on an undefined value at
> /usr/local/lib/perl5/site_perl/5.6.1/OpenInteract.pm line 348.

Which makes me think the theme wasn't retrieve properly. Can you do a:

 SELECT * FROM theme

to see if a theme exists, and if so, do a:

 SELECT * FROM sys_security WHERE class = 'Intranet::Theme'

to see if you get something like:

oi=> select * from sys_security where class like '%::Theme'; 
 sid |         class    | object_id | scope | scope_id | security_level
  25 | OITest::Theme    | 1         | w     | world    | 4
  26 | OITest::Theme    | 1         | g     | 3        | 8

> Chris, thanks for the all time & effort you've put in to OI, and I hope
> all went well with your move last month.  (=

Thanks! The move went pretty well, as did the ISP migration. I'm fairly
settled now and hope to crack down on SPOPS and OI more shortly.

Chris

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