Database

[autowire]

I'm having problems getting an old database to load with a new install. When I look at the database it has duplicate files and I'm wondering if this is the reason it does not load.

All of the files are there and then duplicated with Zen in front of them.

Example:
products
zen_products

When I view "products" all I can see is field, type, collation, etc. but when I view "zen_products" I can see my product listing id, type, model, etc.

Do I need to delete the files that don't have zen in front of them?

Thanks for any help.

[RodG]

I'm having problems getting an old database to load with a new install.

Technically speaking, a database isn't 'loaded' - parts of it are retireved on demand.

When I look at the database it has duplicate files and I'm wondering if this is the reason it does not load.

This isn't really a question that has an answer.. "Does not load" doesn't mean a geat deal to most of us. "Cannot be accessed" is "is accessing the wrong data" are two possible complaints that doe make sense.

All of the files are there

This of course is an assumption (probably quite a solid one), but nonetheless it is still an assumtion... can you actually SEE the files that are NOT there?

and then duplicated with Zen in front of them.

Example:
products
zen_products

This tells us that there is in inconsistancy with your installations. Although you used the same database name and logon details with both installs, with one of the installs you left the default 'zen_' prefix, and the other install you had no prefix at all. No one can tell you which is the 'right' one, because they are both 'right'.

When I view "products" all I can see is field, type, collation, etc. but when I view "zen_products" I can see my product listing id, type, model, etc.

This suggest that 'products' is the newly installed table, and the 'zen_' tables are your originals. .

Do I need to delete the files that don't have zen in front of them?
Thanks for any help.

At this stage you shouldn't be considering deleting anything (why do so many think that delting files will solve problems?)

Both sets of tables can happily co-exist - You just need to ensure that the application (in this case, zencart) is using the tables that contain the data that you want. In your case, it means editing the zencart configuration files so that it is going to look for the tables with the "zen_" prefix (because that is the one you know contains your data).

Hopefully this makes sense?
If not, edit your two config files so that
define('DB_PREFIX', '');
reads
define('DB_PREFIX', 'zen_');

Cheers
Rod

[autowire]

Rod,

Thanks for your insight. Please excuse my poor terminology as I am pretty new to zen and probably shouldn't be doing this myself. Unfortunately I can't afford to pay someone at this time to do this for me.

I changed the DB_PREFIX to "zen_" as your suggested but my site still doesn't access the db information I would like it to. Do you have any other suggestions?

Thanks for you help
Dave

[autowire]

Rod,

I figured it out. I didn't change permissions on one of the files before I changed it.

Thanks again.
Dave