[Fixed in r1666] Custom Field category Order broken in r1665

Hello,

I just have installed r1665 and have a problem.
I am accessing a category has 2 sample items. I am not getting items but just below error appeared.

getData(): SQL QUERY ERROR:
Unknown column 'f.value' in 'order clause' SQL=SELECT SQL_CALC_FOUND_ROWS DISTINCT i.id FROM g97ig_content AS i JOIN g97ig_flexicontent_items_ext AS ie ON ie.item_id = i.id JOIN g97ig_flexicontent_types AS ty ON ie.type_id = ty.id JOIN g97ig_flexicontent_cats_item_relations AS rel ON rel.itemid = i.id JOIN g97ig_categories AS c ON c.id = i.catid LEFT JOIN g97ig_users AS u ON u.id = i.created_by WHERE 1 AND rel.catid IN ('664') AND ( i.state IN (1, -5) OR i.created_by = 0 ) AND ( ( i.publish_up = '0000-00-00 00:00:00' OR i.publish_up <= UTC_TIMESTAMP() ) OR i.created_by = 0 ) AND ( ( i.publish_down = '0000-00-00 00:00:00' OR i.publish_down >= UTC_TIMESTAMP() ) OR i.created_by = 0 ) AND ( ie.language LIKE 'ja%' OR ie.language="*" ) AND ty.access IN (1,1) AND c.access IN (1,1) AND i.access IN (1,1) ORDER BY f.value + 0 ASC, i.title

I use Directory view and I can see category name has 2 items but If I click it to view item list, I am getting an error.
I have one more menu that produces same error. All the others are working fine..

Regards,
Brandon

Hello,
this is easy to fix, (it is custom field ordering)

I missed this, while optimizing the main DB query for high speed in large sites + optimized the FACETED Filter behavior.

-- I have put fix on SVN, just copy the category.php from r1666.

-- But you installed from SVN?
this great we are putting together a BETA testers team, there will be an announcement soon, join in.

Thank you and I would love to join into BETA tester team.

A yes, i was about to send you PM, ok you will be added,

I see you have extracted from SVN , r1665/r1666 is good,

just the BETA releases or Candidate Releases,
will come into packages, and will be more tested than what is on SVN

PS r1665/r1666 category views (category,multi-cats,author etc) are optimized for speed , enable FLEXIcontent debug parameter to see the effect

Regards

brandonking wrote: Thank you and I would love to join into BETA tester team.

Added brandonking to Beta Tester Team.
Welcome!