Query Error are posting in Last System Logs HSNM administration backend general discussion

[azhar]

Dear Support,

In Last System Logs, we are getting following error. BDT is abbreviation of 'Bangladesh Taka', aka Bangladeshi Currency. Did we make anything mistake in configuration?


Error! Query error: Unknown column 'HsCurrencyExchange.BDT' in 'field list' (1054) Query: SELECT SUM(HsUsersTransactions.SellPrice * (CASE WHEN HsUsersTransactions.Currency = 'EUR' THEN HsCurrencyExchange.`BDT` / HsCurrencyExchange.`EUR` WHEN HsUsersTransactions.Currency = 'USD' THEN HsCurrencyExchange.`BDT` / HsCurrencyExchange.`USD` ELSE 1 END)) AS SellPrice FROM HsUsersTransactions INNER JOIN HsCurrencyExchange ON HsCurrencyExchange.HsCurrencyExchangeID = HsUsersTransactions.HsCurrencyExchangeID WHERE HsUsersID = 443 (::portal::app::profile::index ->GetHsUsersStats::db->query)

[HSNMSupport]

Hi Azhar,
we have fixed your issue.
Have a nice day.