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

[Eric R. <er...@1s...>]

On 19 Aug 2002, Chris Winters wrote:

> 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,
>

I increased sys_error.filename to varchar(120), and now the error is
getting logged properly.  Looks like I have a rather long path to the OI
libs that was snagging it:  "/usr/local/lib/perl5/site_perl/5.6.1/\
OpenInteract/Session/DBI.pm".  I guess most people install perl in
/usr/lib.  (=

I'm going to set this to varchar(80), now that I know what it was trying
to squeeze in there.

> >  --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:
>

. . and you were right.  I noticed that the only theme present had a
theme_id of 4, which didn't match up to the object_id's returned by the
query you had me do on the sys_security table.  I set this to 1, and it
fired up!

Now, I kinda suspect this might have something to do with the fact that
this site used to use MySQL as a main datasource.  I just changed it over
to PgSQL and ran "oi_manage --package=INITIAL install_sql" again.  Does a
counter for theme_id get stored somewhere within $WEBSITE_DIR?  Can you
think of any other way this might have happened?  I've been doing a lot of
playing around with oi_manage + installing/removing/upgrading packages, so
it's very possible I just did something you're not supposed to do along
the way.

Thanx.

-----
 Eric Reeves - Network / Systems Administrator
 1st Contact Technologies - 281.333.1444