chao1999 发表于 2019-12-10 19:15:12

升级190522新版本后邮件没有了！

2017版升级190522新版本后突然发现邮件全没了，而且提示“错误，请联系管理员   文件：/general/email/outbox/index.php”
这是怎么回事呢？

sydesmond 发表于 2019-12-10 19:26:18

出现“错误，请联系管理员   文件：/general/email/outbox/index.php”，一般就是数据库出错了。需要把日志文件MYOA\logs\mysql_error.log上传，才好排查具体故障。

chao1999 发表于 2019-12-10 20:21:45

o哦好的，谢谢！！
发现，说有流程也不能用了啊:funk:

chao1999 发表于 2019-12-10 20:25:12

sydesmond 发表于 2019-12-10 19:26
出现“错误，请联系管理员   文件：/general/email/outbox/index.php”，一般就是数据库出错了。需要把日志 ...

请问传到哪里去呢？

通达曾圆圆 发表于 2019-12-10 20:35:56

sydesmond 发表于 2019-12-10 19:26
出现“错误，请联系管理员   文件：/general/email/outbox/index.php”，一般就是数据库出错了。需要把日志 ...

您好，出现报错时候建议您到服务器安装目录下看下MYOA\logs\mysql_error是否与最新的报错日志产生，建议您把报错日志截图发一下。

chao1999 发表于 2019-12-10 21:08:25

本帖最后由 chao1999 于 2019-12-10 21:10 编辑

这只是拷贝了，一部分。好多的，全部截屏吗？？


错误#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='52' and READ_FLAG!='1' and (DELETE_FLAG='' or DELETE_FLAG='0' or DELETE_FLAG='2')
文件：/ispirit/im/count.php?TYPE=email,sms,taskcenter,sns


错误#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='admin' and READ_FLAG!='1' and (DELETE_FLAG='' or DELETE_FLAG='0' or DELETE_FLAG='2')
文件：/ispirit/im/count.php?TYPE=email,sms,taskcenter,sns


错误#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='admin' and READ_FLAG!='1' and (DELETE_FLAG='' or DELETE_FLAG='0' or DELETE_FLAG='2')
文件：/ispirit/im/count.php?TYPE=email,sms,taskcenter,sns


错误#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='张' and READ_FLAG!='1' and (DELETE_FLAG='' or DELETE_FLAG='0' or DELETE_FLAG='2')
文件：/ispirit/im/count.php?TYPE=email,sms,taskcenter,sns


错误#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='张' and READ_FLAG!='1' and (DELETE_FLAG='' or DELETE_FLAG='0' or DELETE_FLAG='2')
文件：/ispirit/im/count.php?TYPE=email,sms,taskcenter,sns


错误#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='52' and READ_FLAG!='1' and (DELETE_FLAG='' or DELETE_FLAG='0' or DELETE_FLAG='2')
文件：/ispirit/im/count.php?TYPE=email,sms,taskcenter,sns


错误#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='admin' and READ_FLAG!='1' and (DELETE_FLAG='' or DELETE_FLAG='0' or DELETE_FLAG='2')
文件：/ispirit/im/count.php?TYPE=email,sms,taskcenter,sns


错误#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='admin' and READ_FLAG!='1' and (DELETE_FLAG='' or DELETE_FLAG='0' or DELETE_FLAG='2')
文件：/ispirit/im/count.php?TYPE=email,sms,taskcenter,sns



通达曾圆圆 发表于 2019-12-11 16:01:50

本帖最后由 通达曾圆圆 于 2019-12-11 16:03 编辑

chao1999 发表于 2019-12-10 21:08
这只是拷贝了，一部分。好多的，全部截屏吗？？



您好，您OA是从哪个版本升级上来的，根据您发的报错信息显示：email_body表中缺from_id字段，建议您到OA数据库中找到email_body表，按照下图添加上from_id 字段；这个字段保存的是邮件发送人user_ID，这个字段是邮件中较重要的数据，如果新加字段的话默认该字段是没内容的，会影响您之前邮件的数据，为保证之前邮件数据完整性，建议您最好恢复升级之前的备份数据，再重新升级。

chao1999 发表于 2019-12-11 18:14:19

本帖最后由 chao1999 于 2019-12-11 18:15 编辑

通达曾圆圆 发表于 2019-12-11 16:01
您好，您OA是从哪个版本升级上来的，根据您发的报错信息显示：email_body表中缺from_id字段，建议您到OA数 ...
您好，多谢您细心专业的讲解，我发现邮件，工作流等等都不能用了，都报错！昨晚折腾了1晚上，最后只好恢复之前的热备份数据，就OK了，备份真的很重要啊！！:L
估计是前天下午不知为何数据库表突然就报错了，导致数据库表损坏，您知道是什么原因能导致类似问题吗？？
页: [1]
查看完整版本: 升级190522新版本后邮件没有了！