12:15:31 [error]: 通用的实体数据存取接口异常:数据库执行异常:Incorrect string value: '\xF0\x9F\x8E\x97\xEF\xB8...' for column `bizdbKLY`.`biz_trader_recruit`.`work_desc` at row 1 sql语句:SET SESSION TRANSACTION ISOLATION LEVEL REPEATABLE READ;start transaction;insert into biz_trader_recruit set `title` = :title , `profile_photo` = :profile_photo , `work_typename` = :work_typename , `feeper` = :feeper , `feetotal` = :feetotal , `meals_providing` = :meals_providing , `urgent_level` = :urgent_level , `settle_catalog` = :settle_catalog , `begin_datetime` = :begin_datetime , `finish_datetime` = :finish_datetime , `begin_hour` = :begin_hour , `begin_hour2` = :begin_hour2 , `finish_hour` = :finish_hour , `finish_hour2` = :finish_hour2 , `need_total` = :need_total , `need_perday` = :need_perday , `requirements` = :requirements , `linker_name` = :linker_name , `linker_phone` = :linker_phone , `age_mode` = :age_mode , `age_min` = :age_min , `age_max` = :age_max , `gender_mode` = :gender_mode , `work_addr` = :work_addr , `work_addr1` = :work_addr1 , `work_addr_lng` = :work_addr_lng , `work_addr_lat` = :work_addr_lat , `work_desc` = :work_desc , `work_process` = :work_process , `work_remark` = :work_remark , `enroll_audit` = :enroll_audit , `settle_mode` = :settle_mode , `biz_traderid` = :biz_traderid , `status` = :status , `remark` = :remark , `createtime` = :createtime , `enrolled_heads` = :enrolled_heads; set @bizid=LAST_INSERT_ID(); update biz_trader_recruit set updatetime=:auto_nowtime, `status`=:auto_status, remark=concat(:auto_remark,ifnull(remark,'')) ,plat_fetchrate=:plat_fetchrate,plat_fetchmoney=:plat_fetchmoney ,sharer_fetchrate=:sharer_fetchrate,sharer_fetchmoney=:sharer_fetchmoney ,salary=:salary,feeper=:auto_feeper where id=@bizid; update biz_trader set updatetime=1656476131 ,freecount_used=ifnull(freecount_used,0)+10 ,freecount_used_remark=concat(:freecount_used_remark,@bizid,' ',ifnull(freecount_used_remark,'')) where id=95; insert into biz_trader_numaccount set createtime=1656476131 ,biz_traderid=95 ,type=1,biz_catalog=0,biz_id=@bizid,`count`=0,`freecount`=10 ,`status`=1,remark=concat(:numaccount_remark,@bizid,' ',ifnull(remark,'')); select * from biz_trader_recruit where id=@bizid;commit; ["22007",1366,"Incorrect string value: '\\xF0\\x9F\\x8E\\x97\\xEF\\xB8...' for column `bizdbKLY`.`biz_trader_recruit`.`work_desc` at row 1"] 异常发生在文件:[/bizroot/approot/klywebapi/prjcenter/prjKLY/bizcenter/Trader/entityDataHandle.php]的[170]行 code[0] ! 异常堆栈上下文: #0 /bizroot/approot/klywebapi/ajaxEntryCenter.php(65): include_once() #1 {main} 数据库执行异常:Incorrect string value: '\xF0\x9F\x8E\x97\xEF\xB8...' for column `bizdbKLY`.`biz_trader_recruit`.`work_desc` at row 1 sql语句:SET SESSION TRANSACTION ISOLATION LEVEL REPEATABLE READ;start transaction;insert into biz_trader_recruit set `title` = :title , `profile_photo` = :profile_photo , `work_typename` = :work_typename , `feeper` = :feeper , `feetotal` = :feetotal , `meals_providing` = :meals_providing , `urgent_level` = :urgent_level , `settle_catalog` = :settle_catalog , `begin_datetime` = :begin_datetime , `finish_datetime` = :finish_datetime , `begin_hour` = :begin_hour , `begin_hour2` = :begin_hour2 , `finish_hour` = :finish_hour , `finish_hour2` = :finish_hour2 , `need_total` = :need_total , `need_perday` = :need_perday , `requirements` = :requirements , `linker_name` = :linker_name , `linker_phone` = :linker_phone , `age_mode` = :age_mode , `age_min` = :age_min , `age_max` = :age_max , `gender_mode` = :gender_mode , `work_addr` = :work_addr , `work_addr1` = :work_addr1 , `work_addr_lng` = :work_addr_lng , `work_addr_lat` = :work_addr_lat , `work_desc` = :work_desc , `work_process` = :work_process , `work_remark` = :work_remark , `enroll_audit` = :enroll_audit , `settle_mode` = :settle_mode , `biz_traderid` = :biz_traderid , `status` = :status , `remark` = :remark , `createtime` = :createtime , `enrolled_heads` = :enrolled_heads; set @bizid=LAST_INSERT_ID(); update biz_trader_recruit set updatetime=:auto_nowtime, `status`=:auto_status, remark=concat(:auto_remark,ifnull(remark,'')) ,plat_fetchrate=:plat_fetchrate,plat_fetchmoney=:plat_fetchmoney ,sharer_fetchrate=:sharer_fetchrate,sharer_fetchmoney=:sharer_fetchmoney ,salary=:salary,feeper=:auto_feeper where id=@bizid; update biz_trader set updatetime=1656476131 ,freecount_used=ifnull(freecount_used,0)+10 ,freecount_used_remark=concat(:freecount_used_remark,@bizid,' ',ifnull(freecount_used_remark,'')) where id=95; insert into biz_trader_numaccount set createtime=1656476131 ,biz_traderid=95 ,type=1,biz_catalog=0,biz_id=@bizid,`count`=0,`freecount`=10 ,`status`=1,remark=concat(:numaccount_remark,@bizid,' ',ifnull(remark,'')); select * from biz_trader_recruit where id=@bizid;commit; ["22007",1366,"Incorrect string value: '\\xF0\\x9F\\x8E\\x97\\xEF\\xB8...' for column `bizdbKLY`.`biz_trader_recruit`.`work_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(530): pdo_query3() #4 /bizroot/approot/klywebapi/base/base.php(355): {closure}() #5 /bizroot/approot/klywebapi/prjcenter/prjKLY/base/common.php(20): filelock_handle() #6 /bizroot/approot/klywebapi/prjcenter/prjKLY/base/AboutActivity.php(533): biz_flkForTrader() #7 /bizroot/approot/klywebapi/prjcenter/prjKLY/bizcenter/Trader/entityDataHandle.php(44): bizbase_recruitEntityHandle() #8 /bizroot/approot/klywebapi/ajaxEntryCenter.php(65): include_once('/bizroot/approo...') #9 {main} [上下文相关信息]: [WsAjaxPrj]=KLY [WsAjaxBiz]=Trader [WsAjaxAction]=entityDataHandle [USER]=nginxphp [HOME]=/home/nginxphp [HTTP_REFERER]=https://servicewechat.com/wx8c230ea00ceb8676/2/page-frame.html [HTTP_ACCEPT_ENCODING]=gzip,compress,br,deflate [HTTP_CONTENT_TYPE]=application/json [HTTP_USER_AGENT]=Mozilla/5.0 (Linux; Android 12; Mi 10 Build/SKQ1.220303.001; wv) AppleWebKit/537.36 (KHTML, like Gecko) Version/4.0 Chrome/86.0.4240.99 XWEB/4255 MMWEBSDK/20220604 Mobile Safari/537.36 MMWEBID/655 MicroMessenger/8.0.24.2180(0x28001837) WeChat/arm64 Weixin NetType/WIFI Language/zh_CN ABI/arm64 MiniProgramEnv/android [HTTP_CHARSET]=utf-8 [HTTP_CONTENT_LENGTH]=926 [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]=13356 [REMOTE_ADDR]=218.69.51.169 [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=Trader&WsAjaxAction=entityDataHandle [SCRIPT_NAME]=/ajaxEntryCenter.php [CONTENT_LENGTH]=926 [CONTENT_TYPE]=application/json [REQUEST_METHOD]=POST [QUERY_STRING]=WsAjaxPrj=KLY&WsAjaxBiz=Trader&WsAjaxAction=entityDataHandle [SCRIPT_FILENAME]=/bizroot/approot/klywebapi/ajaxEntryCenter.php [FCGI_ROLE]=RESPONDER [PHP_SELF]=/ajaxEntryCenter.php [REQUEST_TIME_FLOAT]=1656476131.2855 [REQUEST_TIME]=1656476131 12:15:43 [error]: 通用的实体数据存取接口异常:数据库执行异常:Incorrect string value: '\xF0\x9F\x8E\x97\xEF\xB8...' for column `bizdbKLY`.`biz_trader_recruit`.`work_desc` at row 1 sql语句:SET SESSION TRANSACTION ISOLATION LEVEL REPEATABLE READ;start transaction;insert into biz_trader_recruit set `title` = :title , `profile_photo` = :profile_photo , `work_typename` = :work_typename , `feeper` = :feeper , `feetotal` = :feetotal , `meals_providing` = :meals_providing , `urgent_level` = :urgent_level , `settle_catalog` = :settle_catalog , `begin_datetime` = :begin_datetime , `finish_datetime` = :finish_datetime , `begin_hour` = :begin_hour , `begin_hour2` = :begin_hour2 , `finish_hour` = :finish_hour , `finish_hour2` = :finish_hour2 , `need_total` = :need_total , `need_perday` = :need_perday , `requirements` = :requirements , `linker_name` = :linker_name , `linker_phone` = :linker_phone , `age_mode` = :age_mode , `age_min` = :age_min , `age_max` = :age_max , `gender_mode` = :gender_mode , `work_addr` = :work_addr , `work_addr1` = :work_addr1 , `work_addr_lng` = :work_addr_lng , `work_addr_lat` = :work_addr_lat , `work_desc` = :work_desc , `work_process` = :work_process , `work_remark` = :work_remark , `enroll_audit` = :enroll_audit , `settle_mode` = :settle_mode , `biz_traderid` = :biz_traderid , `status` = :status , `remark` = :remark , `createtime` = :createtime , `enrolled_heads` = :enrolled_heads; set @bizid=LAST_INSERT_ID(); update biz_trader_recruit set updatetime=:auto_nowtime, `status`=:auto_status, remark=concat(:auto_remark,ifnull(remark,'')) ,plat_fetchrate=:plat_fetchrate,plat_fetchmoney=:plat_fetchmoney ,sharer_fetchrate=:sharer_fetchrate,sharer_fetchmoney=:sharer_fetchmoney ,salary=:salary,feeper=:auto_feeper where id=@bizid; update biz_trader set updatetime=1656476143 ,freecount_used=ifnull(freecount_used,0)+10 ,freecount_used_remark=concat(:freecount_used_remark,@bizid,' ',ifnull(freecount_used_remark,'')) where id=95; insert into biz_trader_numaccount set createtime=1656476143 ,biz_traderid=95 ,type=1,biz_catalog=0,biz_id=@bizid,`count`=0,`freecount`=10 ,`status`=1,remark=concat(:numaccount_remark,@bizid,' ',ifnull(remark,'')); select * from biz_trader_recruit where id=@bizid;commit; ["22007",1366,"Incorrect string value: '\\xF0\\x9F\\x8E\\x97\\xEF\\xB8...' for column `bizdbKLY`.`biz_trader_recruit`.`work_desc` at row 1"] 异常发生在文件:[/bizroot/approot/klywebapi/prjcenter/prjKLY/bizcenter/Trader/entityDataHandle.php]的[170]行 code[0] ! 异常堆栈上下文: #0 /bizroot/approot/klywebapi/ajaxEntryCenter.php(65): include_once() #1 {main} 数据库执行异常:Incorrect string value: '\xF0\x9F\x8E\x97\xEF\xB8...' for column `bizdbKLY`.`biz_trader_recruit`.`work_desc` at row 1 sql语句:SET SESSION TRANSACTION ISOLATION LEVEL REPEATABLE READ;start transaction;insert into biz_trader_recruit set `title` = :title , `profile_photo` = :profile_photo , `work_typename` = :work_typename , `feeper` = :feeper , `feetotal` = :feetotal , `meals_providing` = :meals_providing , `urgent_level` = :urgent_level , `settle_catalog` = :settle_catalog , `begin_datetime` = :begin_datetime , `finish_datetime` = :finish_datetime , `begin_hour` = :begin_hour , `begin_hour2` = :begin_hour2 , `finish_hour` = :finish_hour , `finish_hour2` = :finish_hour2 , `need_total` = :need_total , `need_perday` = :need_perday , `requirements` = :requirements , `linker_name` = :linker_name , `linker_phone` = :linker_phone , `age_mode` = :age_mode , `age_min` = :age_min , `age_max` = :age_max , `gender_mode` = :gender_mode , `work_addr` = :work_addr , `work_addr1` = :work_addr1 , `work_addr_lng` = :work_addr_lng , `work_addr_lat` = :work_addr_lat , `work_desc` = :work_desc , `work_process` = :work_process , `work_remark` = :work_remark , `enroll_audit` = :enroll_audit , `settle_mode` = :settle_mode , `biz_traderid` = :biz_traderid , `status` = :status , `remark` = :remark , `createtime` = :createtime , `enrolled_heads` = :enrolled_heads; set @bizid=LAST_INSERT_ID(); update biz_trader_recruit set updatetime=:auto_nowtime, `status`=:auto_status, remark=concat(:auto_remark,ifnull(remark,'')) ,plat_fetchrate=:plat_fetchrate,plat_fetchmoney=:plat_fetchmoney ,sharer_fetchrate=:sharer_fetchrate,sharer_fetchmoney=:sharer_fetchmoney ,salary=:salary,feeper=:auto_feeper where id=@bizid; update biz_trader set updatetime=1656476143 ,freecount_used=ifnull(freecount_used,0)+10 ,freecount_used_remark=concat(:freecount_used_remark,@bizid,' ',ifnull(freecount_used_remark,'')) where id=95; insert into biz_trader_numaccount set createtime=1656476143 ,biz_traderid=95 ,type=1,biz_catalog=0,biz_id=@bizid,`count`=0,`freecount`=10 ,`status`=1,remark=concat(:numaccount_remark,@bizid,' ',ifnull(remark,'')); select * from biz_trader_recruit where id=@bizid;commit; ["22007",1366,"Incorrect string value: '\\xF0\\x9F\\x8E\\x97\\xEF\\xB8...' for column `bizdbKLY`.`biz_trader_recruit`.`work_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(530): pdo_query3() #4 /bizroot/approot/klywebapi/base/base.php(355): {closure}() #5 /bizroot/approot/klywebapi/prjcenter/prjKLY/base/common.php(20): filelock_handle() #6 /bizroot/approot/klywebapi/prjcenter/prjKLY/base/AboutActivity.php(533): biz_flkForTrader() #7 /bizroot/approot/klywebapi/prjcenter/prjKLY/bizcenter/Trader/entityDataHandle.php(44): bizbase_recruitEntityHandle() #8 /bizroot/approot/klywebapi/ajaxEntryCenter.php(65): include_once('/bizroot/approo...') #9 {main} [上下文相关信息]: [WsAjaxPrj]=KLY [WsAjaxBiz]=Trader [WsAjaxAction]=entityDataHandle [USER]=nginxphp [HOME]=/home/nginxphp [HTTP_REFERER]=https://servicewechat.com/wx8c230ea00ceb8676/2/page-frame.html [HTTP_ACCEPT_ENCODING]=gzip,compress,br,deflate [HTTP_CONTENT_TYPE]=application/json [HTTP_USER_AGENT]=Mozilla/5.0 (Linux; Android 12; Mi 10 Build/SKQ1.220303.001; wv) AppleWebKit/537.36 (KHTML, like Gecko) Version/4.0 Chrome/86.0.4240.99 XWEB/4255 MMWEBSDK/20220604 Mobile Safari/537.36 MMWEBID/655 MicroMessenger/8.0.24.2180(0x28001837) WeChat/arm64 Weixin NetType/WIFI Language/zh_CN ABI/arm64 MiniProgramEnv/android [HTTP_CHARSET]=utf-8 [HTTP_CONTENT_LENGTH]=926 [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]=13356 [REMOTE_ADDR]=218.69.51.169 [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=Trader&WsAjaxAction=entityDataHandle [SCRIPT_NAME]=/ajaxEntryCenter.php [CONTENT_LENGTH]=926 [CONTENT_TYPE]=application/json [REQUEST_METHOD]=POST [QUERY_STRING]=WsAjaxPrj=KLY&WsAjaxBiz=Trader&WsAjaxAction=entityDataHandle [SCRIPT_FILENAME]=/bizroot/approot/klywebapi/ajaxEntryCenter.php [FCGI_ROLE]=RESPONDER [PHP_SELF]=/ajaxEntryCenter.php [REQUEST_TIME_FLOAT]=1656476143.4944 [REQUEST_TIME]=1656476143 12:15:51 [error]: 通用的实体数据存取接口异常:数据库执行异常:Incorrect string value: '\xF0\x9F\x8E\x97\xEF\xB8...' for column `bizdbKLY`.`biz_trader_recruit`.`work_desc` at row 1 sql语句:SET SESSION TRANSACTION ISOLATION LEVEL REPEATABLE READ;start transaction;insert into biz_trader_recruit set `title` = :title , `profile_photo` = :profile_photo , `work_typename` = :work_typename , `feeper` = :feeper , `feetotal` = :feetotal , `meals_providing` = :meals_providing , `urgent_level` = :urgent_level , `settle_catalog` = :settle_catalog , `begin_datetime` = :begin_datetime , `finish_datetime` = :finish_datetime , `begin_hour` = :begin_hour , `begin_hour2` = :begin_hour2 , `finish_hour` = :finish_hour , `finish_hour2` = :finish_hour2 , `need_total` = :need_total , `need_perday` = :need_perday , `requirements` = :requirements , `linker_name` = :linker_name , `linker_phone` = :linker_phone , `age_mode` = :age_mode , `age_min` = :age_min , `age_max` = :age_max , `gender_mode` = :gender_mode , `work_addr` = :work_addr , `work_addr1` = :work_addr1 , `work_addr_lng` = :work_addr_lng , `work_addr_lat` = :work_addr_lat , `work_desc` = :work_desc , `work_process` = :work_process , `work_remark` = :work_remark , `enroll_audit` = :enroll_audit , `settle_mode` = :settle_mode , `biz_traderid` = :biz_traderid , `status` = :status , `remark` = :remark , `createtime` = :createtime , `enrolled_heads` = :enrolled_heads; set @bizid=LAST_INSERT_ID(); update biz_trader_recruit set updatetime=:auto_nowtime, `status`=:auto_status, remark=concat(:auto_remark,ifnull(remark,'')) ,plat_fetchrate=:plat_fetchrate,plat_fetchmoney=:plat_fetchmoney ,sharer_fetchrate=:sharer_fetchrate,sharer_fetchmoney=:sharer_fetchmoney ,salary=:salary,feeper=:auto_feeper where id=@bizid; update biz_trader set updatetime=1656476151 ,freecount_used=ifnull(freecount_used,0)+10 ,freecount_used_remark=concat(:freecount_used_remark,@bizid,' ',ifnull(freecount_used_remark,'')) where id=95; insert into biz_trader_numaccount set createtime=1656476151 ,biz_traderid=95 ,type=1,biz_catalog=0,biz_id=@bizid,`count`=0,`freecount`=10 ,`status`=1,remark=concat(:numaccount_remark,@bizid,' ',ifnull(remark,'')); select * from biz_trader_recruit where id=@bizid;commit; ["22007",1366,"Incorrect string value: '\\xF0\\x9F\\x8E\\x97\\xEF\\xB8...' for column `bizdbKLY`.`biz_trader_recruit`.`work_desc` at row 1"] 异常发生在文件:[/bizroot/approot/klywebapi/prjcenter/prjKLY/bizcenter/Trader/entityDataHandle.php]的[170]行 code[0] ! 异常堆栈上下文: #0 /bizroot/approot/klywebapi/ajaxEntryCenter.php(65): include_once() #1 {main} 数据库执行异常:Incorrect string value: '\xF0\x9F\x8E\x97\xEF\xB8...' for column `bizdbKLY`.`biz_trader_recruit`.`work_desc` at row 1 sql语句:SET SESSION TRANSACTION ISOLATION LEVEL REPEATABLE READ;start transaction;insert into biz_trader_recruit set `title` = :title , `profile_photo` = :profile_photo , `work_typename` = :work_typename , `feeper` = :feeper , `feetotal` = :feetotal , `meals_providing` = :meals_providing , `urgent_level` = :urgent_level , `settle_catalog` = :settle_catalog , `begin_datetime` = :begin_datetime , `finish_datetime` = :finish_datetime , `begin_hour` = :begin_hour , `begin_hour2` = :begin_hour2 , `finish_hour` = :finish_hour , `finish_hour2` = :finish_hour2 , `need_total` = :need_total , `need_perday` = :need_perday , `requirements` = :requirements , `linker_name` = :linker_name , `linker_phone` = :linker_phone , `age_mode` = :age_mode , `age_min` = :age_min , `age_max` = :age_max , `gender_mode` = :gender_mode , `work_addr` = :work_addr , `work_addr1` = :work_addr1 , `work_addr_lng` = :work_addr_lng , `work_addr_lat` = :work_addr_lat , `work_desc` = :work_desc , `work_process` = :work_process , `work_remark` = :work_remark , `enroll_audit` = :enroll_audit , `settle_mode` = :settle_mode , `biz_traderid` = :biz_traderid , `status` = :status , `remark` = :remark , `createtime` = :createtime , `enrolled_heads` = :enrolled_heads; set @bizid=LAST_INSERT_ID(); update biz_trader_recruit set updatetime=:auto_nowtime, `status`=:auto_status, remark=concat(:auto_remark,ifnull(remark,'')) ,plat_fetchrate=:plat_fetchrate,plat_fetchmoney=:plat_fetchmoney ,sharer_fetchrate=:sharer_fetchrate,sharer_fetchmoney=:sharer_fetchmoney ,salary=:salary,feeper=:auto_feeper where id=@bizid; update biz_trader set updatetime=1656476151 ,freecount_used=ifnull(freecount_used,0)+10 ,freecount_used_remark=concat(:freecount_used_remark,@bizid,' ',ifnull(freecount_used_remark,'')) where id=95; insert into biz_trader_numaccount set createtime=1656476151 ,biz_traderid=95 ,type=1,biz_catalog=0,biz_id=@bizid,`count`=0,`freecount`=10 ,`status`=1,remark=concat(:numaccount_remark,@bizid,' ',ifnull(remark,'')); select * from biz_trader_recruit where id=@bizid;commit; ["22007",1366,"Incorrect string value: '\\xF0\\x9F\\x8E\\x97\\xEF\\xB8...' for column `bizdbKLY`.`biz_trader_recruit`.`work_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(530): pdo_query3() #4 /bizroot/approot/klywebapi/base/base.php(355): {closure}() #5 /bizroot/approot/klywebapi/prjcenter/prjKLY/base/common.php(20): filelock_handle() #6 /bizroot/approot/klywebapi/prjcenter/prjKLY/base/AboutActivity.php(533): biz_flkForTrader() #7 /bizroot/approot/klywebapi/prjcenter/prjKLY/bizcenter/Trader/entityDataHandle.php(44): bizbase_recruitEntityHandle() #8 /bizroot/approot/klywebapi/ajaxEntryCenter.php(65): include_once('/bizroot/approo...') #9 {main} [上下文相关信息]: [WsAjaxPrj]=KLY [WsAjaxBiz]=Trader [WsAjaxAction]=entityDataHandle [USER]=nginxphp [HOME]=/home/nginxphp [HTTP_REFERER]=https://servicewechat.com/wx8c230ea00ceb8676/2/page-frame.html [HTTP_ACCEPT_ENCODING]=gzip,compress,br,deflate [HTTP_CONTENT_TYPE]=application/json [HTTP_USER_AGENT]=Mozilla/5.0 (Linux; Android 12; Mi 10 Build/SKQ1.220303.001; wv) AppleWebKit/537.36 (KHTML, like Gecko) Version/4.0 Chrome/86.0.4240.99 XWEB/4255 MMWEBSDK/20220604 Mobile Safari/537.36 MMWEBID/655 MicroMessenger/8.0.24.2180(0x28001837) WeChat/arm64 Weixin NetType/WIFI Language/zh_CN ABI/arm64 MiniProgramEnv/android [HTTP_CHARSET]=utf-8 [HTTP_CONTENT_LENGTH]=926 [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]=13356 [REMOTE_ADDR]=218.69.51.169 [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=Trader&WsAjaxAction=entityDataHandle [SCRIPT_NAME]=/ajaxEntryCenter.php [CONTENT_LENGTH]=926 [CONTENT_TYPE]=application/json [REQUEST_METHOD]=POST [QUERY_STRING]=WsAjaxPrj=KLY&WsAjaxBiz=Trader&WsAjaxAction=entityDataHandle [SCRIPT_FILENAME]=/bizroot/approot/klywebapi/ajaxEntryCenter.php [FCGI_ROLE]=RESPONDER [PHP_SELF]=/ajaxEntryCenter.php [REQUEST_TIME_FLOAT]=1656476151.9822 [REQUEST_TIME]=1656476151 12:16:22 [error]: 通用的实体数据存取接口异常:数据库执行异常:Incorrect string value: '\xF0\x9F\x8E\x97\xEF\xB8...' for column `bizdbKLY`.`biz_trader_recruit`.`work_desc` at row 1 sql语句:SET SESSION TRANSACTION ISOLATION LEVEL REPEATABLE READ;start transaction;insert into biz_trader_recruit set `title` = :title , `profile_photo` = :profile_photo , `work_typename` = :work_typename , `feeper` = :feeper , `feetotal` = :feetotal , `meals_providing` = :meals_providing , `urgent_level` = :urgent_level , `settle_catalog` = :settle_catalog , `begin_datetime` = :begin_datetime , `finish_datetime` = :finish_datetime , `begin_hour` = :begin_hour , `begin_hour2` = :begin_hour2 , `finish_hour` = :finish_hour , `finish_hour2` = :finish_hour2 , `need_total` = :need_total , `need_perday` = :need_perday , `requirements` = :requirements , `linker_name` = :linker_name , `linker_phone` = :linker_phone , `age_mode` = :age_mode , `age_min` = :age_min , `age_max` = :age_max , `gender_mode` = :gender_mode , `work_addr` = :work_addr , `work_addr1` = :work_addr1 , `work_addr_lng` = :work_addr_lng , `work_addr_lat` = :work_addr_lat , `work_desc` = :work_desc , `work_process` = :work_process , `work_remark` = :work_remark , `enroll_audit` = :enroll_audit , `settle_mode` = :settle_mode , `biz_traderid` = :biz_traderid , `status` = :status , `remark` = :remark , `createtime` = :createtime , `enrolled_heads` = :enrolled_heads; set @bizid=LAST_INSERT_ID(); update biz_trader_recruit set updatetime=:auto_nowtime, `status`=:auto_status, remark=concat(:auto_remark,ifnull(remark,'')) ,plat_fetchrate=:plat_fetchrate,plat_fetchmoney=:plat_fetchmoney ,sharer_fetchrate=:sharer_fetchrate,sharer_fetchmoney=:sharer_fetchmoney ,salary=:salary,feeper=:auto_feeper where id=@bizid; update biz_trader set updatetime=1656476182 ,freecount_used=ifnull(freecount_used,0)+10 ,freecount_used_remark=concat(:freecount_used_remark,@bizid,' ',ifnull(freecount_used_remark,'')) where id=95; insert into biz_trader_numaccount set createtime=1656476182 ,biz_traderid=95 ,type=1,biz_catalog=0,biz_id=@bizid,`count`=0,`freecount`=10 ,`status`=1,remark=concat(:numaccount_remark,@bizid,' ',ifnull(remark,'')); select * from biz_trader_recruit where id=@bizid;commit; ["22007",1366,"Incorrect string value: '\\xF0\\x9F\\x8E\\x97\\xEF\\xB8...' for column `bizdbKLY`.`biz_trader_recruit`.`work_desc` at row 1"] 异常发生在文件:[/bizroot/approot/klywebapi/prjcenter/prjKLY/bizcenter/Trader/entityDataHandle.php]的[170]行 code[0] ! 异常堆栈上下文: #0 /bizroot/approot/klywebapi/ajaxEntryCenter.php(65): include_once() #1 {main} 数据库执行异常:Incorrect string value: '\xF0\x9F\x8E\x97\xEF\xB8...' for column `bizdbKLY`.`biz_trader_recruit`.`work_desc` at row 1 sql语句:SET SESSION TRANSACTION ISOLATION LEVEL REPEATABLE READ;start transaction;insert into biz_trader_recruit set `title` = :title , `profile_photo` = :profile_photo , `work_typename` = :work_typename , `feeper` = :feeper , `feetotal` = :feetotal , `meals_providing` = :meals_providing , `urgent_level` = :urgent_level , `settle_catalog` = :settle_catalog , `begin_datetime` = :begin_datetime , `finish_datetime` = :finish_datetime , `begin_hour` = :begin_hour , `begin_hour2` = :begin_hour2 , `finish_hour` = :finish_hour , `finish_hour2` = :finish_hour2 , `need_total` = :need_total , `need_perday` = :need_perday , `requirements` = :requirements , `linker_name` = :linker_name , `linker_phone` = :linker_phone , `age_mode` = :age_mode , `age_min` = :age_min , `age_max` = :age_max , `gender_mode` = :gender_mode , `work_addr` = :work_addr , `work_addr1` = :work_addr1 , `work_addr_lng` = :work_addr_lng , `work_addr_lat` = :work_addr_lat , `work_desc` = :work_desc , `work_process` = :work_process , `work_remark` = :work_remark , `enroll_audit` = :enroll_audit , `settle_mode` = :settle_mode , `biz_traderid` = :biz_traderid , `status` = :status , `remark` = :remark , `createtime` = :createtime , `enrolled_heads` = :enrolled_heads; set @bizid=LAST_INSERT_ID(); update biz_trader_recruit set updatetime=:auto_nowtime, `status`=:auto_status, remark=concat(:auto_remark,ifnull(remark,'')) ,plat_fetchrate=:plat_fetchrate,plat_fetchmoney=:plat_fetchmoney ,sharer_fetchrate=:sharer_fetchrate,sharer_fetchmoney=:sharer_fetchmoney ,salary=:salary,feeper=:auto_feeper where id=@bizid; update biz_trader set updatetime=1656476182 ,freecount_used=ifnull(freecount_used,0)+10 ,freecount_used_remark=concat(:freecount_used_remark,@bizid,' ',ifnull(freecount_used_remark,'')) where id=95; insert into biz_trader_numaccount set createtime=1656476182 ,biz_traderid=95 ,type=1,biz_catalog=0,biz_id=@bizid,`count`=0,`freecount`=10 ,`status`=1,remark=concat(:numaccount_remark,@bizid,' ',ifnull(remark,'')); select * from biz_trader_recruit where id=@bizid;commit; ["22007",1366,"Incorrect string value: '\\xF0\\x9F\\x8E\\x97\\xEF\\xB8...' for column `bizdbKLY`.`biz_trader_recruit`.`work_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(530): pdo_query3() #4 /bizroot/approot/klywebapi/base/base.php(355): {closure}() #5 /bizroot/approot/klywebapi/prjcenter/prjKLY/base/common.php(20): filelock_handle() #6 /bizroot/approot/klywebapi/prjcenter/prjKLY/base/AboutActivity.php(533): biz_flkForTrader() #7 /bizroot/approot/klywebapi/prjcenter/prjKLY/bizcenter/Trader/entityDataHandle.php(44): bizbase_recruitEntityHandle() #8 /bizroot/approot/klywebapi/ajaxEntryCenter.php(65): include_once('/bizroot/approo...') #9 {main} [上下文相关信息]: [WsAjaxPrj]=KLY [WsAjaxBiz]=Trader [WsAjaxAction]=entityDataHandle [USER]=nginxphp [HOME]=/home/nginxphp [HTTP_REFERER]=https://servicewechat.com/wx8c230ea00ceb8676/2/page-frame.html [HTTP_ACCEPT_ENCODING]=gzip,compress,br,deflate [HTTP_CONTENT_TYPE]=application/json [HTTP_USER_AGENT]=Mozilla/5.0 (Linux; Android 12; Mi 10 Build/SKQ1.220303.001; wv) AppleWebKit/537.36 (KHTML, like Gecko) Version/4.0 Chrome/86.0.4240.99 XWEB/4255 MMWEBSDK/20220604 Mobile Safari/537.36 MMWEBID/655 MicroMessenger/8.0.24.2180(0x28001837) WeChat/arm64 Weixin NetType/WIFI Language/zh_CN ABI/arm64 MiniProgramEnv/android [HTTP_CHARSET]=utf-8 [HTTP_CONTENT_LENGTH]=934 [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]=13467 [REMOTE_ADDR]=218.69.51.169 [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=Trader&WsAjaxAction=entityDataHandle [SCRIPT_NAME]=/ajaxEntryCenter.php [CONTENT_LENGTH]=934 [CONTENT_TYPE]=application/json [REQUEST_METHOD]=POST [QUERY_STRING]=WsAjaxPrj=KLY&WsAjaxBiz=Trader&WsAjaxAction=entityDataHandle [SCRIPT_FILENAME]=/bizroot/approot/klywebapi/ajaxEntryCenter.php [FCGI_ROLE]=RESPONDER [PHP_SELF]=/ajaxEntryCenter.php [REQUEST_TIME_FLOAT]=1656476182.7348 [REQUEST_TIME]=1656476182 12:16:32 [error]: 通用的实体数据存取接口异常:数据库执行异常:Incorrect string value: '\xF0\x9F\x8E\x97\xEF\xB8...' for column `bizdbKLY`.`biz_trader_recruit`.`work_desc` at row 1 sql语句:SET SESSION TRANSACTION ISOLATION LEVEL REPEATABLE READ;start transaction;insert into biz_trader_recruit set `title` = :title , `profile_photo` = :profile_photo , `work_typename` = :work_typename , `feeper` = :feeper , `feetotal` = :feetotal , `meals_providing` = :meals_providing , `urgent_level` = :urgent_level , `settle_catalog` = :settle_catalog , `begin_datetime` = :begin_datetime , `finish_datetime` = :finish_datetime , `begin_hour` = :begin_hour , `begin_hour2` = :begin_hour2 , `finish_hour` = :finish_hour , `finish_hour2` = :finish_hour2 , `need_total` = :need_total , `need_perday` = :need_perday , `requirements` = :requirements , `linker_name` = :linker_name , `linker_phone` = :linker_phone , `age_mode` = :age_mode , `age_min` = :age_min , `age_max` = :age_max , `gender_mode` = :gender_mode , `work_addr` = :work_addr , `work_addr1` = :work_addr1 , `work_addr_lng` = :work_addr_lng , `work_addr_lat` = :work_addr_lat , `work_desc` = :work_desc , `work_process` = :work_process , `work_remark` = :work_remark , `enroll_audit` = :enroll_audit , `settle_mode` = :settle_mode , `biz_traderid` = :biz_traderid , `status` = :status , `remark` = :remark , `createtime` = :createtime , `enrolled_heads` = :enrolled_heads; set @bizid=LAST_INSERT_ID(); update biz_trader_recruit set updatetime=:auto_nowtime, `status`=:auto_status, remark=concat(:auto_remark,ifnull(remark,'')) ,plat_fetchrate=:plat_fetchrate,plat_fetchmoney=:plat_fetchmoney ,sharer_fetchrate=:sharer_fetchrate,sharer_fetchmoney=:sharer_fetchmoney ,salary=:salary,feeper=:auto_feeper where id=@bizid; update biz_trader set updatetime=1656476192 ,freecount_used=ifnull(freecount_used,0)+1 ,freecount_used_remark=concat(:freecount_used_remark,@bizid,' ',ifnull(freecount_used_remark,'')) where id=95; insert into biz_trader_numaccount set createtime=1656476192 ,biz_traderid=95 ,type=1,biz_catalog=0,biz_id=@bizid,`count`=0,`freecount`=1 ,`status`=1,remark=concat(:numaccount_remark,@bizid,' ',ifnull(remark,'')); select * from biz_trader_recruit where id=@bizid;commit; ["22007",1366,"Incorrect string value: '\\xF0\\x9F\\x8E\\x97\\xEF\\xB8...' for column `bizdbKLY`.`biz_trader_recruit`.`work_desc` at row 1"] 异常发生在文件:[/bizroot/approot/klywebapi/prjcenter/prjKLY/bizcenter/Trader/entityDataHandle.php]的[170]行 code[0] ! 异常堆栈上下文: #0 /bizroot/approot/klywebapi/ajaxEntryCenter.php(65): include_once() #1 {main} 数据库执行异常:Incorrect string value: '\xF0\x9F\x8E\x97\xEF\xB8...' for column `bizdbKLY`.`biz_trader_recruit`.`work_desc` at row 1 sql语句:SET SESSION TRANSACTION ISOLATION LEVEL REPEATABLE READ;start transaction;insert into biz_trader_recruit set `title` = :title , `profile_photo` = :profile_photo , `work_typename` = :work_typename , `feeper` = :feeper , `feetotal` = :feetotal , `meals_providing` = :meals_providing , `urgent_level` = :urgent_level , `settle_catalog` = :settle_catalog , `begin_datetime` = :begin_datetime , `finish_datetime` = :finish_datetime , `begin_hour` = :begin_hour , `begin_hour2` = :begin_hour2 , `finish_hour` = :finish_hour , `finish_hour2` = :finish_hour2 , `need_total` = :need_total , `need_perday` = :need_perday , `requirements` = :requirements , `linker_name` = :linker_name , `linker_phone` = :linker_phone , `age_mode` = :age_mode , `age_min` = :age_min , `age_max` = :age_max , `gender_mode` = :gender_mode , `work_addr` = :work_addr , `work_addr1` = :work_addr1 , `work_addr_lng` = :work_addr_lng , `work_addr_lat` = :work_addr_lat , `work_desc` = :work_desc , `work_process` = :work_process , `work_remark` = :work_remark , `enroll_audit` = :enroll_audit , `settle_mode` = :settle_mode , `biz_traderid` = :biz_traderid , `status` = :status , `remark` = :remark , `createtime` = :createtime , `enrolled_heads` = :enrolled_heads; set @bizid=LAST_INSERT_ID(); update biz_trader_recruit set updatetime=:auto_nowtime, `status`=:auto_status, remark=concat(:auto_remark,ifnull(remark,'')) ,plat_fetchrate=:plat_fetchrate,plat_fetchmoney=:plat_fetchmoney ,sharer_fetchrate=:sharer_fetchrate,sharer_fetchmoney=:sharer_fetchmoney ,salary=:salary,feeper=:auto_feeper where id=@bizid; update biz_trader set updatetime=1656476192 ,freecount_used=ifnull(freecount_used,0)+1 ,freecount_used_remark=concat(:freecount_used_remark,@bizid,' ',ifnull(freecount_used_remark,'')) where id=95; insert into biz_trader_numaccount set createtime=1656476192 ,biz_traderid=95 ,type=1,biz_catalog=0,biz_id=@bizid,`count`=0,`freecount`=1 ,`status`=1,remark=concat(:numaccount_remark,@bizid,' ',ifnull(remark,'')); select * from biz_trader_recruit where id=@bizid;commit; ["22007",1366,"Incorrect string value: '\\xF0\\x9F\\x8E\\x97\\xEF\\xB8...' for column `bizdbKLY`.`biz_trader_recruit`.`work_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(530): pdo_query3() #4 /bizroot/approot/klywebapi/base/base.php(355): {closure}() #5 /bizroot/approot/klywebapi/prjcenter/prjKLY/base/common.php(20): filelock_handle() #6 /bizroot/approot/klywebapi/prjcenter/prjKLY/base/AboutActivity.php(533): biz_flkForTrader() #7 /bizroot/approot/klywebapi/prjcenter/prjKLY/bizcenter/Trader/entityDataHandle.php(44): bizbase_recruitEntityHandle() #8 /bizroot/approot/klywebapi/ajaxEntryCenter.php(65): include_once('/bizroot/approo...') #9 {main} [上下文相关信息]: [WsAjaxPrj]=KLY [WsAjaxBiz]=Trader [WsAjaxAction]=entityDataHandle [USER]=nginxphp [HOME]=/home/nginxphp [HTTP_REFERER]=https://servicewechat.com/wx8c230ea00ceb8676/2/page-frame.html [HTTP_ACCEPT_ENCODING]=gzip,compress,br,deflate [HTTP_CONTENT_TYPE]=application/json [HTTP_USER_AGENT]=Mozilla/5.0 (Linux; Android 12; Mi 10 Build/SKQ1.220303.001; wv) AppleWebKit/537.36 (KHTML, like Gecko) Version/4.0 Chrome/86.0.4240.99 XWEB/4255 MMWEBSDK/20220604 Mobile Safari/537.36 MMWEBID/655 MicroMessenger/8.0.24.2180(0x28001837) WeChat/arm64 Weixin NetType/WIFI Language/zh_CN ABI/arm64 MiniProgramEnv/android [HTTP_CHARSET]=utf-8 [HTTP_CONTENT_LENGTH]=933 [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]=13467 [REMOTE_ADDR]=218.69.51.169 [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=Trader&WsAjaxAction=entityDataHandle [SCRIPT_NAME]=/ajaxEntryCenter.php [CONTENT_LENGTH]=933 [CONTENT_TYPE]=application/json [REQUEST_METHOD]=POST [QUERY_STRING]=WsAjaxPrj=KLY&WsAjaxBiz=Trader&WsAjaxAction=entityDataHandle [SCRIPT_FILENAME]=/bizroot/approot/klywebapi/ajaxEntryCenter.php [FCGI_ROLE]=RESPONDER [PHP_SELF]=/ajaxEntryCenter.php [REQUEST_TIME_FLOAT]=1656476192.604 [REQUEST_TIME]=1656476192 12:16:41 [error]: 通用的实体数据存取接口异常:数据库执行异常:Incorrect string value: '\xF0\x9F\x8E\x97\xEF\xB8...' for column `bizdbKLY`.`biz_trader_recruit`.`work_desc` at row 1 sql语句:SET SESSION TRANSACTION ISOLATION LEVEL REPEATABLE READ;start transaction;insert into biz_trader_recruit set `title` = :title , `profile_photo` = :profile_photo , `work_typename` = :work_typename , `feeper` = :feeper , `feetotal` = :feetotal , `meals_providing` = :meals_providing , `urgent_level` = :urgent_level , `settle_catalog` = :settle_catalog , `begin_datetime` = :begin_datetime , `finish_datetime` = :finish_datetime , `begin_hour` = :begin_hour , `begin_hour2` = :begin_hour2 , `finish_hour` = :finish_hour , `finish_hour2` = :finish_hour2 , `need_total` = :need_total , `need_perday` = :need_perday , `requirements` = :requirements , `linker_name` = :linker_name , `linker_phone` = :linker_phone , `age_mode` = :age_mode , `age_min` = :age_min , `age_max` = :age_max , `gender_mode` = :gender_mode , `work_addr` = :work_addr , `work_addr1` = :work_addr1 , `work_addr_lng` = :work_addr_lng , `work_addr_lat` = :work_addr_lat , `work_desc` = :work_desc , `work_process` = :work_process , `work_remark` = :work_remark , `enroll_audit` = :enroll_audit , `settle_mode` = :settle_mode , `biz_traderid` = :biz_traderid , `status` = :status , `remark` = :remark , `createtime` = :createtime , `enrolled_heads` = :enrolled_heads; set @bizid=LAST_INSERT_ID(); update biz_trader_recruit set updatetime=:auto_nowtime, `status`=:auto_status, remark=concat(:auto_remark,ifnull(remark,'')) ,plat_fetchrate=:plat_fetchrate,plat_fetchmoney=:plat_fetchmoney ,sharer_fetchrate=:sharer_fetchrate,sharer_fetchmoney=:sharer_fetchmoney ,salary=:salary,feeper=:auto_feeper where id=@bizid; update biz_trader set updatetime=1656476201 ,freecount_used=ifnull(freecount_used,0)+1 ,freecount_used_remark=concat(:freecount_used_remark,@bizid,' ',ifnull(freecount_used_remark,'')) where id=95; insert into biz_trader_numaccount set createtime=1656476201 ,biz_traderid=95 ,type=1,biz_catalog=0,biz_id=@bizid,`count`=0,`freecount`=1 ,`status`=1,remark=concat(:numaccount_remark,@bizid,' ',ifnull(remark,'')); select * from biz_trader_recruit where id=@bizid;commit; ["22007",1366,"Incorrect string value: '\\xF0\\x9F\\x8E\\x97\\xEF\\xB8...' for column `bizdbKLY`.`biz_trader_recruit`.`work_desc` at row 1"] 异常发生在文件:[/bizroot/approot/klywebapi/prjcenter/prjKLY/bizcenter/Trader/entityDataHandle.php]的[170]行 code[0] ! 异常堆栈上下文: #0 /bizroot/approot/klywebapi/ajaxEntryCenter.php(65): include_once() #1 {main} 数据库执行异常:Incorrect string value: '\xF0\x9F\x8E\x97\xEF\xB8...' for column `bizdbKLY`.`biz_trader_recruit`.`work_desc` at row 1 sql语句:SET SESSION TRANSACTION ISOLATION LEVEL REPEATABLE READ;start transaction;insert into biz_trader_recruit set `title` = :title , `profile_photo` = :profile_photo , `work_typename` = :work_typename , `feeper` = :feeper , `feetotal` = :feetotal , `meals_providing` = :meals_providing , `urgent_level` = :urgent_level , `settle_catalog` = :settle_catalog , `begin_datetime` = :begin_datetime , `finish_datetime` = :finish_datetime , `begin_hour` = :begin_hour , `begin_hour2` = :begin_hour2 , `finish_hour` = :finish_hour , `finish_hour2` = :finish_hour2 , `need_total` = :need_total , `need_perday` = :need_perday , `requirements` = :requirements , `linker_name` = :linker_name , `linker_phone` = :linker_phone , `age_mode` = :age_mode , `age_min` = :age_min , `age_max` = :age_max , `gender_mode` = :gender_mode , `work_addr` = :work_addr , `work_addr1` = :work_addr1 , `work_addr_lng` = :work_addr_lng , `work_addr_lat` = :work_addr_lat , `work_desc` = :work_desc , `work_process` = :work_process , `work_remark` = :work_remark , `enroll_audit` = :enroll_audit , `settle_mode` = :settle_mode , `biz_traderid` = :biz_traderid , `status` = :status , `remark` = :remark , `createtime` = :createtime , `enrolled_heads` = :enrolled_heads; set @bizid=LAST_INSERT_ID(); update biz_trader_recruit set updatetime=:auto_nowtime, `status`=:auto_status, remark=concat(:auto_remark,ifnull(remark,'')) ,plat_fetchrate=:plat_fetchrate,plat_fetchmoney=:plat_fetchmoney ,sharer_fetchrate=:sharer_fetchrate,sharer_fetchmoney=:sharer_fetchmoney ,salary=:salary,feeper=:auto_feeper where id=@bizid; update biz_trader set updatetime=1656476201 ,freecount_used=ifnull(freecount_used,0)+1 ,freecount_used_remark=concat(:freecount_used_remark,@bizid,' ',ifnull(freecount_used_remark,'')) where id=95; insert into biz_trader_numaccount set createtime=1656476201 ,biz_traderid=95 ,type=1,biz_catalog=0,biz_id=@bizid,`count`=0,`freecount`=1 ,`status`=1,remark=concat(:numaccount_remark,@bizid,' ',ifnull(remark,'')); select * from biz_trader_recruit where id=@bizid;commit; ["22007",1366,"Incorrect string value: '\\xF0\\x9F\\x8E\\x97\\xEF\\xB8...' for column `bizdbKLY`.`biz_trader_recruit`.`work_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(530): pdo_query3() #4 /bizroot/approot/klywebapi/base/base.php(355): {closure}() #5 /bizroot/approot/klywebapi/prjcenter/prjKLY/base/common.php(20): filelock_handle() #6 /bizroot/approot/klywebapi/prjcenter/prjKLY/base/AboutActivity.php(533): biz_flkForTrader() #7 /bizroot/approot/klywebapi/prjcenter/prjKLY/bizcenter/Trader/entityDataHandle.php(44): bizbase_recruitEntityHandle() #8 /bizroot/approot/klywebapi/ajaxEntryCenter.php(65): include_once('/bizroot/approo...') #9 {main} [上下文相关信息]: [WsAjaxPrj]=KLY [WsAjaxBiz]=Trader [WsAjaxAction]=entityDataHandle [USER]=nginxphp [HOME]=/home/nginxphp [HTTP_REFERER]=https://servicewechat.com/wx8c230ea00ceb8676/2/page-frame.html [HTTP_ACCEPT_ENCODING]=gzip,compress,br,deflate [HTTP_CONTENT_TYPE]=application/json [HTTP_USER_AGENT]=Mozilla/5.0 (Linux; Android 12; Mi 10 Build/SKQ1.220303.001; wv) AppleWebKit/537.36 (KHTML, like Gecko) Version/4.0 Chrome/86.0.4240.99 XWEB/4255 MMWEBSDK/20220604 Mobile Safari/537.36 MMWEBID/655 MicroMessenger/8.0.24.2180(0x28001837) WeChat/arm64 Weixin NetType/WIFI Language/zh_CN ABI/arm64 MiniProgramEnv/android [HTTP_CHARSET]=utf-8 [HTTP_CONTENT_LENGTH]=933 [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]=13467 [REMOTE_ADDR]=218.69.51.169 [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=Trader&WsAjaxAction=entityDataHandle [SCRIPT_NAME]=/ajaxEntryCenter.php [CONTENT_LENGTH]=933 [CONTENT_TYPE]=application/json [REQUEST_METHOD]=POST [QUERY_STRING]=WsAjaxPrj=KLY&WsAjaxBiz=Trader&WsAjaxAction=entityDataHandle [SCRIPT_FILENAME]=/bizroot/approot/klywebapi/ajaxEntryCenter.php [FCGI_ROLE]=RESPONDER [PHP_SELF]=/ajaxEntryCenter.php [REQUEST_TIME_FLOAT]=1656476201.9687 [REQUEST_TIME]=1656476201 12:20:17 [error]: 通用的实体数据存取接口异常:数据库执行异常:Incorrect string value: '\xF0\x9F\x8E\x97\xEF\xB8...' for column `bizdbKLY`.`biz_trader_recruit`.`work_desc` at row 1 sql语句:SET SESSION TRANSACTION ISOLATION LEVEL REPEATABLE READ;start transaction;insert into biz_trader_recruit set `title` = :title , `profile_photo` = :profile_photo , `work_typename` = :work_typename , `feeper` = :feeper , `feetotal` = :feetotal , `meals_providing` = :meals_providing , `urgent_level` = :urgent_level , `settle_catalog` = :settle_catalog , `begin_datetime` = :begin_datetime , `finish_datetime` = :finish_datetime , `begin_hour` = :begin_hour , `begin_hour2` = :begin_hour2 , `finish_hour` = :finish_hour , `finish_hour2` = :finish_hour2 , `need_total` = :need_total , `need_perday` = :need_perday , `requirements` = :requirements , `linker_name` = :linker_name , `linker_phone` = :linker_phone , `age_mode` = :age_mode , `age_min` = :age_min , `age_max` = :age_max , `gender_mode` = :gender_mode , `work_addr` = :work_addr , `work_addr1` = :work_addr1 , `work_addr_lng` = :work_addr_lng , `work_addr_lat` = :work_addr_lat , `work_desc` = :work_desc , `work_process` = :work_process , `work_remark` = :work_remark , `enroll_audit` = :enroll_audit , `settle_mode` = :settle_mode , `biz_traderid` = :biz_traderid , `status` = :status , `remark` = :remark , `createtime` = :createtime , `enrolled_heads` = :enrolled_heads; set @bizid=LAST_INSERT_ID(); update biz_trader_recruit set updatetime=:auto_nowtime, `status`=:auto_status, remark=concat(:auto_remark,ifnull(remark,'')) ,plat_fetchrate=:plat_fetchrate,plat_fetchmoney=:plat_fetchmoney ,sharer_fetchrate=:sharer_fetchrate,sharer_fetchmoney=:sharer_fetchmoney ,salary=:salary,feeper=:auto_feeper where id=@bizid; update biz_trader set updatetime=1656476417 ,freecount_used=ifnull(freecount_used,0)+1 ,freecount_used_remark=concat(:freecount_used_remark,@bizid,' ',ifnull(freecount_used_remark,'')) where id=95; insert into biz_trader_numaccount set createtime=1656476417 ,biz_traderid=95 ,type=1,biz_catalog=0,biz_id=@bizid,`count`=0,`freecount`=1 ,`status`=1,remark=concat(:numaccount_remark,@bizid,' ',ifnull(remark,'')); select * from biz_trader_recruit where id=@bizid;commit; ["22007",1366,"Incorrect string value: '\\xF0\\x9F\\x8E\\x97\\xEF\\xB8...' for column `bizdbKLY`.`biz_trader_recruit`.`work_desc` at row 1"] 异常发生在文件:[/bizroot/approot/klywebapi/prjcenter/prjKLY/bizcenter/Trader/entityDataHandle.php]的[170]行 code[0] ! 异常堆栈上下文: #0 /bizroot/approot/klywebapi/ajaxEntryCenter.php(65): include_once() #1 {main} 数据库执行异常:Incorrect string value: '\xF0\x9F\x8E\x97\xEF\xB8...' for column `bizdbKLY`.`biz_trader_recruit`.`work_desc` at row 1 sql语句:SET SESSION TRANSACTION ISOLATION LEVEL REPEATABLE READ;start transaction;insert into biz_trader_recruit set `title` = :title , `profile_photo` = :profile_photo , `work_typename` = :work_typename , `feeper` = :feeper , `feetotal` = :feetotal , `meals_providing` = :meals_providing , `urgent_level` = :urgent_level , `settle_catalog` = :settle_catalog , `begin_datetime` = :begin_datetime , `finish_datetime` = :finish_datetime , `begin_hour` = :begin_hour , `begin_hour2` = :begin_hour2 , `finish_hour` = :finish_hour , `finish_hour2` = :finish_hour2 , `need_total` = :need_total , `need_perday` = :need_perday , `requirements` = :requirements , `linker_name` = :linker_name , `linker_phone` = :linker_phone , `age_mode` = :age_mode , `age_min` = :age_min , `age_max` = :age_max , `gender_mode` = :gender_mode , `work_addr` = :work_addr , `work_addr1` = :work_addr1 , `work_addr_lng` = :work_addr_lng , `work_addr_lat` = :work_addr_lat , `work_desc` = :work_desc , `work_process` = :work_process , `work_remark` = :work_remark , `enroll_audit` = :enroll_audit , `settle_mode` = :settle_mode , `biz_traderid` = :biz_traderid , `status` = :status , `remark` = :remark , `createtime` = :createtime , `enrolled_heads` = :enrolled_heads; set @bizid=LAST_INSERT_ID(); update biz_trader_recruit set updatetime=:auto_nowtime, `status`=:auto_status, remark=concat(:auto_remark,ifnull(remark,'')) ,plat_fetchrate=:plat_fetchrate,plat_fetchmoney=:plat_fetchmoney ,sharer_fetchrate=:sharer_fetchrate,sharer_fetchmoney=:sharer_fetchmoney ,salary=:salary,feeper=:auto_feeper where id=@bizid; update biz_trader set updatetime=1656476417 ,freecount_used=ifnull(freecount_used,0)+1 ,freecount_used_remark=concat(:freecount_used_remark,@bizid,' ',ifnull(freecount_used_remark,'')) where id=95; insert into biz_trader_numaccount set createtime=1656476417 ,biz_traderid=95 ,type=1,biz_catalog=0,biz_id=@bizid,`count`=0,`freecount`=1 ,`status`=1,remark=concat(:numaccount_remark,@bizid,' ',ifnull(remark,'')); select * from biz_trader_recruit where id=@bizid;commit; ["22007",1366,"Incorrect string value: '\\xF0\\x9F\\x8E\\x97\\xEF\\xB8...' for column `bizdbKLY`.`biz_trader_recruit`.`work_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(530): pdo_query3() #4 /bizroot/approot/klywebapi/base/base.php(355): {closure}() #5 /bizroot/approot/klywebapi/prjcenter/prjKLY/base/common.php(20): filelock_handle() #6 /bizroot/approot/klywebapi/prjcenter/prjKLY/base/AboutActivity.php(533): biz_flkForTrader() #7 /bizroot/approot/klywebapi/prjcenter/prjKLY/bizcenter/Trader/entityDataHandle.php(44): bizbase_recruitEntityHandle() #8 /bizroot/approot/klywebapi/ajaxEntryCenter.php(65): include_once('/bizroot/approo...') #9 {main} [上下文相关信息]: [WsAjaxPrj]=KLY [WsAjaxBiz]=Trader [WsAjaxAction]=entityDataHandle [USER]=nginxphp [HOME]=/home/nginxphp [HTTP_REFERER]=https://servicewechat.com/wx8c230ea00ceb8676/2/page-frame.html [HTTP_ACCEPT_ENCODING]=gzip,compress,br,deflate [HTTP_CONTENT_TYPE]=application/json [HTTP_USER_AGENT]=Mozilla/5.0 (Linux; Android 12; Mi 10 Build/SKQ1.220303.001; wv) AppleWebKit/537.36 (KHTML, like Gecko) Version/4.0 Chrome/86.0.4240.99 XWEB/4255 MMWEBSDK/20220604 Mobile Safari/537.36 MMWEBID/655 MicroMessenger/8.0.24.2180(0x28001837) WeChat/arm64 Weixin NetType/WIFI Language/zh_CN ABI/arm64 MiniProgramEnv/android [HTTP_CHARSET]=utf-8 [HTTP_CONTENT_LENGTH]=933 [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]=14504 [REMOTE_ADDR]=218.69.51.169 [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=Trader&WsAjaxAction=entityDataHandle [SCRIPT_NAME]=/ajaxEntryCenter.php [CONTENT_LENGTH]=933 [CONTENT_TYPE]=application/json [REQUEST_METHOD]=POST [QUERY_STRING]=WsAjaxPrj=KLY&WsAjaxBiz=Trader&WsAjaxAction=entityDataHandle [SCRIPT_FILENAME]=/bizroot/approot/klywebapi/ajaxEntryCenter.php [FCGI_ROLE]=RESPONDER [PHP_SELF]=/ajaxEntryCenter.php [REQUEST_TIME_FLOAT]=1656476417.5404 [REQUEST_TIME]=1656476417