数据库问题

lyping

错误#1146: Table 'td_oa_archive.email_20101231' doesn't exist
SQL语句: SELECT * from TD_OA_ARCHIVE.EMAIL_20101231,TD_OA_ARCHIVE.EMAIL_BODY_20101231 where TD_OA_ARCHIVE.EMAIL_20101231.BODY_ID=TD_OA_ARCHIVE.EMAIL_BODY_20101231.BODY_ID and TO_ID='liuyuping' and SEND_FLAG!='0' and (DELETE_FLAG='' or DELETE_FLAG='0' or DELETE_FLAG='2') and BOX_ID='0' and SEND_TIME<='1463538220' order by SEND_TIME desc
文件：/general/email/query/search.php收件箱 - 查询结果

请联系管理员 错误#1146: Table 'td_oa_archive.email_20101231' doesn't exist
SQL语句: SELECT * from TD_OA_ARCHIVE.EMAIL_20101231,TD_OA_ARCHIVE.EMAIL_BODY_20101231 where TD_OA_ARCHIVE.EMAIL_20101231.BODY_ID=TD_OA_ARCHIVE.EMAIL_BODY_20101231.BODY_ID and TO_ID='liuyuping' and SEND_FLAG!='0' and (DELETE_FLAG='' or DELETE_FLAG='0' or DELETE_FLAG='2') and BOX_ID='0' and SEND_TIME<='1463538220' order by SEND_TIME desc limit 0,30
文件：/general/email/query/search.php


查询历史邮件时，弹出以上错误，如果解决， 请各位指导，谢谢！

admin_9

您好，这个是您归档库下边没有相应的数据表或者表算坏导致的。如果有备份的话，可以从备份中找到该表的备份来导入恢复一下。