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?
2
Answers
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.