Sub-Categories not showing

Hi Guys,

I've had a previous install of ZenCart 1.2.6 i think and just installed the latest. Setting up new tables for the new ZenCart.

I've tried copying over what i could from the 1.2.6 database tables to the 1.3.7 database tables but I have a problem where my sub categories arn't showing.

Link: http://rewards2.pacific.net.au

The main categories to the left work, but when you click on them there are no sub categories. I can view the categories and sub categories and products in the admin catalogue section.

Any ideas?

Is there any way i can turn on a debug mode or something?

Thanks
Chino

Also, i can view all my products when i search or go to View All. Looks like the categories are not coming out right.

Reload the files:
/includes/templates/template_default/templates/tpl_index_categories.php
/includes/modules/pages/index/main_template_vars.php
/includes/templates/template_default/templates/tpl_modules_category_row.php
/includes/modules/category_row.php

Just reloaded those files and still not working.

I think it would have something to do with the database. But can't find where, or what it is.

Just created a new sub-category through the admin section. Even that new category didnt show.

OK i just commented out the following and now my categories are showing. Not sure if i should leave it like this.

/includes/templates/template_default/templates/tpl_index_categories.php

Switch to Classic Template ... does it work now?

Do you have both Products and Categories in your Categories?

Categories hold Products or Categories but never both ...

Depending on how you added your products ... do all products have a master_categories_id in the products table? This can be viewed in phpMyAdmin ...

Hello Linda,

I was wondering how do I add or update the master_categories_id ?
I added my products with Easy Populate and all the master_categories_id are set to 0.
Thanks.

HiPCTech:

Hello Linda,

I was wondering how do I add or update the master_categories_id ?
I added my products with Easy Populate and all the master_categories_id are set to 0.
Thanks.

Sorry Linda,
The Lord answered my prayers led me to this post: Here

Where DrByte tells how to reset the master_categories_id. so it is all solved!

Praise the Lord :smile:

The ol' missing the master_categories_id trick eh?! :lamo:

I have a website that when clicking on the category link, it does not show the subcategories either.

Website is at https://www.shearadiance.com

So far, I have:
Deleted and reloaded all the following pages
/includes/templates/template_default/templates/tpl_index_categories.php
/includes/modules/pages/index/main_template_vars.php
/includes/templates/template_default/templates/tpl_modules_category_row.php
/includes/modules/category_row.php

I tried commenting out the lines in the post above here

I have reset the master categories id

I have switched to the classic template - still the same problem

I have pulled a wad of hair out of my head :blush:

This is version 1.3.8.a

Can anyone help me resolve this situation? I am sure it is something really simple, because I do not have this problem on other 1.3.8a sites I have built... just cant figure out WHAT that simple solution is.

THANKS in advance for any help!

I forgot to mention that this site was upgraded to 1.3.8a - so wondering if this could be a database problem?

If anyone else has this problem, hopefully they will find this thread and be able to get some help from it.

I finally figured out (after hours of troubleshooting and rebuilding databases, etc) that the reason the sub-categories did not show up when the category name was clicked was because under Product Listing - the very last item - Show SubCategories on Main Page while navigating - was set to 0. I set it to 1 and it now displays properly.

Hours and hours lost - when all that was needed was to click a button in the admin. :frusty:

Hope this helps someone else!