{"id":16439,"date":"2019-11-30T13:19:27","date_gmt":"2019-11-30T18:19:27","guid":{"rendered":"https:\/\/bangla.salearningschool.com\/recent-posts\/mysql-error-after-upgrading-magento-2-3-2-to-2-3-3\/"},"modified":"2020-02-08T09:29:57","modified_gmt":"2020-02-08T14:29:57","slug":"mysql-error-after-upgrading-magento-2-3-2-to-2-3-3","status":"publish","type":"post","link":"http:\/\/bangla.sitestree.com\/?p=16439","title":{"rendered":"Mysql error after upgrading magento 2.3.2 to 2.3.3"},"content":{"rendered":"

Solution to:<\/strong>
\nSQLSTATE[HY000]: General error: 1419 You do not have the SUPER privilege and binary logging is enabled (you might want to use the less safe log_bin_trust_function_creators variable), query was: CREATE TRIGGER trg_catalog_product_entity_after_insert AFTER INSERT ON catalog_product_entity FOR EACH ROW BEGIN INSERT IGNORE INTO `scconnector_google_feed_cl` (`entity_id`) VALUES (NEW.`entity_id`); END<\/p>\n

Sol:<\/strong>
\nmysql -u root -p set global log_bin_trust_function_creators=1;Worked for me.<\/p>\n

Reference: https:\/\/community.bitnami.com\/t\/mysql-error-after-upgrading-magento-2-3-2-to-2-3-3\/71536<\/a><\/p>\n

By<\/p>\n

Sayed Ahmed<\/strong>
\n<\/em><\/p>\n

BSc. Eng. in Comp. Sc. & Eng. (BUET)<\/strong><\/em>
\nMSc. in Comp. Sc. (U of Manitoba, Canada)<\/strong><\/em>
\nMSc. in Data Science and Analytics (Ryerson University, Canada)<\/strong><\/em>
\nLinkedin<\/strong>: https:\/\/ca.linkedin.com\/in\/sayedjustetc<\/a>
\n<\/em><\/p>\n

Blog<\/strong>: http:\/\/Bangla.SaLearningSchool.com<\/a>, http:\/\/SitesTree.com<\/a> <\/em>
\nOnline and Offline Training<\/strong>: http:\/\/Training.SitesTree.com<\/a> <\/em><\/p>\n

Get access to courses on Big Data, Data Science, AI, Cloud, Linux, System Admin, Web Development and Misc. related. Also, create your own course to sell to others to earn a revenue.<\/em>
\nhttp:\/\/sitestree.com\/training\/<\/a><\/p>\n

I<\/strong>f you want to contribute to the operation of this site (Bangla.SaLearn) including occasional free and\/or low cost online training (using Zoom.us): http:\/\/Training.SitesTree.com<\/a> (or charitable\/non-profit work in the education\/health\/social service sector), you can financially contribute to: safoundation at salearningschool.com<\/a> using Paypal or Credit Card (on <\/em>http:\/\/sitestree.com\/training\/enrol\/index.php?id=114<\/a> ).<\/em>
\n<\/strong>
\nAffiliate Links: Deals on Amazon :<\/em><\/strong>
\nHottest Deals on Amazon USA: http:\/\/tiny.cc\/38lddz<\/a>
\n<\/em>
\nHottest Deals on Amazon CA: http:\/\/tiny.cc\/bgnddz<\/a>
\n<\/em>
\nHottest Deals on Amazon Europe: http:\/\/tiny.cc\/w4nddz<\/a><\/em><\/p>\n","protected":false},"excerpt":{"rendered":"

Solution to: SQLSTATE[HY000]: General error: 1419 You do not have the SUPER privilege and binary logging is enabled (you might want to use the less safe log_bin_trust_function_creators variable), query was: CREATE TRIGGER trg_catalog_product_entity_after_insert AFTER INSERT ON catalog_product_entity FOR EACH ROW BEGIN INSERT IGNORE INTO `scconnector_google_feed_cl` (`entity_id`) VALUES (NEW.`entity_id`); END Sol: mysql -u root -p set … <\/p>\n

Continue reading<\/a><\/p>\n","protected":false},"author":2,"featured_media":0,"comment_status":"closed","ping_status":"closed","sticky":false,"template":"","format":"standard","meta":{"_jetpack_memberships_contains_paid_content":false,"footnotes":""},"categories":[1910,1907,182],"tags":[],"class_list":["post-16439","post","type-post","status-publish","format-standard","hentry","category-ai-ml-ds-rl-dl-nn-nlp-data-mining-optimization","category-magento-2","category---blog","item-wrap"],"jetpack_featured_media_url":"","jetpack_sharing_enabled":true,"jetpack-related-posts":[{"id":16491,"url":"http:\/\/bangla.sitestree.com\/?p=16491","url_meta":{"origin":16439,"position":0},"title":"Insert Products into Magento Programmatically","author":"Sayed","date":"December 8, 2019","format":false,"excerpt":"Magento 2 \u2013 how to add products in Magento using REST API and C # https:\/\/www.iperiusbackup.net\/en\/magento-2-data-load-through-rest-api-interface-and-c\/ magento-2-create-product-programmatically.html https:\/\/www.mageplaza.com\/devdocs\/magento-2-create-product-programmatically.html insert product programmatically https:\/\/magento.stackexchange.com\/questions\/62036\/insert-product-programmatically Programmatically (manually) creating simple Magento product https:\/\/inchoo.net\/magento\/programming-magento\/programatically-manually-creating-simple-magento-product\/ By Sayed Ahmed BSc. Eng. in Comp. Sc. & Eng. (BUET) MSc. in Comp. Sc. (U of Manitoba, Canada) MSc. in\u2026","rel":"","context":"In "AI ML DS RL DL NN NLP Data Mining Optimization"","block_context":{"text":"AI ML DS RL DL NN NLP Data Mining Optimization","link":"http:\/\/bangla.sitestree.com\/?cat=1910"},"img":{"alt_text":"","src":"","width":0,"height":0},"classes":[]},{"id":17077,"url":"http:\/\/bangla.sitestree.com\/?p=17077","url_meta":{"origin":16439,"position":1},"title":"Magento 2 Useful and Important CLI Commands List","author":"Sayed","date":"May 24, 2020","format":false,"excerpt":"\"Cache CLI (Status, Enable, Disable, Clean, Flush) php bin\/magento cache:clean Cleans cache type(s) php bin\/magento cache:disable Disables cache type(s) php bin\/magento cache:enable Enables cache type(s) php bin\/magento cache:flush Flushes cache storage used by cache type(s) php bin\/magento cache:status\" Checks cache status \" Also Check: http:\/\/bangla.salearningschool.com\/recent-posts?s=bin%2Fmagento Also Check: http:\/\/bangla.salearningschool.com\/recent-posts?s=magento Also, Check:\u2026","rel":"","context":"In "\u09ac\u09cd\u09b2\u0997 \u0964 Blog"","block_context":{"text":"\u09ac\u09cd\u09b2\u0997 \u0964 Blog","link":"http:\/\/bangla.sitestree.com\/?cat=182"},"img":{"alt_text":"","src":"","width":0,"height":0},"classes":[]},{"id":16437,"url":"http:\/\/bangla.sitestree.com\/?p=16437","url_meta":{"origin":16439,"position":2},"title":"Update Magento 2 to the latest version","author":"Sayed","date":"November 30, 2019","format":false,"excerpt":"Update Magento 2 to the latest version---https:\/\/devdocs.magento.com\/guides\/v2.3\/comp-mgr\/cli\/cli-upgrade.html Work with Github large file system ---install: Git-lfs: https:\/\/help.github.com\/en\/github\/managing-large-files\/installing-git-large-file-storage ---How to work with: https:\/\/help.github.com\/en\/github\/managing-large-files\/configuring-git-large-file-storage Sure, had to deal with i.e. work with By Sayed Ahmed BSc. Eng. in Comp. Sc. & Eng. (BUET) MSc. in Comp. Sc. (U of Manitoba, Canada) MSc. in\u2026","rel":"","context":"In "AI ML DS RL DL NN NLP Data Mining Optimization"","block_context":{"text":"AI ML DS RL DL NN NLP Data Mining Optimization","link":"http:\/\/bangla.sitestree.com\/?cat=1910"},"img":{"alt_text":"","src":"","width":0,"height":0},"classes":[]},{"id":26262,"url":"http:\/\/bangla.sitestree.com\/?p=26262","url_meta":{"origin":16439,"position":3},"title":"Magento 2 Useful and Important CLI Commands List #Root","author":"Author-Check- Article-or-Video","date":"April 21, 2021","format":false,"excerpt":"\"Cache CLI (Status, Enable, Disable, Clean, Flush) php bin\/magento cache:clean Cleans cache type(s) php bin\/magento cache:disable Disables cache type(s) php bin\/magento cache:enable Enables cache type(s) php bin\/magento cache:flush Flushes cache storage used by cache type(s) php bin\/magento cache:status\" Checks cache status \" Also Check: http:\/\/bangla.salearningschool.com\/recent-posts?s=bin%2Fmagento Also Check: http:\/\/bangla.salearningschool.com\/recent-posts?s=magento Also, Check:\u2026","rel":"","context":"In "FromSitesTree.com"","block_context":{"text":"FromSitesTree.com","link":"http:\/\/bangla.sitestree.com\/?cat=1917"},"img":{"alt_text":"","src":"","width":0,"height":0},"classes":[]},{"id":16498,"url":"http:\/\/bangla.sitestree.com\/?p=16498","url_meta":{"origin":16439,"position":4},"title":"Magento 2: Indexing Options","author":"Sayed","date":"December 9, 2019","format":false,"excerpt":"sudo php bin\/magento indexer:info design_config_grid Design Config Grid customer_grid Customer Grid catalog_category_product Category Products catalog_product_category Product Categories catalogrule_rule Catalog Rule Product catalog_product_attribute Product EAV cataloginventory_stock Stock inventory Inventory catalogrule_product Catalog Product Rule catalog_product_price Product Price scconnector_google_remove Google Product Removal Feed scconnector_google_feed Google Product Feed catalogsearch_fulltext Catalog Search--- Sayed Ahmed BSc.\u2026","rel":"","context":"In "AI ML DS RL DL NN NLP Data Mining Optimization"","block_context":{"text":"AI ML DS RL DL NN NLP Data Mining Optimization","link":"http:\/\/bangla.sitestree.com\/?cat=1910"},"img":{"alt_text":"","src":"","width":0,"height":0},"classes":[]},{"id":17034,"url":"http:\/\/bangla.sitestree.com\/?p=17034","url_meta":{"origin":16439,"position":5},"title":"All About Magento 2: Indexing\/reindexing","author":"Sayed","date":"May 4, 2020","format":false,"excerpt":"[Do not forget to search this site to learn\/find related information] # Use reset to reset current indexing status # You may not need to use this all the time # You will need to use this when you see invalid indexing status or you see index locked; # When\u2026","rel":"","context":"In "\u09ac\u09cd\u09b2\u0997 \u0964 Blog"","block_context":{"text":"\u09ac\u09cd\u09b2\u0997 \u0964 Blog","link":"http:\/\/bangla.sitestree.com\/?cat=182"},"img":{"alt_text":"","src":"https:\/\/i0.wp.com\/bangla.salearningschool.com\/wp-content\/uploads\/2020\/05\/Screen-Shot-2020-05-03-at-3.43.03-PM.png?resize=350%2C200","width":350,"height":200,"srcset":"https:\/\/i0.wp.com\/bangla.salearningschool.com\/wp-content\/uploads\/2020\/05\/Screen-Shot-2020-05-03-at-3.43.03-PM.png?resize=350%2C200 1x, https:\/\/i0.wp.com\/bangla.salearningschool.com\/wp-content\/uploads\/2020\/05\/Screen-Shot-2020-05-03-at-3.43.03-PM.png?resize=525%2C300 1.5x, https:\/\/i0.wp.com\/bangla.salearningschool.com\/wp-content\/uploads\/2020\/05\/Screen-Shot-2020-05-03-at-3.43.03-PM.png?resize=700%2C400 2x"},"classes":[]}],"_links":{"self":[{"href":"http:\/\/bangla.sitestree.com\/index.php?rest_route=\/wp\/v2\/posts\/16439","targetHints":{"allow":["GET"]}}],"collection":[{"href":"http:\/\/bangla.sitestree.com\/index.php?rest_route=\/wp\/v2\/posts"}],"about":[{"href":"http:\/\/bangla.sitestree.com\/index.php?rest_route=\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"http:\/\/bangla.sitestree.com\/index.php?rest_route=\/wp\/v2\/users\/2"}],"replies":[{"embeddable":true,"href":"http:\/\/bangla.sitestree.com\/index.php?rest_route=%2Fwp%2Fv2%2Fcomments&post=16439"}],"version-history":[{"count":1,"href":"http:\/\/bangla.sitestree.com\/index.php?rest_route=\/wp\/v2\/posts\/16439\/revisions"}],"predecessor-version":[{"id":16473,"href":"http:\/\/bangla.sitestree.com\/index.php?rest_route=\/wp\/v2\/posts\/16439\/revisions\/16473"}],"wp:attachment":[{"href":"http:\/\/bangla.sitestree.com\/index.php?rest_route=%2Fwp%2Fv2%2Fmedia&parent=16439"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"http:\/\/bangla.sitestree.com\/index.php?rest_route=%2Fwp%2Fv2%2Fcategories&post=16439"},{"taxonomy":"post_tag","embeddable":true,"href":"http:\/\/bangla.sitestree.com\/index.php?rest_route=%2Fwp%2Fv2%2Ftags&post=16439"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}