Database appears blank after upgrade (but it's not)

Hello! My host upgraded their PHP and that caused my Zen Cart to break, so I upgraded to the new version. I went through the steps of upgrading my database, too.

Now none of the information in my database is displaying (products, customer records, reviews, etc)--either in the admin area or in the store. When I view the database in notepad, the information is still there, so I feel like I must've missed a step or something to get it to recognize the data.

I've been working on this for a week, and have consulted the forums lots of times (and have learned lots about this great program--thanks!) but so far nothing I've tried has worked. I've also started from scratch a couple times, but that doesn't mean I'm not missing something completely obvious.

I'll be very grateful for any advice!

Thanks,

Gezzyka

What do you mean by
"When I view the database in notepad, "

Also, can you go to phpmyadmin and see if the database tables are populated
Thanks
San

If the database contains no products in the admin side, then it's possible that you haven't imported the data properly.

You haven't detailed all the steps you've taken, and probably cannot, since you've been doing it over a lengthy period of time.

Try this:
0. make sure that the DB_PREFIX in your old configure.php is also in your new configure.php files.

1. backup the existing database just in case.
2. import your old database into the new database
3. you should now see errors in your store
4. run zc_install/index.php and choose "Database Upgrade" ... NOT "Install".
5. Follow the prompts for upgrading the database to new structure.

Hi superprg,

Thanks for the response!

When I log into phpmyadmin and looked up the "zen_products_description" there are indeed product names and descriptions there of my products. (Since my host's upgrade, phpmyadmin has taken forever to load everything so I haven't been using it at all when I can help it.)

What do you mean by
"When I view the database in notepad, "

Sorry, I meant that when I download the backup and then view it in notepad, there's data there :-).

Thanks,

Gezzyka

Hi DrByte,

Thanks for the response! You're right, I don't really remember what all I've done--I probably should have been taking notes, but kept feeling like, "This will fix it!" :-)

Thank you for these steps, I'll go through them right now and post back with what happens.

All my best,

Gezzyka

gezzyka:

(Since my host's upgrade, phpmyadmin has taken forever to load everything so I haven't been using it at all when I can help it.)Does your host know about this? What are they doing about it?

And what about the table
zen_products?

Hi DrByte,

That fixed it! Thank you so much. (And I was afraid I'd missed something simple--looks like I copied/pasted the DB_PREFIX from includes\configure.php incorrectly...)

I haven't mentioned the slowdown at phpmyadmin to my host yet--but you're right, I definitely should. (I've only ever really used it to restore backups, so avoiding it hasn't been a big deal.)

I feel like a dolt, but it's wonderful to have everything working again! Thank you so much!

Gezzyka

Thank you so much for your help, superprg! I really appreciate your help with this.

All my best,

Gezzyka

Yikes, it appears I spoke too soon! The products are now displaying on my store page, but not anywhere in the admin menus... I was working on getting the template to display nicely again and didn't realize that the products and customers aren't listed anywhere among the admin lists.

Any suggestions?

Thanks,

Gezzyka

gezzyka:

Yikes, it appears I spoke too soon! The products are now displaying on my store page, but not anywhere in the admin menus... I was working on getting the template to display nicely again and didn't realize that the products and customers aren't listed anywhere among the admin lists.

Any suggestions?

Thanks,

Gezzyka

Please post
admin\includes\configure.php
without passwords
Thanks

Thanks superprg! Your question seems to have gotten it fixed--I've gotten so confused about which file is the original and which is the new one and have about 10 backups on my hard drive right now... It looks like in the process of uploading the new configure.php file in one place, that I uploaded an old one into the admin folder (that's what I get for working on my templates while also trying to get everything working again...) One of these days I will learn to stop multi-tasking.

So, now it appears that the database information is displaying both for the admin and in the shop itself. Next I get to start playing with the new templates :-).

Many, many thanks to both of you. I can't tell you how much I appreciate all your help!

All my best,

Gezzyka