After Upgrade All Products Blank Page

Hi,

I have just upgraded from v1.3.8 to 1.3.9d and the upgrade went very well - thanks to the Zen Cart Team for good instructions!!

The only minor glitch is when I click on the "All Products" category on the left sidebox, the page comes up with the header, etc. but displays no products. It was working in my old cart.

I have checked the Config->All Listing Page, and all of the parameters are the same as my old store with sort orders, etc. Does someone have an idea about where to look to "turn on" this so that the products display in this area.

Thanks in advance,

In your Zen Cart Admin, do you see all of the Categories and Products?

In phpMyAdmin, how many records are in the tables:
products
products_description
products_to_categories

categories
categories_description

If you browse the products table, do all of the products have master_categories_id values? 0 is not a valid master_categories_id ...

Hi Ajeh,

Yes, in Zen Cart Admin when I click on Catalog->Categories/Products are all of the Categories and Products are there, and show up fine in their respective places on the site (https://www.nitwitcollections.com).

In the myPHPAdmin under the products master_categories_id I see "Type" is int(11) then "Null" is No and "Default" is 0. Is this the 0 that you are referring to? What should this be changed to in our to make them show?

Thanks for your help.

Hi Ajeh,

I have been going through the Old vs. New store and have found all settings in Admin panel to be exactly the same. Also, when I looked in myPHPAdmin in the old database under Products and then master_category_id I found the old store to have the same settings including the 0.

Just wanted to update and give you all of the information, so that you may be able to give me another idea of where to look.

Thanks,

I am ot referring to the structure but the content of the products table ...

If you browse the products table there is a field called master_categories_id ... if you sort the products based on master_categories_id do any of them have 0 as the value for the master_categories_id ...

I wanted to know if the tables record counts were correct if you look at the list of table names there should be a list on how many records each of the tables have ... the ones of interest are:

products
products_description
products_to_categories

categories
categories_description

You say you see the Categories and Products in the Admin ...

On the shop, do you see them on the New Products? All Products? If you click on a Category?

Is it only on the product _info page that things break?

What do you see in the directory on the server for: /cache on debug logs? Any error messages showing?

Yes, in the shop I do see the products and they come up when I click on their category, and New Products, just not All Products.

The checking the /cache for the error log.....genius!! It shows an error in the tpl_products_all_default in my custom folder. It showed as an error on line 1. When I downloaded the file and opened it, I see that when I modified it, I must have saved it with "Word Wrap" on, so it garbled the file.

Thanks so much for your help on this...I really appreciate it, Ajeh!

You are most welcome ... thanks for the update on how you were able to use the debug logs to locate the errors/problems and what file(s) the problem was in ... :smile: