Magento Question posted in
The official documentation can be found here.

after upgrade Magento 2.3.4 to 2.4 product can't save , showing error

I have upgraded magento to 2.4 while save product it showing error.
I have try update on schedule, setup upgrade, cache clean reindex, given root user permission, but still get this issue on product save.

SQLSTATE[42S02]: Base table or view not found: 1146 Table 'm24.scconnector_google_feed_cl' doesn't exist, query was: DELETE FROM `catalog_product_entity_media_gallery_value` WHERE (value_id = 630 AND entity_id = 640 AND store_id = 0)

I have tried below commands:

php bin/magento cron:install
php bin/magento cron:run
php bin/magento index:reindex
mysql -u root -p set global log_bin_trust_function_creators=1;
php bin/magento module:disable Magento_GoogleShoppingAds

I can’t found table ‘scconnector_google_feed_cl’.

can anyone tell why this table not showing after migrate from Magento 2.3.4 to 2.4?

Can anyone give me the SQL query for creating table scconnector_google_feed_cl so I can create it?

Tags:

2

Answers


  1. 0 
    DROP TRIGGER IF EXISTS trg_catalog_product_entity_media_gallery_value_after_insert;
DROP TRIGGER IF EXISTS trg_catalog_product_entity_media_gallery_value_after_update;
DROP TRIGGER IF EXISTS trg_catalog_product_entity_media_gallery_value_after_delete;
    Login or Signup to reply.
  2. 0

    0

    It was used in module Magento_GoogleShoppingAds but that module is end of life.

    https://docs.magento.com/user-guide/sales-channels/google-eol.html

    However, the module adds triggers to your MySQL database and sometimes, when you upgrade to e.g. Magento 2.3.6 the module, removes the table but fails to remove the triggers.

    I had to run show triggers in my DB and then I had to drop the triggers before I could save product again.

    drop trigger trg_catalog_product_website_after_insert;
drop trigger trg_catalog_product_website_after_update;
drop trigger trg_catalog_product_website_after_delete;
    Login or Signup to reply.
Please signup or login to give your own answer.

Back To Top
Search