Help: Invalid Master Category

[tvadpro]

I tracked down table_customers_basket_attributes and table_customers_basket in the following files:

admin/customers.php
admin/includes/functions/extra_functions/easypopulate_functions.php
admin/includes/functions/general.php
includes/classes/shopping_cart.php
includes/database_tables.php
includes/functions/functions_customers.php
includes/modules/payment/paypalwpp.php

In the tables themselves, I noticed some of the products_id values are simple product numbers (e.g. "105") while others have an appendage consisting of a colon ( : ) followed by a few dozen characters (0 - 9, a - f) that vaguely resemble a session ID. The short values are recent.

I migrated this site about a month ago from another server, doing a clean install and then importing the database via phpMyAdmin. Maybe something got botched during the import?

[tvadpro]

Okay -- I grew myself a pair and deleted the rows in question from table_customers_basket_attributes and table_customers_basket. Apparently no harm done, and the Easy Populate warning regarding partially-deleted products is gone.

Now if I can just get the catalog to recognize master categories correctly ...

[tvadpro]

Well, it's a new day, so let's try again.

Can anyone suggest a reason why my Zen-Cart would act as if a product's master category were something other than what it is?

Seriously.
Sean

[Ajeh]

Look in your products table via phpMyAdmin at the master_categories_id for the Products ...

They should exist as categories_id in the categories table ...

They should exist as categories_id in the products_to_categories table for their respective products ...

They should be seen if you edit the Product in the Catalog ... Categories/Products ...

They should NOT be 0 ...

You should NOT see Invalid Mastere Category ID selected when you edit the Product ...

[tvadpro]

master_categories_id is correct in table products? Yes.
categories_id correct in table categories? Yes.
categories_id correct in table products_to_categories? Yes.
Product Master Category correct in Categories-Products/Edit Product? Yes.

Thanks Linda. I just re-checked all of the conditions you listed, and everything is as it should be -- yet my catalog still behaves as if the master category for p177 were 73 instead of 74. It's as if my catalog were living in the past or something.

What else could it be? And why would Reset ALL Products Master Categories ID (in Store Manager) cause the master category to change from 74 to 73?

Sean

Look in your products table via phpMyAdmin at the master_categories_id for the Products ...

They should exist as categories_id in the categories table ...

They should exist as categories_id in the products_to_categories table for their respective products ...

They should be seen if you edit the Product in the Catalog ... Categories/Products ...

They should NOT be 0 ...

You should NOT see Invalid Mastere Category ID selected when you edit the Product ...

[Ajeh]

The Reset of the master_categories_id takes the first categories_id found for the product in the products_to_categories table and makes that the master_categories_id ...

It doesn't know right from wrong ... only you do ...

If you edit the Product ... which is marked as the master_categories_id in the dropdown? You should see both, and the master should be selected ...

Check the products_to_categories table for the products_id with the problem ...

Does it only list those two?

[tvadpro]

Thanks Linda -- yes, products_to_categories lists only 73 and 74 for p177. And when I look at the Product Master Category in the product editor dropdown, it shows 74 selected. If I click the dropdown, the selections are (top-to-bottom) invalid master category ID, 73, and 74.

I tried reversing 177 - 73 and 177 - 74, but the revised products_to_categories table still sequences 177 - 73 above 177- 74.

The Rest of the master_categories_id takes the first categories_id found for the product in the products_to_categories table and makes that the master_categories_id ...

It doesn't know right from wrong ... only you do ...

If you edit the Product ... which is marked as the master_categories_id in the dropdown? You should see both, and the master should be selected ...

Check the products_to_categories table for the products_id with the problem ...

Does it only list those two?

[Ajeh]

What does the dropdown read if you click Edit on the Product without touching anything else?

[tvadpro]

It reads 74 -- as it should. But catalog treats this product as if its master category were 73.

What does the dropdown read if you click Edit on the Product without touching anything else?

[Ajeh]

Click on the C for Copy on this product and select the button for Multiple Categories Link Manager ...

Uncheck the Category that is NOT the master_categories_id ...

Click Update Category Links ...

Now re-select the Category you just unchecked ...

NOTE: only Categories with at least 1 product will show on this listing ...