"table doesn't exist" errors after 1.3.7 install

I tried going to: butternugsquash.com/store ... and I don't see any errors

Template needs some TLC, but I see no errors...

Okay - I see what you see now. I can't get past the database upgrade in zcinstall, though. It wants my admin username & password & I'm giving it, but it says they're wrong. What might be causing THIS error?

maggiesmom1:

I can't get past the database upgrade in zcinstall, though. It wants my admin username & password & I'm giving it, but it says they're wrong. What might be causing THIS error?That's the admin username (and associated password) from the database you just loaded ... ie: your live shop.

Yeah - that's what I'm entering. I even went in & looking at the zen_admin table in phpMyAdmin & made sure what's listed under admin_name, admin_pass are what I"m entering & it still won't work.

Are you seeing your actual password under admin_pass ?
If so, you'll never get in ... because the admin_pass field is an encrypted field and thus the value there should not be recognizable. Also, entering what's in that field as the password when logging in etc will always fail.

Yup - I'm seeing the actual password. Is there a way to fix this?

Should I just drop the existing DB & re-import it?

I went ahead & dropped the database & reimported it. The admin_name is bfpvrjqf. The password is encrypted. I have tried every permutation of passwords I've ever used with that admin_name and nothing is working.

In the zcinstaller, on database upgrade page, no matter what password I enter with the bfpvrjqf name, I get 2 errors:

ATTENTION: Problems Found

* Admin Password required to proceed with upgrade more info...
* Admin Password required to proceed with upgrade more info...

They seem to be exactly the same - not sure why I'm getting it twice. Also not sure how to figure out what the stupid password is supposed to be.

All righty. It's all working now. However, it doesn't look like any of my settings have transferred over. My 800 customers are gone, my products are gone - why might that be?

maggiesmom1:

All righty. It's all working now. However, it doesn't look like any of my settings have transferred over. My 800 customers are gone, my products are gone - why might that be?

That suggests that the imported tables are empty, or else the prefix is pointing to a different set of tables, or the database-name is pointing to the wrong database, etc.

I'm sorry to be so thick, but could you tell me exactly what to check? My brain is fried.

1. database name, user, password, host in includes/configure.php

2. database prefix in includes/configure.php

3. log into phpMyAdmin and open the database with the name matching the database name from #1

4. look for the tables whose prefix starts with the prefix from #2

5. peek inside the 'customers" table (with the corresponding prefix in #2 / #4).
   See what data is in there.

That's what Zen Cart is looking at.

If it's empty, then you've got things misconfigured and therefore it's not reading the right data.

Then, go find the "real" data. Then set your configure.php settings to match the appropriate database name, user, password, host, prefix from where the 'real' data is.

Or hire someone to do it for you.