\u304a\u4e16\u8a71\u306b\u306a\u308a\u307e\u3059\u3002<\/p>\n
\u300c\u30e1\u30fc\u30eb\u30de\u30ac\u30b8\u30f3\u8a2d\u5b9a\u300d\u306e\u300c\u30b9\u30c8\u30fc\u30ea\u30fc\u5225\u5c65\u6b74\u300d\u3092\u898b\u3088\u3046\u3068\u3059\u308b\u3068Software error\u304c\u51fa\u307e\u3059\u3002<\/p>\n
\u4f7f\u7528\u4e2d\u306eMilkyStep\u306e\u30d0\u30fc\u30b8\u30e7\u30f3\u306f\u3001Ver 2.11<\/p>\n
\u30b5\u30fc\u30d0\u306f\u3055\u304f\u3089\u30b5\u30fc\u30d0\u30fc\uff08\u30b9\u30bf\u30f3\u30c0\u30fc\u30c9\uff09\u3067\u3059\u3002<\/p>\n
\u30c7\u30fc\u30bf\u30d9\u30fc\u30b9 \u30d0\u30fc\u30b8\u30e7\u30f3: MySQL 5.7<\/p>\n
\u30a8\u30e9\u30fc\u306f\u4ee5\u4e0b\u306e\u901a\u308a\u3067\u3059\u3002<\/p>\n
\uff08\u8ee2\u8f09\u306f\u3058\u3081\uff09
\n_________________________________________________________<\/p>\n
Software error:
\nExpression #4 of SELECT list is not in GROUP BY clause and contains nonaggregated column ‘takigamiaju_ms.temp.clicks_by_sto’ which is not functionally dependent on columns in GROUP BY clause; this is incompatible with sql_mode=only_full_group_by
\nSQL:<\/p>\n
SELECT SQL_CALC_FOUND_ROWS
\n`temp`.story_no,
\nSUM(`ms_his_kaiun_1`.done_users) AS users_by_sto,
\nSUM(`ms_his_kaiun_1`.total_error) AS err_by_sto,
\n`temp`.clicks_by_sto,
\nROUND(
\n( `temp`.clicks_by_sto \/ SUM(`ms_his_kaiun_1`.users) ) * 100, 2
\n) AS ctr_by_sto
\nFROM `temp`
\nLEFT JOIN `ms_his_kaiun_1`
\nON `ms_his_kaiun_1`.story_no = `temp`.story_no AND
\n`ms_his_kaiun_1`.d_type = 1
\nGROUP BY `temp`.story_no
\nORDER BY ms_his_kaiun_1.story_no ASC
\nLIMIT 0,10
\nat .\/lib\/db.pl line 41.
\nFor help, please send mail to the webmaster (support@sakura.ad.jp), giving this error message and the time and date of the error.
\n_________________________________________________________
\n\uff08\u8ee2\u8f09\u7d42\u308f\u308a\uff09<\/p>\n
.\/lib\/db.pl line 41.
\n\u3067Milkystep\u306ems\u30d5\u30a9\u30eb\u30c0\u306e\u4e2d\u306edb.pl\u306e41\u884c\u76ee\u306f
\nif($bind){my $el = 1; map {$sth->bind_param($el,$$_{value},$$_{type}); $el++;} @$bind;}
\n##################
\n$exec = $sth->execute() || die $sth->errstr().”\\nSQL:\\n”.$q;\u3000\u219041\u884c\u76ee\uff1a\u3053\u3053\u3067\u3059\u3002
\n}
\n######################
\nreturn $exec;
\n}<\/p>\n
\u30d0\u30fc\u30b8\u30e7\u30f3\u30a2\u30c3\u30d7\u6642\u306a\u3069\u306b\u30c7\u30fc\u30bf\u30d9\u30fc\u30b9\u306e\u518d\u69cb\u7bc9\u304c\u3046\u307e\u304f\u884c\u308f\u308c\u3066\u3044\u306a\u3044\u5834\u5408\u306b\u30a8\u30e9\u30fc\u304c\u51fa\u308b\u53ef\u80fd\u6027\u3082\u3042\u308b\u3068\u63b2\u793a\u677f\u3067\u8aad\u307f\u307e\u3057\u305f\u306e\u3067\u3001\u518d\u69cb\u7bc9\u3092\u5b9f\u65bd\u3057\u307e\u3057\u305f\u304c\u6539\u5584\u3055\u308c\u307e\u305b\u3093\u3067\u3057\u305f\u3002<\/p>\n
\u89e3\u6c7a\u6cd5\u3092\u3054\u5b58\u77e5\u306e\u65b9\u304c\u3044\u3089\u3063\u3057\u3083\u3044\u307e\u3057\u305f\u3089\u6559\u3048\u3066\u3044\u305f\u3060\u3051\u305f\u3089\u5e78\u3044\u3067\u3059\u3002<\/p>\n","protected":false},"excerpt":{"rendered":"
\u304a\u4e16\u8a71\u306b\u306a\u308a\u307e\u3059\u3002 \u300c\u30e1\u30fc\u30eb\u30de\u30ac\u30b8\u30f3\u8a2d\u5b9a\u300d\u306e\u300c\u30b9\u30c8\u30fc\u30ea\u30fc\u5225\u5c65\u6b74\u300d\u3092\u898b\u3088\u3046\u3068\u3059\u308b\u3068Software error\u304c\u51fa\u307e\u3059\u3002 \u4f7f\u7528\u4e2d\u306eMilkyStep\u306e\u30d0\u30fc\u30b8\u30e7\u30f3\u306f\u3001Ver 2.11 \u30b5\u30fc\u30d0\u306f\u3055\u304f\u3089\u30b5\u30fc\u30d0\u30fc\uff08\u30b9\u30bf\u30f3\u30c0\u30fc\u30c9\uff09\u3067 […]<\/p>\n","protected":false},"author":601,"featured_media":0,"comment_status":"open","ping_status":"closed","sticky":false,"template":"","format":"standard","meta":[],"categories":[3],"tags":[],"_links":{"self":[{"href":"http:\/\/milkystep.com\/ms_poc\/index.php?rest_route=\/wp\/v2\/posts\/3145"}],"collection":[{"href":"http:\/\/milkystep.com\/ms_poc\/index.php?rest_route=\/wp\/v2\/posts"}],"about":[{"href":"http:\/\/milkystep.com\/ms_poc\/index.php?rest_route=\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"http:\/\/milkystep.com\/ms_poc\/index.php?rest_route=\/wp\/v2\/users\/601"}],"replies":[{"embeddable":true,"href":"http:\/\/milkystep.com\/ms_poc\/index.php?rest_route=%2Fwp%2Fv2%2Fcomments&post=3145"}],"version-history":[{"count":4,"href":"http:\/\/milkystep.com\/ms_poc\/index.php?rest_route=\/wp\/v2\/posts\/3145\/revisions"}],"predecessor-version":[{"id":3149,"href":"http:\/\/milkystep.com\/ms_poc\/index.php?rest_route=\/wp\/v2\/posts\/3145\/revisions\/3149"}],"wp:attachment":[{"href":"http:\/\/milkystep.com\/ms_poc\/index.php?rest_route=%2Fwp%2Fv2%2Fmedia&parent=3145"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"http:\/\/milkystep.com\/ms_poc\/index.php?rest_route=%2Fwp%2Fv2%2Fcategories&post=3145"},{"taxonomy":"post_tag","embeddable":true,"href":"http:\/\/milkystep.com\/ms_poc\/index.php?rest_route=%2Fwp%2Fv2%2Ftags&post=3145"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}