2024-10-13 08:05:59 --- 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 '-12,12' at line 1 [ SELECT c1.id, c1.`recommended`, c1.`viewed`, c1.`region_id`, c1.`street_id`, c1.`created_at`, c1.`prod_square`,  (SELECT fpv1.`value_en` FROM `feature_product` AS fp1 LEFT JOIN `variants` AS fpv1 ON fpv1.`id` = fp1.`val` WHERE fp1.`product_id` = c1.`id` AND fp1.`feature_id` = 2 LIMIT 0,1) AS objtype,(SELECT fp2.`val` FROM `feature_product` AS fp2 WHERE fp2.`product_id` = c1.`id` AND fp2.`feature_id` = 25 LIMIT 0,1) AS objyear,(SELECT fp3.`val` FROM `feature_product` AS fp3 WHERE fp3.`product_id` = c1.`id` AND fp3.`feature_id` = 6 LIMIT 0,1) AS objbedrooms,(SELECT fp4.`val` FROM `feature_product` AS fp4 WHERE fp4.`product_id` = c1.`id` AND fp4.`feature_id` = 7 LIMIT 0,1) AS objbaths,(SELECT mcatn.`category_id` FROM `category_product` AS mcatn WHERE mcatn.`product_id` = c1.`id` LIMIT 0,1) AS mcat_id, c1.`price_gel`, c1.`price_usd`, AVG(c_rat.`rating`) AS prat, c1.`title_en` AS title, c1.`banner_text_en` AS banner_text, c1.`bannertext2_en` AS bannertext2, 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 FROM products AS c1 INNER JOIN `category_product` AS cpt ON cpt.`product_id` = c1.`id` AND cpt.`category_id` IN (-1,582,583,591) 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 INNER JOIN category_product AS c6 ON c6.product_id = c1.id AND c6.category_id = 583 WHERE c1.status = 1 GROUP BY c1.id ORDER BY c1.`sort_order` ASC, c1.id DESC,c1.created_at DESC LIMIT -12,12 ] ~ MODPATH/database/classes/Kohana/Database/MySQLi.php [ 171 ] in /var/www/batumihome/data/www/batumihome.ge/modules/database/classes/Kohana/Database/Query.php:251
2024-10-13 08:05:59 --- DEBUG: #0 /var/www/batumihome/data/www/batumihome.ge/modules/database/classes/Kohana/Database/Query.php(251): Kohana_Database_MySQLi->query(1, 'SELECT c1.id, c...', false, Array)
#1 /var/www/batumihome/data/www/batumihome.ge/application/classes/Controller/Index/Catalog.php(254): Kohana_Database_Query->execute()
#2 /var/www/batumihome/data/www/batumihome.ge/system/classes/Kohana/Controller.php(84): Controller_Index_Catalog->action_category()
#3 [internal function]: Kohana_Controller->execute()
#4 /var/www/batumihome/data/www/batumihome.ge/system/classes/Kohana/Request/Client/Internal.php(94): ReflectionMethod->invoke(Object(Controller_Index_Catalog))
#5 /var/www/batumihome/data/www/batumihome.ge/system/classes/Kohana/Request/Client.php(114): Kohana_Request_Client_Internal->execute_request(Object(Request), Object(Response))
#6 /var/www/batumihome/data/www/batumihome.ge/system/classes/Kohana/Request.php(1000): Kohana_Request_Client->execute(Object(Request))
#7 /var/www/batumihome/data/www/batumihome.ge/public/index.php(120): Kohana_Request->execute()
#8 {main} in /var/www/batumihome/data/www/batumihome.ge/modules/database/classes/Kohana/Database/Query.php:251
2024-10-13 11:19:50 --- 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 '-12,12' at line 1 [ SELECT c1.id, c1.`recommended`, c1.`viewed`, c1.`region_id`, c1.`street_id`, c1.`created_at`, c1.`prod_square`,  (SELECT fpv1.`value_en` FROM `feature_product` AS fp1 LEFT JOIN `variants` AS fpv1 ON fpv1.`id` = fp1.`val` WHERE fp1.`product_id` = c1.`id` AND fp1.`feature_id` = 2 LIMIT 0,1) AS objtype,(SELECT fp2.`val` FROM `feature_product` AS fp2 WHERE fp2.`product_id` = c1.`id` AND fp2.`feature_id` = 25 LIMIT 0,1) AS objyear,(SELECT fp3.`val` FROM `feature_product` AS fp3 WHERE fp3.`product_id` = c1.`id` AND fp3.`feature_id` = 6 LIMIT 0,1) AS objbedrooms,(SELECT fp4.`val` FROM `feature_product` AS fp4 WHERE fp4.`product_id` = c1.`id` AND fp4.`feature_id` = 7 LIMIT 0,1) AS objbaths,(SELECT mcatn.`category_id` FROM `category_product` AS mcatn WHERE mcatn.`product_id` = c1.`id` LIMIT 0,1) AS mcat_id, c1.`price_gel`, c1.`price_usd`, AVG(c_rat.`rating`) AS prat, c1.`title_en` AS title, c1.`banner_text_en` AS banner_text, c1.`bannertext2_en` AS bannertext2, 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 FROM products AS c1 INNER JOIN `category_product` AS cpt ON cpt.`product_id` = c1.`id` AND cpt.`category_id` IN (-1,582,583,591) 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 ORDER BY c1.`sort_order` ASC, c1.id DESC,c1.created_at DESC LIMIT -12,12 ] ~ MODPATH/database/classes/Kohana/Database/MySQLi.php [ 171 ] in /var/www/batumihome/data/www/batumihome.ge/modules/database/classes/Kohana/Database/Query.php:251
2024-10-13 11:19:50 --- DEBUG: #0 /var/www/batumihome/data/www/batumihome.ge/modules/database/classes/Kohana/Database/Query.php(251): Kohana_Database_MySQLi->query(1, 'SELECT c1.id, c...', false, Array)
#1 /var/www/batumihome/data/www/batumihome.ge/application/classes/Controller/Index/Catalog.php(27): Kohana_Database_Query->execute()
#2 /var/www/batumihome/data/www/batumihome.ge/system/classes/Kohana/Controller.php(84): Controller_Index_Catalog->action_index()
#3 [internal function]: Kohana_Controller->execute()
#4 /var/www/batumihome/data/www/batumihome.ge/system/classes/Kohana/Request/Client/Internal.php(94): ReflectionMethod->invoke(Object(Controller_Index_Catalog))
#5 /var/www/batumihome/data/www/batumihome.ge/system/classes/Kohana/Request/Client.php(114): Kohana_Request_Client_Internal->execute_request(Object(Request), Object(Response))
#6 /var/www/batumihome/data/www/batumihome.ge/system/classes/Kohana/Request.php(1000): Kohana_Request_Client->execute(Object(Request))
#7 /var/www/batumihome/data/www/batumihome.ge/public/index.php(120): Kohana_Request->execute()
#8 {main} in /var/www/batumihome/data/www/batumihome.ge/modules/database/classes/Kohana/Database/Query.php:251
2024-10-13 14:22:17 --- EMERGENCY: ErrorException [ 8 ]: Undefined index: HTTP_HOST ~ APPPATH/config/settings.php [ 9 ] in /var/www/batumihome/data/www/batumihome.ge/application/config/settings.php:9
2024-10-13 14:22:17 --- DEBUG: #0 /var/www/batumihome/data/www/batumihome.ge/application/config/settings.php(9): Kohana_Core::error_handler(8, 'Undefined index...', '/var/www/batumi...', 9, Array)
#1 /var/www/batumihome/data/www/batumihome.ge/system/classes/Kohana/Core.php(748): include('/var/www/batumi...')
#2 /var/www/batumihome/data/www/batumihome.ge/system/classes/Kohana/Config/File/Reader.php(49): Kohana_Core::load('/var/www/batumi...')
#3 /var/www/batumihome/data/www/batumihome.ge/system/classes/Kohana/Config.php(130): Kohana_Config_File_Reader->load('settings')
#4 /var/www/batumihome/data/www/batumihome.ge/application/classes/Controller/Base.php(17): Kohana_Config->load('settings')
#5 /var/www/batumihome/data/www/batumihome.ge/application/classes/Controller/Index.php(34): Controller_Base->before()
#6 /var/www/batumihome/data/www/batumihome.ge/system/classes/Kohana/Controller.php(69): Controller_Index->before()
#7 [internal function]: Kohana_Controller->execute()
#8 /var/www/batumihome/data/www/batumihome.ge/system/classes/Kohana/Request/Client/Internal.php(94): ReflectionMethod->invoke(Object(Controller_Index_Main))
#9 /var/www/batumihome/data/www/batumihome.ge/system/classes/Kohana/Request/Client.php(114): Kohana_Request_Client_Internal->execute_request(Object(Request), Object(Response))
#10 /var/www/batumihome/data/www/batumihome.ge/system/classes/Kohana/Request.php(1000): Kohana_Request_Client->execute(Object(Request))
#11 /var/www/batumihome/data/www/batumihome.ge/public/index.php(120): Kohana_Request->execute()
#12 {main} in /var/www/batumihome/data/www/batumihome.ge/application/config/settings.php:9