Forum OpenACS Q&A: Re: E-commerce 'category-browse-subcategory.tcl'

Collapse
2: Re: E-commerce 'category-browse-subcategory.tcl' (response to 1)
Posted by Torben Brosten on 12/19/08 01:24 AM
Ricky,

Try browsing to ecommerce/admin and refreshing the db cache.. see if it becomes available after that.

Collapse
3: Re: E-commerce 'category-browse-subcategory.tcl' (response to 2)
Posted by Richard Hamilton on 12/19/08 04:27 AM
Torben, thanks for the reply.

I tried that first of all. Then I connected to the db using psql and issued the queries direct against the tables. With the left outer join to an empty table you get zip back! 😊

R.

Collapse
4: Re: E-commerce 'category-browse-subcategory.tcl' (response to 2)
Posted by Richard Hamilton on 12/19/08 04:41 AM
......although of course logically that should not be happening! :-|
Collapse
5: Re: E-commerce 'category-browse-subcategory.tcl' (response to 2)
Posted by Richard Hamilton on 12/19/08 05:07 AM
OK, apologies from Bozo central, the left inner join thing is a red herring - caused by a typo in my test query! 😟

However, I still have the problem.

So I have flushed the cache and I still have the problem. Product exists and can be searched and displayed, but the category browse function doesn't work. So this now must be caused by either the 'exclude subproducts' clause or the user session id.

R.