Zend_Db_Statement_Exception: SQLSTATE[08S01]: Communication link failure: 1053 Server shutdown in progress in /var/www/vhosts/romarkjewellers.co.uk/httpdocs/lib/Zend/Db/Statement/Pdo.php on line 238

BACKTRACE
=========
[0] Zend_Db_Statement_Pdo->_execute(Array)
[/var/www/vhosts/romarkjewellers.co.uk/httpdocs/lib/Zend/Db/Statement.php:283]

[1] Zend_Db_Statement->execute(Array)
[/var/www/vhosts/romarkjewellers.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.status,
		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.createdOn,
		product.createdBy,
		product.modifiedOn,
		product.modifiedBy,
		product.salesStartOn,
		product.salesEndOn,
		product.monitorStock,
		product.stockLevelAlert,
		product.currentStock,
		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_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 (5,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 (5, 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.status = ? and pic.productId in (
									SELECT if(variantOf is null, productId, variantOf)
									FROM product_spec_list
									WHERE productSpecValueId in (?,?,?,?)
								) and pic.productId in (
									SELECT if(variantOf is null, productId, variantOf)
									FROM product_spec_list
									WHERE productSpecValueId in (?)
								)
group by product.productId
) AS c, Array)
[/var/www/vhosts/romarkjewellers.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.status,
		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.createdOn,
		product.createdBy,
		product.modifiedOn,
		product.modifiedBy,
		product.salesStartOn,
		product.salesEndOn,
		product.monitorStock,
		product.stockLevelAlert,
		product.currentStock,
		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_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 (5,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 (5, 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.status = ? and pic.productId in (
									SELECT if(variantOf is null, productId, variantOf)
									FROM product_spec_list
									WHERE productSpecValueId in (?,?,?,?)
								) and pic.productId in (
									SELECT if(variantOf is null, productId, variantOf)
									FROM product_spec_list
									WHERE productSpecValueId in (?)
								)
group by product.productId
) AS c, Array)
[/var/www/vhosts/romarkjewellers.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.status,
		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.createdOn,
		product.createdBy,
		product.modifiedOn,
		product.modifiedBy,
		product.salesStartOn,
		product.salesEndOn,
		product.monitorStock,
		product.stockLevelAlert,
		product.currentStock,
		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_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 (5,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 (5, 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.status = ? and pic.productId in (
									SELECT if(variantOf is null, productId, variantOf)
									FROM product_spec_list
									WHERE productSpecValueId in (?,?,?,?)
								) and pic.productId in (
									SELECT if(variantOf is null, productId, variantOf)
									FROM product_spec_list
									WHERE productSpecValueId in (?)
								)
group by product.productId
) AS c, Array, NULL)


[5] call_user_func(Array, SELECT COUNT(*) FROM (select count(*)
from 	(
		select
		product.productId,
		product.productTypeId,
		product.priceMechanism,
		product.variantOf,
		product.sku,
		product.barcode,
		product.status,
		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.createdOn,
		product.createdBy,
		product.modifiedOn,
		product.modifiedBy,
		product.salesStartOn,
		product.salesEndOn,
		product.monitorStock,
		product.stockLevelAlert,
		product.currentStock,
		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_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 (5,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 (5, 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.status = ? and pic.productId in (
									SELECT if(variantOf is null, productId, variantOf)
									FROM product_spec_list
									WHERE productSpecValueId in (?,?,?,?)
								) and pic.productId in (
									SELECT if(variantOf is null, productId, variantOf)
									FROM product_spec_list
									WHERE productSpecValueId in (?)
								)
group by product.productId
) AS c, Array, NULL)
[/var/www/vhosts/romarkjewellers.co.uk/httpdocs/lib/Evance/Db.php:74]

[6] Evance_Db::fetchOne(SELECT COUNT(*) FROM (select count(*)
from 	(
		select
		product.productId,
		product.productTypeId,
		product.priceMechanism,
		product.variantOf,
		product.sku,
		product.barcode,
		product.status,
		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.createdOn,
		product.createdBy,
		product.modifiedOn,
		product.modifiedBy,
		product.salesStartOn,
		product.salesEndOn,
		product.monitorStock,
		product.stockLevelAlert,
		product.currentStock,
		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_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 (5,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 (5, 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.status = ? and pic.productId in (
									SELECT if(variantOf is null, productId, variantOf)
									FROM product_spec_list
									WHERE productSpecValueId in (?,?,?,?)
								) and pic.productId in (
									SELECT if(variantOf is null, productId, variantOf)
									FROM product_spec_list
									WHERE productSpecValueId in (?)
								)
group by product.productId
) AS c, Array)
[/var/www/vhosts/romarkjewellers.co.uk/httpdocs/lib/Evance/Data/Grid.php:165]

[7] Evance_Data_Grid->totalRows()
[/var/www/vhosts/romarkjewellers.co.uk/httpdocs/lib/Evance/Data/Grid.php:307]

[8] Evance_Data_Grid->pager()
[/var/www/vhosts/romarkjewellers.co.uk/httpdocs/lib/Evance/Data/Grid.php:239]

[9] Evance_Data_Grid->perPage(12)
[/var/www/vhosts/romarkjewellers.co.uk/httpdocs/controllers/shop.php:108]

[10] ShopController->index()
[/var/www/vhosts/romarkjewellers.co.uk/httpdocs/lib/Evance/Controller.php:88]

[11] Evance_Controller->dispatch(default, shop, index, FALSE)
[/var/www/vhosts/romarkjewellers.co.uk/httpdocs/lib/Evance/Http/Router.php:266]

[12] Evance_Http_Router->attemptRoute(default, shop, index)
[/var/www/vhosts/romarkjewellers.co.uk/httpdocs/lib/Evance/Http/Router.php:39]

[13] Evance_Http_Router->dispatch()
[/var/www/vhosts/romarkjewellers.co.uk/httpdocs/index.php:13]

Warning: PDO::beginTransaction(): MySQL server has gone away in /var/www/vhosts/romarkjewellers.co.uk/httpdocs/lib/Zend/Db/Adapter/Pdo/Abstract.php on line 299


BACKTRACE
=========
[0] Zend_Db_Adapter_Pdo_Abstract->_beginTransaction()
[/var/www/vhosts/romarkjewellers.co.uk/httpdocs/lib/Zend/Db/Adapter/Abstract.php:480]

[1] Zend_Db_Adapter_Abstract->beginTransaction()


[2] call_user_func_array(Array, Array)
[/var/www/vhosts/romarkjewellers.co.uk/httpdocs/lib/Evance/Db.php:137]

[3] Evance_Db::__callStatic(beginTransaction, Array)
[/var/www/vhosts/romarkjewellers.co.uk/httpdocs/lib/Evance/Db/TransactionRaii.php:13]

[4] Evance_Db::beginTransaction()
[/var/www/vhosts/romarkjewellers.co.uk/httpdocs/lib/Evance/Db/TransactionRaii.php:13]

[5] Evance_Db_TransactionRaii->__construct()
[/var/www/vhosts/romarkjewellers.co.uk/httpdocs/lib/Evance/Db/Table.php:521]

[6] Evance_Db_Table::save(class stdClass)
[/var/www/vhosts/romarkjewellers.co.uk/httpdocs/lib/Evance/Session/Controller.php:72]

[7] Evance_Session_Controller->_write(aiqau5jucid2fbndp4qt1fln76, EV_CART_ADOPT_ID|N;GEOLOCATED_LOCALE|s:5:"en-gb";LANGUAGE_GEOLOCATED|b:1;CONTINUE_SHOPPING_URI|s:90:"https://www.romarkjewellers.co.uk/shop/second-hand-jewellery/necklaces/spec.75,55,80,74,64";EVANCE_DATA_GRID|a:1:{s:8:"products";a:3:{s:7:"perPage";i:12;s:9:"direction";N;s:4:"sort";s:11:"pricing:asc";}})