messages api

gistfile1.txt

{"errors":[{"message":"Unknown column 'messages.contact_id' in 'on clause' [ SELECT COUNT(DISTINCT `message`.`id`) AS `records_found`, `message`.`id` AS `id`, `message`.`parent_id` AS `parent_id`, `message`.`contact_id` AS `contact_id`, `message`.`post_id` AS `post_id`, `message`.`data_provider` AS `data_provider`, `message`.`data_provider_message_id` AS `data_provider_message_id`, `message`.`title` AS `title`, `message`.`message` AS `message`, `message`.`datetime` AS `datetime`, `message`.`type` AS `type`, `message`.`status` AS `status`, `message`.`direction` AS `direction`, `message`.`created` AS `created` FROM `messages` AS `message` JOIN `contacts` ON (`messages`.`contact_id` = `contacts`.`id`) ORDER BY `created` DESC ]","code":1054,"class":"Database_Exception","file":"\/private\/var\/wwwdocs\/Lamu\/application\/classes\/Database\/MySQLi.php","line":155,"trace":[{"file":"\/private\/var\/wwwdocs\/Lamu\/modules\/database\/classes\/Kohana\/Database\/Query.php","line":251,"function":"query","class":"Database_MySQLi","type":"->","args":[1,"SELECT COUNT(DISTINCT `message`.`id`) AS `records_found`, `message`.`id` AS `id`, `message`.`parent_id` AS `parent_id`, `message`.`contact_id` AS `contact_id`, `message`.`post_id` AS `post_id`, `message`.`data_provider` AS `data_provider`, `message`.`data_provider_message_id` AS `data_provider_message_id`, `message`.`title` AS `title`, `message`.`message` AS `message`, `message`.`datetime` AS `datetime`, `message`.`type` AS `type`, `message`.`status` AS `status`, `message`.`direction` AS `direction`, `message`.`created` AS `created` FROM `messages` AS `message` JOIN `contacts` ON (`messages`.`contact_id` = `contacts`.`id`) ORDER BY `created` DESC","Model_Message",[]]},{"file":"\/private\/var\/wwwdocs\/Lamu\/modules\/orm\/classes\/Kohana\/ORM.php","line":1063,"function":"execute","class":"Kohana_Database_Query","type":"->","args":[{"last_query":"SHOW FULL COLUMNS FROM `messages`"}]},{"file":"\/private\/var\/wwwdocs\/Lamu\/modules\/orm\/classes\/Kohana\/ORM.php","line":1004,"function":"_load_result","class":"Kohana_ORM","type":"->","args":[true]},{"file":"\/private\/var\/wwwdocs\/Lamu\/application\/classes\/Controller\/Api\/Messages.php","line":189,"function":"find_all","class":"Kohana_ORM","type":"->","args":[]},{"file":"\/private\/var\/wwwdocs\/Lamu\/vendor\/kohana\/core\/classes\/Kohana\/Controller.php","line":84,"function":"action_get_index_collection","class":"Controller_Api_Messages","type":"->","args":[]},{"function":"execute","class":"Kohana_Controller","type":"->","args":[]},{"file":"\/private\/var\/wwwdocs\/Lamu\/vendor\/kohana\/core\/classes\/Kohana\/Request\/Client\/Internal.php","line":97,"function":"invoke","class":"ReflectionMethod","type":"->","args":[{"request":{},"response":{},"acl":{"_guest_role":"guest"},"auth":{},"user":{}}]},{"file":"\/private\/var\/wwwdocs\/Lamu\/vendor\/kohana\/core\/classes\/Kohana\/Request\/Client.php","line":114,"function":"execute_request","class":"Kohana_Request_Client_Internal","type":"->","args":[{},{}]},{"file":"\/private\/var\/wwwdocs\/Lamu\/vendor\/kohana\/core\/classes\/Kohana\/Request.php","line":985,"function":"execute","class":"Kohana_Request_Client","type":"->","args":[{}]},{"file":"\/private\/var\/wwwdocs\/Lamu\/httpdocs\/index.php","line":23,"function":"execute","class":"Kohana_Request","type":"->","args":[]}]}]}