123456789101112131415161718192021222324252627282930313233343536373839404142434445464748495051525354555657585960616263646566676869707172737475767778798081828384858687888990919293949596979899100101102103104105106107108109110111112113114115116117118119120121122123124125126127128129130131132133134135136137138139140141142143144145146147148149150151152153154155156157158159160161162163164165166167168169170171172173174175176177178179180181182183184185186187188189190191192193194195196197198199200201202203204205206207208209210211212213214215216217218219220221222223224225226227228229230231232233234235236237238239240241242243244245246247248249250251252253254255256257258259260261262263264265266267268269270271272273274275276277278279280281282283284285286287288289290291292293294295296297298299300301302303304305306307308309310311312313314315316317318319320321322323324325326327328329330331332333334335336337338339340341342343344345346347348349350351352353354355356357358359360361362363364365366367368369370371372373374375376377378379380381382383384385386387388389390391392393394395396397398399400401402403404405406407408409410411412413414415416417418419420421422423424425426427428429430431432433434435436437438439440441442443444445446447448449450451452453454455456457458459460461462463464465466467468469470471472473474475476477478479480481482483484485486487488489490491492493494495496497498499500501502503504505506507508509510511 |
- 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
|