nightmere upgrading - Products not showing up in their categories

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

[immortalgames]

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.

[immortalgames]

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?

[immortalgames]

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

[immortalgames]

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

[lat9]

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

[immortalgames]

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.

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