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.

mprough:

Sounds to me like it's so large it's being corrupted in transfer... Try big dump maybe (https://www.ozerov.de/bigdump/).

~Melanie

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.

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.

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?

If this i a known issue with the script can you please direct me in the right direction.

no one seems to be replying here was it a silly question or is it best to do anouther upgrade to 2.0

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".

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.

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.

i do not since the old version of opencart are obsolete. as of the PHP versions as well.

packages are depreciated.

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.

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.

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.

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)