11版安装后，日历模块没法使用

Michael · 发表于 2021-2-9 11:31:08

新部署好以后就这样，切换了几个php版本都不行。其他模块正常

34234 · 发表于 2021-2-10 10:53:10

遇到同样的问题，PHP版本7.4.1

Michael_xu · 发表于 2021-2-18 15:59:42

打开TP调试模式，浏览器F12贴一下具体报错信息

Michael · 发表于 2021-2-18 20:19:57

Michael_xu 发表于 2021-2-18 15:59
打开TP调试模式，浏览器F12贴一下具体报错信息

[10501] PDOException in Connection.php line 385
SQLSTATE[42000]: Syntax error or access violation: 1055 Expression #2 of SELECT list is not in GROUP BY clause and contains nonaggregated column 'wkcrm.5kcrm_crm_customer.customer_id' which is not functionally dependent on columns in GROUP BY clause; this is incompatible with sql_mode=only_full_group_by
         $this->PDOStatement->execute();
         // 调试结束
         $this->debug(false, '', $master);
         // 返回结果集
         return $this->getResult($pdo, $procedure);
      } catch (\PDOException $e) {
         if ($this->isBreak($e)) {
            return $this->close()->query($sql, $bind, $master, $pdo);
         }
         throw new PDOException($e, $this->config, $this->getLastsql());
      } catch (\Throwable $e) {
         if ($this->isBreak($e)) {
            return $this->close()->query($sql, $bind, $master, $pdo);
         }
         throw $e;
      } catch (\Exception $e) {
         if ($this->isBreak($e)) {
            return $this->close()->query($sql, $bind, $master, $pdo);
         }
Call Stack
in Connection.php line 385
at Connection->query('SELECT next_time as ...', ['where_AND_next_time' => [0, 1], 'where_AND_owner_user_id' => [0, 1]], false, false) in Query.php line 255
at Query->query('SELECT next_time as ...', ['where_AND_next_time' => [0, 1], 'where_AND_owner_user_id' => [0, 1]], false, false) in Query.php line 2523
at Query->select() in Event.php line 178
at Event->eventCrm(['start_time' => 1612108800000, 'end_time' => 1615737600000, 'user_id' => 1]) in Event.php line 81
at Event->eventCrm()
at ReflectionMethod->invokeArgs(object(Event), []) in App.php line 343
at App::invokeMethod([object(Event), 'eventCrm'], []) in App.php line 611
at App::module(['oa', 'event', 'eventCrm'], ['app_host' => '', 'app_debug' => true, 'app_trace' => true, ...], false) in App.php line 456
at App::exec(['type' => 'module', 'module' => ['oa', 'event', 'eventCrm'], 'convert' => false], ['app_host' => '', 'app_debug' => true, 'app_trace' => true, ...]) in App.php line 139
at App::run() in start.php line 19
at require('C:\phpstudy_pro\WWW\...') in index.php line 21
Exception Datas
PDO Error Info
SQLSTATE 42000
Driver Error Code 1055
Driver Error Message Expression #2 of SELECT list is not in GROUP BY clause and contains nonaggregated column 'wkcrm.5kcrm_crm_customer.customer_id' which is not functionally dependent on columns in GROUP BY clause; this is incompatible with sql_mode=only_full_group_by
Database Status
Error Code 10501
Error Message SQLSTATE[42000]: Syntax error or access violation: 1055 Expression #2 of SELECT list is not in GROUP BY clause and contains nonaggregated column 'wkcrm.5kcrm_crm_customer.customer_id' which is not functionally dependent on columns in GROUP BY clause; this is incompatible with sql_mode=only_full_group_by
Error SQL SELECT next_time as start_time,`customer_id`,`name` FROM `5kcrm_crm_customer` WHERE `next_time` > 0 AND `owner_user_id` <> 0 AND ( ((next_time BETWEEN 1612108800 AND 1615737600) AND ( create_user_id = 1 or owner_user_id = 1)) OR ((next_time > 1612108800 AND next_time <1615737600) AND ( create_user_id = 1 or owner_user_id =1)) OR ((next_time > 1612108800 AND next_time > 1615737600) AND ( create_user_id = 1 or owner_user_id = 1)) ) GROUP BY `start_time`
Database Config
type mysql
hostname 127.0.0.1
database wkcrm
hostport 3306
dsn
params []
charset utf8
prefix 5kcrm_
debug true
deploy 0
rw_separate false
master_num 1
slave_no
read_master false
fields_strict true
result_type 2
resultset_type array
auto_timestamp false
datetime_format Y-m-d H:i:s
sql_explain false
builder
query \think\db\Query
break_reconnect false
Environment Variables
GET Dataempty
POST Dataempty
Filesempty
Cookies
PHPSESSIDfejtm8toq8g9jofnaeg465esvj
Session
install_count627
install_now627
user_id1
Server/Request Data
ALLUSERSPROFILEC:\ProgramData
ANT_HOMEC:\apache-ant-1.10.9
APPDATAC:\Users\Michael\AppData\Roaming
ChocolateyInstallC:\ProgramData\chocolatey
ChocolateyLastPathUpdate132445277696822575
CommonProgramFilesC:\Program Files\Common Files
CommonProgramFiles(x86)C:\Program Files (x86)\Common Files
CommonProgramW6432C:\Program Files\Common Files
COMPUTERNAMEMICHAEL
ComSpecC:\WINDOWS\system32\cmd.exe
DriverDataC:\Windows\System32\Drivers\DriverData
GOPATHC:\Users\Michael\go
HOMEDRIVEC:
HOMEPATH\Users\Michael
JAVA_HOMEC:\Program Files\Java\jdk1.8.0_181
LOCALAPPDATAC:\Users\Michael\AppData\Local
LOGONSERVER\\MICHAEL
M2_HOMEC:\Maven\apache-maven-3.6.3
MAVEN_HOMEC:\Maven\apache-maven-3.6.3
NUMBER_OF_PROCESSORS4
OneDriveC:\Users\Michael\OneDrive
OneDriveConsumerC:\Users\Michael\OneDrive
OSWindows_NT
PathC:\Program Files (x86)\Common Files\Oracle\Java\javapath;C:\Program Files (x86)\Intel\Intel(R) Management Engine Components\iCLS\;C:\Program Files\Intel\Intel(R) Management Engine Components\iCLS\;C:\WINDOWS\system32;C:\WINDOWS;C:\WINDOWS\System32\Wbem;C:\WINDOWS\System32\WindowsPowerShell\v1.0\;C:\WINDOWS\System32\OpenSSH\;C:\Program Files (x86)\Intel\Intel(R) Management Engine Components\DAL;C:\Program Files\Intel\Intel(R) Management Engine Components\DAL;C:\Program Files (x86)\Intel\Intel(R) Management Engine Components\IPT;C:\Program Files\Intel\Intel(R) Management Engine Components\IPT;C:\Program Files\Intel\WiFi\bin\;C:\Program Files\Common Files\Intel\WirelessCommon\;c:\ourwaybi\oracle\instantclient_12_1\vc11;c:\ourwaybi\oracle\instantclient_12_1;C:\ProgramData\chocolatey\bin;C:\Program Files\nodejs\;C:\Go\bin;C:\Users\Michael\AppData\Local\Programs\Python\Python39;C:\Maven\apache-maven-3.6.3\bin\;C:\Program Files\Java\jdk1.8.0_181\lib\dt.jar;C:\Program Files\Java\jdk1.8.0_181\lib\tools.jar;C:\Maven\apache-maven-3.6.3\bin;C:\apache-ant-1.10.9\bin;C:\Program Files\dotnet\;C:\Program Files (x86)\dotnet\;C:\Users\Michael\AppData\Local\Microsoft\WindowsApps;C:\Users\Michael\AppData\Roaming\npm;C:\Users\Michael\go\bin;C:\Users\Michael\AppData\Local\Programs\Python\Python39\Scripts;C:\Program Files (x86)\soar
PATHEXT.COM;.EXE;.BAT;.CMD;.VBS;.VBE;.JS;.JSE;.WSF;.WSH;.MSC
PROCESSOR_ARCHITECTUREAMD64
PROCESSOR_IDENTIFIERIntel64 Family 6 Model 142 Stepping 9, GenuineIntel
PROCESSOR_LEVEL6
PROCESSOR_REVISION8e09
ProgramDataC:\ProgramData
ProgramFilesC:\Program Files
ProgramFiles(x86)C:\Program Files (x86)
ProgramW6432C:\Program Files
PSModulePathC:\Program Files\WindowsPowerShell\Modules;C:\WINDOWS\system32\WindowsPowerShell\v1.0\Modules
PUBLICC:\Users\Public
SystemDriveC:
SystemRootC:\WINDOWS
TEMPC:\Users\Michael\AppData\Local\Temp
TMPC:\Users\Michael\AppData\Local\Temp
USERDOMAINMICHAEL
USERDOMAIN_ROAMINGPROFILEMICHAEL
USERNAMEMichael
USERPROFILEC:\Users\Michael
windirC:\WINDOWS
WXDRIVE_START_ARGS--wxdrive-setting=0 --disable-gpu --disable-software-rasterizer --enable-features=NetworkServiceInProcess
HTTP_COOKIEPHPSESSID=fejtm8toq8g9jofnaeg465esvj
HTTP_ACCEPT_LANGUAGEzh-CN,zh;q=0.9,en-US;q=0.8,en;q=0.7,en-GB;q=0.6
HTTP_ACCEPT_ENCODINGgzip, deflate
HTTP_REFERERhttp://crm.com/
HTTP_ORIGINhttp://crm.com
HTTP_AUTHKEY8f9e368cc3eadbb950a2908bc35f7780
HTTP_USER_AGENTMozilla/5.0 (Windows NT 10.0; Win64; x64) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/88.0.4324.150 Safari/537.36 Edg/88.0.705.68
HTTP_SESSIONIDfejtm8toq8g9jofnaeg465esvj
HTTP_CONTENT_TYPEapplication/json;charset=UTF-8
HTTP_DNT1
HTTP_ACCEPTapplication/json, text/plain, */*
HTTP_CACHE_CONTROLno-cache
HTTP_PRAGMAno-cache
HTTP_CONTENT_LENGTH53
HTTP_CONNECTIONkeep-alive
HTTP_HOSTcrm.com
REDIRECT_STATUS200
SERVER_NAMEcrm.com
SERVER_PORT80
SERVER_ADDR127.0.0.1
REMOTE_PORT11477
REMOTE_ADDR127.0.0.1
SERVER_SOFTWAREnginx/1.15.11
GATEWAY_INTERFACECGI/1.1
REQUEST_SCHEMEhttp
SERVER_PROTOCOLHTTP/1.1
DOCUMENT_ROOTC:/phpstudy_pro/WWW/crm.com
DOCUMENT_URI/index.php/oa/event/eventCrm
REQUEST_URI/index.php/oa/event/eventCrm
SCRIPT_NAME/index.php
CONTENT_LENGTH53
CONTENT_TYPEapplication/json;charset=UTF-8
REQUEST_METHODPOST
QUERY_STRING
PATH_TRANSLATEDC:/phpstudy_pro/WWW/crm.com/oa/event/eventCrm
PATH_INFO/oa/event/eventCrm
SCRIPT_FILENAMEC:/phpstudy_pro/WWW/crm.com/index.php
FCGI_ROLERESPONDER
PHP_SELF/index.php/oa/event/eventCrm
REQUEST_TIME_FLOAT1613650608.5542
REQUEST_TIME1613650608
Environment Variablesempty
ThinkPHP Constants
APP_PATHC:\phpstudy_pro\WWW\crm.com/application/
CONF_PATHC:\phpstudy_pro\WWW\crm.com/config/
RUNTIME_PATHC:\phpstudy_pro\WWW\crm.com/runtime/
THINK_VERSION5.0.24
THINK_START_TIME1613650608.5552
THINK_START_MEM409528
EXT.php
DS\
THINK_PATHC:\phpstudy_pro\WWW\crm.com\thinkphp\
LIB_PATHC:\phpstudy_pro\WWW\crm.com\thinkphp\library\
CORE_PATHC:\phpstudy_pro\WWW\crm.com\thinkphp\library\think\
TRAIT_PATHC:\phpstudy_pro\WWW\crm.com\thinkphp\library\traits\
ROOT_PATHC:\phpstudy_pro\WWW\crm.com\
EXTEND_PATHC:\phpstudy_pro\WWW\crm.com\extend\
VENDOR_PATHC:\phpstudy_pro\WWW\crm.com\vendor\
LOG_PATHC:\phpstudy_pro\WWW\crm.com/runtime/log\
CACHE_PATHC:\phpstudy_pro\WWW\crm.com/runtime/cache\
TEMP_PATHC:\phpstudy_pro\WWW\crm.com/runtime/temp\
CONF_EXT.php
ENV_PREFIXPHP_
UPLOAD_PATH.\public\uploads\
FILE_PATHC:\phpstudy_pro\WWW\crm.com\
IS_CLIfalse
IS_WINtrue
HTMLPURIFIER_PREFIXC:\phpstudy_pro\WWW\crm.com\vendor\ezyang\htmlpurifier\library
DB_NAMEwkcrm
TEMP_DIRC:\phpstudy_pro\WWW\crm.com\public\temp\
ThinkPHP V5.0.24 { 十年磨一剑-为API开发设计的高性能框架 }

Michael · 发表于 2021-2-18 20:48:34

上面是本地的，
服务器上是报这个错误
[10501] PDOException in Connection.php line 385
SQLSTATE[HY000]: General error: 1525 Incorrect DATE value: '0'
         $this->PDOStatement->execute();
         // 调试结束
         $this->debug(false, '', $master);
         // 返回结果集
         return $this->getResult($pdo, $procedure);
      } catch (\PDOException $e) {
         if ($this->isBreak($e)) {
            return $this->close()->query($sql, $bind, $master, $pdo);
         }
         throw new PDOException($e, $this->config, $this->getLastsql());
      } catch (\Throwable $e) {
         if ($this->isBreak($e)) {
            return $this->close()->query($sql, $bind, $master, $pdo);
         }
         throw $e;
      } catch (\Exception $e) {
         if ($this->isBreak($e)) {
            return $this->close()->query($sql, $bind, $master, $pdo);
         }
Call Stack
in Connection.php line 385
at Connection->query('SELECT end_time as s...', ['where_AND_end_time' => [0, 2], 'where_end_time_0_between_1' => ['2021-02-01', 2], 'where_end_time_0_between_2' => ['2021-03-15', 2], ...], false, false) in Query.php line 255
at Query->query('SELECT end_time as s...', ['where_AND_end_time' => [0, 2], 'where_end_time_0_between_1' => ['2021-02-01', 2], 'where_end_time_0_between_2' => ['2021-03-15', 2], ...], false, false) in Query.php line 2523
at Query->select() in Event.php line 202
at Event->eventCrm(['start_time' => 1612108800000, 'end_time' => 1615737600000, 'user_id' => 1]) in Event.php line 81
at Event->eventCrm()
at ReflectionMethod->invokeArgs(object(Event), []) in App.php line 343
at App::invokeMethod([object(Event), 'eventCrm'], []) in App.php line 611
at App::module(['oa', 'event', 'eventCrm'], ['app_host' => '', 'app_debug' => true, 'app_trace' => true, ...], false) in App.php line 456
at App::exec(['type' => 'module', 'module' => ['oa', 'event', 'eventCrm'], 'convert' => false], ['app_host' => '', 'app_debug' => true, 'app_trace' => true, ...]) in App.php line 139
at App::run() in start.php line 19
at require('/www/wwwroot/crm.yyy...') in index.php line 21
Exception Datas
PDO Error Info
SQLSTATE HY000
Driver Error Code 1525
Driver Error Message Incorrect DATE value: '0'
Database Status
Error Code 10501
Error Message SQLSTATE[HY000]: General error: 1525 Incorrect DATE value: '0'
Error SQL SELECT end_time as start_time,`contract_id`,`name` FROM `5kcrm_crm_contract` WHERE `end_time` > '0' AND ( ( `end_time` BETWEEN '2021-02-01' AND '2021-03-15' ) OR ( `end_time` > '2021-03-15' ) ) AND ( `create_user_id` = 1 OR `owner_user_id` = 1 ) GROUP BY `start_time`

Michael_xu · 发表于 2021-2-19 11:22:43

Michael 发表于 2021-2-18 20:19
[10501] PDOException in Connection.php line 385
SQLSTATE[42000]: Syntax error or access violation: ...

关于 ONLY_FULL_GROUP_BY 的问题可以看一下这个：
https://blog.csdn.net/qq_34637782/article/details/101029487

Michael · 发表于 2021-2-19 17:54:44

Michael_xu 发表于 2021-2-19 11:22
关于 ONLY_FULL_GROUP_BY 的问题可以看一下这个：
https://blog.csdn.net/qq_34637782/article/details/1 ...

感谢，这个问题解决了，请问大神General error: 1525 Incorrect DATE value: '0'错误要怎么处理

Michael_xu · 发表于 2021-2-23 10:28:09

Michael 发表于 2021-2-19 17:54
感谢，这个问题解决了，请问大神General error: 1525 Incorrect DATE value: '0'错误要怎么处理 ...

下个版本会修复这个问题，请关注后续升级

Michael · 发表于 2021-3-1 14:38:21

本帖最后由 Michael 于 2021-3-3 01:00 编辑

mysql的bug，升级8.0.23已解决

余生一 · 发表于 2021-5-7 18:18:56

Michael 发表于 2021-2-19 17:54
感谢，这个问题解决了，请问大神General error: 1525 Incorrect DATE value: '0'错误要怎么处理 ...

你是怎么解决的大神