Site maintenance: Tuesday 17 Nov, from 10:00 UTC, about 4–6 hours. Details

This cutover relies on some testing that is still incomplete so may be cancelled at short notice

Forums / Setting Up Categories, Products, Attributes / Sub-Catagories missing in Middle of Page

Sub-Catagories missing in Middle of Page

Locked

Started by theohiobloke on 4 Jan 2007, 5:17 AM · Views: 1,124

Results 1 to 5 of 5
This thread is locked. New replies are disabled.
4 Jan 2007, 5:17 AM
#1
theohiobloke avatar

theohiobloke

New Zenner

Join Date:
May 2005
Posts:
6
Plugin Contributions:
0

Sub-Catagories missing in Middle of Page

I have imported 293 products from a text file using EP.

The problem is that although the sub-catagories appear in the menu at left, the do not appear in the box at the top of the page that shows sub catagories (and images if they have one) .

Right now it just says

There are no products to list in this category.

All the other main catagory pages show sub-catagories in both the sidebox and the main part of the page.

I looked and there is a thread about restricting to document-general but that does not do anything for my problem.

I have looked at the Easy Populate dump and compared it to what I inserted and they are exactly the same.

Any insights on how to fix this .

https://www.holisticvitamins.com/cart/

thanks in advance

4 Jan 2007, 11:56 AM
#2
kobra avatar

kobra

Black Belt

Join Date:
Aug 2005
Location:
Arizona
Posts:
31,500
Plugin Contributions:
4

Re: Sub-Catagories missing in Middle of Page

Taking a quick look I would venture to say that they have not been entered correctly/fully in the DB

You have other cats that are working....Look at ALL the DB entries for one of these and compare to what you have for the one not functioning. Insure that the indexes are there and correct

Zen-Venom Get Bitten

4 Jan 2007, 12:02 PM
#3
theohiobloke avatar

theohiobloke

New Zenner

Join Date:
May 2005
Posts:
6
Plugin Contributions:
0

Re: Sub-Catagories missing in Middle of Page

OK so if I look at the tables in phpMyAdmin I should be able to compare indexes?

Please can you let me know which tables to look at in MySQL?

thanks

John

4 Jan 2007, 12:43 PM
#4
kobra avatar

kobra

Black Belt

Join Date:
Aug 2005
Location:
Arizona
Posts:
31,500
Plugin Contributions:
4

Re: Sub-Catagories missing in Middle of Page

Without knowing what you have done already look at these for one that works and most probable it is that you might have omitted or incorrectly entered the products_to_categories links

categories
categories_description
meta_tags_products_description
meta_tags_categories_description
products
products_description
products_to_categories

Actually, for the one that does not work this is the path: product_info&cPath=104_105&products_id=1415

and one that works is: product_info&cPath=102&products_id=458

Zen-Venom Get Bitten

4 Jan 2007, 2:34 PM
#5
ajeh avatar

ajeh

Oba-san

Join Date:
Sep 2003
Location:
Ohio
Posts:
62,757
Plugin Contributions:
1

Re: Sub-Catagories missing in Middle of Page

You appear to have both Products and Categories in some of your Categories ...

Categories hold Products OR Categories but not both or things will not work correctly ...

Linda McGrath
If you have to think ... you haven't been zenned ...

**Did YOU buy the Zen Cart Team a cup of coffee and a donut today? Just click here to support the Zen Cart Team!!**

Are you using the latest? Perhaps you've a problem that's fixed in the latest version: [Upgrade today!]
Officially PayPal-Certified! Just click here

Try our Zen Cart Recommended Services - Hosting, Payment and more ...
Signup for our Announcements Forums to stay up to date on important changes and updates!