nightmere upgrading - Products not showing up in their categories
I have done a fresh install of zc since my old php versions are no longer supported. Then restored my zc 155 database. my problem is my products do not show up in there categories on the store front, but show up on the store front as new products. also my products do not show up at all in admin area, or in categories or as products of thoses categries in admin area at all.
can somone please guide me to a fix for this.
server information/ specs and php versions can be posted upon request.
Re: nightmere upgrading - Products not showing up in their categories
Also Search funtion/ search bar returns no results
Re: nightmere upgrading - Products not showing up in their categories
Based on the steps you identified in your original post, it sounds like the zc155 database wasn't updated. Was the zc_install process run on the database?
Re: nightmere upgrading - Products not showing up in their categories
I had to do a fresh install and reinsert the zc 155 database via phpmyadmin as zc 155 was no longer supported by my php version. also had to move from mysql to mariadb.
Re: nightmere upgrading - Products not showing up in their categories
What you should have done is
- Make a copy (via phpMyAdmin) of the zc155 database (for backup)
- Copy the new Zen Cart version's files (I'm presuming zc158a, BTW) to the site.
- Copy the existing site's /includes/configure.php and /YOUR_ADMIN/includes/configure.php, making any necessary modifications to the HTTP_SERVER and DIR_FS_CATALOG settings. Make sure that the database references either the initial zc155 database or its copy.
- Navigate to yoursite.com/zc_install and let the Zen Cart upgrade script properly upgrade your zc155 database to its zc158 format.
- Rename or remove the /zc_install sub-directory.
Re: nightmere upgrading - Products not showing up in their categories
Also, how many tables are in your database? How many of them are named "admin" but with different prefixes? like "zen_admin", "admin", "v155_admin", etc? If you have more than one set of tables, chances are that your old site had a different DB_PREFIX set in your configure.php files, and your new site is using a different DB_PREFIX, so is pointing to the wrong set of data.
What lat9 said above is how to avoid such a situation.
If you do have 2 sets of tables, look at the old site's configure.php file to see the DB_PREFIX and set your new site's configure.php files (both of them) to use the same DB_PREFIX as the old site. Then you'll need to re-upload the v158 zc_install directory and run zc_install to upgrade your data.
And then of course delete zc_install when done. And use phpMyAdmin to delete the "wrong" set of database tables that you had created by doing the "fresh" install of 158 with the wrong prefix.
Re: nightmere upgrading - Products not showing up in their categories
thank you for the quick replys btw. there in no db prefix for the database, what i will do is give you a clearer look at what may be going on. there may be a missing table in sql or a change in something. im going to post specs and more info as this may help other people as well with a smother upgrade process.
Re: nightmere upgrading - Products not showing up in their categories
Re: nightmere upgrading - Products not showing up in their categories
Re: nightmere upgrading - Products not showing up in their categories
