Forum Forum Magento Theme SNS Simo – Magento Theme SQLSTATE[23000] with quickstart

  • Author
  • #3643


    I’m getting lots of errors when trying to reindex data after installing theme with quickstart.

    Same goes for updating/creating a category or saving a product.

    Same when trying to add category or product.
    Here goes the error I’m getting while trying to reindex data via shell:
    Product Attributes index process unknown error:
    exception ‘PDOException’ with message ‘SQLSTATE[23000]: Integrity constraint violation: 1452 Cannot add or update a child row: a foreign key constraint fails (mydb.cataloginventory_stock_status, CONSTRAINT FK_SNSPFX_CATINV_STOCK_STS_PRD_ID_SNSPFX_CAT_PRD_ENTT_ENTT_ID FOREIGN KEY (product_id) REFERENCES __catalog_product_entity (`e)’ in /home/mysite/public_html/lib/Zend/Db/Statement/Pdo.php:228

You must be logged in to reply to this topic. Click here to login or register