2022-03-03 16:12:51 --- EMERGENCY: Database_Exception [ 1055 ]: Expression #11 of SELECT list is not in GROUP BY clause and contains nonaggregated column 'hunland_main.cptt.title' which is not functionally dependent on columns in GROUP BY clause; this is incompatible with sql_mode=only_full_group_by [ SELECT COUNT(*) AS cnt FROM (SELECT c1.id, c1.`created_at`, AVG(c_rat.`rating`) AS prat, c1.`title`, c1.alias, c2.name AS bname, c1.image_id AS main_img_id, c1.sq_image_id AS sqr_img_id, c4.filename AS main_image, c5.filename AS sqr_image, cptt.title AS pcat_title, cptt.alias AS pcat_alias FROM products AS c1 INNER JOIN `category_product` AS cpt ON cpt.`product_id` = c1.`id` AND cpt.`category_id` IN (-1,582,583,584,585,586,587,588,589,590) INNER JOIN `categories` AS cptt ON cptt.id = cpt.`category_id` LEFT JOIN `product_reviews` AS c_rat ON c_rat.`product_id` = c1.`id` AND c_rat.`status` = 1 LEFT JOIN images AS c4 ON c4.id = c1.image_id LEFT JOIN images AS c5 ON c5.id = c1.sq_image_id LEFT JOIN brands AS c2 ON c2.id = c1.brand_id WHERE c1.status = 1 GROUP BY c1.id) AS ttab ] ~ MODPATH/database/classes/Kohana/Database/MySQLi.php [ 171 ] in /var/www/quadcats/data/www/hunland.up6.ru/modules/database/classes/Kohana/Database/Query.php:251
2022-03-03 16:12:51 --- DEBUG: #0 /var/www/quadcats/data/www/hunland.up6.ru/modules/database/classes/Kohana/Database/Query.php(251): Kohana_Database_MySQLi->query(1, 'SELECT COUNT(*)...', false, Array)
#1 /var/www/quadcats/data/www/hunland.up6.ru/application/classes/Controller/Index/Catalog.php(21): Kohana_Database_Query->execute(Object(Database_MySQLi))
#2 /var/www/quadcats/data/www/hunland.up6.ru/system/classes/Kohana/Controller.php(84): Controller_Index_Catalog->action_index()
#3 [internal function]: Kohana_Controller->execute()
#4 /var/www/quadcats/data/www/hunland.up6.ru/system/classes/Kohana/Request/Client/Internal.php(94): ReflectionMethod->invoke(Object(Controller_Index_Catalog))
#5 /var/www/quadcats/data/www/hunland.up6.ru/system/classes/Kohana/Request/Client.php(114): Kohana_Request_Client_Internal->execute_request(Object(Request), Object(Response))
#6 /var/www/quadcats/data/www/hunland.up6.ru/system/classes/Kohana/Request.php(1000): Kohana_Request_Client->execute(Object(Request))
#7 /var/www/quadcats/data/www/hunland.up6.ru/public/index.php(118): Kohana_Request->execute()
#8 {main} in /var/www/quadcats/data/www/hunland.up6.ru/modules/database/classes/Kohana/Database/Query.php:251
2022-03-03 16:39:04 --- EMERGENCY: Database_Exception [ 1055 ]: Expression #11 of SELECT list is not in GROUP BY clause and contains nonaggregated column 'hunland_main.cptt.title' which is not functionally dependent on columns in GROUP BY clause; this is incompatible with sql_mode=only_full_group_by [ SELECT COUNT(*) AS cnt FROM (SELECT c1.id, c1.`created_at`, AVG(c_rat.`rating`) AS prat, c1.`title`, c1.alias, c2.name AS bname, c1.image_id AS main_img_id, c1.sq_image_id AS sqr_img_id, c4.filename AS main_image, c5.filename AS sqr_image, cptt.title AS pcat_title, cptt.alias AS pcat_alias FROM products AS c1 INNER JOIN `category_product` AS cpt ON cpt.`product_id` = c1.`id` AND cpt.`category_id` IN (-1,582,583,584,585,586,587,588,589,590) INNER JOIN `categories` AS cptt ON cptt.id = cpt.`category_id` LEFT JOIN `product_reviews` AS c_rat ON c_rat.`product_id` = c1.`id` AND c_rat.`status` = 1 LEFT JOIN images AS c4 ON c4.id = c1.image_id LEFT JOIN images AS c5 ON c5.id = c1.sq_image_id LEFT JOIN brands AS c2 ON c2.id = c1.brand_id WHERE c1.status = 1 GROUP BY c1.id) AS ttab ] ~ MODPATH/database/classes/Kohana/Database/MySQLi.php [ 171 ] in /var/www/quadcats/data/www/hunland.up6.ru/modules/database/classes/Kohana/Database/Query.php:251
2022-03-03 16:39:04 --- DEBUG: #0 /var/www/quadcats/data/www/hunland.up6.ru/modules/database/classes/Kohana/Database/Query.php(251): Kohana_Database_MySQLi->query(1, 'SELECT COUNT(*)...', false, Array)
#1 /var/www/quadcats/data/www/hunland.up6.ru/application/classes/Controller/Index/Catalog.php(21): Kohana_Database_Query->execute(Object(Database_MySQLi))
#2 /var/www/quadcats/data/www/hunland.up6.ru/system/classes/Kohana/Controller.php(84): Controller_Index_Catalog->action_index()
#3 [internal function]: Kohana_Controller->execute()
#4 /var/www/quadcats/data/www/hunland.up6.ru/system/classes/Kohana/Request/Client/Internal.php(94): ReflectionMethod->invoke(Object(Controller_Index_Catalog))
#5 /var/www/quadcats/data/www/hunland.up6.ru/system/classes/Kohana/Request/Client.php(114): Kohana_Request_Client_Internal->execute_request(Object(Request), Object(Response))
#6 /var/www/quadcats/data/www/hunland.up6.ru/system/classes/Kohana/Request.php(1000): Kohana_Request_Client->execute(Object(Request))
#7 /var/www/quadcats/data/www/hunland.up6.ru/public/index.php(118): Kohana_Request->execute()
#8 {main} in /var/www/quadcats/data/www/hunland.up6.ru/modules/database/classes/Kohana/Database/Query.php:251
2022-03-03 18:16:58 --- EMERGENCY: ErrorException [ 8 ]: Undefined index: image ~ APPPATH/views/index/catalog/v_catalog_index.php [ 34 ] in /var/www/quadcats/data/www/hunland.up6.ru/application/views/index/catalog/v_catalog_index.php:34
2022-03-03 18:16:58 --- DEBUG: #0 /var/www/quadcats/data/www/hunland.up6.ru/application/views/index/catalog/v_catalog_index.php(34): Kohana_Core::error_handler(8, 'Undefined index...', '/var/www/quadca...', 34, Array)
#1 /var/www/quadcats/data/www/hunland.up6.ru/system/classes/Kohana/View.php(62): include('/var/www/quadca...')
#2 /var/www/quadcats/data/www/hunland.up6.ru/system/classes/Kohana/View.php(359): Kohana_View::capture('/var/www/quadca...', Array)
#3 /var/www/quadcats/data/www/hunland.up6.ru/system/classes/Kohana/View.php(236): Kohana_View->render()
#4 /var/www/quadcats/data/www/hunland.up6.ru/application/views/index/v_base.php(96): Kohana_View->__toString()
#5 /var/www/quadcats/data/www/hunland.up6.ru/system/classes/Kohana/View.php(62): include('/var/www/quadca...')
#6 /var/www/quadcats/data/www/hunland.up6.ru/system/classes/Kohana/View.php(359): Kohana_View::capture('/var/www/quadca...', Array)
#7 /var/www/quadcats/data/www/hunland.up6.ru/system/classes/Kohana/Controller/Template.php(44): Kohana_View->render()
#8 /var/www/quadcats/data/www/hunland.up6.ru/application/classes/Controller/Index.php(155): Kohana_Controller_Template->after()
#9 /var/www/quadcats/data/www/hunland.up6.ru/system/classes/Kohana/Controller.php(87): Controller_Index->after()
#10 [internal function]: Kohana_Controller->execute()
#11 /var/www/quadcats/data/www/hunland.up6.ru/system/classes/Kohana/Request/Client/Internal.php(94): ReflectionMethod->invoke(Object(Controller_Index_Catalog))
#12 /var/www/quadcats/data/www/hunland.up6.ru/system/classes/Kohana/Request/Client.php(114): Kohana_Request_Client_Internal->execute_request(Object(Request), Object(Response))
#13 /var/www/quadcats/data/www/hunland.up6.ru/system/classes/Kohana/Request.php(1000): Kohana_Request_Client->execute(Object(Request))
#14 /var/www/quadcats/data/www/hunland.up6.ru/public/index.php(118): Kohana_Request->execute()
#15 {main} in /var/www/quadcats/data/www/hunland.up6.ru/application/views/index/catalog/v_catalog_index.php:34
2022-03-03 18:23:06 --- EMERGENCY: Database_Exception [ 1064 ]: You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near 'GROUP BY c1.id ORDER BY c1.`sort_order` ASC, c1.id DESC,c1.created_at DESC LIMIT' at line 1 [ SELECT c1.id, c1.`created_at`, AVG(c_rat.`rating`) AS prat, c1.`title`, c1.alias, c2.name AS bname, c1.image_id AS main_img_id, c1.sq_image_id AS sqr_img_id, c4.filename AS main_image, c5.filename AS sqr_image, cpt.`category_id` AS pcid, c1.`advantages` FROM products AS c1 INNER JOIN `category_product` AS cpt ON cpt.`product_id` = c1.`id` AND cpt.`category_id` IN (-1,582,583,584,585,586,587,588,589,590) INNER JOIN `categories` AS cptt ON cptt.id = cpt.`category_id` LEFT JOIN `product_reviews` AS c_rat ON c_rat.`product_id` = c1.`id` AND c_rat.`status` = 1 LEFT JOIN images AS c4 ON c4.id = c1.image_id LEFT JOIN images AS c5 ON c5.id = c1.sq_image_id LEFT JOIN brands AS c2 ON c2.id = c1.brand_id WHERE c1.status = 1 AND  GROUP BY c1.id ORDER BY c1.`sort_order` ASC, c1.id DESC,c1.created_at DESC LIMIT 0,32 ] ~ MODPATH/database/classes/Kohana/Database/MySQLi.php [ 171 ] in /var/www/quadcats/data/www/hunland.up6.ru/modules/database/classes/Kohana/Database/Query.php:251
2022-03-03 18:23:06 --- DEBUG: #0 /var/www/quadcats/data/www/hunland.up6.ru/modules/database/classes/Kohana/Database/Query.php(251): Kohana_Database_MySQLi->query(1, 'SELECT c1.id, c...', false, Array)
#1 /var/www/quadcats/data/www/hunland.up6.ru/application/classes/Controller/Index/Catalog.php(27): Kohana_Database_Query->execute(Object(Database_MySQLi))
#2 /var/www/quadcats/data/www/hunland.up6.ru/system/classes/Kohana/Controller.php(84): Controller_Index_Catalog->action_index()
#3 [internal function]: Kohana_Controller->execute()
#4 /var/www/quadcats/data/www/hunland.up6.ru/system/classes/Kohana/Request/Client/Internal.php(94): ReflectionMethod->invoke(Object(Controller_Index_Catalog))
#5 /var/www/quadcats/data/www/hunland.up6.ru/system/classes/Kohana/Request/Client.php(114): Kohana_Request_Client_Internal->execute_request(Object(Request), Object(Response))
#6 /var/www/quadcats/data/www/hunland.up6.ru/system/classes/Kohana/Request.php(1000): Kohana_Request_Client->execute(Object(Request))
#7 /var/www/quadcats/data/www/hunland.up6.ru/public/index.php(118): Kohana_Request->execute()
#8 {main} in /var/www/quadcats/data/www/hunland.up6.ru/modules/database/classes/Kohana/Database/Query.php:251
2022-03-03 18:23:53 --- EMERGENCY: Database_Exception [ 1064 ]: You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near 'GROUP BY c1.id ORDER BY c1.`sort_order` ASC, c1.id DESC,c1.created_at DESC LIMIT' at line 1 [ SELECT c1.id, c1.`created_at`, AVG(c_rat.`rating`) AS prat, c1.`title`, c1.alias, c2.name AS bname, c1.image_id AS main_img_id, c1.sq_image_id AS sqr_img_id, c4.filename AS main_image, c5.filename AS sqr_image, MAX(cpt.`category_id`) AS pcid, c1.`advantages` FROM products AS c1 INNER JOIN `category_product` AS cpt ON cpt.`product_id` = c1.`id` AND cpt.`category_id` IN (-1,582,583,584,585,586,587,588,589,590) INNER JOIN `categories` AS cptt ON cptt.id = cpt.`category_id` LEFT JOIN `product_reviews` AS c_rat ON c_rat.`product_id` = c1.`id` AND c_rat.`status` = 1 LEFT JOIN images AS c4 ON c4.id = c1.image_id LEFT JOIN images AS c5 ON c5.id = c1.sq_image_id LEFT JOIN brands AS c2 ON c2.id = c1.brand_id WHERE c1.status = 1 AND  GROUP BY c1.id ORDER BY c1.`sort_order` ASC, c1.id DESC,c1.created_at DESC LIMIT 0,32 ] ~ MODPATH/database/classes/Kohana/Database/MySQLi.php [ 171 ] in /var/www/quadcats/data/www/hunland.up6.ru/modules/database/classes/Kohana/Database/Query.php:251
2022-03-03 18:23:53 --- DEBUG: #0 /var/www/quadcats/data/www/hunland.up6.ru/modules/database/classes/Kohana/Database/Query.php(251): Kohana_Database_MySQLi->query(1, 'SELECT c1.id, c...', false, Array)
#1 /var/www/quadcats/data/www/hunland.up6.ru/application/classes/Controller/Index/Catalog.php(27): Kohana_Database_Query->execute(Object(Database_MySQLi))
#2 /var/www/quadcats/data/www/hunland.up6.ru/system/classes/Kohana/Controller.php(84): Controller_Index_Catalog->action_index()
#3 [internal function]: Kohana_Controller->execute()
#4 /var/www/quadcats/data/www/hunland.up6.ru/system/classes/Kohana/Request/Client/Internal.php(94): ReflectionMethod->invoke(Object(Controller_Index_Catalog))
#5 /var/www/quadcats/data/www/hunland.up6.ru/system/classes/Kohana/Request/Client.php(114): Kohana_Request_Client_Internal->execute_request(Object(Request), Object(Response))
#6 /var/www/quadcats/data/www/hunland.up6.ru/system/classes/Kohana/Request.php(1000): Kohana_Request_Client->execute(Object(Request))
#7 /var/www/quadcats/data/www/hunland.up6.ru/public/index.php(118): Kohana_Request->execute()
#8 {main} in /var/www/quadcats/data/www/hunland.up6.ru/modules/database/classes/Kohana/Database/Query.php:251