Query Error are posting in Last System Logs
Posted: 16 Jun 2020, 10:41
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)
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)