Magento Asked by AL-MAHBUB KHAN on February 8, 2021
Bellow error showing I did do an update on schedule, setup upgrade, cache clean reindex, give root user try everything but still get this issue on product saves.
The Bellow problem is showing when I try to save the product from the admin pannel.
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 did try bellow code:
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 didn’t see 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 for creating this scconnector_google_feed_cl so I can create it?
In magento 2.4 GoogleShoppingAds is removed. But there is still a database trigger on the update, insert and delete of an entity.
On the table 'catalog_product_entity_media_gallery_value' you have 3 triggers, just delete them to resolve the issue.
Answered by Yolan Mees on February 8, 2021
The tables ending by _cl are tables created for "Update by schedule" indexes.
So in "System > Index Management", maybe try to put your "Google Product Feed" index from "update by schedule" to "on save", and then put it to "Update by schedule" again.
Answered by Peekmo on February 8, 2021
Get help from others!
Recent Answers
Recent Questions
© 2024 TransWikia.com. All rights reserved. Sites we Love: PCI Database, UKBizDB, Menu Kuliner, Sharing RPP