Warning (512): SQL Error: 1064: You have an error in your SQL syntax; check the manual that corresponds to your MariaDB server version for the right syntax to use near 'THEN 0 ELSE 1 END) ASC, `Product`.`product_priority` ASC' at line 1 [CORE/cake/libs/model/datasources/dbo_source.php, line 684]Code | Context$out = null;if ($error) {trigger_error('<span style="color:Red;text-align:left"><b>' . __('SQL Error:', true) . "</b> {$this->error}</span>", E_USER_WARNING);$sql = "SELECT `Product`.`product_id`, `Product`.`parent_id`, `Product`.`product_title`, `Product`.`slug`, `Product`.`short_name`, `Product`.`short_description`, `Product`.`product_logo`, `Product`.`product_image`, `Product`.`product_large_image`, `Product`.`product_desc`, `Product`.`product_spec`, `Product`.`product_priority`, `Product`.`product_status`, `Product`.`featured`, `Product`.`product_banner_image`, `Product`.`product_category_id`, `Product`.`product_spec_two` FROM `products` AS `Product` WHERE ((`Product`.`product_id` IS NULL) OR (`Product`.`parent_id` IS NULL)) AND `Product`.`product_status` = '1' ORDER BY (CASE WHEN `Product`.`product_id` = THEN 0 ELSE 1 END) ASC, `Product`.`product_priority` ASC " $error = "1064: You have an error in your SQL syntax; check the manual that corresponds to your MariaDB server version for the right syntax to use near 'THEN 0 ELSE 1 END) ASC, `Product`.`product_priority` ASC' at line 1" $out = nullDboSource::showQuery() - CORE/cake/libs/model/datasources/dbo_source.php, line 684 DboSource::execute() - CORE/cake/libs/model/datasources/dbo_source.php, line 266 DboSource::fetchAll() - CORE/cake/libs/model/datasources/dbo_source.php, line 410 DboSource::read() - CORE/cake/libs/model/datasources/dbo_source.php, line 823 Model::find() - CORE/cake/libs/model/model.php, line 2127 ProductController::details() - APP/controllers/product_controller.php, line 320 Dispatcher::_invoke() - CORE/cake/dispatcher.php, line 204 Dispatcher::dispatch() - CORE/cake/dispatcher.php, line 171 [main] - APP/webroot/index.php, line 83
Query: SELECT `Product`.`product_id`, `Product`.`parent_id`, `Product`.`product_title`, `Product`.`slug`, `Product`.`short_name`, `Product`.`short_description`, `Product`.`product_logo`, `Product`.`product_image`, `Product`.`product_large_image`, `Product`.`product_desc`, `Product`.`product_spec`, `Product`.`product_priority`, `Product`.`product_status`, `Product`.`featured`, `Product`.`product_banner_image`, `Product`.`product_category_id`, `Product`.`product_spec_two` FROM `products` AS `Product` WHERE ((`Product`.`product_id` IS NULL) OR (`Product`.`parent_id` IS NULL)) AND `Product`.`product_status` = '1' ORDER BY (CASE WHEN `Product`.`product_id` = THEN 0 ELSE 1 END) ASC, `Product`.`product_priority` ASC
Warning (2): Invalid argument supplied for foreach() [APP/views/products/details.ctp, line 11]Code | Context<label>Variant:</label><!-- <button class="variant-btn active"><?php echo $data['Product']['short_name'];?></button> --><?php foreach($varients as $varient){ ?>$___viewFn = "/var/www/kamcoindia.tedsys.in/app/views/products/details.ctp" $___dataForView = array( "home_content" => array( "Links" => array() ), "Settings" => array( "Settings" => array() ), "faqs" => array( array(), array(), array(), array(), array(), array(), array(), array(), array(), array() ), "units" => array(), "newproduct" => array( "Product" => array() ), "testimonials" => array( array(), array(), array() ), "Videogallery" => array( array(), array(), array(), array(), array(), array(), array(), array() ), "Photogallery" => array( array(), array(), array(), array(), array(), array(), array(), array() ), "banner" => array( "Banner" => array() ), "tenders" => array(), "news" => array( array(), array(), array() ), "product" => array( array(), array(), array(), array(), array() ), "product_category" => array( array(), array(), array(), array(), array(), array() ), "getAllRights" => array( "" ), "SessionUserName" => null, "SessionUserId" => null, "linksdetails" => "", "pro_data" => array(), "cat_data" => false, "product_images" => array(), "varients" => false, "data" => false, "slug" => "tw", "content" => array( "Links" => array() ) ) $loadHelpers = true $cached = false $text = TextHelper TextHelper::$helpers = NULL TextHelper::$base = "" TextHelper::$webroot = "/" TextHelper::$theme = NULL TextHelper::$here = "/product/details/tw" TextHelper::$params = array TextHelper::$action = "details" TextHelper::$plugin = NULL TextHelper::$data = NULL TextHelper::$namedArgs = NULL TextHelper::$argSeparator = NULL TextHelper::$validationErrors = NULL TextHelper::$tags = array TextHelper::$__tainted = NULL TextHelper::$__cleaned = NULL $javascript = JavascriptHelper JavascriptHelper::$useNative = true JavascriptHelper::$enabled = true JavascriptHelper::$safe = false JavascriptHelper::$tags = array JavascriptHelper::$_blockOptions = array JavascriptHelper::$_cachedEvents = array JavascriptHelper::$_cacheEvents = false JavascriptHelper::$_cacheToFile = false JavascriptHelper::$_cacheAll = false JavascriptHelper::$_rules = array JavascriptHelper::$__scriptBuffer = NULL JavascriptHelper::$helpers = NULL JavascriptHelper::$base = "" JavascriptHelper::$webroot = "/" JavascriptHelper::$theme = NULL JavascriptHelper::$here = "/product/details/tw" JavascriptHelper::$params = array JavascriptHelper::$action = "details" JavascriptHelper::$plugin = NULL JavascriptHelper::$data = NULL JavascriptHelper::$namedArgs = NULL JavascriptHelper::$argSeparator = NULL JavascriptHelper::$validationErrors = NULL JavascriptHelper::$__tainted = NULL JavascriptHelper::$__cleaned = NULL $ajax = AjaxHelper AjaxHelper::$helpers = array AjaxHelper::$Html = HtmlHelper object AjaxHelper::$Javascript = JavascriptHelper object AjaxHelper::$callbacks = array AjaxHelper::$ajaxOptions = array AjaxHelper::$dragOptions = array AjaxHelper::$dropOptions = array AjaxHelper::$sortOptions = array AjaxHelper::$sliderOptions = array AjaxHelper::$editorOptions = array AjaxHelper::$autoCompleteOptions = array AjaxHelper::$__ajaxBuffer = array AjaxHelper::$base = "" AjaxHelper::$webroot = "/" AjaxHelper::$theme = NULL AjaxHelper::$here = "/product/details/tw" AjaxHelper::$params = array AjaxHelper::$action = "details" AjaxHelper::$plugin = NULL AjaxHelper::$data = NULL AjaxHelper::$namedArgs = NULL AjaxHelper::$argSeparator = NULL AjaxHelper::$validationErrors = NULL AjaxHelper::$tags = array AjaxHelper::$__tainted = NULL AjaxHelper::$__cleaned = NULL AjaxHelper::$Form = FormHelper object $pagination = PaginationHelper PaginationHelper::$ajaxLinkOptions = array PaginationHelper::$style = "html" PaginationHelper::$paramStyle = "get" PaginationHelper::$_pageDetails = array PaginationHelper::$helpers = array PaginationHelper::$base = "" PaginationHelper::$webroot = "/" PaginationHelper::$theme = NULL PaginationHelper::$here = "/product/details/tw" PaginationHelper::$params = array PaginationHelper::$action = "details" PaginationHelper::$plugin = NULL PaginationHelper::$data = NULL PaginationHelper::$namedArgs = NULL PaginationHelper::$argSeparator = NULL PaginationHelper::$validationErrors = NULL PaginationHelper::$tags = array PaginationHelper::$__tainted = NULL PaginationHelper::$__cleaned = NULL PaginationHelper::$Html = HtmlHelper object PaginationHelper::$Ajax = AjaxHelper object $form = FormHelper FormHelper::$helpers = array FormHelper::$fieldset = array FormHelper::$__options = array FormHelper::$fields = array FormHelper::$requestType = NULL FormHelper::$defaultModel = NULL FormHelper::$_inputDefaults = array FormHelper::$base = "" FormHelper::$webroot = "/" FormHelper::$theme = NULL FormHelper::$here = "/product/details/tw" FormHelper::$params = array FormHelper::$action = "details" FormHelper::$plugin = NULL FormHelper::$data = NULL FormHelper::$namedArgs = NULL FormHelper::$argSeparator = NULL FormHelper::$validationErrors = NULL FormHelper::$tags = array FormHelper::$__tainted = NULL FormHelper::$__cleaned = NULL FormHelper::$Html = HtmlHelper object $html = HtmlHelper HtmlHelper::$tags = array HtmlHelper::$_crumbs = array HtmlHelper::$__includedScripts = array HtmlHelper::$_scriptBlockOptions = array HtmlHelper::$__docTypes = array HtmlHelper::$helpers = NULL HtmlHelper::$base = "" HtmlHelper::$webroot = "/" HtmlHelper::$theme = NULL HtmlHelper::$here = "/product/details/tw" HtmlHelper::$params = array HtmlHelper::$action = "details" HtmlHelper::$plugin = NULL HtmlHelper::$data = NULL HtmlHelper::$namedArgs = NULL HtmlHelper::$argSeparator = NULL HtmlHelper::$validationErrors = NULL HtmlHelper::$__tainted = NULL HtmlHelper::$__cleaned = NULL $session = SessionHelper SessionHelper::$helpers = array SessionHelper::$__active = true SessionHelper::$valid = false SessionHelper::$error = false SessionHelper::$_userAgent = "7a9ab50e96bd155e50a631d6a0f2f95f" SessionHelper::$path = "/" SessionHelper::$lastError = NULL SessionHelper::$security = "medium" SessionHelper::$time = 1778924891 SessionHelper::$sessionTime = 1778936891 SessionHelper::$cookieLifeTime = false SessionHelper::$watchKeys = array SessionHelper::$id = NULL SessionHelper::$host = NULL SessionHelper::$timeout = NULL SessionHelper::$base = "" SessionHelper::$webroot = "/" SessionHelper::$here = "/product/details/tw" SessionHelper::$params = array SessionHelper::$action = "details" SessionHelper::$data = NULL SessionHelper::$theme = NULL SessionHelper::$plugin = NULL $home_content = array( "Links" => array( "id" => "1", "parent_id" => "0", "text" => "Home", "title_image" => "Title_1.jpg", "image" => "Links_1.png", "title" => "", "keywords" => "Home", "description" => "", "link_url" => "", "priority" => "1", "status" => "1", "page" => "Y", "has_children" => "0", "content" => "<p>KAMCO was started to cater to the needs of small and marginal farmers. The products cater specifically to this segment and helps small farmers to enjoy mechanized farming. The Quality Standards for each and every product has been tested and certified by competent authorities. The global standards and system maintained has earned KAMCO ISO 9001 certification.</p>", "url" => "home", "lft" => null, "rght" => null, "rightside_content" => "Home", "navigation" => "1", "last_updated" => "2025-11-29" ) ) $Settings = array( "Settings" => array( "id" => "1", "company" => "Kerala Agro Machinery Corporation Limited", "address" => "Regd. Office: Athani - 683 585, Ernakulam Dist., Kerala State. ", "phone" => "91-484-2474301 (5lines), 9400865666", "email" => "mail@kamcoindia.com", "facebook" => "https://www.facebook.com/kamcoindia", "twitter" => "tw", "instagram" => "https://www.instagram.com/kamcoindiaofficial/", "youtube" => "https://www.youtube.com/channel/UCh7eaVTY8Z85h7ml_TO9wbA", "happy_farmers" => "100", "years_of_experience" => "50", "dealers_acreoss_country" => "80", "skilled_man_power" => "900", "footer_note" => "KAMCO was started way back in 1973 to aid farmers in their quest for higher productivity, more prosperity and greater happiness in their lives.", "sale_order_pattern" => "ABCD", "sale_order_starting_from" => "1500", "payment_terms" => "<p>test payment terms </p> <p>test payment terms 2</p> <ul> <li>point 1</li> <li>point 2</li> </ul> ", "about_kamco" => "KAMCO, a name synonymous with agricultural excellence, has been at the forefront of revolutionizing farming practices for decades. With a steadfast commitment to innovation and quality, we've consistently delivered cutting-edge solutions that empower farmers to achieve higher yields and greater efficiency.From our humble beginnings to becoming a global leader, KAMCO has always been driven by a passion for agriculture and a dedication to our customers. Our unwavering focus on research and development has led to the creation of a diverse range of products, including tractors, tillers, reapers, and more.", "vision" => "To provide sustainable and affordable farming solutions through agricultural mechanization.", "mission" => "Deliver total farming solutions by sourcing and developing the latest technologies to boost agricultural production across our nation.", "training" => "KAMCO organizes training programs to educate farmers on modern mechanized farming practices and efficient equipment usage.", "quality_policy" => "KAMCO ensures customer satisfaction through quality products and services, adopting improved technology and team participation. Certified under ISO 9001:2015, we deliver reliable, globally trusted agricultural solutions.", "leadership_description" => "As a state-owned leader, KAMCO champions mechanized farming, empowering small-scale farmers with reliable machinery.", "revolution" => "Our ISO-certified machinery blends technology and quality to achieve higher productivity, efficiency, and sustainability in agriculture." ) ) $faqs = array( array( "Faq" => array() ), array( "Faq" => array() ), array( "Faq" => array() ), array( "Faq" => array() ), array( "Faq" => array() ), array( "Faq" => array() ), array( "Faq" => array() ), array( "Faq" => array() ), array( "Faq" => array() ), array( "Faq" => array() ) ) $units = array() $newproduct = array( "Product" => array( "product_id" => "33", "parent_id" => "0", "product_title" => "DRONE", "slug" => "fia-qd10", "short_name" => "FIA QD10", "short_description" => "KAMCO Fuselage Agriculture Drone FIA QD10 is a Quadcopter with Tank Capacity of 10 Ltr. The total payload capacity of the machine is below 25Kg and belongs to the Small Category. The Flight distance is 1 Km radius and the flying height is limited to 50 feet. The frame material is Aircraft Aluminum and the energy source is 2 Nos of 16000mAh LiFePO4 Battery. The flight time is 25 Minutes in single charging and can cover 1 Acre in just 7 Minutes. This machine is suitable for spraying liquid / water soluble Chemicals, Fertilizers, Pesticides etc.", "product_logo" => "Pro_Ico_33.png", "product_image" => "Product_33.png", "product_large_image" => "Product_large_img_33.png", "product_desc" => "<ul> <li>Modern Technology Developed and Manufactured in India</li> <li>Designed for Spraying Fertilizers and Pesticides in the Most Efficient and Economical Way</li> <li>Ensuring Even Distribution of Plant Nutrients</li> <li>Environment Friendly</li> <li>Ensuring the Most Efficient Way for Plant Protection</li> <li>Ease in Operation and Handling</li> </ul> ", "product_spec" => "<ul> <li>Flight Time<br /> <strong>25 Minutes</strong></li> <li>Payload<br /> <strong>10 Liters</strong></li> <li>Weight<br /> <strong>25 Kg</strong></li> <li>Category<br /> <strong>Small</strong></li> <li>Power<br /> <strong>4 KW</strong></li> <li>Diagonal Wheelbase<br /> <strong>2140 mm</strong></li> <li>Dimensions (Folded)<br /> <strong>655*515*630 mm</strong></li> <li>Dimensions (Unfolded)<br /> <strong>1695*1795*630 mm</strong></li> <li>Type<br /> <strong>Multirotor</strong></li> <li>Configuration<br /> <strong>Quadcopter</strong></li> <li>Maximum Altitude<br /> <strong>50 feet</strong></li> <li>Tank Volume<br /> <strong>10 Litre</strong></li> <li>Tank Weight<br /> <strong>0.9 kg</strong></li> <li>Pressure Nozzle<br /> <strong>Single nozzle * 4</strong></li> <li>Pump Flow<br /> <strong>8L/Minute</strong></li> <li>Working Voltage<br /> <strong>44.4 V</strong></li> <li>Spraying Width<br /> <strong>4-6 m</strong></li> <li>Battery Voltage<br /> <strong>44.4V (12S)</strong></li> <li>Battery Capacity<br /> <strong>16000 mAh</strong></li> <li>Battery Weight<br /> <strong>3.6 kg</strong></li> <li>Battery Size<br /> <strong>170*110*236 mm</strong></li> <li>Charging Plug<br /> <strong>XT90 socket</strong></li> <li>Magnifying Power<br /> <strong>25C</strong></li> <li>Remote Weight<br /> <strong>490g (Tx), 26g (Rx), 15.6g (Camera)</strong></li> <li>Remote Channel<br /> <strong>12</strong></li> <li>Remote Battery Capacity<br /> <strong>4000 mAh</strong></li> <li>Remote Endurance<br /> <strong>25 hours</strong></li> <li>Remote Frequency<br /> <strong>2.400GHz-2.4833GHz</strong></li> <li>Communication<br /> <strong>FHSS</strong></li> <li>Distance<br /> <strong>500 meters (Video/Data)</strong></li> <li>Stator Size<br /> <strong>100*10 mm</strong></li> <li>KV Data<br /> <strong>100 rpm/v</strong></li> <li>Pull Force<br /> <strong>13.5 kg/rotor</strong></li> <li>Type of Rotor<br /> <strong>BLDC</strong></li> <li>Number of Rotors<br /> <strong>4</strong></li> <li>Propeller Diameter * Pitch<br /> <strong>30*9 inch</strong></li> <li>Propeller Weight<br /> <strong>90 g</strong></li> <li>Maximum Current<br /> <strong>100A</strong></li> <li>Maximum Voltage<br /> <strong>44.4V (12S LiPo)</strong></li> <li>Hovering Accuracy<br /> <strong>±1m in a horizontal direction</strong></li> <li>Max Yaw Speed<br /> <strong>150°/s</strong></li> <li>Max Vertical Speed<br /> <strong>6 m/s</strong></li> <li>Temperature Range<br /> <strong>-10°C to 60°C</strong></li> <li>Collision Avoidance System<br /> <strong>Optional</strong></li> <li>Mini Camera Resolution<br /> <strong>720P @ 30fps</strong></li> <li>Mini Camera Size<br /> <strong>30.2 x 29.8 x 26.8 mm</strong></li> <li>Mini Camera Voltage<br /> <strong>5V</strong></li> <li>Mini Camera Temperature Range<br /> <strong>-10°C to +40°C</strong></li> <li>Charger Input Voltage<br /> <strong>100-240V</strong></li> <li>Charger Output Power<br /> <strong>1080W (540W x 2)</strong></li> <li>Charger Discharging Power<br /> <strong>50W x 2</strong></li> <li>Charger Charging Range<br /> <strong>1.0-20.0A x 2</strong></li> <li>Charger Balance Current<br /> <strong>1.2A Max</strong></li> <li>Battery Type<br /> <strong>LiPo/LIHV</strong></li> <li>Battery Cell Count<br /> <strong>6S x 2</strong></li> <li>Charging Modes<br /> <strong>Fast Charge/Balance Charge/Storage</strong></li> <li>Charger Size<br /> <strong>272 x 202 x 118.6 mm</strong></li> </ul> ", "product_priority" => "0", "product_status" => "1", "featured" => "1", "product_banner_image" => "Product_banner_33.png", "product_category_id" => "8", "product_spec_two" => "<p>Drone is now available for international delivery. With a powerful engine, versatile implements, and a user-friendly design, it’s the perfect tool to boost agricultural productivity. Order now to enhance your farming operations.</p> " ) ) $testimonials = array( array( "Testimonial" => array() ), array( "Testimonial" => array() ), array( "Testimonial" => array() ) ) $Videogallery = array( array( "Videogallery" => array() ), array( "Videogallery" => array() ), array( "Videogallery" => array() ), array( "Videogallery" => array() ), array( "Videogallery" => array() ), array( "Videogallery" => array() ), array( "Videogallery" => array() ), array( "Videogallery" => array() ) ) $Photogallery = array( array( "Photogallery" => array() ), array( "Photogallery" => array() ), array( "Photogallery" => array() ), array( "Photogallery" => array() ), array( "Photogallery" => array() ), array( "Photogallery" => array() ), array( "Photogallery" => array() ), array( "Photogallery" => array() ) ) $banner = array( "Banner" => array( "banner_id" => "32", "banner_title" => "video1", "banner_title2" => "video2", "banner_type" => "", "banner_image" => "banner_image_32.", "banner_url" => "http://kamcoindia.tedsys.in/", "status" => "1", "banner_product_image" => "banner_product_image_32.", "priority" => "1", "video_file" => "video_file_32.mp4" ) ) $tenders = array() $news = array( array( "News" => array() ), array( "News" => array() ), array( "News" => array() ) ) $product = array( array( "Product" => array() ), array( "Product" => array() ), array( "Product" => array() ), array( "Product" => array() ), array( "Product" => array() ) ) $product_category = array( array( "ProductCategory" => array() ), array( "ProductCategory" => array() ), array( "ProductCategory" => array() ), array( "ProductCategory" => array() ), array( "ProductCategory" => array() ), array( "ProductCategory" => array() ) ) $getAllRights = array( "" ) $SessionUserName = null $SessionUserId = null $linksdetails = "" $pro_data = array() $cat_data = false $product_images = array() $varients = false $data = false $slug = "tw" $content = array( "Links" => array( "id" => "3", "parent_id" => "0", "text" => "Products", "title_image" => "Title_3.jpg", "image" => "", "title" => "Products", "keywords" => "Products", "description" => "Products", "link_url" => "", "priority" => "3", "status" => "1", "page" => "Y", "has_children" => "0", "content" => "", "url" => "product", "lft" => null, "rght" => null, "rightside_content" => "Products", "navigation" => "1", "last_updated" => "2025-11-29" ) )include - APP/views/products/details.ctp, line 11 View::_render() - CORE/cake/libs/view/view.php, line 731 View::render() - CORE/cake/libs/view/view.php, line 426 Controller::render() - CORE/cake/libs/controller/controller.php, line 909 Dispatcher::_invoke() - CORE/cake/dispatcher.php, line 207 Dispatcher::dispatch() - CORE/cake/dispatcher.php, line 171 [main] - APP/webroot/index.php, line 83