gistfile1.txt

[2014-11-24 16:50:26] request.CRITICAL: Uncaught PHP Exception Doctrine\DBAL\DBALException: "An exception occurred while executing 'SELECT h.master_version, h.focalpoint_name, h.focalpoint_email, h.username, h.date, h.rsd_tables, h.totals, h.totals_rsd, c.name, p.status, c.oracle_id 										FROM asr_application h   										JOIN code_countries c ON c.id = h.country  										JOIN code_status p ON h.status = p.id  										WHERE h.year = :year  										AND  h.master_version  = (SELECT MAX(master_version) FROM asr_application h2 WHERE h2.country = h.country) 									' with params [2013]:  SQLSTATE[42S22]: Column not found: 1054 Unknown column 'h.username' in 'field list'" at /usr/local/projects/unhcr/psr/shared/vendor/doctrine/dbal/lib/Doctrine/DBAL/DBALException.php line 47 {"exception":"[object] (Doctrine\\DBAL\\DBALException: An exception occurred while executing 'SELECT h.master_version, h.focalpoint_name, h.focalpoint_email, h.username, h.date, h.rsd_tables, h.totals, h.totals_rsd, c.name, p.status, c.oracle_id\n\t\t\t\t\t\t\t\t\t\tFROM asr_application h  \n\t\t\t\t\t\t\t\t\t\tJOIN code_countries c ON c.id = h.country \n\t\t\t\t\t\t\t\t\t\tJOIN code_status p ON h.status = p.id \n\t\t\t\t\t\t\t\t\t\tWHERE h.year = :year \n\t\t\t\t\t\t\t\t\t\tAND  h.master_version  = (SELECT MAX(master_version) FROM asr_application h2 WHERE h2.country = h.country)\n\t\t\t\t\t\t\t\t\t' with params [2013]:\n\nSQLSTATE[42S22]: Column not found: 1054 Unknown column 'h.username' in 'field list' at /usr/local/projects/unhcr/psr/shared/vendor/doctrine/dbal/lib/Doctrine/DBAL/DBALException.php:47, PDOException: SQLSTATE[42S22]: Column not found: 1054 Unknown column 'h.username' in 'field list' at /usr/local/projects/unhcr/psr/shared/vendor/doctrine/dbal/lib/Doctrine/DBAL/Statement.php:138)"} []