{"action":"opened","issue":{"url":"https://api.github.com/repos/Yoast/wpseo-woocommerce/issues/279","repository_url":"https://api.github.com/repos/Yoast/wpseo-woocommerce","labels_url":"https://api.github.com/repos/Yoast/wpseo-woocommerce/issues/279/labels{/name}","comments_url":"https://api.github.com/repos/Yoast/wpseo-woocommerce/issues/279/comments","events_url":"https://api.github.com/repos/Yoast/wpseo-woocommerce/issues/279/events","html_url":"https://github.com/Yoast/wpseo-woocommerce/issues/279","id":361432745,"node_id":"MDU6SXNzdWUzNjE0MzI3NDU=","number":279,"title":"Removing product from API produces mySQL max_allowed_packet error due to Yoast notice","user":{"login":"devonto","id":6807236,"node_id":"MDQ6VXNlcjY4MDcyMzY=","avatar_url":"https://avatars2.githubusercontent.com/u/6807236?v=4","gravatar_id":"","url":"https://api.github.com/users/devonto","html_url":"https://github.com/devonto","followers_url":"https://api.github.com/users/devonto/followers","following_url":"https://api.github.com/users/devonto/following{/other_user}","gists_url":"https://api.github.com/users/devonto/gists{/gist_id}","starred_url":"https://api.github.com/users/devonto/starred{/owner}{/repo}","subscriptions_url":"https://api.github.com/users/devonto/subscriptions","organizations_url":"https://api.github.com/users/devonto/orgs","repos_url":"https://api.github.com/users/devonto/repos","events_url":"https://api.github.com/users/devonto/events{/privacy}","received_events_url":"https://api.github.com/users/devonto/received_events","type":"User","site_admin":false},"labels":[],"state":"open","locked":false,"assignee":null,"assignees":[],"milestone":null,"comments":0,"created_at":"2018-09-18T18:43:10Z","updated_at":"2018-09-18T18:43:10Z","closed_at":null,"author_association":"NONE","body":"### What did you expect to happen?\r\nDeleting products in bulk via the WooCommerce API should occur normally, without error\r\n\r\n### What happened instead?\r\nProducts were deleted, but API response was erroneous and logs output as follows:\r\n\r\n` mod_fcgid: stderr: WordPress database error Got a packet bigger than 'max_allowed_packet' bytes for query UPDATE `sco_usermeta` SET `meta_value` = 'a:1134:{i:0;a:2:{s:7:\\\\\"message\\\\\";s:569:\\\\\"<h2>Make sure you don\\\\'t miss out on traffic!</h2><p>You just binned a Product. Search engines and other websites can still send traffic to your deleted post. You should create a redirect to ensure your visitors do not get a 404 error when they click on the no longer working URL. With Yoast SEO Premium, you can easily create such redirects.</p><p><a class=\\\\\"button-primary\\\\\" href=\\\\\"https://yoa.st/1d0?php_version=7.1.21&platform=wordpress&platform_version=4.9.8&software=free&software_version=8.1&role=unknown&days_active=72\\\\\" target=\\\\\"_blank\\\\\">Get Yoast SEO Premium</a></p>\\\\\";s:7:\\\\\"options\\\\\";a:9:{s:4:\\\\\"type\\\\\";s:29:\\\\\"notice-warning is-dismissible\\\\\";s:2:\\\\\"id\\\\\";s:0:\\\\\"\\\\\";s:5:\\\\\"nonce\\\\\";N;s:8:\\\\\"priority\\\\\";d:0.5;s:9:\\\\\"data_json\\\\\";a:0:{}s:13:\\\\\"dismissal_key\\\\\";N;s:12:\\\\\"capabilities\\\\\";a:1:{i:0;s:20:\\\\\"wpseo_manage_options\\\\\";}s:16:\\\\\"capability_check\\\\\";s:3:\\\\\"all\\\\\";s:14:\\\\\"yoast_branding\\\\\";b:1;}}i:1;a:2:{s:7:\\\\\"message\\\\\";s:569:\\\\\"<h2>Make sure you don\\\\'t miss out on traffic!</h2><p>You just binned a Product. Search engines and other websites can still send traffic to your deleted post. You should create a redirect to ensure your visitors do not get a 404 error when they click on the no longer working URL. With Yoast SEO Premium, you can easily create such redirects.</p><p><a class=\\\\\"button-primary\\\\\" href=\\\\\"https://yoa.st/1d0?php_version=7.1.21&platform=wordpress&platform_version=4.9.8&software=free&software_version=8.1&role=unknown&days_active=72\\\\\" target=\\\\\"_blank\\\\\">Get Yoast SEO Premium</a></p>\\\\\";s:7:\\\\\"options\\\\\";a:9:{s:4:\\\\\"type\\\\\";s:29:\\\\\"notice-warning is-dismissible\\\\\";s:2:\\\\\"id\\\\\";s:0:\\\\\"\\\\\";s:5:\\\\\"nonce\\\\\";N;s:8:\\\\\"priority\\\\\";d:0.5;s:9:\\\\\"data_json\\\\\";a:0:{}s:13:\\\\\"dismissal_key\\\\\";N;s:12:\\\\\"capabilities\\\\\";a:1:{i:0;s:20:\\\\\"wpseo_manage_options\\\\\";}s:16:\\\\\"capability_check\\\\\";s:3:\\\\\"all\\\\\";s:14:\\\\\"yoast_branding\\\\\";b:1;}}i:2;a:2:{s:7:\\\\\"message\\\\\";s:569:\\\\\"<h2>Make sure you don\\\\'t miss out on traffic!</h2><p>You just binned a Product. Search engines and other websites can still send traffic to your deleted post. You should create a redirect to ensure your visitors do not get a 404 error when they click on the no longer working URL. With Yoast SEO Premium, you can easily create such redirects.</p><p><a class=\\\\\"button-primary\\\\\" href=\\\\\"https://yoa.st/1d0?php_version=7.1.21&platform=wordpress&platform_version=4.9.8&software=free&software_version=8.1&role=unknown&days_active=72\\\\\" target=\\\\\"_blank\\\\\">Get Yoast SEO Premium</a></p>\\\\\";s:7:\\\\\"options\\\\\";a:9:{s:4:\\\\\"type\\\\\";s:29:\\\\\"notice-warning is-dismissible\\\\\";s:2:\\\\\"id\\\\\";s:0:\\\\\"\\\\\";s:5:\\\\\"nonce\\\\\";N;s:8:\\\\\"priority\\\\\";d:0.5;s:9:\\\\\"data_json\\\\\";a:0:{}s:13:\\\\\"dismissal_key\\\\\";N;s:12:\\\\\"capabilities\\\\\";a:1:{i:0;s:20:\\\\\"wpseo_manage_options\\\\\";}s:16:\\\\\"capability_check\\\\\";s:3:\\\\\"all\\\\\";s:14:\\\\\"yoast_branding\\\\\";b:1;}}i:3;a:2:{s:7:\\\\\"message\\\\\";s:569:\\\\\"<h2>Make sure you don\\\\'t miss out on traffic!</h2><p>You just binned a Product. Search engines and other websites can still send traffic to your deleted post. You should create a redirect to ensure your visitors do not get a 404 error when they click on the no longer working URL. With Yoast SEO Premium, you can easily create such redirects.</p><p><a class=\\\\\"button-primary\\\\\" href=\\\\\"https://yoa.st/1d0?php_version=7.1.21&platform=wordpress&platform_version=4.9.8&software=free&software_version=8.1&role=unknown&days_active=72\\\\\" target=\\\\\"_blank\\\\\">Get Yoast SEO Premium</a></p>\\\\\";s:7:\\\\\"options\\\\\";a:9:{s:4:\\\\\"type\\\\\";s:29:\\\\\"notice-warning is-dismissible\\\\\";s:2:\\\\\"id\\\\\";s:0:\\\\\"\\\\\";s:5:\\\\\"nonce\\\\\";N;s:8:\\\\\"priority\\\\\";d:0.5;s:9:\\\\\"data_json\\\\\";a:0:{}s:13:\\\\\"dismissal_key\\\\\";N;s:12:\\\\\"capabilities\\\\\";a:1:{i:0;s:20:\\\\\"wpseo_manage_options\\\\\";}s:16:\\\\\"capability_check\\\\\";s:3:\\\\\"all\\\\\";s:14:\\\\\"yoast_branding\\\\\";b:1;}}i:4;a:2:{s:7:\\\\\"message\\\\\";s:569:\\\\\"<h2>Make sure you don\\\\'t miss out on traffic!</h2><p>You just binned a Product. Search engines and other websites can still send traffic to your deleted post. You should create a redirect to ensure your visitors do not get a 404 error when they click on the no longer working URL. With Yoast SEO Premium, you can easily create such redirects.</p><p><a class=\\\\\"button-primary\\\\\" href=\\\\\"https://yoa.st/1d0?php_version=7.1.21&platform=wordpress&platform_version=4.9.8&software=free&software_version=8.1&role=unknown&days_active=72\\\\\" target=\\\\\"_blank\\\\\">Get Yoast SEO Premium</a></p>\\\\\";s:7:\\\\\"options\\\\\";a:9:{s:4:\\\\\"type\\\\\";s:29:\\\\\"notice-warning is-dismissible\\\\\";s:2:\\\\\"id\\\\\";s:0:\\\\\"\\\\\";s:5:\\\\\"nonce\\\\\";N;s:8:\\\\\"priority\\\\\";d:0.5;s:9:\\\\\"data_json\\\\\";a:0:{}s:13:\\\\\"dismissal_key\\\\\";N;s:12:\\\\\"capabilities\\\\\";a:1:{i:0;s:20:\\\\\"wpseo_manage_options\\\\\";}s:16:\\\\\"capability_check\\\\\";s:3:\\\\\"all\\\\\";s:14:\\\\\"yoast_branding\\\\\";b:1;}}i:5;a:2:{s:7:\\\\\"message\\\\\";s:569:\\\\\"<h2>Make sure you don\\\\'t miss out on traffic!</h2><p>You just binned a Product. Search engines and other websites can still send traffic to your deleted post. You should create a redirect to ensure your visitors do not get a 404 error when they click on the no longer working URL. With Yoast SEO Premium, you can easily create such redirects.</p><p><a class=\\\\\"button-primary\\\\\" href=\\\\\"https://yoa.st/1d0?php_version=7.1.21&platform=wordpress&platform_version=4.9.8&software=free&software_version=8.1&role=unknown&days_active=72\\\\\" target=\\\\\"_blank\\\\\">Get Yoast SEO Premium</a></p>\\\\\";s:7:\\\\\"options\\\\\";a:9:{s:4:\\\\\"type\\\\\";s:29:\\\\\"notice-warning is-dismissible\\\\\";s:2:\\\\\"id\\\\\";s:0:\\\\\"\\\\\";s:5:\\\\\"nonce\\\\\";N;s:8:\\\\\"priority\\\\\";d:0.5;s:9:\\\\\"data_json\\\\\";a:0:{}s:13:\\\\\"dismissal_key\\\\\";N;s:12:\\\\\"capabilities\\\\\";a:1:{i:0;s:20:\\\\\"wpseo_manage_options\\\\\";}s:16:\\\\\"capability_check\\\\\";s:3:\\\\\"all\\\\\";s:14:\\\\\"yoast_branding\\\\\";b:1;}}i:6;a:2:{s:7:\\\\\"message\\\\\";s:569:\\\\\"<h2>Make sure you don\\\\'t miss out on traffic!</h2><p>You just binned a Product. Search engines and other websites can still send traffic to your deleted post. You should create a redirect to ensure your visitors do not get a 404 error when they click on the no longer working URL. With Yoast SEO Premium, you can easily create such redirects.</p><p><a class=\\\\\"button-primary\\\\\" href=\\\\\"https://yoa.st/1d0?php_version=7.1.21&platform=wordpress&platform_version=4.9.8&software=free&software_version=8.1&role=unknown&days_active=72\\\\\" target=\\\\\"_blank\\\\\">Get Yoast SEO Premium</a></p>\\\\\";s:7:\\\\\"options\\\\\";a:9:{s:4:\\\\\"type\\\\\";s:29:\\\\\"notice-warning is-dismissible\\\\\";s:2:\\\\\"id\\\\\";s:0:\\\\\"\\\\\";s:5:\\\\\"nonce\\\\\";N;s:8:\\\\\"priority\\\\\";d:0.5;s:9:\\\\\"data_json\\\\\";a:0:{}s:13:\\\\\"dismissal_key\\\\\";N;s:12:\\\\\"capabilities\\\\\";a:1:{i:0;s:20:\\\\\"wpseo_manage_options\\\\\";}s:16:\\\\\"capability_check\\\\\";s:3:\\\\\"all\\\\\";s:14:\\\\\"yoast_branding\\\\\";b:1;}}i:7;a:2:{s:7:\\\\\"message\\\\\";s:569:\\\\\"<h2>Make sure y...`\r\n\r\n\r\n### How can we reproduce this behavior?\r\nUse API to delete products in bulk\r\n\r\nCan you provide a link to a page which shows this issue?\r\nN/A\r\n\r\n### Technical info\r\n* WordPress version: 4.9.8\r\n* WooCommerce version: 3.4.5\r\n* Yoast SEO version: 8.2\r\n* Yoast SEO WooCommerce version: 8.2\r\n"}}
{"actor":{"display_login":"devonto"}}