Product Page 404 error, after moving website

Question

I have created a testing version of my website, in the same server, but using a different domain name. Frontend and backend works ok, but product pages redirect to

404 page error

I have tried:

• clearing cache
• reindexing data
• re-save products
• cleared catalog url rewrites
• disabling all third-party modules.
• resetting directory permissions

Nothing worked.

Am I missing something?

Answer 1

It seems that issue was caused by this error found in exception log:

cannot add or update a child row: a foreign key constraint fails (db_name.report_event, CONSTRA...”

In order to solve this, I followed instructions here:

https://www.mttr.io/blog/web-development/magento-cannot-add-or-update-a-child-row-report-event/

and run this query in my database:

INSERT INTO `report_event_types` (`event_type_id`, `event_name`, `customer_login`) VALUES
(1, 'catalog_product_view', 1),
(2, 'sendfriend_product', 1),
(3, 'catalog_product_compare_add_product', 1),
(4, 'checkout_cart_add_product', 1),
(5, 'wishlist_add_product', 1),
(6, 'wishlist_share', 1);