Zend_Db_Statement_Exception: SQLSTATE[42S22]: Column not found: 1054 Unknown column 'product.Created_On' in 'field list' in /var/www/vhosts/countrysideshowjumps.co.uk/httpdocs/lib/Zend/Db/Statement/Pdo.php on line 238
BACKTRACE ========= [0] Zend_Db_Statement_Pdo->_execute(Array) [/var/www/vhosts/countrysideshowjumps.co.uk/httpdocs/lib/Zend/Db/Statement.php:303] [1] Zend_Db_Statement->execute(Array) [/var/www/vhosts/countrysideshowjumps.co.uk/httpdocs/lib/Zend/Db/Adapter/Abstract.php:464] [2] Zend_Db_Adapter_Abstract->query(SELECT COUNT(*) FROM (select count(*) from ( select product.productId, product.productTypeId, product.priceMechanism, product.variantOf, product.sku, product.barcode, product.isActive, COALESCE(translation.productTitle, product.productTitle) as productTitle, COALESCE(translation.alias, product.alias) as alias, product.alias as alias_translated, COALESCE(translation.fullDescription, product.fullDescription) as fullDescription, COALESCE(translation.shortDescription, product.shortDescription) as shortDescription, COALESCE(translation.metaTitle, product.metaTitle) as metaTitle, COALESCE(translation.metaDescription, product.metaDescription) as metaDescription, COALESCE(translation.metaKeywords, product.metaKeywords) as metaKeywords, product.manufacturerId, COALESCE(translation.model, product.model) as model, COALESCE(translation.variant, product.variant) as variant, product.partNumber, product.weight, product.shelfWidth, product.shelfHeight, product.shelfDepth, product.discontinued, product.discontinuedOn, product.discontinuedBy, COALESCE(translation.discontinuedBecause, product.discontinuedBecause) as discontinuedBecause, product.Created_On, product.Created_By, product.Modified_On, product.Modified_By, product.salesStartOn, product.salesEndOn, product.monitorStock, product.stockLevelAlert, product.taxClassId, product.dispatchDaysMin, product.dispatchDaysMax, product.orderQuantityMin, product.orderQuantityMax, product.shippingClassId, product.productBandId, product.deleted, product.supersededBy, product.purchasable, product.searchable, product.condition, product.templateId, product.indexable, product.averageRating, product.countRating, translation.locale from product as product left join ( select * from ( select translation.*, if(translation.country is null, translation.language, concat(translation.language,'-', translation.country)) as locale from product_translation as translation where (translation.language='en' and (translation.country is null or translation.country like 'gb')) order by locale desc ) as translation group by translation.productId ) as translation on translation.productId=product.productId ) as product left join product_media as media on media.productId = product.productId and media.isPrimary = 'Y' left join product_manufacturer as manufacturer on product.manufacturerId=manufacturer.manufacturerId left join product_stock as stock on stock.productId=product.productId left join product_band as pb on pb.productBandId=product.productBandId left join currency as currency on currency.isoCode='GBP' left join product_prices_current as price on price.productPriceId = (select price2.productPriceId from product_prices_current as price2 where price2.productId = product.productId and price2.priceType=product.priceMechanism and price2.lowestInClass = 'Y' and price2.currency='GBP' and (isnull(price2.accessRoleId)) and (isnull(price2.geozoneId) or price2.geozoneId in (22)) order by isnull(price2.accessRoleId) asc, isnull(price2.geozoneId) asc, price2.price asc limit 1 ) left join tax as localeTax on localeTax.taxId=( select taxId from tax where taxClassId = product.taxClassId and geozoneId in (22, NULL) order by taxRate desc limit 1 ) join product_category_entry as pic on pic.productId = product.productId and pic.categoryId in (?) where product.deleted='N' and product.productTypeId!=? and (product.isActive='Y' and product.deleted='N' and (product.salesStartOn<=Now() or product.salesStartOn IS NULL) and (product.salesEndOn IS NULL or product.salesEndOn>Now()) ) group by product.productId ) AS c, Array) [/var/www/vhosts/countrysideshowjumps.co.uk/httpdocs/lib/Zend/Db/Adapter/Pdo/Abstract.php:232] [3] Zend_Db_Adapter_Pdo_Abstract->query(SELECT COUNT(*) FROM (select count(*) from ( select product.productId, product.productTypeId, product.priceMechanism, product.variantOf, product.sku, product.barcode, product.isActive, COALESCE(translation.productTitle, product.productTitle) as productTitle, COALESCE(translation.alias, product.alias) as alias, product.alias as alias_translated, COALESCE(translation.fullDescription, product.fullDescription) as fullDescription, COALESCE(translation.shortDescription, product.shortDescription) as shortDescription, COALESCE(translation.metaTitle, product.metaTitle) as metaTitle, COALESCE(translation.metaDescription, product.metaDescription) as metaDescription, COALESCE(translation.metaKeywords, product.metaKeywords) as metaKeywords, product.manufacturerId, COALESCE(translation.model, product.model) as model, COALESCE(translation.variant, product.variant) as variant, product.partNumber, product.weight, product.shelfWidth, product.shelfHeight, product.shelfDepth, product.discontinued, product.discontinuedOn, product.discontinuedBy, COALESCE(translation.discontinuedBecause, product.discontinuedBecause) as discontinuedBecause, product.Created_On, product.Created_By, product.Modified_On, product.Modified_By, product.salesStartOn, product.salesEndOn, product.monitorStock, product.stockLevelAlert, product.taxClassId, product.dispatchDaysMin, product.dispatchDaysMax, product.orderQuantityMin, product.orderQuantityMax, product.shippingClassId, product.productBandId, product.deleted, product.supersededBy, product.purchasable, product.searchable, product.condition, product.templateId, product.indexable, product.averageRating, product.countRating, translation.locale from product as product left join ( select * from ( select translation.*, if(translation.country is null, translation.language, concat(translation.language,'-', translation.country)) as locale from product_translation as translation where (translation.language='en' and (translation.country is null or translation.country like 'gb')) order by locale desc ) as translation group by translation.productId ) as translation on translation.productId=product.productId ) as product left join product_media as media on media.productId = product.productId and media.isPrimary = 'Y' left join product_manufacturer as manufacturer on product.manufacturerId=manufacturer.manufacturerId left join product_stock as stock on stock.productId=product.productId left join product_band as pb on pb.productBandId=product.productBandId left join currency as currency on currency.isoCode='GBP' left join product_prices_current as price on price.productPriceId = (select price2.productPriceId from product_prices_current as price2 where price2.productId = product.productId and price2.priceType=product.priceMechanism and price2.lowestInClass = 'Y' and price2.currency='GBP' and (isnull(price2.accessRoleId)) and (isnull(price2.geozoneId) or price2.geozoneId in (22)) order by isnull(price2.accessRoleId) asc, isnull(price2.geozoneId) asc, price2.price asc limit 1 ) left join tax as localeTax on localeTax.taxId=( select taxId from tax where taxClassId = product.taxClassId and geozoneId in (22, NULL) order by taxRate desc limit 1 ) join product_category_entry as pic on pic.productId = product.productId and pic.categoryId in (?) where product.deleted='N' and product.productTypeId!=? and (product.isActive='Y' and product.deleted='N' and (product.salesStartOn<=Now() or product.salesStartOn IS NULL) and (product.salesEndOn IS NULL or product.salesEndOn>Now()) ) group by product.productId ) AS c, Array) [/var/www/vhosts/countrysideshowjumps.co.uk/httpdocs/lib/Zend/Db/Adapter/Abstract.php:795] [4] Zend_Db_Adapter_Abstract->fetchOne(SELECT COUNT(*) FROM (select count(*) from ( select product.productId, product.productTypeId, product.priceMechanism, product.variantOf, product.sku, product.barcode, product.isActive, COALESCE(translation.productTitle, product.productTitle) as productTitle, COALESCE(translation.alias, product.alias) as alias, product.alias as alias_translated, COALESCE(translation.fullDescription, product.fullDescription) as fullDescription, COALESCE(translation.shortDescription, product.shortDescription) as shortDescription, COALESCE(translation.metaTitle, product.metaTitle) as metaTitle, COALESCE(translation.metaDescription, product.metaDescription) as metaDescription, COALESCE(translation.metaKeywords, product.metaKeywords) as metaKeywords, product.manufacturerId, COALESCE(translation.model, product.model) as model, COALESCE(translation.variant, product.variant) as variant, product.partNumber, product.weight, product.shelfWidth, product.shelfHeight, product.shelfDepth, product.discontinued, product.discontinuedOn, product.discontinuedBy, COALESCE(translation.discontinuedBecause, product.discontinuedBecause) as discontinuedBecause, product.Created_On, product.Created_By, product.Modified_On, product.Modified_By, product.salesStartOn, product.salesEndOn, product.monitorStock, product.stockLevelAlert, product.taxClassId, product.dispatchDaysMin, product.dispatchDaysMax, product.orderQuantityMin, product.orderQuantityMax, product.shippingClassId, product.productBandId, product.deleted, product.supersededBy, product.purchasable, product.searchable, product.condition, product.templateId, product.indexable, product.averageRating, product.countRating, translation.locale from product as product left join ( select * from ( select translation.*, if(translation.country is null, translation.language, concat(translation.language,'-', translation.country)) as locale from product_translation as translation where (translation.language='en' and (translation.country is null or translation.country like 'gb')) order by locale desc ) as translation group by translation.productId ) as translation on translation.productId=product.productId ) as product left join product_media as media on media.productId = product.productId and media.isPrimary = 'Y' left join product_manufacturer as manufacturer on product.manufacturerId=manufacturer.manufacturerId left join product_stock as stock on stock.productId=product.productId left join product_band as pb on pb.productBandId=product.productBandId left join currency as currency on currency.isoCode='GBP' left join product_prices_current as price on price.productPriceId = (select price2.productPriceId from product_prices_current as price2 where price2.productId = product.productId and price2.priceType=product.priceMechanism and price2.lowestInClass = 'Y' and price2.currency='GBP' and (isnull(price2.accessRoleId)) and (isnull(price2.geozoneId) or price2.geozoneId in (22)) order by isnull(price2.accessRoleId) asc, isnull(price2.geozoneId) asc, price2.price asc limit 1 ) left join tax as localeTax on localeTax.taxId=( select taxId from tax where taxClassId = product.taxClassId and geozoneId in (22, NULL) order by taxRate desc limit 1 ) join product_category_entry as pic on pic.productId = product.productId and pic.categoryId in (?) where product.deleted='N' and product.productTypeId!=? and (product.isActive='Y' and product.deleted='N' and (product.salesStartOn<=Now() or product.salesStartOn IS NULL) and (product.salesEndOn IS NULL or product.salesEndOn>Now()) ) group by product.productId ) AS c, Array) [5] call_user_func_array(Array, Array) [/var/www/vhosts/countrysideshowjumps.co.uk/httpdocs/lib/Evance/Db.php:128] [6] Evance_Db::__callStatic(fetchOne, Array) [/var/www/vhosts/countrysideshowjumps.co.uk/httpdocs/lib/Evance/Data/Grid.php:165] [7] Evance_Db::fetchOne(SELECT COUNT(*) FROM (select count(*) from ( select product.productId, product.productTypeId, product.priceMechanism, product.variantOf, product.sku, product.barcode, product.isActive, COALESCE(translation.productTitle, product.productTitle) as productTitle, COALESCE(translation.alias, product.alias) as alias, product.alias as alias_translated, COALESCE(translation.fullDescription, product.fullDescription) as fullDescription, COALESCE(translation.shortDescription, product.shortDescription) as shortDescription, COALESCE(translation.metaTitle, product.metaTitle) as metaTitle, COALESCE(translation.metaDescription, product.metaDescription) as metaDescription, COALESCE(translation.metaKeywords, product.metaKeywords) as metaKeywords, product.manufacturerId, COALESCE(translation.model, product.model) as model, COALESCE(translation.variant, product.variant) as variant, product.partNumber, product.weight, product.shelfWidth, product.shelfHeight, product.shelfDepth, product.discontinued, product.discontinuedOn, product.discontinuedBy, COALESCE(translation.discontinuedBecause, product.discontinuedBecause) as discontinuedBecause, product.Created_On, product.Created_By, product.Modified_On, product.Modified_By, product.salesStartOn, product.salesEndOn, product.monitorStock, product.stockLevelAlert, product.taxClassId, product.dispatchDaysMin, product.dispatchDaysMax, product.orderQuantityMin, product.orderQuantityMax, product.shippingClassId, product.productBandId, product.deleted, product.supersededBy, product.purchasable, product.searchable, product.condition, product.templateId, product.indexable, product.averageRating, product.countRating, translation.locale from product as product left join ( select * from ( select translation.*, if(translation.country is null, translation.language, concat(translation.language,'-', translation.country)) as locale from product_translation as translation where (translation.language='en' and (translation.country is null or translation.country like 'gb')) order by locale desc ) as translation group by translation.productId ) as translation on translation.productId=product.productId ) as product left join product_media as media on media.productId = product.productId and media.isPrimary = 'Y' left join product_manufacturer as manufacturer on product.manufacturerId=manufacturer.manufacturerId left join product_stock as stock on stock.productId=product.productId left join product_band as pb on pb.productBandId=product.productBandId left join currency as currency on currency.isoCode='GBP' left join product_prices_current as price on price.productPriceId = (select price2.productPriceId from product_prices_current as price2 where price2.productId = product.productId and price2.priceType=product.priceMechanism and price2.lowestInClass = 'Y' and price2.currency='GBP' and (isnull(price2.accessRoleId)) and (isnull(price2.geozoneId) or price2.geozoneId in (22)) order by isnull(price2.accessRoleId) asc, isnull(price2.geozoneId) asc, price2.price asc limit 1 ) left join tax as localeTax on localeTax.taxId=( select taxId from tax where taxClassId = product.taxClassId and geozoneId in (22, NULL) order by taxRate desc limit 1 ) join product_category_entry as pic on pic.productId = product.productId and pic.categoryId in (?) where product.deleted='N' and product.productTypeId!=? and (product.isActive='Y' and product.deleted='N' and (product.salesStartOn<=Now() or product.salesStartOn IS NULL) and (product.salesEndOn IS NULL or product.salesEndOn>Now()) ) group by product.productId ) AS c, Array) [/var/www/vhosts/countrysideshowjumps.co.uk/httpdocs/lib/Evance/Data/Grid.php:165] [8] Evance_Data_Grid->totalRows() [/var/www/vhosts/countrysideshowjumps.co.uk/httpdocs/lib/Evance/Data/Grid.php:307] [9] Evance_Data_Grid->pager() [/var/www/vhosts/countrysideshowjumps.co.uk/httpdocs/lib/Evance/Data/Grid.php:239] [10] Evance_Data_Grid->perPage(12) [/var/www/vhosts/countrysideshowjumps.co.uk/httpdocs/controllers/shop.php:90] [11] ShopController->index() [/var/www/vhosts/countrysideshowjumps.co.uk/httpdocs/lib/Evance/Controller.php:84] [12] Evance_Controller->dispatch(default, shop, index, FALSE) [/var/www/vhosts/countrysideshowjumps.co.uk/httpdocs/lib/Evance/Http/Router.php:266] [13] Evance_Http_Router->attemptRoute(default, shop, index) [/var/www/vhosts/countrysideshowjumps.co.uk/httpdocs/lib/Evance/Http/Router.php:39] [14] Evance_Http_Router->dispatch() [/var/www/vhosts/countrysideshowjumps.co.uk/httpdocs/index.php:13]
An error has occured with the website. If possible, please contact info@countryside-equestrian.co.uk for support, and to alert us to the issue.