I am facing issue on product page and category page.

enter image description here

Can any one suggest or guide me on this ?

  • Did you change definer in database dump? Jun 10 '19 at 7:35
  • Have you recently moved server, have you connected your site correctly and run setup upgrade and redeployed your site Jun 10 '19 at 18:02
  • @DavaGordon yes we switched the server. Jun 11 '19 at 4:48
  • @AdarshEdiyottil yes that's why it created issue. But i did not dump server team did. can you tell me that how definer change during db dump? Jun 11 '19 at 4:50
  • @CharulTyagi seems like an issue with your env config Jun 13 '19 at 15:54

I have found after debug and research we need to run query on database.

ALTER DEFINER=user@localhost VIEW inventory_stock_1 AS select distinct legacy_stock_status.product_id AS product_id,legacy_stock_status.website_id AS website_id,legacy_stock_status.stock_id AS stock_id,legacy_stock_status.qty AS quantity,legacy_stock_status.stock_status AS is_salable,product.sku AS sku from (db_name.cataloginventory_stock_status legacy_stock_status join db_name.catalog_product_entity product on((legacy_stock_status.product_id = product.entity_id)));

Your Answer

By clicking “Post Your Answer”, you agree to our terms of service, privacy policy and cookie policy

Not the answer you're looking for? Browse other questions tagged or ask your own question.