From the top of my head - so make a backup:
Update ps_product_attribute p, ps_product_attribute_shop ps SET ps.id_product=p.id_product WHERE ps.id_product_attribute=p.id_product_attribute.
Edit History
From the top of my head - so make a backup:
Update ps_product_attribute p, ps_product_attribute_shop ps SET ps.id_product=p.id_product WHERE ps.is_product_attribute=p.id_product_attribute.