为什么出差和外出申请的查询其中一个会报错

lerbin

好像是数据库的原因更新出差表出差查询就不会报错，但是外出查询就会报错，更新外出表，外出查询就不会报错，但是出差查询就会报错，怎么解决？？

出差查询报错

编码: JUSTEP150210; 提示: 执行KSQL出错, KSQL: SELECT OA_WM_EvecApply.*  FROM OA_WM_EvecApply OA_WM_EvecApply WHERE ((fBizState IN ('bsEditing','bsExecuting','bsFinished')) AND ((fCreatePerID = 'PSN01') OR (OA_WM_EvecApply IN (SELECT EXECUTE_CONCEPT.fMasterID AS EXECUTE_CONCEPT_fMasterID FROM OA_evection_EXECUTE EXECUTE_CONCEPT WHERE EXECUTE_CONCEPT.fCreatePsnID = 'PSN01') ))) ORDER BY fDEPTPATH DESC LIMIT 0, 20
        at com.justep.exception.BusinessException.create(Unknown Source)
        at com.justep.system.data.impl.TableUtilsImplement.ksqlSelect(Unknown Source)
        at com.justep.system.data.impl.TableUtilsImplement.ksqlSelect(Unknown Source)
        at com.justep.system.data.impl.TableUtilsImplement.ksqlSelect(Unknown Source)
        at com.justep.system.data.BizData.query(Unknown Source)
        at BizProcedure.query(BizProcedure.java:13)
        ... 25 more
Caused by: com.justep.exception.BusinessException: 编码: JUSTEP150039; 提示: 执行sql: SELECT  OA_WM_EvecApply.FDEPTPATH AS fDEPTPATH, OA_WM_EvecApply.fID AS OA_WM_EvecApply FROM OA_WM_OtherApply OA_WM_EvecApply  WHERE ( ( fBizState IN (?, ?, ?) ) AND ( (fCreatePerID = ?) OR (OA_WM_EvecApply.fID IN (SELECT  EXECUTE_CONCEPT.FMASTERID AS EXECUTE_CONCEPT_fMasterID FROM OA_PUB_EXECUTE EXECUTE_CONCEPT  WHERE (EXECUTE_CONCEPT.FCREATEPSNID = ?) AND (EXECUTE_CONCEPT.fBizKind = '出差申请'))) ) ) AND (OA_WM_EvecApply.fType = '出差申请')  ORDER BY fDEPTPATH DESC, binds: [bsEditing, bsExecuting, bsFinished, PSN01, PSN01]出错
        at com.justep.exception.BusinessException.create(Unknown Source)
        at com.justep.system.ksql.KSQLUtils.execSqlSelect(Unknown Source)
        ... 30 more
Caused by: java.sql.SQLException: Unknown column 'OA_WM_EvecApply.FDEPTPATH' in 'field list'
        at com.mysql.jdbc.MysqlIO.checkErrorPacket(MysqlIO.java:2928)
        at com.mysql.jdbc.MysqlIO.sendCommand(MysqlIO.java:1571)
        at com.mysql.jdbc.MysqlIO.sqlQueryDirect(MysqlIO.java:1666)
        at com.mysql.jdbc.Connection.execSQL(Connection.java:2994)
        at com.mysql.jdbc.PreparedStatement.executeInternal(PreparedStatement.java:936)
        at com.mysql.jdbc.PreparedStatement.executeQuery(PreparedStatement.java:1030)
        at org.apache.tomcat.dbcp.dbcp.DelegatingPreparedStatement.executeQuery(DelegatingPreparedStatement.java:96)
        at org.apache.tomcat.dbcp.dbcp.DelegatingPreparedStatement.executeQuery(DelegatingPreparedStatement.java:96)
        ... 31 more

jishuang

Unknown column 'OA_WM_EvecApply.FDEPTPATH' in 'field list'

数据库没有这个字段

lerbin

jishuang 发表于 2015-2-5 13:37
Unknown column 'OA_WM_EvecApply.FDEPTPATH' in 'field list'

数据库没有这个字段

在出差里加这个字段就好了