Unable to change sort order of categories

July 24, 2008, 07:10:47 AM

Welcome, Guest. Please login or register.
Did you miss your activation email?

News:

Home

Help

Joomla-addons.org > Component support > Easy FAQ > EasyFAQ 1.0 > Bugs > Unable to change sort order of categories

Pages: [1]

« previous next »

Author

Topic: Unable to change sort order of categories (Read 9848 times)

lapouche

Newbie

Offline

Posts: 1

Unable to change sort order of categories

« on: August 24, 2006, 04:14:31 PM »

Hello,

I have just installed the latest version of Easyfaq on Joomla 1.0.10 and it works perfectly except for the category ordering feature: no matter what option I select in the menu item for category ordering, I always get the same result, i.e. the categories are ordered according to their ID. I found a thread discussing this issue, but my understanding was it had been solved since.

Any help would be appreciated.
Thanks
Mike


	Logged

coolpluggy

Newbie

Offline

Posts: 2

Re: Unable to change sort order of categories

« Reply #1 on: September 06, 2006, 03:53:54 PM »

I have got the same problem. Joomla-1.0.11, EasyFaq-1.0rc1. I am using the display "List and introtext (loaded with AJAX)". Ordering of categories does not work. Ordering of FAQ items works. When I use the display "Categories and FAQ" the ordering of categories does work, but I don't like that display. What could be the problem?


	Logged

Adam

Administrator
Hero Member

Offline

Posts: 4.580

Re: Unable to change sort order of categories

« Reply #2 on: September 07, 2006, 09:41:42 AM »

Could you try to replicate the issue on the demo server? http://demo.joomla-addons.org


	Logged

- Joomla developer -

IMPORTANT: http://www.joomla-addons.org/option,com_smf/Itemid,7/topic,1332.0.html
Do not send support requests by PM. Post on the forum instead.

coolpluggy

Newbie

Offline

Posts: 2

Re: Unable to change sort order of categories

« Reply #3 on: September 07, 2006, 11:00:03 AM »

The demo server has the same problem. Choose Categorie ordering: Ordering and and change the display from List and introtext (AJAX) to Categorie and FAQ and you see it happening. Looks like in List and introtext view only the CategorieID is used for ordering.

frank


	Logged

cord

Newbie

Offline

Posts: 10

Re: Unable to change sort order of categories

« Reply #4 on: September 14, 2006, 11:27:16 AM »

I got the same problem reordering the faq categories after updating toRC 1 today.
I am using Joomla 1.0.11.

It works only if I choose the display mode "Categories and FAQ", in all the other display modes ordering does not work.

Is there allready some type of fix available?

Thanks for any hints!


« Last Edit: September 14, 2006, 12:05:10 PM by cord »	Logged

Adam

Administrator
Hero Member

Offline

Posts: 4.580

Re: Unable to change sort order of categories

« Reply #5 on: September 14, 2006, 12:23:16 PM »

Open /administrator/components/com_easyfaq/easyfaq.class.php.

change:

Code:

$query = "SELECT * FROM #__categories WHERE parent_id = $catid AND section = 'com_easyfaq' AND published = 1";

to:

Code:

$query = "SELECT * FROM #__categories WHERE parent_id = $catid AND section = 'com_easyfaq' AND published = 1 ORDER BY " . $params->get('cat_order');

That should do it.


	Logged

- Joomla developer -

IMPORTANT: http://www.joomla-addons.org/option,com_smf/Itemid,7/topic,1332.0.html
Do not send support requests by PM. Post on the forum instead.

cord

Newbie

Offline

Posts: 10

Re: Unable to change sort order of categories

« Reply #6 on: September 14, 2006, 01:11:13 PM »

Quote from: Adam on September 14, 2006, 12:23:16 PM

Open /administrator/components/com_easyfaq/easyfaq.class.php.

change:

Code:

$query = "SELECT * FROM #__categories WHERE parent_id = $catid AND section = 'com_easyfaq' AND published = 1";

to:

Code:

$query = "SELECT * FROM #__categories WHERE parent_id = $catid AND section = 'com_easyfaq' AND published = 1 ORDER BY " . $params->get('cat_order');

That should do it.

Excellent - that solves the problem for me! Grin

Thanks for the quick reply!


	Logged

Pages: [1]

« previous next »

Jump to: