工作流转交下一步出错
这个工作流转交下一步结束流程时报错。刚才测试过，这一步转交之后是一个子流程。增加子流程之后就会出现这个报错。但是条件是达不到子流程的转入条件的。应该会自动结束才对。如果下一步只要结束就没有这个错误提醒。 日志的报错是这样的 ，不知道是什么原因引起
错误#1054: Unknown column 'ALL_DEPT53' in 'where clause'
SQL语句: SELECT UID,USER_ID,USER_NAME,DEPT_ID,SEX,DEPT_ID_OTHER,USER.USER_PRIV,USER_PRIV_OTHER from USER,USER_PRIV where DEPT_ID!=0 and (USER.NOT_LOGIN='0' or USER.NOT_MOBILE_LOGIN='0') and USER.USER_PRIV=USER_PRIV.USER_PRIVand (1=2or USER.DEPT_ID in(ALL_DEPT53,94,24,1,42,3,72,75,37,8,11,13,14,12,4,35,36,5,64,105,29,28,32,27,6,103,46,104,60,19,106,107,20,108,109,73,61,110,111,76,26,77,67,30,31,21,7,62,18,95,96,10,38,39,40,100,97,23,91,92,45,33,34,101,102,47,59) or find_in_set('ALL_DEPT53',DEPT_ID_OTHER)or find_in_set('94',DEPT_ID_OTHER)or find_in_set('24',DEPT_ID_OTHER)or find_in_set('1',DEPT_ID_OTHER)or find_in_set('42',DEPT_ID_OTHER)or find_in_set('3',DEPT_ID_OTHER)or find_in_set('72',DEPT_ID_OTHER)or find_in_set('75',DEPT_ID_OTHER)or find_in_set('37',DEPT_ID_OTHER)or find_in_set('8',DEPT_ID_OTHER)or find_in_set('11',DEPT_ID_OTHER)or find_in_set('13',DEPT_ID_OTHER)or find_in_set('14',DEPT_ID_OTHER)or find_in_set('12',DEPT_ID_OTHER)or find_in_set('4',DEPT_ID_OTHER)or find_in_set('35',DEPT_ID_OTHER)or find_in_set('36',DEPT_ID_OTHER)or find_in_set('5',DEPT_ID_OTHER)or find_in_set('64',DEPT_ID_OTHER)or find_in_set('105',DEPT_ID_OTHER)or find_in_set('29',DEPT_ID_OTHER)or find_in_set('28',DEPT_ID_OTHER)or find_in_set('32',DEPT_ID_OTHER)or find_in_set('27',DEPT_ID_OTHER)or find_in_set('6',DEPT_ID_OTHER)or find_in_set('103',DEPT_ID_OTHER)or find_in_set('46',DEPT_ID_OTHER)or find_in_set('104',DEPT_ID_OTHER)or find_in_set('60',DEPT_ID_OTHER)or find_in_set('19',DEPT_ID_OTHER)or find_in_set('106',DEPT_ID_OTHER)or find_in_set('107',DEPT_ID_OTHER)or find_in_set('20',DEPT_ID_OTHER)or find_in_set('108',DEPT_ID_OTHER)or find_in_set('109',DEPT_ID_OTHER)or find_in_set('73',DEPT_ID_OTHER)or find_in_set('61',DEPT_ID_OTHER)or find_in_set('110',DEPT_ID_OTHER)or find_in_set('111',DEPT_ID_OTHER)or find_in_set('76',DEPT_ID_OTHER)or find_in_set('26',DEPT_ID_OTHER)or find_in_set('77',DEPT_ID_OTHER)or find_in_set('67',DEPT_ID_OTHER)or find_in_set('30',DEPT_ID_OTHER)or find_in_set('31',DEPT_ID_OTHER)or find_in_set('21',DEPT_ID_OTHER)or find_in_set('7',DEPT_ID_OTHER)or find_in_set('62',DEPT_ID_OTHER)or find_in_set('18',DEPT_ID_OTHER)or find_in_set('95',DEPT_ID_OTHER)or find_in_set('96',DEPT_ID_OTHER)or find_in_set('10',DEPT_ID_OTHER)or find_in_set('38',DEPT_ID_OTHER)or find_in_set('39',DEPT_ID_OTHER)or find_in_set('40',DEPT_ID_OTHER)or find_in_set('100',DEPT_ID_OTHER)or find_in_set('97',DEPT_ID_OTHER)or find_in_set('23',DEPT_ID_OTHER)or find_in_set('91',DEPT_ID_OTHER)or find_in_set('92',DEPT_ID_OTHER)or find_in_set('45',DEPT_ID_OTHER)or find_in_set('33',DEPT_ID_OTHER)or find_in_set('34',DEPT_ID_OTHER)or find_in_set('101',DEPT_ID_OTHER)or find_in_set('102',DEPT_ID_OTHER)or find_in_set('47',DEPT_ID_OTHER)or find_in_set('59',DEPT_ID_OTHER) )and USER.DEPT_ID != 0 order by PRIV_NO,USER_NO,USER_NAME
文件：/general/workflow/list/input_form/work_next.php?flow_type=1&flow_id=91&run_id=15291&run_name=%E5%AD%90%E6%B5%81%E7%A8%8B%E6%B5%8B%E8%AF%95(2016-06-22%2010%3A56%3A42)&prcs_id=1&prcs_name=1&flow_prcs=1&remind_info=1,2,0,0,2,0,0,2,0,&prcs_key_id=56306 deathmen 发表于 2016-6-22 15:46 http://club.tongda2000.com/static/image/common/back.gif
日志的报错是这样的 ，不知道是什么原因引起
错误#1054: Unknown column 'ALL_DEPT5 ...
您好，qq上已经单独联系您了，烦请看一下消息。 通达赵延庆 发表于 2016-6-22 17:19 static/image/common/back.gif
您好，qq上已经单独联系您了，烦请看一下消息。
:handshake deathmen 发表于 2016-6-22 17:31 static/image/common/back.gif
此问题为用户调整过组织结构，造成经办权限错乱，清空经办权限，重新设置即可解决。
页:
[1]