kly_api/logfiles/2022090115_fetchPageData.log

15:11:57 [error]: 通用分页查询排序接口异常：PdoUtil发生异常，数据库连接失败，请检查数据库配置
	异常发生在文件:[D:\www\bizdbKLY\prjcenter\prjKLY\bizcenter\Public\fetchPageData.php]的[53]行 code[0] ！
	异常堆栈上下文：
		#0 D:\www\bizdbKLY\ajaxEntryCenter.php(65): include_once()
		#1 {main}
PdoUtil发生异常，数据库连接失败，请检查数据库配置
	异常发生在文件:[D:\www\bizdbKLY\base\mysql.php]的[89]行 code[0] ！
	异常堆栈上下文：
		#0 D:\www\bizdbKLY\base\mysql.php(9): PdoUtil->__construct(Array)
		#1 D:\www\bizdbKLY\base\mysql.php(29): mysqldb()
		#2 D:\www\bizdbKLY\prjcenter\prjKLY\base\AboutActivity.php(1507): pdo_fetchall(' select btr.*  ...', Array)
		#3 D:\www\bizdbKLY\prjcenter\prjKLY\bizcenter\Public\fetchPageData.php(25): bizbase_recruitAboutQuery(NULL, NULL, NULL, 'fetchallByPubli...', '1', 10, Array, Array)
		#4 D:\www\bizdbKLY\ajaxEntryCenter.php(65): include_once('D:\\www\\bizdbKLY...')
		#5 {main}
