string(103) "Illegal mix of collations (ujis_japanese_ci,IMPLICIT) and (utf8_general_ci,COERCIBLE) for operation '='" array(5) { [0]=> array(7) { ["file"]=> string(50) "/home/machisapo/www/php/ACMS/GET/Entry/Summary.php" ["line"]=> int(82) ["function"]=> string(5) "query" ["class"]=> string(2) "DB" ["object"]=> object(DB)#1 (3) { ["_connection"]=> resource(19) of type (mysql link) ["_fetch"]=> array(0) { } ["_dsn"]=> array(3) { ["type"]=> string(5) "mysql" ["debug"]=> bool(true) ["charset"]=> string(5) "UTF-8" } } ["type"]=> string(2) "->" ["args"]=> array(2) { [0]=> &string(865) "SELECT * FROM acms_entry LEFT JOIN acms_blog ON blog_id = entry_blog_id LEFT JOIN acms_category ON category_id = entry_category_id INNER JOIN ( SELECT field_eid, field_value AS strfield_sort, field_value + 0 AS intfield_sort FROM acms_field WHERE 1 AND field_key = 'spot_genre' AND ( 0 OR field_value = '���������' ) ) AS field_end ON field_end.field_eid = entry_id WHERE 1 AND entry_datetime BETWEEN '1000-01-01 00:00:00' AND '9999-12-31 23:59:59' AND ( 1 AND entry_start_datetime <= '2017-12-11 09:16:05' AND entry_end_datetime >= '2017-12-11 09:16:05' AND entry_status = 'open' AND entry_approval <> 'pre_approval' ) AND entry_blog_id IN ('7') AND entry_category_id IN ('155') AND entry_indexing = 'on' GROUP BY entry_category_sort, entry_id ORDER BY entry_category_sort DESC, entry_id DESC LIMIT 0, 51" [1]=> &string(3) "all" } } [1]=> array(7) { ["file"]=> string(36) "/home/machisapo/www/php/ACMS/GET.php" ["line"]=> int(219) ["function"]=> string(3) "get" ["class"]=> string(22) "ACMS_GET_Entry_Summary" ["object"]=> object(ACMS_GET_Entry_Summary)#106 (34) { ["config":protected]=> array(35) { ["order"]=> string(9) "sort-desc" ["limit"]=> int(50) ["offset"]=> int(0) ["indexing"]=> string(2) "on" ["secret"]=> string(3) "off" ["notfound"]=> string(2) "on" ["notfoundStatus404"]=> string(3) "off" ["noimage"]=> string(2) "on" ["pagerDelta"]=> string(1) "3" ["pagerCurAttr"]=> string(12) " class="cur"" ["unit"]=> string(1) "3" ["newtime"]=> string(6) "259200" ["imageX"]=> int(100) ["imageY"]=> int(100) ["imageTrim"]=> string(2) "on" ["imageZoom"]=> string(3) "off" ["imageCenter"]=> string(3) "off" ["entryFieldOn"]=> string(2) "on" ["categoryInfoOn"]=> string(2) "on" ["categoryFieldOn"]=> string(3) "off" ["userInfoOn"]=> string(3) "off" ["userFieldOn"]=> string(3) "off" ["blogInfoOn"]=> string(3) "off" ["blogFieldOn"]=> string(3) "off" ["pagerOn"]=> string(2) "on" ["simplePagerOn"]=> string(3) "off" ["mainImageOn"]=> string(2) "on" ["detailDateOn"]=> string(2) "on" ["fullTextOn"]=> string(2) "on" ["fulltextWidth"]=> string(3) "200" ["fulltextMarker"]=> string(3) "..." ["tagOn"]=> string(2) "on" ["hiddenCurrentEntry"]=> string(3) "off" ["loop_class"]=> string(0) "" ["relational"]=> string(3) "off" } ["entries":protected]=> NULL ["amount":protected]=> object(SQL_Select)#65 (13) { ["_tables"]=> array(1) { [0]=> array(2) { ["table"]=> string(5) "entry" ["alias"]=> NULL } } ["_leftJoins"]=> array(2) { [0]=> array(4) { ["table"]=> string(4) "blog" ["a"]=> object(SQL_Field)#73 (2) { ["_field"]=> string(7) "blog_id" ["_scope"]=> NULL } ["b"]=> object(SQL_Field)#87 (2) { ["_field"]=> string(13) "entry_blog_id" ["_scope"]=> NULL } ["where"]=> NULL } [1]=> array(4) { ["table"]=> string(8) "category" ["a"]=> object(SQL_Field)#67 (2) { ["_field"]=> string(11) "category_id" ["_scope"]=> NULL } ["b"]=> object(SQL_Field)#66 (2) { ["_field"]=> string(17) "entry_category_id" ["_scope"]=> NULL } ["where"]=> NULL } } ["_innerJoins"]=> array(1) { [0]=> array(6) { ["table"]=> object(SQL_Select)#78 (13) { ["_tables"]=> array(1) { [0]=> array(2) { ["table"]=> string(5) "field" ["alias"]=> NULL } } ["_leftJoins"]=> array(0) { } ["_innerJoins"]=> array(0) { } ["_selects"]=> array(3) { [0]=> array(2) { ["field"]=> object(SQL_Field_Function)#57 (3) { ["_args"]=> array(1) { [0]=> NULL } ["_field"]=> string(9) "field_eid" ["_scope"]=> NULL } ["alias"]=> NULL } [1]=> array(2) { ["field"]=> object(SQL_Field_Function)#60 (3) { ["_args"]=> array(1) { [0]=> NULL } ["_field"]=> string(11) "field_value" ["_scope"]=> NULL } ["alias"]=> string(13) "strfield_sort" } [2]=> array(2) { ["field"]=> object(SQL_Field_Function)#75 (3) { ["_args"]=> array(1) { [0]=> NULL } ["_field"]=> object(SQL_Field_Operator)#85 (5) { ["_value"]=> int(0) ["_operator"]=> string(1) "+" ["_args"]=> array(1) { [0]=> NULL } ["_field"]=> string(11) "field_value" ["_scope"]=> NULL } ["_scope"]=> NULL } ["alias"]=> string(13) "intfield_sort" } } ["_havings"]=> array(0) { } ["_groups"]=> array(0) { } ["_limit"]=> NULL ["_orders"]=> array(0) { } ["_fdOrders"]=> NULL ["_where"]=> NULL ["_union"]=> array(0) { } ["_straightJoin"]=> bool(false) ["_wheres"]=> array(2) { [0]=> array(2) { ["where"]=> object(SQL_Field_Operator)#81 (5) { ["_value"]=> string(10) "spot_genre" ["_operator"]=> string(1) "=" ["_args"]=> array(1) { [0]=> NULL } ["_field"]=> string(9) "field_key" ["_scope"]=> NULL } ["glue"]=> string(3) "AND" } [1]=> array(2) { ["where"]=> object(SQL_Where)#88 (1) { ["_wheres"]=> array(1) { [0]=> array(2) { ["where"]=> object(SQL_Field_Operator)#53 (5) { ["_value"]=> string(27) "���������" ["_operator"]=> string(1) "=" ["_args"]=> array(1) { [0]=> NULL } ["_field"]=> string(11) "field_value" ["_scope"]=> NULL } ["glue"]=> string(2) "OR" } } } ["glue"]=> string(3) "AND" } } } ["a"]=> string(9) "field_eid" ["b"]=> string(8) "entry_id" ["als"]=> string(9) "field_end" ["scp"]=> NULL ["where"]=> NULL } } ["_selects"]=> array(1) { [0]=> array(2) { ["field"]=> object(SQL_Field_Function)#147 (3) { ["_args"]=> array(1) { [0]=> string(5) "COUNT" } ["_field"]=> string(18) "DISTINCT(entry_id)" ["_scope"]=> NULL } ["alias"]=> string(12) "entry_amount" } } ["_havings"]=> array(0) { } ["_groups"]=> array(0) { } ["_limit"]=> NULL ["_orders"]=> array(0) { } ["_fdOrders"]=> NULL ["_where"]=> NULL ["_union"]=> array(0) { } ["_straightJoin"]=> bool(false) ["_wheres"]=> array(5) { [0]=> array(2) { ["where"]=> object(SQL_Field_Operator_Between)#99 (7) { ["_a"]=> string(19) "1000-01-01 00:00:00" ["_b"]=> string(19) "9999-12-31 23:59:59" ["_value"]=> NULL ["_operator"]=> NULL ["_args"]=> array(1) { [0]=> NULL } ["_field"]=> string(14) "entry_datetime" ["_scope"]=> NULL } ["glue"]=> string(3) "AND" } [1]=> array(2) { ["where"]=> object(SQL_Where)#64 (1) { ["_wheres"]=> array(4) { [0]=> array(2) { ["where"]=> object(SQL_Field_Operator)#30 (5) { ["_value"]=> string(19) "2017-12-11 09:16:05" ["_operator"]=> string(2) "<=" ["_args"]=> array(1) { [0]=> NULL } ["_field"]=> string(20) "entry_start_datetime" ["_scope"]=> NULL } ["glue"]=> string(3) "AND" } [1]=> array(2) { ["where"]=> object(SQL_Field_Operator)#69 (5) { ["_value"]=> string(19) "2017-12-11 09:16:05" ["_operator"]=> string(2) ">=" ["_args"]=> array(1) { [0]=> NULL } ["_field"]=> string(18) "entry_end_datetime" ["_scope"]=> NULL } ["glue"]=> string(3) "AND" } [2]=> array(2) { ["where"]=> object(SQL_Field_Operator)#91 (5) { ["_value"]=> string(4) "open" ["_operator"]=> string(1) "=" ["_args"]=> array(1) { [0]=> NULL } ["_field"]=> string(12) "entry_status" ["_scope"]=> NULL } ["glue"]=> string(3) "AND" } [3]=> array(2) { ["where"]=> object(SQL_Field_Operator)#93 (5) { ["_value"]=> string(12) "pre_approval" ["_operator"]=> string(2) "<>" ["_args"]=> array(1) { [0]=> NULL } ["_field"]=> string(14) "entry_approval" ["_scope"]=> NULL } ["glue"]=> string(3) "AND" } } } ["glue"]=> string(3) "AND" } [2]=> array(2) { ["where"]=> object(SQL_Field_Operator_In)#80 (6) { ["_not"]=> bool(false) ["_value"]=> array(1) { [0]=> string(1) "7" } ["_operator"]=> NULL ["_args"]=> array(1) { [0]=> NULL } ["_field"]=> string(13) "entry_blog_id" ["_scope"]=> NULL } ["glue"]=> string(3) "AND" } [3]=> array(2) { ["where"]=> object(SQL_Field_Operator_In)#145 (6) { ["_not"]=> bool(false) ["_value"]=> array(1) { [0]=> string(3) "155" } ["_operator"]=> NULL ["_args"]=> array(1) { [0]=> NULL } ["_field"]=> string(17) "entry_category_id" ["_scope"]=> NULL } ["glue"]=> string(3) "AND" } [4]=> array(2) { ["where"]=> object(SQL_Field_Operator)#153 (5) { ["_value"]=> string(2) "on" ["_operator"]=> string(1) "=" ["_args"]=> array(1) { [0]=> NULL } ["_field"]=> string(14) "entry_indexing" ["_scope"]=> NULL } ["glue"]=> string(3) "AND" } } } ["eids":protected]=> NULL ["blogSubQuery":protected]=> object(SQL_Select)#96 (13) { ["_tables"]=> array(1) { [0]=> array(2) { ["table"]=> string(4) "blog" ["alias"]=> NULL } } ["_leftJoins"]=> array(0) { } ["_innerJoins"]=> array(0) { } ["_selects"]=> array(1) { [0]=> array(2) { ["field"]=> object(SQL_Field_Function)#94 (3) { ["_args"]=> array(1) { [0]=> NULL } ["_field"]=> string(7) "blog_id" ["_scope"]=> NULL } ["alias"]=> NULL } } ["_havings"]=> array(0) { } ["_groups"]=> array(0) { } ["_limit"]=> NULL ["_orders"]=> array(0) { } ["_fdOrders"]=> NULL ["_where"]=> NULL ["_union"]=> array(0) { } ["_straightJoin"]=> bool(false) ["_wheres"]=> array(2) { [0]=> array(2) { ["where"]=> object(SQL_Field_Operator)#86 (5) { ["_value"]=> int(7) ["_operator"]=> string(1) "=" ["_args"]=> array(1) { [0]=> NULL } ["_field"]=> string(7) "blog_id" ["_scope"]=> NULL } ["glue"]=> string(3) "AND" } [1]=> array(2) { ["where"]=> object(SQL_Field_Operator_In)#74 (6) { ["_not"]=> bool(false) ["_value"]=> array(1) { [0]=> string(4) "open" } ["_operator"]=> NULL ["_args"]=> array(1) { [0]=> NULL } ["_field"]=> string(11) "blog_status" ["_scope"]=> NULL } ["glue"]=> string(3) "AND" } } } ["categorySubQuery":protected]=> object(SQL_Select)#71 (13) { ["_tables"]=> array(1) { [0]=> array(2) { ["table"]=> string(8) "category" ["alias"]=> NULL } } ["_leftJoins"]=> array(0) { } ["_innerJoins"]=> array(0) { } ["_selects"]=> array(1) { [0]=> array(2) { ["field"]=> object(SQL_Field_Function)#92 (3) { ["_args"]=> array(1) { [0]=> NULL } ["_field"]=> string(11) "category_id" ["_scope"]=> NULL } ["alias"]=> NULL } } ["_havings"]=> array(0) { } ["_groups"]=> array(0) { } ["_limit"]=> NULL ["_orders"]=> array(0) { } ["_fdOrders"]=> NULL ["_where"]=> NULL ["_union"]=> array(0) { } ["_straightJoin"]=> bool(false) ["_wheres"]=> array(2) { [0]=> array(2) { ["where"]=> object(SQL_Field_Operator)#100 (5) { ["_value"]=> int(155) ["_operator"]=> string(1) "=" ["_args"]=> array(1) { [0]=> NULL } ["_field"]=> string(11) "category_id" ["_scope"]=> NULL } ["glue"]=> string(3) "AND" } [1]=> array(2) { ["where"]=> object(SQL_Where)#79 (1) { ["_wheres"]=> array(2) { [0]=> array(2) { ["where"]=> object(SQL_Field_Operator)#95 (5) { ["_value"]=> NULL ["_operator"]=> string(1) "=" ["_args"]=> array(1) { [0]=> NULL } ["_field"]=> string(15) "category_status" ["_scope"]=> NULL } ["glue"]=> string(2) "OR" } [1]=> array(2) { ["where"]=> object(SQL_Field_Operator)#48 (5) { ["_value"]=> string(4) "open" ["_operator"]=> string(1) "=" ["_args"]=> array(1) { [0]=> NULL } ["_field"]=> string(15) "category_status" ["_scope"]=> NULL } ["glue"]=> string(2) "OR" } } } ["glue"]=> string(3) "AND" } } } ["_axis"]=> array(2) { ["bid"]=> string(4) "self" ["cid"]=> string(18) "descendant-or-self" } ["tpl"]=> string(6556) "

飯豊町

ただいまページを準備しております。もうしばらくお待ちください。

" ["bid"]=> int(7) ["uid"]=> NULL ["cid"]=> int(155) ["eid"]=> NULL ["keyword"]=> string(0) "" ["tag"]=> string(0) "" ["tags"]=> array(0) { } ["field"]=> string(38) "spot_genre/���������" ["Field"]=> &object(Field_Search)#70 (6) { ["_aryOperator"]=> array(1) { ["spot_genre"]=> array(1) { [0]=> string(2) "eq" } } ["_aryConnector"]=> array(1) { ["spot_genre"]=> array(1) { [0]=> string(2) "or" } } ["_arySeparator"]=> array(1) { ["spot_genre"]=> string(3) "and" } ["_aryField"]=> array(1) { ["spot_genre"]=> array(1) { [0]=> string(27) "���������" } } ["_aryChild"]=> array(0) { } ["_aryMeta"]=> array(0) { } } ["start"]=> string(19) "1000-01-01 00:00:00" ["end"]=> string(19) "9999-12-31 23:59:59" ["alt"]=> NULL ["step"]=> NULL ["action"]=> NULL ["squareSize"]=> NULL ["isCSRF"]=> bool(false) ["Q"]=> object(Field)#111 (3) { ["_aryField"]=> array(13) { ["field"]=> array(1) { [0]=> string(38) "spot_genre/���������" } ["path"]=> array(1) { [0]=> string(26) "/passport2017/spot/ok/iide" } ["tag"]=> array(0) { } ["page"]=> array(1) { [0]=> int(1) } ["start"]=> array(1) { [0]=> string(19) "1000-01-01 00:00:00" } ["end"]=> array(1) { [0]=> string(19) "9999-12-31 23:59:59" } ["protocol"]=> array(1) { [0]=> string(4) "http" } ["bid"]=> array(1) { [0]=> string(1) "7" } ["cid"]=> array(1) { [0]=> int(155) } ["eid"]=> array(0) { } ["uid"]=> array(0) { } ["keyword"]=> array(0) { } ["order"]=> array(0) { } } ["_aryChild"]=> array(1) { ["field"]=> &object(Field_Search)#70 (6) { ["_aryOperator"]=> array(1) { ["spot_genre"]=> array(1) { [0]=> string(2) "eq" } } ["_aryConnector"]=> array(1) { ["spot_genre"]=> array(1) { [0]=> string(2) "or" } } ["_arySeparator"]=> array(1) { ["spot_genre"]=> string(3) "and" } ["_aryField"]=> array(1) { ["spot_genre"]=> array(1) { [0]=> string(27) "���������" } } ["_aryChild"]=> array(0) { } ["_aryMeta"]=> array(0) { } } } ["_aryMeta"]=> array(0) { } } ["Get"]=> object(Field)#108 (3) { ["_aryField"]=> array(0) { } ["_aryChild"]=> array(0) { } ["_aryMeta"]=> array(0) { } } ["Post"]=> object(Field_Validation)#31 (5) { ["_aryV"]=> array(0) { } ["_aryMethod"]=> array(0) { } ["_aryField"]=> array(0) { } ["_aryChild"]=> array(0) { } ["_aryMeta"]=> array(0) { } } ["_scope"]=> array(0) { } ["mid"]=> int(120) ["mbid"]=> int(7) ["identifier"]=> string(15) "spot_list_table" ["showField"]=> bool(true) ["page"]=> string(1) "1" ["order"]=> string(0) "" } ["type"]=> string(2) "->" ["args"]=> array(0) { } } [2]=> array(6) { ["file"]=> string(41) "/home/machisapo/www/php/ACMS/function.php" ["line"]=> int(4582) ["function"]=> string(4) "fire" ["class"]=> string(8) "ACMS_GET" ["object"]=> object(ACMS_GET_Entry_Summary)#106 (34) { ["config":protected]=> array(35) { ["order"]=> string(9) "sort-desc" ["limit"]=> int(50) ["offset"]=> int(0) ["indexing"]=> string(2) "on" ["secret"]=> string(3) "off" ["notfound"]=> string(2) "on" ["notfoundStatus404"]=> string(3) "off" ["noimage"]=> string(2) "on" ["pagerDelta"]=> string(1) "3" ["pagerCurAttr"]=> string(12) " class="cur"" ["unit"]=> string(1) "3" ["newtime"]=> string(6) "259200" ["imageX"]=> int(100) ["imageY"]=> int(100) ["imageTrim"]=> string(2) "on" ["imageZoom"]=> string(3) "off" ["imageCenter"]=> string(3) "off" ["entryFieldOn"]=> string(2) "on" ["categoryInfoOn"]=> string(2) "on" ["categoryFieldOn"]=> string(3) "off" ["userInfoOn"]=> string(3) "off" ["userFieldOn"]=> string(3) "off" ["blogInfoOn"]=> string(3) "off" ["blogFieldOn"]=> string(3) "off" ["pagerOn"]=> string(2) "on" ["simplePagerOn"]=> string(3) "off" ["mainImageOn"]=> string(2) "on" ["detailDateOn"]=> string(2) "on" ["fullTextOn"]=> string(2) "on" ["fulltextWidth"]=> string(3) "200" ["fulltextMarker"]=> string(3) "..." ["tagOn"]=> string(2) "on" ["hiddenCurrentEntry"]=> string(3) "off" ["loop_class"]=> string(0) "" ["relational"]=> string(3) "off" } ["entries":protected]=> NULL ["amount":protected]=> object(SQL_Select)#65 (13) { ["_tables"]=> array(1) { [0]=> array(2) { ["table"]=> string(5) "entry" ["alias"]=> NULL } } ["_leftJoins"]=> array(2) { [0]=> array(4) { ["table"]=> string(4) "blog" ["a"]=> object(SQL_Field)#73 (2) { ["_field"]=> string(7) "blog_id" ["_scope"]=> NULL } ["b"]=> object(SQL_Field)#87 (2) { ["_field"]=> string(13) "entry_blog_id" ["_scope"]=> NULL } ["where"]=> NULL } [1]=> array(4) { ["table"]=> string(8) "category" ["a"]=> object(SQL_Field)#67 (2) { ["_field"]=> string(11) "category_id" ["_scope"]=> NULL } ["b"]=> object(SQL_Field)#66 (2) { ["_field"]=> string(17) "entry_category_id" ["_scope"]=> NULL } ["where"]=> NULL } } ["_innerJoins"]=> array(1) { [0]=> array(6) { ["table"]=> object(SQL_Select)#78 (13) { ["_tables"]=> array(1) { [0]=> array(2) { ["table"]=> string(5) "field" ["alias"]=> NULL } } ["_leftJoins"]=> array(0) { } ["_innerJoins"]=> array(0) { } ["_selects"]=> array(3) { [0]=> array(2) { ["field"]=> object(SQL_Field_Function)#57 (3) { ["_args"]=> array(1) { [0]=> NULL } ["_field"]=> string(9) "field_eid" ["_scope"]=> NULL } ["alias"]=> NULL } [1]=> array(2) { ["field"]=> object(SQL_Field_Function)#60 (3) { ["_args"]=> array(1) { [0]=> NULL } ["_field"]=> string(11) "field_value" ["_scope"]=> NULL } ["alias"]=> string(13) "strfield_sort" } [2]=> array(2) { ["field"]=> object(SQL_Field_Function)#75 (3) { ["_args"]=> array(1) { [0]=> NULL } ["_field"]=> object(SQL_Field_Operator)#85 (5) { ["_value"]=> int(0) ["_operator"]=> string(1) "+" ["_args"]=> array(1) { [0]=> NULL } ["_field"]=> string(11) "field_value" ["_scope"]=> NULL } ["_scope"]=> NULL } ["alias"]=> string(13) "intfield_sort" } } ["_havings"]=> array(0) { } ["_groups"]=> array(0) { } ["_limit"]=> NULL ["_orders"]=> array(0) { } ["_fdOrders"]=> NULL ["_where"]=> NULL ["_union"]=> array(0) { } ["_straightJoin"]=> bool(false) ["_wheres"]=> array(2) { [0]=> array(2) { ["where"]=> object(SQL_Field_Operator)#81 (5) { ["_value"]=> string(10) "spot_genre" ["_operator"]=> string(1) "=" ["_args"]=> array(1) { [0]=> NULL } ["_field"]=> string(9) "field_key" ["_scope"]=> NULL } ["glue"]=> string(3) "AND" } [1]=> array(2) { ["where"]=> object(SQL_Where)#88 (1) { ["_wheres"]=> array(1) { [0]=> array(2) { ["where"]=> object(SQL_Field_Operator)#53 (5) { ["_value"]=> string(27) "���������" ["_operator"]=> string(1) "=" ["_args"]=> array(1) { [0]=> NULL } ["_field"]=> string(11) "field_value" ["_scope"]=> NULL } ["glue"]=> string(2) "OR" } } } ["glue"]=> string(3) "AND" } } } ["a"]=> string(9) "field_eid" ["b"]=> string(8) "entry_id" ["als"]=> string(9) "field_end" ["scp"]=> NULL ["where"]=> NULL } } ["_selects"]=> array(1) { [0]=> array(2) { ["field"]=> object(SQL_Field_Function)#147 (3) { ["_args"]=> array(1) { [0]=> string(5) "COUNT" } ["_field"]=> string(18) "DISTINCT(entry_id)" ["_scope"]=> NULL } ["alias"]=> string(12) "entry_amount" } } ["_havings"]=> array(0) { } ["_groups"]=> array(0) { } ["_limit"]=> NULL ["_orders"]=> array(0) { } ["_fdOrders"]=> NULL ["_where"]=> NULL ["_union"]=> array(0) { } ["_straightJoin"]=> bool(false) ["_wheres"]=> array(5) { [0]=> array(2) { ["where"]=> object(SQL_Field_Operator_Between)#99 (7) { ["_a"]=> string(19) "1000-01-01 00:00:00" ["_b"]=> string(19) "9999-12-31 23:59:59" ["_value"]=> NULL ["_operator"]=> NULL ["_args"]=> array(1) { [0]=> NULL } ["_field"]=> string(14) "entry_datetime" ["_scope"]=> NULL } ["glue"]=> string(3) "AND" } [1]=> array(2) { ["where"]=> object(SQL_Where)#64 (1) { ["_wheres"]=> array(4) { [0]=> array(2) { ["where"]=> object(SQL_Field_Operator)#30 (5) { ["_value"]=> string(19) "2017-12-11 09:16:05" ["_operator"]=> string(2) "<=" ["_args"]=> array(1) { [0]=> NULL } ["_field"]=> string(20) "entry_start_datetime" ["_scope"]=> NULL } ["glue"]=> string(3) "AND" } [1]=> array(2) { ["where"]=> object(SQL_Field_Operator)#69 (5) { ["_value"]=> string(19) "2017-12-11 09:16:05" ["_operator"]=> string(2) ">=" ["_args"]=> array(1) { [0]=> NULL } ["_field"]=> string(18) "entry_end_datetime" ["_scope"]=> NULL } ["glue"]=> string(3) "AND" } [2]=> array(2) { ["where"]=> object(SQL_Field_Operator)#91 (5) { ["_value"]=> string(4) "open" ["_operator"]=> string(1) "=" ["_args"]=> array(1) { [0]=> NULL } ["_field"]=> string(12) "entry_status" ["_scope"]=> NULL } ["glue"]=> string(3) "AND" } [3]=> array(2) { ["where"]=> object(SQL_Field_Operator)#93 (5) { ["_value"]=> string(12) "pre_approval" ["_operator"]=> string(2) "<>" ["_args"]=> array(1) { [0]=> NULL } ["_field"]=> string(14) "entry_approval" ["_scope"]=> NULL } ["glue"]=> string(3) "AND" } } } ["glue"]=> string(3) "AND" } [2]=> array(2) { ["where"]=> object(SQL_Field_Operator_In)#80 (6) { ["_not"]=> bool(false) ["_value"]=> array(1) { [0]=> string(1) "7" } ["_operator"]=> NULL ["_args"]=> array(1) { [0]=> NULL } ["_field"]=> string(13) "entry_blog_id" ["_scope"]=> NULL } ["glue"]=> string(3) "AND" } [3]=> array(2) { ["where"]=> object(SQL_Field_Operator_In)#145 (6) { ["_not"]=> bool(false) ["_value"]=> array(1) { [0]=> string(3) "155" } ["_operator"]=> NULL ["_args"]=> array(1) { [0]=> NULL } ["_field"]=> string(17) "entry_category_id" ["_scope"]=> NULL } ["glue"]=> string(3) "AND" } [4]=> array(2) { ["where"]=> object(SQL_Field_Operator)#153 (5) { ["_value"]=> string(2) "on" ["_operator"]=> string(1) "=" ["_args"]=> array(1) { [0]=> NULL } ["_field"]=> string(14) "entry_indexing" ["_scope"]=> NULL } ["glue"]=> string(3) "AND" } } } ["eids":protected]=> NULL ["blogSubQuery":protected]=> object(SQL_Select)#96 (13) { ["_tables"]=> array(1) { [0]=> array(2) { ["table"]=> string(4) "blog" ["alias"]=> NULL } } ["_leftJoins"]=> array(0) { } ["_innerJoins"]=> array(0) { } ["_selects"]=> array(1) { [0]=> array(2) { ["field"]=> object(SQL_Field_Function)#94 (3) { ["_args"]=> array(1) { [0]=> NULL } ["_field"]=> string(7) "blog_id" ["_scope"]=> NULL } ["alias"]=> NULL } } ["_havings"]=> array(0) { } ["_groups"]=> array(0) { } ["_limit"]=> NULL ["_orders"]=> array(0) { } ["_fdOrders"]=> NULL ["_where"]=> NULL ["_union"]=> array(0) { } ["_straightJoin"]=> bool(false) ["_wheres"]=> array(2) { [0]=> array(2) { ["where"]=> object(SQL_Field_Operator)#86 (5) { ["_value"]=> int(7) ["_operator"]=> string(1) "=" ["_args"]=> array(1) { [0]=> NULL } ["_field"]=> string(7) "blog_id" ["_scope"]=> NULL } ["glue"]=> string(3) "AND" } [1]=> array(2) { ["where"]=> object(SQL_Field_Operator_In)#74 (6) { ["_not"]=> bool(false) ["_value"]=> array(1) { [0]=> string(4) "open" } ["_operator"]=> NULL ["_args"]=> array(1) { [0]=> NULL } ["_field"]=> string(11) "blog_status" ["_scope"]=> NULL } ["glue"]=> string(3) "AND" } } } ["categorySubQuery":protected]=> object(SQL_Select)#71 (13) { ["_tables"]=> array(1) { [0]=> array(2) { ["table"]=> string(8) "category" ["alias"]=> NULL } } ["_leftJoins"]=> array(0) { } ["_innerJoins"]=> array(0) { } ["_selects"]=> array(1) { [0]=> array(2) { ["field"]=> object(SQL_Field_Function)#92 (3) { ["_args"]=> array(1) { [0]=> NULL } ["_field"]=> string(11) "category_id" ["_scope"]=> NULL } ["alias"]=> NULL } } ["_havings"]=> array(0) { } ["_groups"]=> array(0) { } ["_limit"]=> NULL ["_orders"]=> array(0) { } ["_fdOrders"]=> NULL ["_where"]=> NULL ["_union"]=> array(0) { } ["_straightJoin"]=> bool(false) ["_wheres"]=> array(2) { [0]=> array(2) { ["where"]=> object(SQL_Field_Operator)#100 (5) { ["_value"]=> int(155) ["_operator"]=> string(1) "=" ["_args"]=> array(1) { [0]=> NULL } ["_field"]=> string(11) "category_id" ["_scope"]=> NULL } ["glue"]=> string(3) "AND" } [1]=> array(2) { ["where"]=> object(SQL_Where)#79 (1) { ["_wheres"]=> array(2) { [0]=> array(2) { ["where"]=> object(SQL_Field_Operator)#95 (5) { ["_value"]=> NULL ["_operator"]=> string(1) "=" ["_args"]=> array(1) { [0]=> NULL } ["_field"]=> string(15) "category_status" ["_scope"]=> NULL } ["glue"]=> string(2) "OR" } [1]=> array(2) { ["where"]=> object(SQL_Field_Operator)#48 (5) { ["_value"]=> string(4) "open" ["_operator"]=> string(1) "=" ["_args"]=> array(1) { [0]=> NULL } ["_field"]=> string(15) "category_status" ["_scope"]=> NULL } ["glue"]=> string(2) "OR" } } } ["glue"]=> string(3) "AND" } } } ["_axis"]=> array(2) { ["bid"]=> string(4) "self" ["cid"]=> string(18) "descendant-or-self" } ["tpl"]=> string(6556) "

飯豊町

ただいまページを準備しております。もうしばらくお待ちください。

" ["bid"]=> int(7) ["uid"]=> NULL ["cid"]=> int(155) ["eid"]=> NULL ["keyword"]=> string(0) "" ["tag"]=> string(0) "" ["tags"]=> array(0) { } ["field"]=> string(38) "spot_genre/���������" ["Field"]=> &object(Field_Search)#70 (6) { ["_aryOperator"]=> array(1) { ["spot_genre"]=> array(1) { [0]=> string(2) "eq" } } ["_aryConnector"]=> array(1) { ["spot_genre"]=> array(1) { [0]=> string(2) "or" } } ["_arySeparator"]=> array(1) { ["spot_genre"]=> string(3) "and" } ["_aryField"]=> array(1) { ["spot_genre"]=> array(1) { [0]=> string(27) "���������" } } ["_aryChild"]=> array(0) { } ["_aryMeta"]=> array(0) { } } ["start"]=> string(19) "1000-01-01 00:00:00" ["end"]=> string(19) "9999-12-31 23:59:59" ["alt"]=> NULL ["step"]=> NULL ["action"]=> NULL ["squareSize"]=> NULL ["isCSRF"]=> bool(false) ["Q"]=> object(Field)#111 (3) { ["_aryField"]=> array(13) { ["field"]=> array(1) { [0]=> string(38) "spot_genre/���������" } ["path"]=> array(1) { [0]=> string(26) "/passport2017/spot/ok/iide" } ["tag"]=> array(0) { } ["page"]=> array(1) { [0]=> int(1) } ["start"]=> array(1) { [0]=> string(19) "1000-01-01 00:00:00" } ["end"]=> array(1) { [0]=> string(19) "9999-12-31 23:59:59" } ["protocol"]=> array(1) { [0]=> string(4) "http" } ["bid"]=> array(1) { [0]=> string(1) "7" } ["cid"]=> array(1) { [0]=> int(155) } ["eid"]=> array(0) { } ["uid"]=> array(0) { } ["keyword"]=> array(0) { } ["order"]=> array(0) { } } ["_aryChild"]=> array(1) { ["field"]=> &object(Field_Search)#70 (6) { ["_aryOperator"]=> array(1) { ["spot_genre"]=> array(1) { [0]=> string(2) "eq" } } ["_aryConnector"]=> array(1) { ["spot_genre"]=> array(1) { [0]=> string(2) "or" } } ["_arySeparator"]=> array(1) { ["spot_genre"]=> string(3) "and" } ["_aryField"]=> array(1) { ["spot_genre"]=> array(1) { [0]=> string(27) "���������" } } ["_aryChild"]=> array(0) { } ["_aryMeta"]=> array(0) { } } } ["_aryMeta"]=> array(0) { } } ["Get"]=> object(Field)#108 (3) { ["_aryField"]=> array(0) { } ["_aryChild"]=> array(0) { } ["_aryMeta"]=> array(0) { } } ["Post"]=> object(Field_Validation)#31 (5) { ["_aryV"]=> array(0) { } ["_aryMethod"]=> array(0) { } ["_aryField"]=> array(0) { } ["_aryChild"]=> array(0) { } ["_aryMeta"]=> array(0) { } } ["_scope"]=> array(0) { } ["mid"]=> int(120) ["mbid"]=> int(7) ["identifier"]=> string(15) "spot_list_table" ["showField"]=> bool(true) ["page"]=> string(1) "1" ["order"]=> string(0) "" } ["type"]=> string(2) "->" } [3]=> array(3) { ["file"]=> string(41) "/home/machisapo/www/php/ACMS/function.php" ["line"]=> int(4054) ["function"]=> string(4) "boot" } [4]=> array(3) { ["file"]=> string(29) "/home/machisapo/www/index.php" ["line"]=> int(2032) ["function"]=> string(5) "build" } }
Fatal error: Illegal mix of collations (ujis_japanese_ci,IMPLICIT) and (utf8_general_ci,COERCIBLE) for operation '='
SELECT *
 FROM acms_entry
 LEFT JOIN acms_blog ON blog_id = entry_blog_id
 LEFT JOIN acms_category ON category_id = entry_category_id
 INNER JOIN (
SELECT field_eid, field_value AS strfield_sort, field_value + 0 AS intfield_sort
 FROM acms_field
 
 WHERE 1
  AND field_key = 'spot_genre'
  AND ( 0
  OR field_value = '���������'
  )
) AS field_end ON field_end.field_eid = entry_id
 
 WHERE 1
  AND entry_datetime BETWEEN '1000-01-01 00:00:00' AND '9999-12-31 23:59:59'
  AND ( 1
  AND entry_start_datetime <= '2017-12-11 09:16:05'
  AND entry_end_datetime >= '2017-12-11 09:16:05'
  AND entry_status = 'open'
  AND entry_approval <> 'pre_approval'
  )
  AND entry_blog_id IN ('7')
  AND entry_category_id IN ('155')
  AND entry_indexing = 'on'
 GROUP BY entry_category_sort, entry_id
 ORDER BY entry_category_sort DESC, entry_id DESC
 LIMIT 0, 51
in /home/machisapo/www/php/DB.php on line 178