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 ppc1.* from product_prices_current as ppc1
left join product_prices_current as ppc2 on ppc2.productId=ppc1.productId
and ppc2.quantity=ppc1.quantity
and ppc2.currency=ppc1.currency
and (ppc1.price=(
select ppc3.price from product_prices_current as ppc3
where ppc3.productId=ppc1.productId
and ppc3.currency=ppc1.currency
and (isnull(ppc3.accessRoleId))
and (isnull(ppc3.geozoneId) or ppc3.geozoneId in (5,22))
and ppc3.quantity=ppc1.quantity
and ppc3.priceType=ppc1.priceType
and ppc3.priceUnit=ppc1.priceUnit
order by ppc3.geozoneId desc, ppc3.accessRoleId desc, ppc3.quantity asc, ppc3.price asc
limit 1
) or
((ppc1.price is null) and isnull((
select ppc3.price from product_prices_current as ppc3
where ppc3.productId=ppc1.productId
and ppc3.currency=ppc1.currency
and (isnull(ppc3.accessRoleId))
and (isnull(ppc3.geozoneId) or ppc3.geozoneId in (5,22))
and ppc3.quantity=ppc1.quantity
and ppc3.priceType=ppc1.priceType
and ppc3.priceUnit=ppc1.priceUnit
order by ppc3.geozoneId desc, ppc3.accessRoleId desc, ppc3.quantity asc, ppc3.price asc
limit 1
)))
)
and ppc2.priceType=ppc1.priceType
and ppc2.priceUnit=ppc1.priceUnit
where ppc1.productId in (?,?,?)
and ppc1.currency=?
and (isnull(ppc1.accessRoleId))
and (isnull(ppc1.geozoneId) or ppc1.geozoneId in (5,22))
and ppc1.productPriceId=ppc2.productPriceId
order by ppc1.priceType asc, ppc1.accessRoleId asc, ppc1.geozoneId asc, ppc1.currency asc, ppc1.quantity asc, ppc1.price asc, ppc1.startOn desc, Array)
[/var/www/vhosts/romarkjewellers.co.uk/httpdocs/lib/Zend/Db/Adapter/Pdo/Abstract.php:232]
[3] Zend_Db_Adapter_Pdo_Abstract->query(select ppc1.* from product_prices_current as ppc1
left join product_prices_current as ppc2 on ppc2.productId=ppc1.productId
and ppc2.quantity=ppc1.quantity
and ppc2.currency=ppc1.currency
and (ppc1.price=(
select ppc3.price from product_prices_current as ppc3
where ppc3.productId=ppc1.productId
and ppc3.currency=ppc1.currency
and (isnull(ppc3.accessRoleId))
and (isnull(ppc3.geozoneId) or ppc3.geozoneId in (5,22))
and ppc3.quantity=ppc1.quantity
and ppc3.priceType=ppc1.priceType
and ppc3.priceUnit=ppc1.priceUnit
order by ppc3.geozoneId desc, ppc3.accessRoleId desc, ppc3.quantity asc, ppc3.price asc
limit 1
) or
((ppc1.price is null) and isnull((
select ppc3.price from product_prices_current as ppc3
where ppc3.productId=ppc1.productId
and ppc3.currency=ppc1.currency
and (isnull(ppc3.accessRoleId))
and (isnull(ppc3.geozoneId) or ppc3.geozoneId in (5,22))
and ppc3.quantity=ppc1.quantity
and ppc3.priceType=ppc1.priceType
and ppc3.priceUnit=ppc1.priceUnit
order by ppc3.geozoneId desc, ppc3.accessRoleId desc, ppc3.quantity asc, ppc3.price asc
limit 1
)))
)
and ppc2.priceType=ppc1.priceType
and ppc2.priceUnit=ppc1.priceUnit
where ppc1.productId in (?,?,?)
and ppc1.currency=?
and (isnull(ppc1.accessRoleId))
and (isnull(ppc1.geozoneId) or ppc1.geozoneId in (5,22))
and ppc1.productPriceId=ppc2.productPriceId
order by ppc1.priceType asc, ppc1.accessRoleId asc, ppc1.geozoneId asc, ppc1.currency asc, ppc1.quantity asc, ppc1.price asc, ppc1.startOn desc, Array)
[/var/www/vhosts/romarkjewellers.co.uk/httpdocs/lib/Zend/Db/Adapter/Abstract.php:702]
[4] Zend_Db_Adapter_Abstract->fetchAll(select ppc1.* from product_prices_current as ppc1
left join product_prices_current as ppc2 on ppc2.productId=ppc1.productId
and ppc2.quantity=ppc1.quantity
and ppc2.currency=ppc1.currency
and (ppc1.price=(
select ppc3.price from product_prices_current as ppc3
where ppc3.productId=ppc1.productId
and ppc3.currency=ppc1.currency
and (isnull(ppc3.accessRoleId))
and (isnull(ppc3.geozoneId) or ppc3.geozoneId in (5,22))
and ppc3.quantity=ppc1.quantity
and ppc3.priceType=ppc1.priceType
and ppc3.priceUnit=ppc1.priceUnit
order by ppc3.geozoneId desc, ppc3.accessRoleId desc, ppc3.quantity asc, ppc3.price asc
limit 1
) or
((ppc1.price is null) and isnull((
select ppc3.price from product_prices_current as ppc3
where ppc3.productId=ppc1.productId
and ppc3.currency=ppc1.currency
and (isnull(ppc3.accessRoleId))
and (isnull(ppc3.geozoneId) or ppc3.geozoneId in (5,22))
and ppc3.quantity=ppc1.quantity
and ppc3.priceType=ppc1.priceType
and ppc3.priceUnit=ppc1.priceUnit
order by ppc3.geozoneId desc, ppc3.accessRoleId desc, ppc3.quantity asc, ppc3.price asc
limit 1
)))
)
and ppc2.priceType=ppc1.priceType
and ppc2.priceUnit=ppc1.priceUnit
where ppc1.productId in (?,?,?)
and ppc1.currency=?
and (isnull(ppc1.accessRoleId))
and (isnull(ppc1.geozoneId) or ppc1.geozoneId in (5,22))
and ppc1.productPriceId=ppc2.productPriceId
order by ppc1.priceType asc, ppc1.accessRoleId asc, ppc1.geozoneId asc, ppc1.currency asc, ppc1.quantity asc, ppc1.price asc, ppc1.startOn desc, Array)
[5] call_user_func_array(Array, Array)
[/var/www/vhosts/romarkjewellers.co.uk/httpdocs/lib/Evance/Db.php:137]
[6] Evance_Db::__callStatic(fetchAll, Array)
[/var/www/vhosts/romarkjewellers.co.uk/httpdocs/lib/Evance/Db/RowSet.php:23]
[7] Evance_Db::fetchAll(select ppc1.* from product_prices_current as ppc1
left join product_prices_current as ppc2 on ppc2.productId=ppc1.productId
and ppc2.quantity=ppc1.quantity
and ppc2.currency=ppc1.currency
and (ppc1.price=(
select ppc3.price from product_prices_current as ppc3
where ppc3.productId=ppc1.productId
and ppc3.currency=ppc1.currency
and (isnull(ppc3.accessRoleId))
and (isnull(ppc3.geozoneId) or ppc3.geozoneId in (5,22))
and ppc3.quantity=ppc1.quantity
and ppc3.priceType=ppc1.priceType
and ppc3.priceUnit=ppc1.priceUnit
order by ppc3.geozoneId desc, ppc3.accessRoleId desc, ppc3.quantity asc, ppc3.price asc
limit 1
) or
((ppc1.price is null) and isnull((
select ppc3.price from product_prices_current as ppc3
where ppc3.productId=ppc1.productId
and ppc3.currency=ppc1.currency
and (isnull(ppc3.accessRoleId))
and (isnull(ppc3.geozoneId) or ppc3.geozoneId in (5,22))
and ppc3.quantity=ppc1.quantity
and ppc3.priceType=ppc1.priceType
and ppc3.priceUnit=ppc1.priceUnit
order by ppc3.geozoneId desc, ppc3.accessRoleId desc, ppc3.quantity asc, ppc3.price asc
limit 1
)))
)
and ppc2.priceType=ppc1.priceType
and ppc2.priceUnit=ppc1.priceUnit
where ppc1.productId in (?,?,?)
and ppc1.currency=?
and (isnull(ppc1.accessRoleId))
and (isnull(ppc1.geozoneId) or ppc1.geozoneId in (5,22))
and ppc1.productPriceId=ppc2.productPriceId
order by ppc1.priceType asc, ppc1.accessRoleId asc, ppc1.geozoneId asc, ppc1.currency asc, ppc1.quantity asc, ppc1.price asc, ppc1.startOn desc, Array)
[/var/www/vhosts/romarkjewellers.co.uk/httpdocs/lib/Evance/Db/RowSet.php:23]
[8] Evance_Db_RowSet->fetchAcross(select ppc1.* from product_prices_current as ppc1
left join product_prices_current as ppc2 on ppc2.productId=ppc1.productId
and ppc2.quantity=ppc1.quantity
and ppc2.currency=ppc1.currency
and (ppc1.price=(
select ppc3.price from product_prices_current as ppc3
where ppc3.productId=ppc1.productId
and ppc3.currency=ppc1.currency
and (isnull(ppc3.accessRoleId))
and (isnull(ppc3.geozoneId) or ppc3.geozoneId in (5,22))
and ppc3.quantity=ppc1.quantity
and ppc3.priceType=ppc1.priceType
and ppc3.priceUnit=ppc1.priceUnit
order by ppc3.geozoneId desc, ppc3.accessRoleId desc, ppc3.quantity asc, ppc3.price asc
limit 1
) or
((ppc1.price is null) and isnull((
select ppc3.price from product_prices_current as ppc3
where ppc3.productId=ppc1.productId
and ppc3.currency=ppc1.currency
and (isnull(ppc3.accessRoleId))
and (isnull(ppc3.geozoneId) or ppc3.geozoneId in (5,22))
and ppc3.quantity=ppc1.quantity
and ppc3.priceType=ppc1.priceType
and ppc3.priceUnit=ppc1.priceUnit
order by ppc3.geozoneId desc, ppc3.accessRoleId desc, ppc3.quantity asc, ppc3.price asc
limit 1
)))
)
and ppc2.priceType=ppc1.priceType
and ppc2.priceUnit=ppc1.priceUnit
where ppc1.productId in :productIds
and ppc1.currency=?
and (isnull(ppc1.accessRoleId))
and (isnull(ppc1.geozoneId) or ppc1.geozoneId in (5,22))
and ppc1.productPriceId=ppc2.productPriceId
order by ppc1.priceType asc, ppc1.accessRoleId asc, ppc1.geozoneId asc, ppc1.currency asc, ppc1.quantity asc, ppc1.price asc, ppc1.startOn desc, Array)
[/var/www/vhosts/romarkjewellers.co.uk/httpdocs/lib/Evance/Db/RowSet.php:10]
[9] Evance_Db_RowSet->__construct(select ppc1.* from product_prices_current as ppc1
left join product_prices_current as ppc2 on ppc2.productId=ppc1.productId
and ppc2.quantity=ppc1.quantity
and ppc2.currency=ppc1.currency
and (ppc1.price=(
select ppc3.price from product_prices_current as ppc3
where ppc3.productId=ppc1.productId
and ppc3.currency=ppc1.currency
and (isnull(ppc3.accessRoleId))
and (isnull(ppc3.geozoneId) or ppc3.geozoneId in (5,22))
and ppc3.quantity=ppc1.quantity
and ppc3.priceType=ppc1.priceType
and ppc3.priceUnit=ppc1.priceUnit
order by ppc3.geozoneId desc, ppc3.accessRoleId desc, ppc3.quantity asc, ppc3.price asc
limit 1
) or
((ppc1.price is null) and isnull((
select ppc3.price from product_prices_current as ppc3
where ppc3.productId=ppc1.productId
and ppc3.currency=ppc1.currency
and (isnull(ppc3.accessRoleId))
and (isnull(ppc3.geozoneId) or ppc3.geozoneId in (5,22))
and ppc3.quantity=ppc1.quantity
and ppc3.priceType=ppc1.priceType
and ppc3.priceUnit=ppc1.priceUnit
order by ppc3.geozoneId desc, ppc3.accessRoleId desc, ppc3.quantity asc, ppc3.price asc
limit 1
)))
)
and ppc2.priceType=ppc1.priceType
and ppc2.priceUnit=ppc1.priceUnit
where ppc1.productId in :productIds
and ppc1.currency=?
and (isnull(ppc1.accessRoleId))
and (isnull(ppc1.geozoneId) or ppc1.geozoneId in (5,22))
and ppc1.productPriceId=ppc2.productPriceId
order by ppc1.priceType asc, ppc1.accessRoleId asc, ppc1.geozoneId asc, ppc1.currency asc, ppc1.quantity asc, ppc1.price asc, ppc1.startOn desc, Array)
[/var/www/vhosts/romarkjewellers.co.uk/httpdocs/lib/Evance/Db/Sql.php:79]
[10] Evance_Db_Sql->rowSet()
[/var/www/vhosts/romarkjewellers.co.uk/httpdocs/controllers/shop.php:193]
[11] ShopController->index()
[/var/www/vhosts/romarkjewellers.co.uk/httpdocs/lib/Evance/Controller.php:88]
[12] Evance_Controller->dispatch(default, shop, index, FALSE)
[/var/www/vhosts/romarkjewellers.co.uk/httpdocs/lib/Evance/Http/Router.php:266]
[13] Evance_Http_Router->attemptRoute(default, shop, index)
[/var/www/vhosts/romarkjewellers.co.uk/httpdocs/lib/Evance/Http/Router.php:39]
[14] Evance_Http_Router->dispatch()
[/var/www/vhosts/romarkjewellers.co.uk/httpdocs/index.php:13]
An error has occured with the website. If possible, please contact enquiries@romarkjewellers.co.uk for support, and to alert us to the issue.
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:87:"https://www.romarkjewellers.co.uk/shop/second-hand-jewellery/necklaces/spec.80,76,62,84";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";}})
An error has occured with the website. If possible, please contact enquiries@romarkjewellers.co.uk for support, and to alert us to the issue.