Help please. An error occurred while creating an object. product Prestashop 1.6.1.3

[MJ_C]

I wonder if anyone might be able to help with 

An error occurred while creating an object. product for Prestashop 1.6.1.3.

I read some bits about running some sql and it told me duplictae, so i assumed that may not be my issue.

If I turn debug to true then try to save the product it shows below.

=====

UPDATE `ps_product` SET `id_product` = '5246',`id_shop_default` = '1',`id_manufacturer` = '0',`id_supplier` = '3',`reference` = 'ECMJ02--09LS',`supplier_reference` = '',`location` = '',`width` = '0',`height` = '0',`depth` = '0',`weight` = '0',`quantity_discount` = '0',`ean13` = '',`upc` = '',`cache_is_pack` = '0',`cache_has_attachments` = '0',`is_virtual` = '0',`id_category_default` = '314',`id_tax_rules_group` = '0',`on_sale` = '0',`online_only` = '0',`ecotax` = '0',`minimal_quantity` = '1',`price` = '10.5',`wholesale_price` = '0',`unity` = '',`unit_price_ratio` = '0',`additional_shipping_cost` = '0',`customizable` = '0',`text_fields` = '0',`uploadable_files` = '0',`active` = '1',`redirect_type` = '404',`id_product_redirected` = '0',`available_for_order` = '1',`available_date` = '0000-00-00',`condition` = 'new',`show_price` = '1',`indexed` = '0',`visibility` = 'both',`cache_default_attribute` = '0',`advanced_stock_management` = '0',`date_add` = '2016-12-26 07:39:42',`date_upd` = '2018-04-02 00:54:48',`pack_stock_type` = '3' WHERE `id_product` = 5246

Lock wait timeout exceeded; try restarting transaction

======

 

Anyone any ideas as I can't save any product or create new ones.