[上下文相关信息]：
	[WsAjaxPrj]=KLY
	[WsAjaxBiz]=Public
	[WsAjaxAction]=fetchPageData
	[pageIndex]=1
	[bizCatalog]=RecruitEntity
	[handleMode]=fetchall
	[PATH]=D:\software\cood_tools\Zulu\zulu-8\bin\;C:\Program Files (x86)\Common Files\Oracle\Java\javapath;C:\Windows\system32;C:\Windows;C:\Windows\System32\Wbem;C:\Windows\System32\WindowsPowerShell\v1.0\;C:\Windows\System32\OpenSSH\;C:\Program Files (x86)\NVIDIA Corporation\PhysX\Common;D:\software\cood_tools\xshell7\;C:\ProgramData\ComposerSetup\bin;D:\software\cood_tools\Git\cmd;D:\software\cood_tools\tortoiseSVN\bin;D:\software\cood_tools\TortoiseGit\bin;D:\software\cood_tools\phpstudy\Extensions\php\php7.2.9nts;D:\software\cood_tools\phpstudy\Extensions\php\php7.4.3nts;D:\software\cood_tools\phpstudy\Extensions\php\php5.5.9nts;D:\software\cood_tools\nodejs\;D:\software\cood_tools\Python310;D:\software\cood_tools\Python310\Scripts;D:\software\cood_tools\Python27;D:\software\cood_tools\Python27\Scripts;C:\Program Files\NVIDIA Corporation\NVIDIA NvDLISR;D:\software\cood_tools\微信web开发者工具\dll;D:\software\cood_tools\java8\jdk1.8.0_311\bin;C:\Program Files\Docker\Docker\resources\bin;C:\ProgramData\DockerDesktop\version-bin;C:\Users\ZHAA\AppData\Local\Microsoft\WindowsApps;C:\Users\ZHAA\AppData\Roaming\Composer\vendor\bin;D:\software\cood_tools\Microsoft VS Code\bin;C:\Users\ZHAA\AppData\Roaming\npm;D:\software\cood_tools\APICloud Studio 3\bin;D:\software\cood_tools\Fiddler
	[SYSTEMROOT]=C:\Windows
	[COMSPEC]=C:\Windows\system32\cmd.exe
	[PATHEXT]=.COM;.EXE;.BAT;.CMD;.VBS;.VBE;.JS;.JSE;.WSF;.WSH;.MSC
	[WINDIR]=C:\Windows
	[PHPRC]=D:/software/cood_tools/phpstudy/Extensions/php/php7.4.3nts
	[_FCGI_SHUTDOWN_EVENT_]=8960
	[SCRIPT_NAME]=/ajaxEntryCenter.php
	[REQUEST_URI]=/ajaxEntryCenter.php?WsAjaxPrj=KLY&WsAjaxBiz=Public&WsAjaxAction=fetchPageData
	[QUERY_STRING]=WsAjaxPrj=KLY&WsAjaxBiz=Public&WsAjaxAction=fetchPageData
	[REQUEST_METHOD]=POST
	[SERVER_PROTOCOL]=HTTP/1.1
	[GATEWAY_INTERFACE]=CGI/1.1
	[REMOTE_PORT]=60798
	[SCRIPT_FILENAME]=D:/www/bizdbKLY/ajaxEntryCenter.php
	[SERVER_ADMIN]=admin@example.com
	[CONTEXT_DOCUMENT_ROOT]=D:/www/bizdbKLY
	[CONTEXT_PREFIX]=
	[REQUEST_SCHEME]=http
	[DOCUMENT_ROOT]=D:/www/bizdbKLY
	[REMOTE_ADDR]=127.0.0.1
	[SERVER_PORT]=80
	[SERVER_ADDR]=127.0.0.1
	[SERVER_NAME]=api.bizdbkly.com
	[SERVER_SOFTWARE]=Apache/2.4.39 (Win64) OpenSSL/1.1.1b mod_fcgid/2.3.9a mod_log_rotate/1.02
	[SERVER_SIGNATURE]=
	[SystemRoot]=C:\Windows
	[CONTENT_LENGTH]=404
	[CONTENT_TYPE]=multipart/form-data; boundary=--------------------------547831780924574694677818
	[HTTP_CONNECTION]=close
	[HTTP_ACCEPT_ENCODING]=gzip, deflate, br
	[HTTP_HOST]=api.bizdbkly.com
	[HTTP_POSTMAN_TOKEN]=ad3be8e3-0045-4e18-b68d-f8061df8bca4
	[HTTP_ACCEPT]=*/*
	[HTTP_USER_AGENT]=PostmanRuntime/7.29.2
	[FCGI_ROLE]=RESPONDER
	[PHP_SELF]=/ajaxEntryCenter.php
	[REQUEST_TIME_FLOAT]=1662016296.6972
	[REQUEST_TIME]=1662016296 

15:13:48 [error]: 通用分页查询排序接口异常：PdoUtil发生异常，数据库连接失败，请检查数据库配置
	异常发生在文件:[D:\www\bizdbKLY\prjcenter\prjKLY\bizcenter\Public\fetchPageData.php]的[53]行 code[0] ！
	异常堆栈上下文：
		#0 D:\www\bizdbKLY\ajaxEntryCenter.php(65): include_once()
		#1 {main}
PdoUtil发生异常，数据库连接失败，请检查数据库配置
	异常发生在文件:[D:\www\bizdbKLY\base\mysql.php]的[115]行 code[0] ！
	异常堆栈上下文：
		#0 D:\www\bizdbKLY\base\mysql.php(11): PdoUtil->__construct(Array)
		#1 D:\www\bizdbKLY\base\mysql.php(37): mysqldb()
		#2 D:\www\bizdbKLY\prjcenter\prjKLY\base\AboutActivity.php(1507): pdo_fetchall(' select btr.*  ...', Array)
		#3 D:\www\bizdbKLY\prjcenter\prjKLY\bizcenter\Public\fetchPageData.php(25): bizbase_recruitAboutQuery(NULL, NULL, NULL, 'fetchallByPubli...', '1', 10, Array, Array)
		#4 D:\www\bizdbKLY\ajaxEntryCenter.php(65): include_once('D:\\www\\bizdbKLY...')
		#5 {main}
[上下文相关信息]：
	[WsAjaxPrj]=KLY
	[WsAjaxBiz]=Public
	[WsAjaxAction]=fetchPageData
	[pageIndex]=1
	[bizCatalog]=RecruitEntity
	[handleMode]=fetchall
	[PATH]=D:\software\cood_tools\Zulu\zulu-8\bin\;C:\Program Files (x86)\Common Files\Oracle\Java\javapath;C:\Windows\system32;C:\Windows;C:\Windows\System32\Wbem;C:\Windows\System32\WindowsPowerShell\v1.0\;C:\Windows\System32\OpenSSH\;C:\Program Files (x86)\NVIDIA Corporation\PhysX\Common;D:\software\cood_tools\xshell7\;C:\ProgramData\ComposerSetup\bin;D:\software\cood_tools\Git\cmd;D:\software\cood_tools\tortoiseSVN\bin;D:\software\cood_tools\TortoiseGit\bin;D:\software\cood_tools\phpstudy\Extensions\php\php7.2.9nts;D:\software\cood_tools\phpstudy\Extensions\php\php7.4.3nts;D:\software\cood_tools\phpstudy\Extensions\php\php5.5.9nts;D:\software\cood_tools\nodejs\;D:\software\cood_tools\Python310;D:\software\cood_tools\Python310\Scripts;D:\software\cood_tools\Python27;D:\software\cood_tools\Python27\Scripts;C:\Program Files\NVIDIA Corporation\NVIDIA NvDLISR;D:\software\cood_tools\微信web开发者工具\dll;D:\software\cood_tools\java8\jdk1.8.0_311\bin;C:\Program Files\Docker\Docker\resources\bin;C:\ProgramData\DockerDesktop\version-bin;C:\Users\ZHAA\AppData\Local\Microsoft\WindowsApps;C:\Users\ZHAA\AppData\Roaming\Composer\vendor\bin;D:\software\cood_tools\Microsoft VS Code\bin;C:\Users\ZHAA\AppData\Roaming\npm;D:\software\cood_tools\APICloud Studio 3\bin;D:\software\cood_tools\Fiddler
	[SYSTEMROOT]=C:\Windows
	[COMSPEC]=C:\Windows\system32\cmd.exe
	[PATHEXT]=.COM;.EXE;.BAT;.CMD;.VBS;.VBE;.JS;.JSE;.WSF;.WSH;.MSC
	[WINDIR]=C:\Windows
	[PHPRC]=D:/software/cood_tools/phpstudy/Extensions/php/php7.4.3nts
	[_FCGI_SHUTDOWN_EVENT_]=8960
	[SCRIPT_NAME]=/ajaxEntryCenter.php
	[REQUEST_URI]=/ajaxEntryCenter.php?WsAjaxPrj=KLY&WsAjaxBiz=Public&WsAjaxAction=fetchPageData
	[QUERY_STRING]=WsAjaxPrj=KLY&WsAjaxBiz=Public&WsAjaxAction=fetchPageData
	[REQUEST_METHOD]=POST
	[SERVER_PROTOCOL]=HTTP/1.1
	[GATEWAY_INTERFACE]=CGI/1.1
	[REMOTE_PORT]=60883
	[SCRIPT_FILENAME]=D:/www/bizdbKLY/ajaxEntryCenter.php
	[SERVER_ADMIN]=admin@example.com
	[CONTEXT_DOCUMENT_ROOT]=D:/www/bizdbKLY
	[CONTEXT_PREFIX]=
	[REQUEST_SCHEME]=http
	[DOCUMENT_ROOT]=D:/www/bizdbKLY
	[REMOTE_ADDR]=127.0.0.1
	[SERVER_PORT]=80
	[SERVER_ADDR]=127.0.0.1
	[SERVER_NAME]=api.bizdbkly.com
	[SERVER_SOFTWARE]=Apache/2.4.39 (Win64) OpenSSL/1.1.1b mod_fcgid/2.3.9a mod_log_rotate/1.02
	[SERVER_SIGNATURE]=
	[SystemRoot]=C:\Windows
	[CONTENT_LENGTH]=404
	[CONTENT_TYPE]=multipart/form-data; boundary=--------------------------177570252542845045347207
	[HTTP_CONNECTION]=close
	[HTTP_ACCEPT_ENCODING]=gzip, deflate, br
	[HTTP_HOST]=api.bizdbkly.com
	[HTTP_POSTMAN_TOKEN]=507de09c-17d4-49d2-949b-b3fa716b5319
	[HTTP_ACCEPT]=*/*
	[HTTP_USER_AGENT]=PostmanRuntime/7.29.2
	[FCGI_ROLE]=RESPONDER
	[PHP_SELF]=/ajaxEntryCenter.php
	[REQUEST_TIME_FLOAT]=1662016407.0065
	[REQUEST_TIME]=1662016407 

