마이페이지 검수 대기 목록이 뜨지 않고
>>
org.springframework.web.util.NestedServletException: Request processing failed; nested exception is org.springframework.dao.TransientDataAccessResourceException: ### Error querying database. Cause: java.sql.SQLException: Bad format for Time '-01:33:24' in column 4 ### The error may exist in kr/co/xvision/mybatis/MyPageMapper.xml ### The error may involve kr.co.xvision.mybatis.MyPageMapper.actionin ### The error occurred while handling results ### SQL: select id,(select a.title from senseworld.input a where a.id=b.inputId) as title,b.page,if(sec_to_time(unix_timestamp(endTime)-unix_timestamp(updateTime)) < "00:06:00",sec_to_time(unix_timestamp(endTime)-unix_timestamp(updateTime)),"00:06:00") as getTime,status,Gvt,updateTime from senseworld.input_page b where inputUser=? and status=? limit 0,10 ### Cause: java.sql.SQLException: Bad format for Time '-01:33:24' in column 4 ; SQL []; Bad format for Time '-01:33:24' in column 4;
와 같은 내용만 계속 나옵니다. 어떻게 해결해야 할까요?
|