Page 1 of 1
Products Not getting Displayed in the Main category Page
Posted: Mon Dec 09, 2013 6:06 am
by Arthi
Hi,
I have installed Broadleaf and i have configured it with My sql server.
I have created a product called "Demo" with URL /merchandise/Demo.
I have added the product in "Merchandise" category.
The product is added in the database and I could able to see the product in the URL
http://localhost:8080/merchandise/Demo.
But the product is not getting displayed in the list of Products in Merchandise.
http://localhost:8080/merchandiseAm i missing anything here?
Thanks,
Arthi
Re: Products Not getting Displayed in the Main category Page
Posted: Mon Dec 09, 2013 6:43 am
by Theo Schumacher
Hi
Check in the Product if 'merchandise' is listed as parent category, probably even default parent category in your case.
If you are working with jetty demo, the contents of the category might be in the server cash and will not see what has changed in the admin. There are two completely different instances of jetty.
When you switch to tomcat server with connection pooling, you will not have this problem.
You should restart the demo-site but only if you have changed 'create-drop' instruction into 'update' in the properties file, otherwise your db is reloaded from scratch and your Demo product disappears.
Re: Products Not getting Displayed in the Main category Page
Posted: Mon Dec 09, 2013 7:49 am
by Arthi
Hi,
Thanks for your reply. I tried changing development.properties file in site to "update" from "create-drop". I am Getting 404 error after restarting the server.. Any pointers? Should i have to change the developement.propeties in admin also which says "none"..
Re: Products Not getting Displayed in the Main category Page
Posted: Mon Dec 09, 2013 11:09 am
by Theo Schumacher
I think your database was deletedwhen stopping jetty and update does not recreate.
Try starting one time with 'create'. if you can access, change to update.
To be sure you can kill the jetty process but it work without that.
Re: Products Not getting Displayed in the Main category Page
Posted: Tue Dec 10, 2013 2:50 am
by Arthi
Hi Theo,
Thanks for the reply!!!!! That worked
Re: Products Not getting Displayed in the Main category Page
Posted: Mon Jul 13, 2015 11:44 pm
by ndhonghai
Dear Theo,
Could you please explain below case?
- I create one 'Sport' category with same level as 'Primary Nav' category
Code: Select all
INSERT INTO BLC_CATEGORY (CATEGORY_ID,DESCRIPTION,NAME,URL,DEFAULT_PARENT_CATEGORY_ID,ACTIVE_START_DATE) VALUES (3, 'Sport','Sport Nav','/sport',1,CURRENT_TIMESTAMP);
INSERT INTO BLC_CATEGORY_XREF (CATEGORY_XREF_ID, SUB_CATEGORY_ID, CATEGORY_ID, DISPLAY_ORDER) VALUES (8,3,1,2);
- I assign 'Hot Sauces' to be sub-cat of 'Sport'
Code: Select all
INSERT INTO BLC_CATEGORY_XREF (CATEGORY_XREF_ID, SUB_CATEGORY_ID, CATEGORY_ID, DISPLAY_ORDER) VALUES (9,2002,3,1);
Then I checked in admin site to ensure everything correct. And I wait for Solr re-index data with log:
Code: Select all
[ WARN] 11:38:01 SolrIndexDaoImpl - Category circular reference identified for category id 2002
But there is no products shown via url : 'http://localhost:8080/sport'
I expect 'Hot Sauces' products are displayed.
Thanks.
Re: Products Not getting Displayed in the Main category Page
Posted: Sun Aug 09, 2015 11:15 pm
by ndhonghai