15:14:30 [error]: 通用分页查询排序接口异常：数据库执行异常:
 sql语句： select btr.*  ,round((btr.finish_datetime-:select_nowdate)/86400) as restdays  ,bt.id as btid,bt.company_name,bt.catalog as bt_catalog,bt.certif_confirmed as bt_certif_confirmed  ,bu.id as buid,bu.mobile bu_mobile  ,concat(brd.id,'-',brd.begin_datetime,'-',brd.finish_datetime,'-',bt2.id,'-',bt2bu.id,'-',bt2bu.mobile,'-',bt2.true_name) as delegate_info  ,(select count(*) from biz_todowork btdw where btdw.biz_recruitid=btr.id and ( btdw.`status`>=2 ) ) as now_worker_total ,(select count(*) from biz_todowork btdw where btdw.biz_recruitid=btr.id and ( btdw.`status`>=1 ) ) as now_worker_total000 ,(select count(*) from biz_todowork btdw where btdw.biz_recruitid=btr.id and ( btdw.`status`=-1 or btdw.`status`=-3 ) ) as num_abnormal_total    FROM (SELECT *, CONCAT(FROM_UNIXTIME(begin_datetime,"%Y%m%d"), REPLACE(begin_hour,':','')) AS begin_time_new FROM biz_trader_recruit ) btr   left join biz_trader           bt    on bt.id=btr.biz_traderid   left join base_user            bu    on bu.id=bt.base_userid   left join biz_recruit_delegate brd   on brd.biz_recruitid=btr.id and brd.finish_datetime>1662016469  left join biz_trader2          bt2   on bt2.id=brd.biz_trader2id   left join base_user            bt2bu on bt2bu.id=bt2.base_userid   left join biz_worker_trace     wktr  on wktr.biz_workerid=0 and wktr.biz_catalog=0 and wktr.biz_id=btr.id   where 1=1 and btr.`deleted`=0  and 1=1  and ((btr.settle_catalog=0 and btr.begin_time_new >= :query_nowdate_new_ma) or (btr.settle_catalog=1))  and  (select count(*) from biz_todowork btdw where btdw.biz_recruitid=btr.id and ( btdw.`status`>=2 or btdw.`status`=-1 or btdw.`status`=-3 ) ) <btr.need_total   order by btr.istop desc,btr.id desc   limit 0,10 
