- create a content type with a date field
- set environment so that sort criterion on date field is date, not count
- navigation page shows error like this

user warning: Unknown column 'field_termin_gelb_month' in 'order clause' query: SELECT DISTINCT(n.nid) AS nid, COUNT(DISTINCT(n.nid)) AS count, YEAR(content_type_job.field_termin_gelb_value) AS field_termin_gelb_year FROM tst_node AS n INNER JOIN temp_faceted_search_results_1 AS results ON n.nid = results.nid INNER JOIN tst_content_type_job AS content_type_job ON n.vid = content_type_job.vid WHERE ((content_type_job.field_termin_gelb_value IS NOT NULL) AND (n.type IN ('job'))) GROUP BY field_termin_gelb_year ASC ORDER BY field_termin_gelb_year ASC, field_termin_gelb_month ASC, field_termin_gelb_day ASC LIMIT 0, 11 in /www/htdocs/konzep/z/includes/database.mysql.inc on line 172.

Comments

david lesieur’s picture

Project: Faceted Search » CCK Facets
Version: 6.x-1.x-dev » 5.x-1.x-dev
david lesieur’s picture

Status: Active » Fixed

This has been fixed recently.

Anonymous’s picture

Status: Fixed » Closed (fixed)

Automatically closed -- issue fixed for two weeks with no activity.