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

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

On Mon, 19 Aug 2002, Eric Reeves wrote:

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

Now that it's up and running, I attempted to login and noticed the
superuser account isn't working.  I can log in, but I don't get any of the
admin boxes, and when I click 'Edit my info', it attempts to look up
user_id 4.  I must have done something 4 times more than I should have to
get all of these counters to increment.  I figured as much.

I'm going to wipe out the database & website directory in the morning, and
start from scratch.  I'm pretty sure that'll take care of it, but I'll let
you know what happens.

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