Bizzare Caterories / Sidebox Problem

I just activated my categories sidebox and noticed that it is only showing 37 items instead of 166.

My items are organised in this way

Main category

Sub Cats A, B, C, D

Sub Cats A & B have items in them

Sub Cats C & D have two further sub cats each ... C1, C2, D1 & D2 with items in them.

Now I notice that the categories box is only showing that I have items in A & B and if I try to navigate to C1, C2, D1 or D2, I get a message saying there are no items to list there.

The items are however in the products table and the products to categories table has a full complement of items.

I can add items in C1, C2, D1 or D2 to the cart and chackout if I navigate to them directly using the product id but if I go to the index page and look for these items and click, I get a page not found error.

Also, C1, C2, D1 & D2 turns up empty in the admin.

Can anyone point me to what is likely messed up?

Thanks

I got lost at the stop sign ... :lamo:

Have you an URL that we could perhaps peek at to see what is up here? :smile:

Hi

:oops:

Thanks for the response.

Sent you the url.

All waht the long winded explanation meant to say was that in the categories sidebox in the catalogue and the attributes controller in admin, items in subcats nested more than two layers from the main categories do not appear even though they are in the catalogue.

The sidebox shows 37 items but if you click on all items, you will find there are 166.

Do you import your products?

Do you have Products and Categories mixed inside the same Category?

Do you use Linked Products?

Do you import your products?
I use the gallery 2 bridge I have been working on here:
Do you have Products and Categories mixed inside the same Category?
No. Just one category and one or two layers of subcats with the images in those
Do you use Linked Products?
Not sure what those are but some images appear in more than one album in G2. I.E. linked in G2.

My items aren't really for sale and I only just reinstalled ZC to work further on the G2 bridge and the moneybookers module for others that might need these (you might have read my rants against you senior folk here lol).

I haven't had the sidebox up for several versions of the bridge although I know it worked fine before. I guess I'll have to iteratively install versons of the bridge to see where it broke.

When I manually look in the products to categories table, I can see all the items are properly mapped to categories.

If I knew what file controls the display, I could avoid the pain.

Things just don't make sense on the data ...

Check the number of records in:
products
products_description
products_to_categories

If you do not use Linked Products, then these should match ...

Also check that these two tables have the same number of records:
categories
categories_descripton

products table = 166 records
products_description = 166 records
products_to_categories = 166 records

If you do not use Linked Products, then these should match ...

Also check that these two tables have the same number of records:
categories = 16 records
categories_descripton = 16 records

So everything looks as it should.

However, when I look at the contents of products_to_categories, I notice that the category ids entered are different for most products from the actual ids in the categories table.

This has to do with the G2 Bridge (I forgot the link before: http://gallery.menalto.com/node/69302)

Thanks for helping me track the issue down.

That is what I am seeing that the categories_id do not match so I am not sure what your code is doing on this as I do not use it ...

Ajeh:

That is what I am seeing that the categories_id do not match so I am not sure what your code is doing on this as I do not use it ...

Thanks. Now that I know where the issue has come from, I can tackle it.

Cheers!

Solved.

This was a G2 to ZC Bridge specific issue and an update of the bridge will be posted on the G2 site presently.

Thanks for the update and glad that you found the source of the problem ... :smile:

I have just added extra pages to my "more information" box ie. page_5 , page_6 , page_7 , page_8.

page_5 and page_6 work perfectly.

page_7 and page_8 give the following messages when clicked on.

Warning: main(includes/templates/template_default/templates/tpl_page_8_default.php) [function.main]: failed to open stream: No such file or directory in /home/tidytoys/public_html/shop/includes/templates/template_default/common/tpl_main_page.php on line 120

Warning: main(includes/templates/template_default/templates/tpl_page_8_default.php) [function.main]: failed to open stream: No such file or directory in /home/tidytoys/public_html/shop/includes/templates/template_default/common/tpl_main_page.php on line 120

Fatal error: main() [function.require]: Failed opening required 'includes/templates/template_default/templates/tpl_page_8_default.php' (include_path='.:/usr/lib/php:/usr/local/lib/php') in /home/tidytoys/public_html/shop/includes/templates/template_default/common/tpl_main_page.php on line 120

I thought that Id been cloning all the pages as I went along, so Im a bit perplexed as to why two work and two dont.

website is http://www.tidytoys.co.uk

Do a search in the Tools ... Developers Tool Kit ... for:
page_3

Look at what files come up and where ...

Then do a search on:
page_7

what is different between the two? Did you miss a language file or anything like that?

Hi Linda,

Id been using the developers toolkit approach from the start and everything seemed to match up ok.

After your memo I thought I would check again and spotted the problem .... the 7 & 8 filenames were named
tpl_page_8.default.php instead of tpl_page_8_default.php

One of the filenames mentioned in the warning messages had coding mentioning a bannerSix and there wasnt a mention of a bannerSeven or bannerEight .... so I thought this might be what the problem was ... Im rather glad it turned out to be this simple.

I also did all these changes for my friends website too and all hers worked, but she has a different zen cart version !

Thank you Linda :smile: