Elevate Web Cardiff

Magento Advice & Tips

Magento Error – SQLSTATE[HY000]: General error: 1205 Lock wait timeout exceeded

SQLSTATE[HY000]: General error: 1205 Lock wait timeout exceeded; try restarting transaction
Sometimes deadlock issues can be caused on the database.

This might happen if you are running a lot of custom scripts and killing the scripts before the database connection gets chance to close

If you login to MySQL from CLI and run the command


you will get the following output
|     […]

Magento Developer Cardiff

Are you looking for a local Magento Web Developer based in Cardiff? Give us a quick call, or email to let us know what you are looking for. Whether this is optimising your current store, installing extensions. Customising your Magento website with extra functionality. Integrating your store into stock control systems, or manufacturers stock.


We have worked on developing Magento websites […]

Magento Cardsave Module and IWD One Step Checkout

If you have tried installing the Cardsave Magento module and IWD one step checkout modules together you will find that the customer is notified of failure, even though the transactions are successful

You may see a message similar to “Your payment attempt has been declined by your issuing bank. Please check your credit/debit card details and try again.”

This is due to the […]

Magento Error creating orders – UNQ_SALES_FLAT_INVOICE_INCREMENT_ID

Error: exception ‘PDOException’ with message ‘SQLSTATE[23000]: Integrity constraint violation: 1062 Duplicate entry ‘100000001’ for key ‘UNQ_SALES_FLAT_INVOICE_INCREMENT_ID”

We have seen errors caused like this before when people have manually copied order tables from one magento install to another

SELECT * FROM eav_entity_store

To resolve this issue, lets check what the latest order id for this store is

SELECT increment_id FROM `sales_flat_order` WHERE store_id = 1 ORDER BY increment_id DESC LIMIT 0, 1



The table eav_entity store must have the following […]

Magento 1.8.1 Bug Fixes

After installing Magento 1.8.1, you might run into a few problems that stop you from being able to use your store.
Here are a few common problems and fixes you might want to look at fixing

Customers cannot login to accounts

To fix this, you need to make edits to the following two login forms

template/persistent/customer/form/login.phtml and under

add the following code in the login […]

Using $this->getPriceHtml in custom phtml file

However in magento 1.8 this stopped working and now you need to make an edit to a core file to stop the error
Fatal error: Call to a member function getStoreLabel() on a non-object

Just open \app\design\frontend\base\default\template\catalog\product\price.phtml

and change

$_specialPriceStoreLabel = $this->getProductAttribute(‘special_price’)->getStoreLabel();

$specialPriceAttr = $this->getProductAttribute(‘special_price’);
if (!is_null($specialPriceAttr)) {
$_specialPriceStoreLabel = $specialPriceAttr->getStoreLabel();
} […]

elevateZoom – jQuery Image zoom plugin Launched

We are proud to announce the first public release of our image zoom plugin

elevateZoom is a highly-customizable jQuery Image zoom Plugin with multiple zoom modes including lens zoom, window zoom and inner zoom

Features such as Tinting fadeIn/fadeOut, easing, opacity, borders mean you can customise the plugin to suit your needs.


We will over time be releasing tutorials for other lighbox’s and shopping carts such […]

Magento – Get list of all SKU’s from the database

To get a list of all the SKU’s from the database, it is just a simple query

SELECT `sku` FROM `catalog_product_entity` AS CPE


If you find this useful, or you are looking for a more specific query, then let us know and we will revise this post with the answer for you.