database upgrade password problem

[bminister]

OK, when you enter your username and password which button do you press? What error do you see?

[trdlasvegas]

OK Thanks Guys, I found it!!!

When I exported my old database and imported it into my new database it created a duplicate set of fields EXCEPT one admin field had the old username and password and the other had the new username and password.

The database update program was looking at the old one while the admin section I been logging in and out was using the new one.

I think it may be time to correct the database errors before I go on.

Thanks for suggesting to look at that bminster!!!

Tony

[bminister]

:) It was a really interesting zen cart case.

[bminister]

Actually you don't need to create/delete/merge the store database when you want to upgrade your zen cart version. Just run your-store.com/zc_install and follow the database upgrade instructions.

[DrByte]

Actually you don't need to create/delete/merge the store database when you want to upgrade your zen cart version. Just run your-store.com/zc_install and follow the database upgrade instructions.

Actually, yes, you do, if you're following the published upgrade procedures correctly, since they involve setting up a second database, installing a clean new ZC, which creates empty tables, and then importing the old data and running the database-upgrade step.

Be careful how you're instructing people about doing upgrades. Your comment suggests that you'd recommend they upgrade a live site directly, which is a VERY BAD IDEA.

[bminister]

Thanks!
Does it mean that the direct database upgrade won't work? (Of course the back up is always available)

[DrByte]

What it means is that you're not following official instructions. Thus you're throwing caution to the wind. And in such cases it's dangerous to be making suggestions to others when they're contrary to the recommended method as posted by the Zen Cart developers.

[DrByte]

When I exported my old database and imported it into my new database it created a duplicate set of fields ...

Yes, that can be a very serious problem, not with just *that* table, but with *all* your tables.
If you're going to import a database, you should DROP all the existing tables FIRST before importing. That's assuming you're really wanting to replace the old data. Of course, do backups before doing any dropping or importing.

I think it may be time to correct the database errors before I go on.

Absolutely.