problem with Reports and currency fields

Hello,

I’m having an issue with Reports. When I add a currency field to the report and save, the report is empty. With no currency fields it populates with data. If I add a currency field no data is populated and the report is empty.

Sugarlog shows this error:

Thu Jan 22 12:51:28 2015 [10842][1][FATAL] Query Failed: SELECT count(*) c FROM (SELECT contacts.id AS ‘contacts_id’, contacts.currency_id AS ‘contacts_currency_id’, contacts_cstm.summa_c AS ‘Summa0’ FROM contacts LEFT JOIN contacts_cstm contacts_cstm ON contacts.id = contacts_cstm.id_c WHERE contacts.deleted = 0 ) as n: MySQL error 1054: Unknown column ‘contacts.currency_id’ in ‘field list’

Thu Jan 22 12:51:28 2015 [10842][1][FATAL] Query Failed: SELECT contacts.id AS ‘contacts_id’, contacts.currency_id AS ‘contacts_currency_id’, contacts_cstm.summa_c AS ‘Summa0’ FROM contacts LEFT JOIN contacts_cstm contacts_cstm ON contacts.id = contacts_cstm.id_c WHERE contacts.deleted = 0 LIMIT 0,20: MySQL error 1054: Unknown column ‘contacts.currency_id’ in ‘field list’

I’ve tried the quick rebuild several times and it does not help.

Thank you for highlighting this, I will log as a bug.

Hello, is there a github issue tracker for this bug?

I have created an issue on github: #140