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
Thank you for your time reading me.
Regards,
the_observer.