| 12345678910111213141516171819202122 |
- 2025-08-07 11:42:12.991 ERROR c.c.r.backend.aspect.DaoMapperAop - 出错方法:getTradeHistoryCount---错误原因:
- ### Error querying database. Cause: com.mysql.jdbc.exceptions.jdbc4.MySQLSyntaxErrorException: Table 'crm_partners.trade_history_mt4_202510' doesn't exist
- ### The error may exist in class path resource [mapper/TradeShardingDao.xml]
- ### The error may involve com.crm.ib.dao.mapper.TradeShardingDao.getTradeHistoryCount-Inline
- ### The error occurred while setting parameters
- ### SQL: select count(*) from trade_history_MT4_202510 trade left join custom_login ca on trade.login=ca.login left join user_info agent on ca.agent_id = agent.id WHERE agent.ib_no like concat(?,'%') and trade.close_time >= ? and trade.close_time < ? and agent.group_id=? and agent.stamp like binary concat(?,'%')
- ### Cause: com.mysql.jdbc.exceptions.jdbc4.MySQLSyntaxErrorException: Table 'crm_partners.trade_history_mt4_202510' doesn't exist
- ; bad SQL grammar []; nested exception is com.mysql.jdbc.exceptions.jdbc4.MySQLSyntaxErrorException: Table 'crm_partners.trade_history_mt4_202510' doesn't exist
- 2025-08-07 11:42:12.992 ERROR java.lang.RuntimeException - 出错类:com.crm.ib.service.impl.TradeHistoryShardingServiceImpluccess
- ,出错方法getListuccess
- java.lang.RuntimeException: system erroruccess,异常行号:48
- 2025-08-07 11:42:18.270 ERROR c.c.r.backend.aspect.DaoMapperAop - 出错方法:getTradeHistoryCount---错误原因:
- ### Error querying database. Cause: com.mysql.jdbc.exceptions.jdbc4.MySQLSyntaxErrorException: Table 'crm_partners.trade_history_mt4_202510' doesn't exist
- ### The error may exist in class path resource [mapper/TradeShardingDao.xml]
- ### The error may involve com.crm.ib.dao.mapper.TradeShardingDao.getTradeHistoryCount-Inline
- ### The error occurred while setting parameters
- ### SQL: select count(*) from trade_history_MT4_202510 trade left join custom_login ca on trade.login=ca.login left join user_info agent on ca.agent_id = agent.id WHERE agent.ib_no like concat(?,'%') and trade.close_time >= ? and trade.close_time < ? and agent.group_id=? and agent.stamp like binary concat(?,'%')
- ### Cause: com.mysql.jdbc.exceptions.jdbc4.MySQLSyntaxErrorException: Table 'crm_partners.trade_history_mt4_202510' doesn't exist
- ; bad SQL grammar []; nested exception is com.mysql.jdbc.exceptions.jdbc4.MySQLSyntaxErrorException: Table 'crm_partners.trade_history_mt4_202510' doesn't exist
- 2025-08-07 11:42:18.271 ERROR java.lang.RuntimeException - 出错类:com.crm.ib.service.impl.TradeHistoryShardingServiceImpluccess
- ,出错方法getListuccess
- java.lang.RuntimeException: system erroruccess,异常行号:48
|