SQLSTATE[23000]: Integrity constraint violation: 1062Try re-indexin from Admin panel > System > Index management or from the command prompt using the following command:
Duplicate entry '167-1' for key 'IDX_STOCK_PRODUCT'
./shell php indexer.php reindexall