rsanchez / json

Output ExpressionEngine data in JSON format.
http://devot-ee.com/add-ons/json/
101 stars 234 forks source link

PHP Error using json:members #22

Closed grantmx closed 11 years ago

grantmx commented 11 years ago

Hey Rob - I just noticed that the json:members is returning a PHP error.

using a simple tag: {exp:json:members username="grantmx"}

EE version 2.7.1 - Build Date: 20130924


Error Number: 1054

Unknown column 'm.daylight_savings' in 'field list'

SELECT m.member_id, m.group_id, m.username, m.screen_name, m.email, m.signature, m.avatar_filename, m.avatar_width, m.avatar_height, m.photo_filename, m.photo_width, m.photo_height, m.url, m.location, m.occupation, m.interests, m.bio, m.join_date, m.last_visit, m.last_activity, m.last_entry_date, m.last_comment_date, m.last_forum_post_date, m.total_entries, m.total_comments, m.total_forum_topics, m.total_forum_posts, m.language, m.timezone, m.daylight_savings, m.bday_d, m.bday_m, m.bday_y, d.m_field_id_1 AS chatroll, d.m_field_id_2 AS free_chat, d.m_field_id_3 AS campus_type FROM (exp_members m) JOIN exp_member_data d ON m.member_id = d.member_id WHERE m.member_id IN ('1')

Filename: third_party/json/pi.json.php

Line Number: 419


rsanchez commented 11 years ago

Thanks for the heads up. Fixed in the latest.

grantmx commented 11 years ago

Forked it and it works. Thanks Bro!