错误代码一般如下：
#1054: Unknown column 'FROM_ID' in 'field list'
SQL语句: SELECT EMAIL_ID,READ_FLAG,FROM_ID,SUBJECT,IMPORTANT,USER_NAME,AVATAR,DEPT_ID from EMAIL,EMAIL_BODY LEFT JOIN USER ON USER.USER_ID = EMAIL_BODY.FROM_ID where EMAIL.BODY_ID=EMAIL_BODY.BODY_ID and BOX_ID=0 and TO_ID='admin' and SEND_FLAG='1' and (DELETE_FLAG='0' or DELETE_FLAG='2') order by SEND_TIME desc limit 0,15
文件: D:/MYOA/webroot/general/mytable/intel_view/index.php
修改办法：
返回数据库查看出错的几张表。查看表中的数据无任何异常，但当打开表结构发现几个表字段名的后面多加了两个空格。发现问题后修改回来一切正常了。
原因：
返回webroot\general\system\security\submit.php文件解密后打开发现了问题所在：
if ( tdoa_optional( "TDEA" ) && tdoa_optional( "EXAM" ) )
{
$query = "ALTER TABLE `EMAIL_BODY` CHANGE `FROM_ID` `FROM_ID ` VARCHAR( 20 ) NOT NULL";
@mysql_query( $query, $connection );
$query = "ALTER TABLE `FILE_CONTENT` CHANGE `SORT_ID` `SORT_ID ` INT( 11 ) DEFAULT '0' NOT NULL";
@mysql_query( $query, $connection );
$query = "ALTER TABLE `FLOW_RUN` CHANGE `RUN_NAME` `RUN_NAME ` VARCHAR( 200 ) NOT NULL";
@mysql_query( $query, $connection );
}
直接干掉这段代码就行了
还有其它几个文件也有，自己解密后搜一下，改一下