[Solved] No items available for this category

Myl
Topic Author
Offline
Junior Member

12 years 5 months ago - 12 years 5 months ago #20762 by Myl

[Solved] No items available for this category was created by Myl

I've some products in a category but when I see this category in frontend the result is: "No items available for this category".

My products and this category are all published.
In category table (beckend) I can see all the items assigned (6 [view items] ).

If I directly link a product there isn't problem, I can see it without problem.

I try to uninstall flexicontent and I've deleted all the products, category and menu. After this I try to rebuild all the structure but the problem was the same.

I search in all the forum about this problem but I cannot found anything useful (This post <a class="postlink-local" href=" www.flexicontent.org/phpbb/viewtopic.php...+this+category#p1642 ">viewtopic.php?f=29&t=385&p=1672&hilit=no+items+available+for+this+category#p1642 isn't solved).

What i can do?

[I use Joomla 1.7 and Flexicontent v2.0 RC1a r979]

Another Thankyou
Myl

Last edit: 12 years 5 months ago by Myl.

Please Log in or Create an account to join the conversation.

yopyop001
Offline
Moderator

12 years 5 months ago #20763 by yopyop001

Replied by yopyop001 on topic [Solved] No items available for this category

Hi,

In your category parameters,

Parameters : layout common

Do you use the option, "Order with custom field" ?

If yes, try to disable this option. When the field is not filled for the items, it can return 'no results'

(I had this problem, but it was with the 1.5.6 on Joomla 1.5, i've not tried it with J1.7-FC2.0)

Regards

Please Log in or Create an account to join the conversation.

Myl
Topic Author
Offline
Junior Member

12 years 5 months ago #20768 by Myl

Replied by Myl on topic [Solved] No items available for this category

Hi,

This is my options:

Primary Order: Default
Order with custom field: please select
Direction: Ascending
Field Type: Text

I cannot disable "order with custom field" but I haven't got nothing selected.

Myl

Please Log in or Create an account to join the conversation.

ggppdk
Offline
Administrator

12 years 5 months ago #20774 by ggppdk

Replied by ggppdk on topic [Solved] No items available for this category

Lets check for a database query error

--now there is no code to print it, lets add code to print it ...

Edit your file (frontend):
components/com_flexicontent/models/category.php

replace your getData() function with this:

Code:

function getData()
{
	$format	= JRequest::getVar('format', null);
	// Lets load the content if it doesn't already exist
	if (empty($this->_data)) {
		$query = $this->_buildQuery();
		$this->_total = $this->_getListCount($query);
		
		if ($this->_db->getErrorNum()) {
			echo $query."<br>";
			echo $this->_db->getErrorMsg()."<br>";
		}

		if ((int)$this->getState('limitstart') < (int)$this->_total) {
			$this->_data = $this->_getList( $query, $this->getState('limitstart'), $this->getState('limit') );
		} else {
			$this->_data = $this->_getList( $query, 0, $this->getState('limit') );
		}
		
		if ($this->_db->getErrorNum()) {
			echo $query."<br>";
			echo $this->_db->getErrorMsg()."<br>";
		}
	}
	return $this->_data;
}

Refresh the category view, to check if now an error is printed.

If it is not it must be some configuration issue.

Regards

-- Flexicontent is Free but involves a big effort on our part.
Like the our support? (for a bug-free FC, despite having a long list of functions) Like the features? Like the ongoing development and future commitment to FLEXIcontent?
-- Add your voice to the FLEXIcontent JED listing with a 5-star...

Please Log in or Create an account to join the conversation.

Myl
Topic Author
Offline
Junior Member

12 years 5 months ago #20788 by Myl

Replied by Myl on topic [Solved] No items available for this category

Hi,
I try to use you're code and nothing happend.
No error was printed.

I have always: "No items available for this category" and anything else.

I'll try to change another time all the configurations..

I'll keep in touch about this.
If you have other suggestions I'm here

Myl

Please Log in or Create an account to join the conversation.

ggppdk
Offline
Administrator

12 years 5 months ago #20802 by ggppdk

Replied by ggppdk on topic [Solved] No items available for this category

There is a parameter "Owner items" in the menu item under slider "Basic Options"

Set this option to 'No'

Also i was thinking Joomla has various options for linking to the category, mainly for displaying fields, but we have all these options and much more in the category properties, and in the templates.

-- But maybe we need one more parameter to allow different template, in the menu item, but then we must
also load the category parameters of the template,
will examine in v2.1 ...

Please Log in or Create an account to join the conversation.