rsanchez/json — Issue #15: display_by="week" Support?
Author: grantmx
Created: 2012-01-28 01:30:14+00:00
State: open

Hey Rob - I'm getting this PHP error when I add the display_by="week" parameter.

===============================

Error Number: 1054

Unknown column 'yearweek' in 'order clause'

SELECT t.title, t.url_title, t.entry_id, t.channel_id, t.author_id, t.status, t.entry_date, t.edit_date, t.expiration_date, wd.`field_id_1` AS `related_ministry`, wd.`field_id_2` AS `event_time`, wd.`field_id_17` AS `links`, wd.`field_id_13` AS `event_desc`, wd.`field_id_14` AS `event_location` FROM (`exp_channel_titles` t) JOIN `exp_channel_data` wd ON `t`.`entry_id` = `wd`.`entry_id` WHERE `t`.`entry_id` IN ('19') ORDER BY `yearweek` ASC, `t`.`sticky` desc, `t`.`entry_date` asc, `t`.`entry_id` asc

Filename: third_party/json/pi.json.php

Line Number: 135
===========================

Is this supported? Thanks!