Contents
Why is there an integrity constraint in Magento?
Specifically, the ‘log_visitor_info’ table had about 100 more records than some of the other related visitor log tables, so the DB is trying to create a record ID from another table that already exists here. I just deleted the last 100 or so records from this specific table and things worked again without the error.
How can I solve this problem in Magento?
I have searched the db for this key 363624 , but it is not duplicated as the messages says how can i solve this ? It is not duplicated but rather something must be trying to duplicate it. How did you export the database? I would check that the dumped SQL file has the line ” SET FOREIGN_KEY_CHECKS=0; ” or similar at the top.
What is primary key 0 in Magento Stack Exchange?
Primary key 0 is the ” NOT LOGGED IN ” customer group. That is how far I am into for now. I will let you know if I find anything else. Thanks for contributing an answer to Magento Stack Exchange!
Why is my SQLSTATE error still giving error?
Also remove /var/cache, /var/session. still giving error. Can anybody suggest a solution? the message means you are doing another insert with the same combination of columns that are part of the IDX_STOCK_PRODUCT, which seams to be defined as UNIQUE.
How did you export the database in Magento?
It is not duplicated but rather something must be trying to duplicate it. How did you export the database? I would check that the dumped SQL file has the line ” SET FOREIGN_KEY_CHECKS=0; ” or similar at the top. If not, I would drop the database and add this line to the top of the file: then try again.
How to set foreign key checks in SQL?
I would check that the dumped SQL file has the line ” SET FOREIGN_KEY_CHECKS=0; ” or similar at the top. If not, I would drop the database and add this line to the top of the file: then try again. After that need to clear var/session dir (If your session stored in files) cause you will get same error until you clear session files.