-
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
-
Re: nightmere upgrading - Products not showing up in their categories
Quote:
Originally Posted by
immortalgames
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.
I *have* read all of the other posts, but the linked database data is no longer available for perusal (hopefully it did not include customer data). I don't see though, what process was used to obtain the "backup" of the previous/old database to be able to indicate whether a step (option) was missed in backing up the database, if a table did not get restored, if a table existed and did not get its data replaced or if in adding data from the recovered database new record designations were assigned that caused a loss of correlation between product and category.
In the more recent versions, queries were modified to require relationships to exist in order to retrieve results as compared to older versions that allowed a lapse of relationship within the admin. At least in the older versions, data could be retrieved and issues corrected by pushing the correct relationship where found to be broken. Now, unexpected results occur which requires one to dig into the database more in order to resolve the issue.
As you show in your images, in the admin there appear to be product and there appear to be categories. On the catalog side, there appear to be product in categories.
From those conditions, it appears to me that product have master_categories assigned, categories exist, but the table products_to_categories does not have appropriate information to represent the product/category relationships.
If that is true, there are ways to restore the relationships using one or more sql queries at least to restore primary relationships with linked product to be rebuilt separately. Such would be simpler if that table is/was in the 155 version of the sql.
-
Re: nightmere upgrading - Products not showing up in their categories
Thank you for your swift reply, this helped heaps. (products_to_categories) in SQL had not executed correctly from the 1.55 database as this is a huge database, did take me awhile to copy just that one table from the database but however fixed the issue so it was worth it. thank you very much for this. im going to painstakingly go through the rest of the database for any other error but in all very pleased with the result. updating or moving PHP or SQL versions/ SQL processors is painfull when you have long term working website. will message again if anything.
Thank you again guys for your help.:cool:
-
Re: nightmere upgrading - Products not showing up in their categories
im still having an issue with products not showing up with a name, and in turn not showing up in search or inorder to edit them in the admin area.
-
Re: nightmere upgrading - Products not showing up in their categories
If you'll do a database export (via phpMyAdmin) and PM me a link to where I can download that, I'll see what I can see.
-
Re: nightmere upgrading - Products not showing up in their categories
I have PM-ed you thank you
-
Re: nightmere upgrading - Products not showing up in their categories
Quote:
Originally Posted by
immortalgames
I have PM-ed you thank you
Got it!
On initial inspection, I see that the site has one language (english), 9626 entries in the products table and 1290 (!) entries in the products_description table. I'm pretty sure that for a product to be considered as valid, it needs to have an entry in both of those tables (as well as others).
Any ideas as to where those other 8336 products' descriptions disappeared to? Do you have a backup of the current/previous site's database?
-
Re: nightmere upgrading - Products not showing up in their categories
yes, what i will have a look and PM you back. thank you
-
Re: nightmere upgrading - Products not showing up in their categories
Quote:
Originally Posted by
lat9
Got it!
On initial inspection, I see that the site has one language (english), 9626 entries in the products table and 1290 (!) entries in the products_description table. I'm pretty sure that for a product to be considered as valid, it needs to have an entry in both of those tables (as well as others).
Any ideas as to where those other 8336 products' descriptions disappeared to? Do you have a backup of the current/previous site's database?
just a quick question is there an easier way of filling the products with no description with a generic entry for example ("no description") with a sql querie that way i can at least see the product for editing
-
Re: nightmere upgrading - Products not showing up in their categories
Assuming that you can get to phpMyAdmin or some other database tool then the following will insert a product name of "No Name" which will allow you to see and edit the missing product details. Please back up the database before using this command.
Code:
INSERT IGNORE INTO products_description SELECT products_id, 1, 'NO Name', Null, Null, 0 FROM products;
Note:
1. If you use a table prefix then you will need to add the prefix to the table names. i.e. id you use "ZEN" then command will be.
Code:
INSERT IGNORE INTO ZEN_products_description SELECT ZEN_products_id, 1, 'NO Name', Null, Null, 0 FROM products;
2. You will see a lot of errors because there are some products already with names. These will not be overwritten.
3. If you have the old database you would be better to export the products_description table and import to your new database.
-
Re: nightmere upgrading - Products not showing up in their categories
Sounds to me like it's so large it's being corrupted in transfer... Try big dump maybe (https://www.ozerov.de/bigdump/).
~Melanie
-
Re: nightmere upgrading - Products not showing up in their categories
you're going to fix 8,000 product description records this way?
I would start looking at old database backups and see which ones have good data for this table.
-
Re: nightmere upgrading - Products not showing up in their categories
Quote:
Originally Posted by
mprough
I was thinking that was the exactly the problem as i started exicuting from 1290 product_description only and had fixed that specfic problem. now the issue seems to be adding new products. when i do this it conflics with older products and atemps to overwrite them.
-
Re: nightmere upgrading - Products not showing up in their categories
Quote:
Originally Posted by
swguy
you're going to fix 8,000 product description records this way?
I would start looking at old database backups and see which ones have good data for this table.
now the issue seems to be adding new products. when i do this it conflics with older products and atemps to overwrite them.
-
Re: nightmere upgrading - Products not showing up in their categories
Quote:
Originally Posted by
immortalgames
now the issue seems to be adding new products. when i do this it conflics with older products and atemps to overwrite them.
Any idea how to fix this problem. or where i should look?
-
Re: nightmere upgrading - Products not showing up in their categories
If this i a known issue with the script can you please direct me in the right direction.
-
Re: nightmere upgrading - Products not showing up in their categories
no one seems to be replying here was it a silly question or is it best to do anouther upgrade to 2.0
-
Re: nightmere upgrading - Products not showing up in their categories
Quote:
Originally Posted by
immortalgames
no one seems to be replying here was it a silly question or is it best to do anouther upgrade to 2.0
It's just that your method of upgrading seems to be non-standard and the way you added those products appears to be one of the root causes.
There are a bunch of database tables that reference a particular product and it appears that you've not populated those additional tables "properly".
-
Re: nightmere upgrading - Products not showing up in their categories
My database is so huge that it is difficult to locate everything regarding to products and product IDs (bunch of database tables that reference a particular product)
Can you name all of them so I can find where they all are, and know which ones are fully being executed and which ones are not. As i have over 9000 products in my database. there was a tool mentioned above but I can always do it in increments in phpmyadmin.
-
Re: nightmere upgrading - Products not showing up in their categories
Don't you have a working backup of the old zen cart version?
Then just use the default method as has been already said.
9000 products isn't that much.
Just make the proper PHP settings to let phpmyadmin upload and execute the uploaded database without interruption.
-
Re: nightmere upgrading - Products not showing up in their categories
i do not since the old version of opencart are obsolete. as of the PHP versions as well.
-
Re: nightmere upgrading - Products not showing up in their categories
packages are depreciated.
-
Re: nightmere upgrading - Products not showing up in their categories
Quote:
Originally Posted by
Shop Suey
Don't you have a working backup of the old zen cart version?
Then just use the default method as has been already said.
9000 products isn't that much.
Just make the proper PHP settings to let phpmyadmin upload and execute the uploaded database without interruption.
Quote:
Originally Posted by
immortalgames
i do not since the old version of opencart are obsolete. as of the PHP versions as well.
I believe that Shop Suey was referring to your old (zc155) database. If you simply
- Create a new database in your hosting account (you'll need the database credentials, i.e server name, user name, user password and database name)
- Put a fresh (i.e. unmodified) version of the zc201 code into the file system
- Run the zc_install process, letting that process create your /includes/configure.php and /admin/includes/configure.php based on the current file-system path and database credentials.
- Via your webhost's phpMyAdmin, DROP all database tables in the newly-created database and then import the zc155 copy of the site's database (you'll need to know a Zen Cart admin user and password for the subsequent update).
- Re-run the zc_install process. You should now see an 'Update" path and entering the aforementioned admin id/password, the zc_install processing will update that database in steps from zc155 to 156 to 157 to 158 to 200.
-
Re: nightmere upgrading - Products not showing up in their categories
Quote:
Originally Posted by
lat9
I believe that Shop Suey was referring to your old (zc155) database. If you simply
- Create a new database in your hosting account (you'll need the database credentials, i.e server name, user name, user password and database name)
- Put a fresh (i.e. unmodified) version of the zc201 code into the file system
- Run the zc_install process, letting that process create your /includes/configure.php and /admin/includes/configure.php based on the current file-system path and database credentials.
- Via your webhost's phpMyAdmin, DROP all database tables in the newly-created database and then import the zc155 copy of the site's database (you'll need to know a Zen Cart admin user and password for the subsequent update).
- Re-run the zc_install process. You should now see an 'Update" path and entering the aforementioned admin id/password, the zc_install processing will update that database in steps from zc155 to 156 to 157 to 158 to 200.
I have already done this process upgrading from 155 -158
simply put i just want to know every table refrencing to product disriptions, IDs. any table that refrences to any product in the database. so i can do i side by side and see what was, and what wasnt inproted. the reason im asking of this is so i can can easly find and do a side by side.
Example (CTRL F) and see if the numbers match up.
Code:
ZEN_products_description SELECT ZEN_products_id,
there might be a table for products that does not have the word product init.
(all them lines of SQL give me a head ache)
