Sub-Categories not showing

**Cheeky Chino** · 18 Jul 2007, 05:39 AM

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

**Cheeky Chino** · 18 Jul 2007, 05:50 AM

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

**Ajeh** · 18 Jul 2007, 05:55 AM

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

**Cheeky Chino** · 18 Jul 2007, 06:10 AM

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.

**Cheeky Chino** · 18 Jul 2007, 06:17 AM

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

**Cheeky Chino** · 18 Jul 2007, 06:24 AM

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

<?php
//if (PRODUCT_LIST_CATEGORY_ROW_STATUS == 0) {
// do nothing
//} else {
// display subcategories
/**
* require the code to display the sub-categories-grid, if any exist
*/
require($template->get_template_dir('tpl_modules_category_row.php',DIR_WS_TEMPLATE, $current_page_base,'templates'). '/tpl_modules_category_row.php');
//}

Should i look at another fix or will this be fine?

**Ajeh** · 25 Jul 2007, 05:21 AM

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 ...

**HiPCTech** · 9 Aug 2007, 02:04 AM

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** · 9 Aug 2007, 02:47 AM

Originally Posted by 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