Whenever a logged in user tries to do something related to his account, then he is redirected to 404 page. Below, I give 4 cases that the error occurs.
Case 1. User tries to login, the page is blank, then if you refresh the user account area appears with a message "We can't show you the wishlist now".
Case 2. User is logged in and tries to visit a product page, then he is redirected to the 404 page.
Case 3. User tries to add a product to cart, then he is redirected to the 404 page.
Case 4: Visitor (not logged in) orders a product and at the success page (after successfully submitting the order) decides to create an account (the system offers it with a button), then the same as Case 1 happens.
I upgraded from Magento 2.2.0 to 2.2.5, but the problem is still there.
Preconditions
- Magento Version 2.2.0 and 2.2.5 (after update).
- php 7.0.13 on apache and nginx / debian 9.
- One Website, with Two stores and Two Store Views (one for each store).
Steps to reproduce
In order to reproduce one has to login first or try to visit a product page so that he can face this 404 error.
Expected result
- The logged in user should be able to visit a product's page.
- The visitor should be able to login normally without error.
Actual result
- The logged in user was redirected to the 404 page (the product link on the browser is the correct one).
- The visitor saw a blank page, then had to refresh in order to view his account page.
Here is an exception from exception.log file:
[2018-10-07 10:26:49] main.CRITICAL: SQLSTATE[23000]: Integrity constraint violation: 1452 Cannot add or update a child row: a foreign key constraint fails (mysitedb.report_viewed_product_index, CONSTRAINT REPORT_VIEWED_PRD_IDX_CSTR_ID_CSTR_ENTT_ENTT_ID FOREIGN KEY (customer_id) REFERENCES customer_entity_renamed (entity_id) ON D), query was: INSERT INTO report_viewed_product_index(customer_id,product_id,store_id) VALUES (?, ?, ?) ON DUPLICATE KEY UPDATE customer_id = VALUES(customer_id), product_id = VALUES(product_id), store_id = VALUES(store_id) {"exception":"[object] (Zend_Db_Statement_Exception(code: 23000): SQLSTATE[23000]: Integrity constraint violation: 1452 Cannot add or update a child row: a foreign key constraint fails (mysitedb.report_viewed_product_index, CONSTRAINT REPORT_VIEWED_PRD_IDX_CSTR_ID_CSTR_ENTT_ENTT_ID FOREIGN KEY (customer_id) REFERENCES customer_entity_renamed (entity_id) ON D), query was: INSERT INTO report_viewed_product_index(customer_id,product_id,store_id) VALUES (?, ?, ?) ON DUPLICATE KEY UPDATE customer_id = VALUES(customer_id), product_id = VALUES(product_id), store_id = VALUES(store_id) at /home/mysite/domains/mysitedb.mysite.com/public_html/vendor/magento/zendframework1/library/Zend/Db/Statement/Pdo.php:235, PDOException(code: 23000): SQLSTATE[23000]: Integrity constraint violation: 1452 Cannot add or update a child row: a foreign key constraint fails (mysitedb.report_viewed_product_index, CONSTRAINT REPORT_VIEWED_PRD_IDX_CSTR_ID_CSTR_ENTT_ENTT_IDFOREIGN KEY (customer_id) REFERENCES customer_entity_renamed (entity_id) ON D) at /home/mysite/domains/mysitedb.mysite.com/public_html/vendor/magento/zendframework1/library/Zend/Db/Statement/Pdo.php:228)"} []
