marinaberths.ae

You have an error in your SQL syntax

1213 - Deadlock found when trying to get lock; try restarting transaction

insert into product_price_index (products_id, groups_id, currencies_id, flag_process, products_last_modified) select * from ( select p.products_id, ifnull(pp.groups_id, g.groups_id), ifnull(pp.currencies_id, 0), 1, ifnull(p.products_last_modified, p.products_date_added) from products p left join (select groups_id from groups union all select 0) g on 1 left join products_prices pp on p.products_id=pp.products_id and g.groups_id=pp.groups_id left join product_price_index ft1 on ft1.products_id=p.products_id and g.groups_id=ft1.groups_id and 0=ft1.currencies_id where p.products_status=1 and ft1.products_id is null ) as dt ON DUPLICATE KEY UPDATE flag_process=1

Filename: lib/common/extensions/ProductPriceIndex/ProductPriceIndex.php
Line: 82

1213 - Deadlock found when trying to get lock; try restarting transaction

update product_price_index ft set ft.flag_process=1 where ft.flag_process<>1 order by ft.products_status desc, ft.last_modified, flag_process desc limit 50

Filename: lib/common/extensions/ProductPriceIndex/ProductPriceIndex.php
Line: 103