21:08:46 [error]: 通用的实体数据存取接口异常:数据库执行异常:Incorrect string value: '\xF0\x9F\x98\x8D' for column `bizdbKLY`.`biz_appraisal`.`result_desc` at row 1 sql语句:SET SESSION TRANSACTION ISOLATION LEVEL REPEATABLE READ;start transaction;set @handle_id=0; select @handle_id:=id from biz_appraisal where biz_catalog=:biz_catalog and biz_id=:biz_id limit 1; insert into biz_appraisal ( `createtime`,`biz_catalog`, biz_id, `fromerid`, `toerid`,`result_level`, result_desc, remark) select :nowtime, :biz_catalog,:biz_id, :fromerid, :toerid , :result_level,:result_desc,:remark from dual where ifnull(@handle_id,0)=0; update biz_appraisal set updatetime=:nowtime,fromerid=:fromerid,toerid=:toerid, `result_level`=:result_level, result_desc=:result_desc, remark=concat(:remark,remark) where ifnull(@handle_id,0)<>0 and id=ifnull(@handle_id,0);commit; ["22007",1366,"Incorrect string value: '\\xF0\\x9F\\x98\\x8D' for column `bizdbKLY`.`biz_appraisal`.`result_desc` at row 1"] 异常发生在文件:[/bizroot/approot/klywebapi/prjcenter/prjKLY/bizcenter/Worker/entityDataHandle.php]的[133]行 code[0] ! 异常堆栈上下文: #0 /bizroot/approot/klywebapi/ajaxEntryCenter.php(65): include_once() #1 {main} 数据库执行异常:Incorrect string value: '\xF0\x9F\x98\x8D' for column `bizdbKLY`.`biz_appraisal`.`result_desc` at row 1 sql语句:SET SESSION TRANSACTION ISOLATION LEVEL REPEATABLE READ;start transaction;set @handle_id=0; select @handle_id:=id from biz_appraisal where biz_catalog=:biz_catalog and biz_id=:biz_id limit 1; insert into biz_appraisal ( `createtime`,`biz_catalog`, biz_id, `fromerid`, `toerid`,`result_level`, result_desc, remark) select :nowtime, :biz_catalog,:biz_id, :fromerid, :toerid , :result_level,:result_desc,:remark from dual where ifnull(@handle_id,0)=0; update biz_appraisal set updatetime=:nowtime,fromerid=:fromerid,toerid=:toerid, `result_level`=:result_level, result_desc=:result_desc, remark=concat(:remark,remark) where ifnull(@handle_id,0)<>0 and id=ifnull(@handle_id,0);commit; ["22007",1366,"Incorrect string value: '\\xF0\\x9F\\x98\\x8D' for column `bizdbKLY`.`biz_appraisal`.`result_desc` at row 1"] 异常发生在文件:[/bizroot/approot/klywebapi/base/mysql.php]的[104]行 code[0] ! 异常堆栈上下文: #0 /bizroot/approot/klywebapi/base/mysql.php(156): PdoUtil->errhandle() #1 /bizroot/approot/klywebapi/base/mysql.php(171): PdoUtil->query2() #2 /bizroot/approot/klywebapi/base/mysql.php(20): PdoUtil->query2_withtrans() #3 /bizroot/approot/klywebapi/prjcenter/prjKLY/base/AboutActivity.php(2473): pdo_query3() #4 /bizroot/approot/klywebapi/prjcenter/prjKLY/bizcenter/Worker/entityDataHandle.php(68): bizbase_todoWorkEntityHandle() #5 /bizroot/approot/klywebapi/ajaxEntryCenter.php(65): include_once('/bizroot/approo...') #6 {main} [上下文相关信息]: [WsAjaxPrj]=KLY [WsAjaxBiz]=Worker [WsAjaxAction]=entityDataHandle [USER]=nginxphp [HOME]=/home/nginxphp [HTTP_REFERER]=https://servicewechat.com/wxcd35a60de7b5942a/0/page-frame.html [HTTP_ACCEPT_ENCODING]=gzip,compress,br,deflate [HTTP_CONTENT_TYPE]=application/json [HTTP_USER_AGENT]=Mozilla/5.0 (Linux; Android 10; AQM-AL10 Build/HONORAQM-AL10; wv) AppleWebKit/537.36 (KHTML, like Gecko) Version/4.0 Chrome/86.0.4240.99 XWEB/3171 MMWEBSDK/20211001 Mobile Safari/537.36 MMWEBID/7532 MicroMessenger/8.0.16.2040(0x2800105B) Process/appbrand1 WeChat/arm64 Weixin NetType/WIFI Language/zh_CN ABI/arm64 MiniProgramEnv/android [HTTP_CHARSET]=utf-8 [HTTP_CONTENT_LENGTH]=301 [HTTP_CONNECTION]=keep-alive [HTTP_HOST]=api.kuailaiyou.top [REDIRECT_STATUS]=200 [SERVER_NAME]=api.kuailaiyou.top [SERVER_PORT]=443 [SERVER_ADDR]=172.18.217.149 [REMOTE_PORT]=6136 [REMOTE_ADDR]=221.197.110.50 [SERVER_SOFTWARE]=nginx/1.20.1 [GATEWAY_INTERFACE]=CGI/1.1 [HTTPS]=on [REQUEST_SCHEME]=https [SERVER_PROTOCOL]=HTTP/1.1 [DOCUMENT_ROOT]=/bizroot/approot/klywebapi [DOCUMENT_URI]=/ajaxEntryCenter.php [REQUEST_URI]=/ajaxEntryCenter.php?WsAjaxPrj=KLY&WsAjaxBiz=Worker&WsAjaxAction=entityDataHandle [SCRIPT_NAME]=/ajaxEntryCenter.php [CONTENT_LENGTH]=301 [CONTENT_TYPE]=application/json [REQUEST_METHOD]=POST [QUERY_STRING]=WsAjaxPrj=KLY&WsAjaxBiz=Worker&WsAjaxAction=entityDataHandle [SCRIPT_FILENAME]=/bizroot/approot/klywebapi/ajaxEntryCenter.php [FCGI_ROLE]=RESPONDER [PHP_SELF]=/ajaxEntryCenter.php [REQUEST_TIME_FLOAT]=1640869726.2509 [REQUEST_TIME]=1640869726