{"id":254,"date":"2019-11-26T09:59:00","date_gmt":"2019-11-26T01:59:00","guid":{"rendered":"https:\/\/wp.dj47.top\/?p=254"},"modified":"2021-10-20T16:16:19","modified_gmt":"2021-10-20T08:16:19","slug":"%e5%90%af%e5%8a%a8%e6%97%b6%e6%88%96%e6%9f%a5%e8%af%a2%e6%97%b6%e6%8a%a5%e9%94%99%ef%bc%9aerror-while-setting-value-%c2%b7%c2%b7%c2%b7%c2%b7%c2%b7%c2%b7-to-sql_mode","status":"publish","type":"post","link":"https:\/\/www.djlog.cn\/?p=254","title":{"rendered":"\u542f\u52a8\u65f6\u6216\u67e5\u8be2\u65f6\u62a5\u9519\uff1aError while setting value &#8216;\u00b7\u00b7\u00b7\u00b7\u00b7\u00b7&#8217; to &#8216;sql_mode&#8217;"},"content":{"rendered":"<p><span style=\"color: #e36c09; font-family: 'Helvetica Neue', Helvetica, Arial, sans-serif; font-size: 14px; background-color: #ffffff;\">\u62a5\u9519\u5185\u5bb9\u5982\u4e0b\uff1a<\/span><\/p>\n<pre class=\"language-javascript\"><code>2019-11-26T01:15:10.213099Z 0 [ERROR] \r\nF:\\phpstudy_pro\\COM\\..\\Extensions\\MySQL5.7.26\\\\bin\\mysqld.exe: \r\nError while setting value 'ONLY_FULL_GROUP_BY, STRICT_TRANS_TABLES, ERROR_FOR_DIVISION_BY_ZERO, NO_AUTO_CREATE_USER, NO_ENGINE_SUBSTITUTION' to 'sql_mode' \r\n2019-11-26T01:15:10.213099Z 0 [ERROR] Aborting<\/code><\/pre>\n<p><span style=\"color: #333333; font-family: 'Helvetica Neue', Helvetica, Arial, sans-serif; font-size: 14px; background-color: #ffffff;\">\u6392\u67e5\u53ca\u89e3\u51b3\uff1a<\/span><\/p>\n<pre class=\"language-javascript\"><code>\u9996\u5148\u6392\u67e5 sql_mode \u7684\u5404\u4e2a\u53c2\u6570\u95f4\u9664\u9017\u53f7\u5916\u662f\u5426\u6709\u7a7a\u683c\uff0c\u6709\u5219\u53bb\u9664\u3002\r\n\u68c0\u67e5\u53c2\u6570\u662f\u5426\u5df2\u7ecf\u88ab\u5e9f\u9664\uff0c\u4f8b\u5982\uff1aNO_AUTO_CREATE_USER \u5728 5.7.* \u7684\u65e5\u5fd7\u4e2d\u63d0\u5230\u5df2\u5e9f\u9664\u8be5\u6a21\u5f0f\uff0c\u5728 8.0.11 \u4e2d\u5220\u9664\u4e86\uff0c\u53bb\u9664\u540e\u91cd\u542f\u3002<\/code><\/pre>\n","protected":false},"excerpt":{"rendered":"<p>\u62a5\u9519\u5185\u5bb9\u5982\u4e0b\uff1a 2019-11-26T01:15:10.213099Z 0 [ERROR] F:\\phpstu [&hellip;]<\/p>\n","protected":false},"author":1,"featured_media":0,"comment_status":"open","ping_status":"closed","sticky":false,"template":"","format":"standard","meta":[],"categories":[5],"tags":[28],"class_list":["post-254","post","type-post","status-publish","format-standard","hentry","category-mysql","tag-mysql"],"_links":{"self":[{"href":"https:\/\/www.djlog.cn\/index.php?rest_route=\/wp\/v2\/posts\/254","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/www.djlog.cn\/index.php?rest_route=\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/www.djlog.cn\/index.php?rest_route=\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/www.djlog.cn\/index.php?rest_route=\/wp\/v2\/users\/1"}],"replies":[{"embeddable":true,"href":"https:\/\/www.djlog.cn\/index.php?rest_route=%2Fwp%2Fv2%2Fcomments&post=254"}],"version-history":[{"count":0,"href":"https:\/\/www.djlog.cn\/index.php?rest_route=\/wp\/v2\/posts\/254\/revisions"}],"wp:attachment":[{"href":"https:\/\/www.djlog.cn\/index.php?rest_route=%2Fwp%2Fv2%2Fmedia&parent=254"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/www.djlog.cn\/index.php?rest_route=%2Fwp%2Fv2%2Fcategories&post=254"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/www.djlog.cn\/index.php?rest_route=%2Fwp%2Fv2%2Ftags&post=254"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}