#0  clDbPdo->query(SELECT COUNT(DISTINCT(entProductTemplate.templateId)) FROM entProductTemplate LEFT JOIN entProduct ON entProductTemplate.templateProductId = entProduct.productId LEFT JOIN entProductToRoute ON entProductTemplate.templateId = entProductToRoute.parentId LEFT JOIN entRoute ON entProductToRoute.routeId = entRoute.routeId AND entProductToRoute.parentType = 'productTemplate' LEFT JOIN entProductTemplateToCategory ON entProductTemplate.templateId = entProductTemplateToCategory.templateId LEFT JOIN entProductText AS text1 ON entProductTemplate.templateTitleTextId = text1.textId AND text1.textLangId = 2 LEFT JOIN entProductText AS text2 ON entProductTemplate.templateShortDescriptionTextId = text2.textId AND text2.textLangId = 2 WHERE entRoute.routePathLangId = 2 AND entProductTemplateToCategory.categoryId IN() AND entProductTemplate.templateStatus = 'active' AND entProduct.productStatus = 'active') called at [/home/httpd/inonestore/inonestore.se/platform/core/clDaoBaseSql.php:517]
#1  clDaoBaseSql->readEntriesTotal(Array ([fields] => Array ([0] => DISTINCT(entProductTemplate.templateId),[1] => templateProductId,[templateTitleTextId] => text1.textContent,[templateShortDescriptionTextId] => text2.textContent,[2] => templateDefaultPriceSet,[3] => productPrice,[4] => productQuantity,[5] => productVat,[6] => productPriceRecommended,[7] => productDiscount,[8] => productDeliveryTime,[9] => routePath,[categoryId] => entProductTemplateToCategory.categoryId),[entities] => Array ([0] => entProductTemplate,[1] => entProduct,[2] => entProductToRoute,[3] => entRoute,[4] => entProductCategory,[5] => entProductText),[entitiesExtended] => entProductTemplate LEFT JOIN entProduct ON entProductTemplate.templateProductId = entProduct.productId LEFT JOIN entProductToRoute ON entProductTemplate.templateId = entProductToRoute.parentId LEFT JOIN entRoute ON entProductToRoute.routeId = entRoute.routeId AND entProductToRoute.parentType = 'productTemplate' LEFT JOIN entProductTemplateToCategory ON entProductTemplate.templateId = entProductTemplateToCategory.templateId LEFT JOIN entProductText AS text1 ON entProductTemplate.templateTitleTextId = text1.textId AND text1.textLangId = 2 LEFT JOIN entProductText AS text2 ON entProductTemplate.templateShortDescriptionTextId = text2.textId AND text2.textLangId = 2,[groupBy] => entProductTemplate.templateId,[criterias] => entRoute.routePathLangId = 2 AND entProductTemplateToCategory.categoryId IN() AND entProductTemplate.templateStatus = 'active' AND entProduct.productStatus = 'active',[withHelpers] => 1,[count] => 1,[countField] => ,[entries] => ,[sorting] => )) called at [/home/httpd/inonestore/inonestore.se/platform/core/clDaoBaseSql.php:431]
#2  clDaoBaseSql->readData(Array ([fields] => Array ([0] => DISTINCT(entProductTemplate.templateId),[1] => templateProductId,[templateTitleTextId] => text1.textContent,[templateShortDescriptionTextId] => text2.textContent,[2] => templateDefaultPriceSet,[3] => productPrice,[4] => productQuantity,[5] => productVat,[6] => productPriceRecommended,[7] => productDiscount,[8] => productDeliveryTime,[9] => routePath,[categoryId] => entProductTemplateToCategory.categoryId),[entities] => Array ([0] => entProductTemplate,[1] => entProduct,[2] => entProductToRoute,[3] => entRoute,[4] => entProductCategory,[5] => entProductText),[entitiesExtended] => entProductTemplate LEFT JOIN entProduct ON entProductTemplate.templateProductId = entProduct.productId LEFT JOIN entProductToRoute ON entProductTemplate.templateId = entProductToRoute.parentId LEFT JOIN entRoute ON entProductToRoute.routeId = entRoute.routeId AND entProductToRoute.parentType = 'productTemplate' LEFT JOIN entProductTemplateToCategory ON entProductTemplate.templateId = entProductTemplateToCategory.templateId LEFT JOIN entProductText AS text1 ON entProductTemplate.templateTitleTextId = text1.textId AND text1.textLangId = 2 LEFT JOIN entProductText AS text2 ON entProductTemplate.templateShortDescriptionTextId = text2.textId AND text2.textLangId = 2,[groupBy] => entProductTemplate.templateId,[criterias] => entRoute.routePathLangId = 2 AND entProductTemplateToCategory.categoryId IN() AND entProductTemplate.templateStatus = 'active' AND entProduct.productStatus = 'active')) called at [/home/httpd/inonestore/inonestore.se/platform/core/clTextDaoBaseSql.php:195]
#3  clTextDaoBaseSql->readData(Array ([fields] => Array ([0] => DISTINCT(entProductTemplate.templateId),[1] => templateProductId,[templateTitleTextId] => templateTitleTextId,[templateShortDescriptionTextId] => templateShortDescriptionTextId,[2] => templateDefaultPriceSet,[3] => productPrice,[4] => productQuantity,[5] => productVat,[6] => productPriceRecommended,[7] => productDiscount,[8] => productDeliveryTime,[9] => routePath,[categoryId] => entProductTemplateToCategory.categoryId),[entities] => Array ([0] => entProductTemplate,[1] => entProduct,[2] => entProductToRoute,[3] => entRoute,[4] => entProductCategory),[entitiesExtended] => entProductTemplate LEFT JOIN entProduct ON entProductTemplate.templateProductId = entProduct.productId LEFT JOIN entProductToRoute ON entProductTemplate.templateId = entProductToRoute.parentId LEFT JOIN entRoute ON entProductToRoute.routeId = entRoute.routeId AND entProductToRoute.parentType = 'productTemplate' LEFT JOIN entProductTemplateToCategory ON entProductTemplate.templateId = entProductTemplateToCategory.templateId,[groupBy] => entProductTemplate.templateId,[criterias] => entRoute.routePathLangId = 2 AND entProductTemplateToCategory.categoryId IN() AND entProductTemplate.templateStatus = 'active' AND entProduct.productStatus = 'active')) called at [/home/httpd/inonestore/inonestore.se/platform/modules/product/models/clProductTemplateDaoMysql.php:275]
#4  clProductTemplateDaoMysql->read(Array ([fields] => Array ([0] => DISTINCT(entProductTemplate.templateId),[1] => templateProductId,[templateTitleTextId] => templateTitleTextId,[templateShortDescriptionTextId] => templateShortDescriptionTextId,[2] => templateDefaultPriceSet,[3] => productPrice,[4] => productQuantity,[5] => productVat,[6] => productPriceRecommended,[7] => productDiscount,[8] => productDeliveryTime,[9] => routePath,[categoryId] => entProductTemplateToCategory.categoryId),[categoryId] => Array (),[search] => )) called at [/home/httpd/inonestore/inonestore.se/platform/modules/product/models/clProductTemplate.php:88]
#5  clProductTemplate->readByCategory(Array (), Array ([0] => DISTINCT(entProductTemplate.templateId),[1] => templateProductId,[templateTitleTextId] => templateTitleTextId,[templateShortDescriptionTextId] => templateShortDescriptionTextId,[2] => templateDefaultPriceSet,[3] => productPrice,[4] => productQuantity,[5] => productVat,[6] => productPriceRecommended,[7] => productDiscount,[8] => productDeliveryTime,[9] => routePath,[categoryId] => entProductTemplateToCategory.categoryId), ) called at [/home/httpd/inonestore/inonestore.se/platform/views/html/product/list.php:193]
#6  require(/home/httpd/inonestore/inonestore.se/platform/views/html/product/list.php) called at [/home/httpd/inonestore/inonestore.se/platform/core/clLayoutHtml.php:152]
#7  clLayoutHtml->renderView(product/list.php) called at [/home/httpd/inonestore/inonestore.se/platform/core/clLayoutHtml.php:264]
#8  clLayoutHtml->render() called at [/home/httpd/inonestore/inonestore.se/public_html/index.php:392]

0 => Exception: "SqlError: 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 ') AND entProductTemplate.templateStatus = 'active' AND entProduct.productStatus ' at line 1 Query: SELECT COUNT(DISTINCT(entProductTemplate.templateId)) FROM entProductTemplate LEFT JOIN entProduct ON entProductTemplate.templateProductId = entProduct.productId LEFT JOIN entProductToRoute ON entProductTemplate.templateId = entProductToRoute.parentId LEFT JOIN entRoute ON entProductToRoute.routeId = entRoute.routeId AND entProductToRoute.parentType = 'productTemplate' LEFT JOIN entProductTemplateToCategory ON entProductTemplate.templateId = entProductTemplateToCategory.templateId LEFT JOIN entProductText AS text1 ON entProductTemplate.templateTitleTextId = text1.textId AND text1.textLangId = 2 LEFT JOIN entProductText AS text2 ON entProductTemplate.templateShortDescriptionTextId = text2.textId AND text2.textLangId = 2 WHERE entRoute.routePathLangId = 2 AND entProductTemplateToCategory.categoryId IN() AND entProductTemplate.templateStatus = 'active' AND entProduct.productStatus = 'active'" on line 186 in file /home/httpd/inonestore/inonestore.se/platform/core/clDbPdo.php at code 0