["HY093",null,null]
	异常发生在文件:[D:\www\bizdbKLY\prjcenter\prjKLY\bizcenter\Public\fetchPageData.php]的[53]行 code[0] ！
	异常堆栈上下文：
		#0 D:\www\bizdbKLY\ajaxEntryCenter.php(65): include_once()
		#1 {main}
数据库执行异常:
 sql语句： select btr.*  ,round((btr.finish_datetime-:select_nowdate)/86400) as restdays  ,bt.id as btid,bt.company_name,bt.catalog as bt_catalog,bt.certif_confirmed as bt_certif_confirmed  ,bu.id as buid,bu.mobile bu_mobile  ,concat(brd.id,'-',brd.begin_datetime,'-',brd.finish_datetime,'-',bt2.id,'-',bt2bu.id,'-',bt2bu.mobile,'-',bt2.true_name) as delegate_info  ,(select count(*) from biz_todowork btdw where btdw.biz_recruitid=btr.id and ( btdw.`status`>=2 ) ) as now_worker_total ,(select count(*) from biz_todowork btdw where btdw.biz_recruitid=btr.id and ( btdw.`status`>=1 ) ) as now_worker_total000 ,(select count(*) from biz_todowork btdw where btdw.biz_recruitid=btr.id and ( btdw.`status`=-1 or btdw.`status`=-3 ) ) as num_abnormal_total    FROM (SELECT *, CONCAT(FROM_UNIXTIME(begin_datetime,"%Y%m%d"), REPLACE(begin_hour,':','')) AS begin_time_new FROM biz_trader_recruit ) btr   left join biz_trader           bt    on bt.id=btr.biz_traderid   left join base_user            bu    on bu.id=bt.base_userid   left join biz_recruit_delegate brd   on brd.biz_recruitid=btr.id and brd.finish_datetime>1662016469  left join biz_trader2          bt2   on bt2.id=brd.biz_trader2id   left join base_user            bt2bu on bt2bu.id=bt2.base_userid   left join biz_worker_trace     wktr  on wktr.biz_workerid=0 and wktr.biz_catalog=0 and wktr.biz_id=btr.id   where 1=1 and btr.`deleted`=0  and 1=1  and ((btr.settle_catalog=0 and btr.begin_time_new >= :query_nowdate_new_ma) or (btr.settle_catalog=1))  and  (select count(*) from biz_todowork btdw where btdw.biz_recruitid=btr.id and ( btdw.`status`>=2 or btdw.`status`=-1 or btdw.`status`=-3 ) ) <btr.need_total   order by btr.istop desc,btr.id desc   limit 0,10 
