|
From: Eric R. <er...@1s...> - 2002-08-20 04:21:50
|
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 |