{"id":1048,"date":"2018-10-28T01:25:57","date_gmt":"2018-10-27T21:25:57","guid":{"rendered":"http:\/\/sbbo.ru\/blog\/?p=1048"},"modified":"2022-08-22T17:43:34","modified_gmt":"2022-08-22T13:43:34","slug":"oshibka-hostcms-posle-ustanovki-na-novyj-server","status":"publish","type":"post","link":"https:\/\/sbbo.ru\/blog\/solution\/oshibka-hostcms-posle-ustanovki-na-novyj-server\/","title":{"rendered":"\u041e\u0448\u0438\u0431\u043a\u0430 HostCMS 6.8.4 \u043f\u043e\u0441\u043b\u0435 \u0443\u0441\u0442\u0430\u043d\u043e\u0432\u043a\u0438 \u043d\u0430 \u043d\u043e\u0432\u044b\u0439 \u0441\u0435\u0440\u0432\u0435\u0440"},"content":{"rendered":"<p>\u0418\u043d\u043e\u0433\u0434\u0430 \u0442\u0440\u0435\u0431\u0443\u0435\u0442\u0441\u044f \u043f\u0435\u0440\u0435\u043d\u043e\u0441\u0438\u0442\u044c \u0441\u0430\u0439\u0442\u044b \u043d\u0430 \u0434\u0440\u0443\u0433\u0438\u0435 \u0432\u0435\u0431-\u0441\u0435\u0440\u0432\u0435\u0440\u0430, \u0438\u043d\u043e\u0433\u0434\u0430 \u0440\u0430\u0437\u0432\u043e\u0440\u0430\u0447\u0438\u0432\u0430\u0442\u044c \u0441\u0438\u0441\u0442\u0435\u043c\u0443 \u0443\u043f\u0440\u0430\u0432\u043b\u0435\u043d\u0438\u044f \u0441\u0430\u0439\u0442\u043e\u043c, \u043d\u0430 \u043d\u043e\u0432\u044b\u0445 VPS \u0441\u043e \u0441\u0432\u0435\u0436\u0435\u0439 \u0443\u0441\u0442\u0430\u043d\u043e\u0432\u043b\u0435\u043d\u043d\u043e\u0439 \u043e\u043f\u0435\u0440\u0430\u0446\u0438\u043e\u043d\u043d\u043e\u0439 \u0441\u0438\u0441\u0442\u0435\u043c\u043e\u0439. \u0423\u0441\u0442\u0430\u043d\u043e\u0432\u043a\u0430 \u0438\u0434\u0435\u0442 \u043a\u0430\u043a \u043e\u0431\u044b\u0447\u043d\u043e, \u043d\u0435\u0447\u0435\u0433\u043e \u043d\u0435 \u043f\u0440\u0435\u0434\u0432\u0435\u0449\u0430\u0435\u0442 \u043f\u0440\u043e\u0431\u043b\u0435\u043c, <span class=\"user-name\">PHP <\/span> <span class=\"user-company\">7.0.32, <\/span><span class=\"user-name\">MySQL <\/span> <span class=\"user-company\">5.7.24, <\/span><span class=\"user-name\">GD: <\/span> <span class=\"user-company\">2.1.1, <\/span><span class=\"user-name\">PCRE: <\/span> <span class=\"user-company\">8.38, \u0432\u0441\u0451 \u0432 \u043d\u0430\u043b\u0438\u0447\u0438\u0438 Multibyte String, JSON, SimpleXML, Iconv. <\/span>\u0412\u0441\u0451 \u043f\u043e\u0434\u0445\u043e\u0434\u0438\u0442 \u043f\u043e\u0434 \u0441\u0438\u0441\u0442\u0435\u043c\u043d\u044b\u0435 \u0442\u0440\u0435\u0431\u043e\u0432\u0430\u043d\u0438\u044f HostCMS, \u043d\u043e \u0432\u043e\u0437\u043d\u0438\u043a\u0430\u0435\u0442 \u043e\u0448\u0438\u0431\u043a\u0430: Exception: Query error 42000: SQLSTATE[42000]: Syntax error or access violation: 1055 Expression #1 of SELECT list is not in GROUP BY clause and contains nonaggregated \u0447\u0442\u043e \u0434\u0435\u043b\u0430\u0442\u044c?<!--more--><\/p>\n<p>Exception: Query error 42000: SQLSTATE[42000]: Syntax error or access violation: 1055 Expression #1 of SELECT list is not in GROUP BY clause and contains nonaggregated column &#8216;hostcms_db.shop_discounts.value&#8217; which is not functionally dependent on columns in GROUP BY clause; this is incompatible with sql_mode=only_full_group_by. Query: SELECT MIN(t.absolute_price) AS `min`, MAX(t.absolute_price) AS `max` FROM (SELECT IF (`shop_items`.`shop_currency_id` = &#8216;3&#8217;, IF (shop_discounts.value, IF(shop_discounts.type, price * 53 &#8212; shop_discounts.value, price * (100 &#8212; shop_discounts.value) * 53 \/ 100), shop_items.price * 53), IF (`shop_items`.`shop_currency_id` = &#8216;2&#8217;, IF (shop_discounts.value, IF(shop_discounts.type, price * 60 &#8212; shop_discounts.value, price * (100 &#8212; shop_discounts.value) * 60 \/ 100), shop_items.price * 60), IF (`shop_items`.`shop_currency_id` = &#8216;1&#8217;, IF (shop_discounts.value, IF(shop_discounts.type, price * 1 &#8212; shop_discounts.value, price * (100 &#8212; shop_discounts.value) * 1 \/ 100), shop_items.price * 1), price))) AS `absolute_price` FROM `shop_items` LEFT OUTER JOIN `shop_item_discounts` ON `shop_items`.`id` = `shop_item_discounts`.`shop_item_id` LEFT OUTER JOIN `shop_discounts` ON `shop_item_discounts`.`shop_discount_id` = `shop_discounts`.`id` AND ( `shop_discounts`.`end_datetime` &gt;= &#8216;2018-11-12 22:46:10&#8217; OR `shop_discounts`.`end_datetime` = &#8216;0000-00-00 00:00:00&#8217; AND `shop_discounts`.`start_datetime` &lt;= &#8216;2018-11-12 22:46:10&#8217; ) WHERE `shop_items`.`deleted` = 0 AND `shop_items`.`shop_id` = &#8216;3&#8217; AND `shop_items`.`active` = 1 AND ( `shop_items`.`shop_group_id` IN (&#8216;604&#8217;) AND `shop_items`.`shortcut_id` = 0 OR `shop_items`.`id` IN (SELECT `shop_items`.`shortcut_id` FROM `shop_items` WHERE `shop_items`.`deleted` = 0 AND `shop_items`.`active` = 1 AND `shop_items`.`shop_group_id` IN (&#8216;604&#8217;) AND `shop_items`.`shortcut_id` &gt; 0 AND ( `shop_items`.`start_datetime` &lt; &#8216;2018-11-12 22:46:10&#8217; OR `shop_items`.`start_datetime` = &#8216;0000-00-00 00:00:00&#8217; ) AND ( `shop_items`.`end_datetime` &gt; &#8216;2018-11-12 22:46:10&#8217; OR `shop_items`.`end_datetime` = &#8216;0000-00-00 00:00:00&#8217; ) AND `shop_items`.`siteuser_group_id` IN (0, -1)) ) GROUP BY `shop_items`.`id`) AS `t`<br \/>\n36 modules\/core\/exception.php<br \/>\n569 modules\/core\/database\/pdo.php<br \/>\n80 modules\/core\/querybuilder\/statement.php<br \/>\n249 hostcmsfiles\/lib\/lib_47\/lib_config_47.php<br \/>\n193 templates\/template15\/template.htm<br \/>\n96 modules\/template\/model.php<br \/>\n166 modules\/core\/page.php<br \/>\n207 templates\/template13\/template.htm<br \/>\n96 modules\/template\/model.php<br \/>\n166 modules\/core\/page.php<br \/>\n511 modules\/core\/command\/controller\/default.php<br \/>\n195 modules\/core\/router\/route.php<br \/>\n239 index.php<\/p>\n<p>\u0421\u0438\u0442\u0443\u0430\u0446\u0438\u044f \u0434\u043e\u0432\u043e\u043b\u044c\u043d\u043e \u043f\u0440\u043e\u0441\u0442\u0430\u044f, \u0435\u0441\u043b\u0438 \u0443 \u0412\u0430\u0441 \u0435\u0441\u0442\u044c \u0434\u043e\u0441\u0442\u0443\u043f \u043f\u043e SSH \u043a \u0441\u0435\u0440\u0432\u0435\u0440\u0443, \u0438\u043b\u0438 \u0432\u044b \u043c\u043e\u0436\u0435\u0442\u0435 \u0438\u0437\u043c\u0435\u043d\u0438\u0442\u044c \u043a\u043e\u043d\u0444\u0438\u0433\u0443\u0440\u0430\u0446\u0438\u043e\u043d\u043d\u044b\u0439 \u0444\u0430\u0439\u043b \u043d\u0430\u0445\u043e\u0434\u044f\u0449\u0438\u0439\u0441\u044f \u043f\u043e \u0430\u0434\u0440\u0435\u0441\u0443: \/etc\/mysql\/my.cnf<\/p>\n<p>\u041e\u0442\u043a\u0440\u044b\u0432\u0430\u0435\u0442 \u0435\u0433\u043e, \u0438\u0449\u0435\u043c \u0441\u0435\u043a\u0446\u0438\u044e [mysqld], \u0434\u043e\u043f\u0438\u0441\u044b\u0432\u0430\u0435\u043c \u0432 \u043d\u0435\u0451 \u043e\u0434\u043d\u0443 \u0438\u0437 \u0437\u0430\u043f\u0438\u0441\u0435\u0439 \u043d\u0430 \u0432\u044b\u0431\u043e\u0440:<\/p>\n<ul>\n<li>\u0418\u043b\u0438 \u043a\u0430\u043a \u043d\u0430\u043f\u0438\u0441\u0430\u043d\u043e \u0432 \u0434\u043e\u043a\u0443\u043c\u0435\u043d\u0442\u0430\u0446\u0438\u0438 CMS: sql-mode=&#187;&#187;<\/li>\n<li>\u0418\u043b\u0438 \u0442\u0430\u043a\u0443\u044e \u0441\u0442\u0440\u043e\u0447\u043a\u0443:\n<pre class=\"brush: plain; title: ; notranslate\" title=\"\">sql_mode = STRICT_TRANS_TABLES,NO_ZERO_IN_DATE,NO_ZERO_DATE,ERROR_FOR_DIVISION_BY_ZERO,NO_AUTO_CREATE_USER,NO_ENGINE_SUBSTITUTIO<\/pre>\n<\/li>\n<\/ul>\n<p>\u041f\u043e\u0441\u043b\u0435 \u044d\u0442\u043e\u0433\u043e \u043f\u0435\u0440\u0435\u0437\u0430\u043f\u0443\u0441\u043a\u0430\u0435\u043c \u0441\u043b\u0443\u0436\u0431\u0443 MySQL (service mysql restart), \u0437\u0430\u0445\u043e\u0434\u0438\u043c \u043d\u0430 \u0441\u0430\u0439\u0442 \u0438 \u043d\u0430\u0431\u043b\u044e\u0434\u0430\u0435\u043c \u043e\u0442\u0441\u0443\u0442\u0441\u0442\u0432\u0438\u0435 \u043e\u0448\u0438\u0431\u043a\u0438.<\/p>\n<p>&nbsp;<\/p>\n<!-- AddThis Advanced Settings generic via filter on the_content --><!-- AddThis Share Buttons generic via filter on the_content -->","protected":false},"excerpt":{"rendered":"<p>\u0418\u043d\u043e\u0433\u0434\u0430 \u0442\u0440\u0435\u0431\u0443\u0435\u0442\u0441\u044f \u043f\u0435\u0440\u0435\u043d\u043e\u0441\u0438\u0442\u044c \u0441\u0430\u0439\u0442\u044b \u043d\u0430 \u0434\u0440\u0443\u0433\u0438\u0435 \u0432\u0435\u0431-\u0441\u0435\u0440\u0432\u0435\u0440\u0430, \u0438\u043d\u043e\u0433\u0434\u0430 \u0440\u0430\u0437\u0432\u043e\u0440\u0430\u0447\u0438\u0432\u0430\u0442\u044c \u0441\u0438\u0441\u0442\u0435\u043c\u0443 \u0443\u043f\u0440\u0430\u0432\u043b\u0435\u043d\u0438\u044f \u0441\u0430\u0439\u0442\u043e\u043c, \u043d\u0430 \u043d\u043e\u0432\u044b\u0445 VPS \u0441\u043e \u0441\u0432\u0435\u0436\u0435\u0439 \u0443\u0441\u0442\u0430\u043d\u043e\u0432\u043b\u0435\u043d\u043d\u043e\u0439 \u043e\u043f\u0435\u0440\u0430\u0446\u0438\u043e\u043d\u043d\u043e\u0439 \u0441\u0438\u0441\u0442\u0435\u043c\u043e\u0439. \u0423\u0441\u0442\u0430\u043d\u043e\u0432\u043a\u0430 \u0438\u0434\u0435\u0442 \u043a\u0430\u043a \u043e\u0431\u044b\u0447\u043d\u043e, \u043d\u0435\u0447\u0435\u0433\u043e \u043d\u0435 \u043f\u0440\u0435\u0434\u0432\u0435\u0449\u0430\u0435\u0442 \u043f\u0440\u043e\u0431\u043b\u0435\u043c, PHP 7.0.32, MySQL 5.7.24, GD: 2.1.1, PCRE: 8.38, \u0432\u0441\u0451 \u0432 \u043d\u0430\u043b\u0438\u0447\u0438\u0438 Multibyte &hellip; <a href=\"https:\/\/sbbo.ru\/blog\/solution\/oshibka-hostcms-posle-ustanovki-na-novyj-server\/\">\u0427\u0438\u0442\u0430\u0442\u044c \u0434\u0430\u043b\u0435\u0435 <span class=\"meta-nav\">&rarr;<\/span><\/a><!-- AddThis Advanced Settings generic via filter on get_the_excerpt --><!-- AddThis Share Buttons generic via filter on get_the_excerpt --><\/p>\n","protected":false},"author":1,"featured_media":0,"comment_status":"closed","ping_status":"closed","sticky":false,"template":"","format":"standard","meta":[],"categories":[26],"tags":[27,21],"_links":{"self":[{"href":"https:\/\/sbbo.ru\/blog\/wp-json\/wp\/v2\/posts\/1048"}],"collection":[{"href":"https:\/\/sbbo.ru\/blog\/wp-json\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/sbbo.ru\/blog\/wp-json\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/sbbo.ru\/blog\/wp-json\/wp\/v2\/users\/1"}],"replies":[{"embeddable":true,"href":"https:\/\/sbbo.ru\/blog\/wp-json\/wp\/v2\/comments?post=1048"}],"version-history":[{"count":3,"href":"https:\/\/sbbo.ru\/blog\/wp-json\/wp\/v2\/posts\/1048\/revisions"}],"predecessor-version":[{"id":1070,"href":"https:\/\/sbbo.ru\/blog\/wp-json\/wp\/v2\/posts\/1048\/revisions\/1070"}],"wp:attachment":[{"href":"https:\/\/sbbo.ru\/blog\/wp-json\/wp\/v2\/media?parent=1048"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/sbbo.ru\/blog\/wp-json\/wp\/v2\/categories?post=1048"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/sbbo.ru\/blog\/wp-json\/wp\/v2\/tags?post=1048"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}