["HY093",null,null]
	异常发生在文件:[D:\www\bizdbKLY\base\mysql.php]的[131]行 code[0] ！
	异常堆栈上下文：
		#0 D:\www\bizdbKLY\base\mysql.php(255): PdoUtil->errhandle(Array, ' select btr.*  ...')
		#1 D:\www\bizdbKLY\base\mysql.php(36): PdoUtil->fetchall(' select btr.*  ...', Array, '')
		#2 D:\www\bizdbKLY\prjcenter\prjKLY\base\AboutActivity.php(1507): pdo_fetchall(' select btr.*  ...', Array)
		#3 D:\www\bizdbKLY\prjcenter\prjKLY\bizcenter\Public\fetchPageData.php(25): bizbase_recruitAboutQuery(NULL, NULL, NULL, 'fetchallByPubli...', '1', 10, Array, Array)
		#4 D:\www\bizdbKLY\ajaxEntryCenter.php(65): include_once('D:\\www\\bizdbKLY...')
		#5 {main}
[上下文相关信息]：
	[WsAjaxPrj]=KLY
	[WsAjaxBiz]=Public
	[WsAjaxAction]=fetchPageData
	[pageIndex]=1
	[bizCatalog]=RecruitEntity
	[handleMode]=fetchall
	[PATH]=D:\software\cood_tools\Zulu\zulu-8\bin\;C:\Program Files (x86)\Common Files\Oracle\Java\javapath;C:\Windows\system32;C:\Windows;C:\Windows\System32\Wbem;C:\Windows\System32\WindowsPowerShell\v1.0\;C:\Windows\System32\OpenSSH\;C:\Program Files (x86)\NVIDIA Corporation\PhysX\Common;D:\software\cood_tools\xshell7\;C:\ProgramData\ComposerSetup\bin;D:\software\cood_tools\Git\cmd;D:\software\cood_tools\tortoiseSVN\bin;D:\software\cood_tools\TortoiseGit\bin;D:\software\cood_tools\phpstudy\Extensions\php\php7.2.9nts;D:\software\cood_tools\phpstudy\Extensions\php\php7.4.3nts;D:\software\cood_tools\phpstudy\Extensions\php\php5.5.9nts;D:\software\cood_tools\nodejs\;D:\software\cood_tools\Python310;D:\software\cood_tools\Python310\Scripts;D:\software\cood_tools\Python27;D:\software\cood_tools\Python27\Scripts;C:\Program Files\NVIDIA Corporation\NVIDIA NvDLISR;D:\software\cood_tools\微信web开发者工具\dll;D:\software\cood_tools\java8\jdk1.8.0_311\bin;C:\Program Files\Docker\Docker\resources\bin;C:\ProgramData\DockerDesktop\version-bin;C:\Users\ZHAA\AppData\Local\Microsoft\WindowsApps;C:\Users\ZHAA\AppData\Roaming\Composer\vendor\bin;D:\software\cood_tools\Microsoft VS Code\bin;C:\Users\ZHAA\AppData\Roaming\npm;D:\software\cood_tools\APICloud Studio 3\bin;D:\software\cood_tools\Fiddler
	[SYSTEMROOT]=C:\Windows
	[COMSPEC]=C:\Windows\system32\cmd.exe
	[PATHEXT]=.COM;.EXE;.BAT;.CMD;.VBS;.VBE;.JS;.JSE;.WSF;.WSH;.MSC
	[WINDIR]=C:\Windows
	[PHPRC]=D:/software/cood_tools/phpstudy/Extensions/php/php7.4.3nts
	[_FCGI_SHUTDOWN_EVENT_]=8960
	[SCRIPT_NAME]=/ajaxEntryCenter.php
	[REQUEST_URI]=/ajaxEntryCenter.php?WsAjaxPrj=KLY&WsAjaxBiz=Public&WsAjaxAction=fetchPageData
	[QUERY_STRING]=WsAjaxPrj=KLY&WsAjaxBiz=Public&WsAjaxAction=fetchPageData
	[REQUEST_METHOD]=POST
	[SERVER_PROTOCOL]=HTTP/1.1
	[GATEWAY_INTERFACE]=CGI/1.1
	[REMOTE_PORT]=60940
	[SCRIPT_FILENAME]=D:/www/bizdbKLY/ajaxEntryCenter.php
	[SERVER_ADMIN]=admin@example.com
	[CONTEXT_DOCUMENT_ROOT]=D:/www/bizdbKLY
	[CONTEXT_PREFIX]=
	[REQUEST_SCHEME]=http
	[DOCUMENT_ROOT]=D:/www/bizdbKLY
	[REMOTE_ADDR]=127.0.0.1
	[SERVER_PORT]=80
	[SERVER_ADDR]=127.0.0.1
	[SERVER_NAME]=api.bizdbkly.com
	[SERVER_SOFTWARE]=Apache/2.4.39 (Win64) OpenSSL/1.1.1b mod_fcgid/2.3.9a mod_log_rotate/1.02
	[SERVER_SIGNATURE]=
	[SystemRoot]=C:\Windows
	[CONTENT_LENGTH]=404
	[CONTENT_TYPE]=multipart/form-data; boundary=--------------------------112811269322775771939474
	[HTTP_CONNECTION]=close
	[HTTP_ACCEPT_ENCODING]=gzip, deflate, br
	[HTTP_HOST]=api.bizdbkly.com
	[HTTP_POSTMAN_TOKEN]=955ceb8e-ecac-40ca-b387-ed20738119f1
	[HTTP_ACCEPT]=*/*
	[HTTP_USER_AGENT]=PostmanRuntime/7.29.2
	[FCGI_ROLE]=RESPONDER
	[PHP_SELF]=/ajaxEntryCenter.php
	[REQUEST_TIME_FLOAT]=1662016469.8749
	[REQUEST_TIME]=1662016469