catalog Product/categories entries gone

[maperr55]

HI Ajeh,
Thank you for the reply and help.
I switched it and the results was the same.

The Auto repair work folder has ID 1
The Cycle work folder ID 2

the cycle work folder has nothing in it at this time.
The Auto Repair work folder reports 2 of 4 active.
When you enter it you see nothing 0 categories, 0 Products. except the message
NOTE: Category has SubCategories
Products cannot be added.
This was happening in the 1.3.9 version of the cart. I hoped the upgrade would fix it, alas no luck.
Just not sure which way to go from here.
Thank You,
Mark

[Ajeh]

Can you see any of your products in the Admin?

If not, if you do a search in the Admin, do you see any of your products?

Do you import your Products?

How many Products do you think you have?

If you go to phpMyAdmin and look at your database ...

How many records are in:
products
products_description

categories
categories_description

products_to_categories

[maperr55]

Hi Ajeh,
Thanks for the reply, sorry it took a bit to get back to this. When you where all the hats in a company it can get a bit hectic at times.

Can you see any of your products in the Admin?

NO

If not, if you do a search in the Admin, do you see any of your products?

YES, search takes me to the products showing on the front side

Do you import your Products?
NO

How many Products do you think you have?
2 folders in category, none in one and it says 2 of 4 in the other, but I think their are only suppose to be 2.



If you go to phpMyAdmin and look at your database ...

[B]How many records are in:

products
Looks like 5 records I have prod ID on 5 lines 1-5

products_description

5

categories
0-82 83 total
categories_description
4
products_to_categories
5

As I stated I thought the problem lies within the DB and looking at the difference in these different items if they are suppose to match might explain the problem. Now just what to do to correct it?
Thank you,
Mark

[Ajeh]

One of the main problems is you have:
categories
0-82 83 total
categories_description
4

with only 4 categories_descriptions you are not seeing the other categories ...

This makes it hard to know where the Products really belong ...

[maperr55]

Hi Ajeh,
Yeah, I saw this number here and went this can't be right.
What do you think I should do to right the ship and get it so I can use this thing again?
Thanks,
Mark

[Ajeh]

If you look at the table:
categories_description

can you find a match to each of the categories_id that are in the table:
categories

If so, delete from the table:
categories_description

and record that does not have a match in the table:
categories

Next, look in the table:
products_to_categories

and make sure that the field:
products_id
categories_id

are valid for the Products in:
products

and for the Categories in:
categories

[maperr55]

HI Ajeh,
Thank you for the reply and help. I will pick through these and see what happens.
Thanks,
Mark

[maperr55]

HI Ajeh,
Thanks for the help and advice. I went through and removed all the miss matches, what a mess. In removing all the garbage I lost my 2 categories so I decided to remove them all and clean things up and re-created the categories. The messages for the product in categories error is gone and I was able to create new categories folders and add items to them. I allow my customers to add their items to the cart boy I wish I new what they did to mess up the DB this bad.
Thanks for your help and incite.
Mark