[ic] userdb Oddity

[Mike Heins]

Quoting Marty Tennison (marty@sediva.com):
> > Orko wrote on Monday, April 08, 2002 4:03 PM
> >
> > I'm trying to understand why the following situation is happening:
> >
> > 1) user logs into our site and fills out an order form with
> > name, phone
> >    number, etc.  Their data is saved into the userdb
> > correctly by using
> >    a [userdb save] on the receipt.
> > 2) user calls us and says that they mispelled their email
> > address, and
> >    would like us to change it
> > 3) I go into the userdb (MySQL) and change his email address to the
> >    correct spelling, verifying that it is correct afterwards with a
> >    lookup of his correct and non-correct email addresses.
> > The correct
> >    one is there, the non-correct one is not.
> > 4) The user goes back into the site, and their email address that is
> >    displayed to them after they log in is the non-correct
> > spelling... He
> >    calls back, so I check the userdb, and their email address has
> >    changed back to the old spelling!  The correct one is not present
> >    anymore...
> >
> 
> --- [snip] ----
> 
> Hi Orko,
> 
> Are you updating the database by command line or some other utilty?
> If so try making the changes using the Interchange menus in the Admin
> section and see if that fixes your problem.   What it sounds like is
> you are upding the tables but the userdb.txt file in the products
> directory is not getting updated.

No, I think what is needed is to have the user log out then log back
in again.

Nothing about changing the database changes their session. When they
place an order, the old email address in their order form is submitted,
saved into the user database, and overwrites the changed one.

-- 
Red Hat, Inc., 3005 Nichols Rd., Hamilton, OH  45013
phone +1.513.523.7621      <mheins@redhat.com>

Light travels faster than sound. This is why some people appear bright
until you hear them speak. -- unknown