通达OA2009完美平台出现乱码，急啊。

tsheitao

#1054: Unknown column 'RUN_NAME' in 'field list'
SQL语句: SELECT FLOW_RUN_PRCS.PRCS_ID,FLOW_RUN.RUN_ID,FLOW_RUN.FLOW_ID,PRCS_FLAG,FLOW_PRCS,FLOW_NAME,RUN_NAME,FLOW_TYPE,LIST_FLDS_STR,FORM_ID from FLOW_RUN_PRCS,FLOW_RUN,FLOW_TYPE WHERE FLOW_RUN_PRCS.RUN_ID=FLOW_RUN.RUN_ID and FLOW_RUN.FLOW_ID=FLOW_TYPE.FLOW_ID and USER_ID='shilei' and DEL_FLAG='0' and PRCS_FLAG<>'4' and PRCS_FLAG<>'5' and CHILD_RUN='0' order by FLOW_RUN_PRCS.PRCS_FLAG,PRCS_TIME desc limit 0,15
文件: D:/MYOA/webroot/general/mytable/intel_view/index.php
Warning: mysql_fetch_array(): supplied argument is not a valid MySQL result resource in D:\MYOA\webroot\general\mytable\工作流.php on line 23

内部邮件错误错误#1054: Unknown column 'FROM_ID' in 'where clause'
SQL语句: SELECT count(*) from EMAIL_BODY where FROM_ID='shilei' and SEND_FLAG='0'
文件: D:/MYOA/webroot/general/email/menu.php

Warning: mysql_fetch_array(): supplied argument is not a valid MySQL result resource in D:\MYOA\webroot\general\email\menu.php on line 89
错误#1054: Unknown column 'FROM_ID' in 'where clause'
SQL语句: SELECT EMAIL_ID from EMAIL,EMAIL_BODY where EMAIL.BODY_ID=EMAIL_BODY.BODY_ID and FROM_ID='shilei' and DELETE_FLAG!='2' and DELETE_FLAG!='4' group by EMAIL.BODY_ID
文件: D:/MYOA/webroot/general/email/menu.php
#1054: Unknown column 'EMAIL_BODY.FROM_ID' in 'on clause'
SQL语句: SELECT count(*) from EMAIL,EMAIL_BODY LEFT JOIN USER ON USER.USER_ID = EMAIL_BODY.FROM_ID where EMAIL.BODY_ID=EMAIL_BODY.BODY_ID and TO_ID='shilei' and READ_FLAG!='1' and (DELETE_FLAG='' or DELETE_FLAG='0' or DELETE_FLAG='2')
文件: D:/MYOA/webroot/general/email/news.php
Warning: mysql_fetch_array(): supplied argument is not a valid MySQL result resource in D:\MYOA\webroot\general\email\news.php on line 27

未读邮件

tsheitao 于 2010-8-5 22:35 补充以下内容

没人理睬啊。。。。
继续求。。。

uuuuuu

请修复数据库 试试

rauismo

1、修复数据库
2、重新把PJ补丁覆盖一下。覆盖前需要停止通达的一切服务
3、重新安装OA覆盖，前提是先备份好数据

aroc

停电或者非正常关机情况下，请修复数据库试下

tsheitao

修复数据库
也重新覆盖PJ了
都不能用，RMB求解决。

tsheitao

49495418 QQ 50元求解决、
49495418 QQ 50元求解决、
本文来源:阳光网驿
原文地址:http://bbs.sunwy.org/viewthread. ... mp;page=1#pid560999

zippool

我知道你的问题出在哪里了，已经发QQ加你了！