Skip to content

Instantly share code, notes, and snippets.

@amichaelgrant
Created January 23, 2013 17:48
Show Gist options
  • Save amichaelgrant/4610953 to your computer and use it in GitHub Desktop.
Save amichaelgrant/4610953 to your computer and use it in GitHub Desktop.
This happens when executing this commands from the UI Reports -> Client Reports ->Run
Response Text: {"developerMessage":"The request caused a data integrity issue to be fired by the database.","developerDocLink":"https://github.com/keithwoodlock/mifosx/wiki/HTTP-API-Error-codes","httpStatusCode":"403","defaultUserMessage":"Unknown column 'c.joining_date' in 'field list'","userMessageGlobalisationCode":"error.msg.sql.error","errors":[{"developerMessage":"Unknown column 'c.joining_date' in 'field list'","defaultUserMessage":"Unknown column 'c.joining_date' in 'field list'","userMessageGlobalisationCode":"error.msg.sql.error","parameterName":"Sql: select x.* from (select ounder.`name` as \"Office/Branch\", concat(c.lastname, if(c.firstname > \"\", concat(\", \", c.firstname), \"\")) as \"Name\", \r\nc.joining_date as \"Joining Date\"\r\nfrom m_office o \r\njoin m_office ounder on ounder.hierarchy like concat(o.hierarchy, '%')\r\nand ounder.hierarchy like concat('.', '%')\r\njoin m_client c on c.office_id = ounder.id\r\nwhere o.id = 1\r\nand c.is_deleted=0\r\norder by ounder.hierarchy) x","value":null,"args":[]}]} Text Status: error Error Thrown: Forbidden
Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment