[fixed in r1787] Issue with order "Best rated" on frontend

Hello,

I use r1781 with joomla 2.5.

On the frontend, when I select "Best rated" for ordering, I received the followinf error:

getData(): SQL QUERY ERROR:
Unknown column 'votes' in 'order clause' SQL=
SELECT SQL_CALC_FOUND_ROWS i.id
FROM mj4b7_content AS i
JOIN mj4b7_flexicontent_items_ext AS ie ON ie.item_id = i.id
JOIN mj4b7_flexicontent_types AS ty ON ie.type_id = ty.id
JOIN mj4b7_flexicontent_cats_item_relations AS rel ON rel.itemid = i.id
JOIN mj4b7_categories AS c ON c.id = i.catid
LEFT JOIN mj4b7_users AS u ON u.id = i.created_by
LEFT JOIN mj4b7_flexicontent_fields_item_relations AS f ON f.item_id = i.id AND f.field_id=30
WHERE 1
AND rel.catid IN ('8')
AND ( i.state IN (1, -5)
OR ( i.created_by = 573 AND i.created_by != 0 ) )
AND ( ( i.publish_up = '0000-00-00 00:00:00' OR i.publish_up <= UTC_TIMESTAMP() )
OR ( i.created_by = 573 AND i.created_by != 0 ) )
AND ( ( i.publish_down = '0000-00-00 00:00:00' OR i.publish_down >= UTC_TIMESTAMP() )
OR ( i.created_by = 573 AND i.created_by != 0 ) )
AND ty.access IN (0,1,1,2,3,4)
AND c.access IN (0,1,1,2,3,4)
AND i.access IN (0,1,1,2,3,4)
GROUP BY i.id
ORDER BY votes DESC, i.title LIMIT 0, 10

But if I choose "Best rated" directly in the category primary order on the administrator site, it works.

I have the same error with "Most commented".

How can I resolve this ?

Thanks

Frederic

Hello

please goto component parameters "Content lists" TAB and de-select allowing the frontend user to order by it

will test and fix in upcoming version

thanks for reporting

Many thanks.

Frederic

Hello

i will post back here with the fix,

so that you can get it earlier (before next public package is released)

Regards

Hello

fixed in r1787

Great.

Thanks a lot.