Gallery 4 Bugor not? Problem when ordering by rate

the_observer
Phoca Newbie
Phoca Newbie
Posts: 9
Joined: 14 Apr 2013, 12:07

Gallery 4 Bugor not? Problem when ordering by rate

Post by the_observer »

Hi all.

I don't know if this is a bug or if i am doing something wrong.
Using the native joomla3 way i have the site bilingual and works ok (i just mention this in case it is relevant) except when i set category ordering by rating.

I have two levels of categories for each language like below:

1st level is 6 categories E.g. CatA CatB e.t.c. up to CatF
Inside them I have 2nd level of Categories like : CatA1,CatA2... Cat B1,CatB2... e.t.c. up to CatF1,CatF2...

For purposes of displaying i have rate ONLY the 1st level of categories Cat A to CatF and then i ask phoca gallery to short by rating and it works like a charm while presenting this level of categories.If i click to display a category of the second level i get the below error:

Code: Select all

0 - SQL=SELECT cc.id, cc.title, cc.alias, cc.published, cc.approved, cc.parent_id, cc.deleteuserid, cc.accessuserid, cc.uploaduserid, cc.access FROM nzqu0_phocagallery_categories AS cc WHERE cc.id = 0 AND cc.published = 1 AND cc.approved = 1 AND cc.id <> 73 ORDER BY r.average ASC, cc.id ASC LIMIT 0, 1
Am i doing something wrong or is this a bug?

Thank you for your time reading me.

Regards,
the_observer.
User avatar
Jan
Phoca Hero
Phoca Hero
Posts: 47810
Joined: 10 Nov 2007, 18:23
Location: Czech Republic
Contact:

Re: Gallery 4 Bugor not? Problem when ordering by rate

Post by Jan »

Hi, where exactly do you get this problem? In frontend?
If you find Phoca extensions useful, please support the project
the_observer
Phoca Newbie
Phoca Newbie
Posts: 9
Joined: 14 Apr 2013, 12:07

Re: Gallery 4 Bugor not? Problem when ordering by rate

Post by the_observer »

Yes in the frondend.

But, by now i have quit the 'rating' method in order to sort the categories due to the above mentioned problem...

I just numbered them and used ordering ascending in the options...

Regards,
the_observer.
Post Reply