Product Sub-Categories do not show up, after moving products

[Ajeh]

Sure ...

Also, if you switch to the Classic Template does it work?

[Kevin205]

Sure ...

Also, if you switch to the Classic Template does it work?

Tried classic still does not show up. I will pm the path. Thank you.

[Ajeh]

Could you go to phpMyAdmin and in the table:
products_to_categories

do a search on:
categories_id

for the value:
63

what comes up?

[Kevin205]

Could you go to phpMyAdmin and in the table:
products_to_categories

do a search on:
categories_id

for the value:
63

what comes up?

SELECT * FROM `zen_products_to_categories` WHERE `categories_id`=63

resulted:
products_id 5357

[Ajeh]

If you have no Products in categories_id 63, then there should not be a record for anything with categories_id 63 ...

Check the tables:
products
products_description

for the:
products_id

5357 ... do you have any records?

From what I can see, you do not have a products_id 5357 ... so this is a bad record ...

If that is correct, then delete that record from the table:
products_to_categories

for products_id 5357 categories_id 63

and see if your subcategories are now working ...

[Kevin205]

If you have no Products in categories_id 63, then there should not be a record for anything with categories_id 63 ...

Check the tables:
products
products_description

for the:
products_id

5357 ... do you have any records?

From what I can see, you do not have a products_id 5357 ... so this is a bad record ...

If that is correct, then delete that record from the table:
products_to_categories

for products_id 5357 categories_id 63

and see if your subcategories are now working ...

That did it. Thank you.

How did you know it was products_id 5357

[mc12345678]

That did it. Thank you.

How did you know it was products_id 5357

You told her: (see below).

SELECT * FROM `zen_products_to_categories` WHERE `categories_id`=63

resulted:
products_id 5357

I couldn't remember the query/table associated, but that basically was what I was trying to guide to: a product was "associated" with the category in question, but wasn't readily identified without doing some of the ajeh magic. :)

[Kevin205]

You told her: (see below).


I couldn't remember the query/table associated, but that basically was what I was trying to guide to: a product was "associated" with the category in question, but wasn't readily identified without doing some of the ajeh magic. :)

Solved.

MC, that's why they call you guys the experts. I did not realize it.

MC and Linda, Thank you.

[Ajeh]

Thanks for the update that all is working correctly now ...