{"action":"closed","issue":{"url":"https://api.github.com/repos/woocommerce/woocommerce/issues/12222","repository_url":"https://api.github.com/repos/woocommerce/woocommerce","labels_url":"https://api.github.com/repos/woocommerce/woocommerce/issues/12222/labels{/name}","comments_url":"https://api.github.com/repos/woocommerce/woocommerce/issues/12222/comments","events_url":"https://api.github.com/repos/woocommerce/woocommerce/issues/12222/events","html_url":"https://github.com/woocommerce/woocommerce/issues/12222","id":186146751,"number":12222,"title":"WordPress database error – Duplicate key name","user":{"login":"decarvalhoaa","id":14371822,"avatar_url":"https://avatars.githubusercontent.com/u/14371822?v=3","gravatar_id":"","url":"https://api.github.com/users/decarvalhoaa","html_url":"https://github.com/decarvalhoaa","followers_url":"https://api.github.com/users/decarvalhoaa/followers","following_url":"https://api.github.com/users/decarvalhoaa/following{/other_user}","gists_url":"https://api.github.com/users/decarvalhoaa/gists{/gist_id}","starred_url":"https://api.github.com/users/decarvalhoaa/starred{/owner}{/repo}","subscriptions_url":"https://api.github.com/users/decarvalhoaa/subscriptions","organizations_url":"https://api.github.com/users/decarvalhoaa/orgs","repos_url":"https://api.github.com/users/decarvalhoaa/repos","events_url":"https://api.github.com/users/decarvalhoaa/events{/privacy}","received_events_url":"https://api.github.com/users/decarvalhoaa/received_events","type":"User","site_admin":false},"labels":[],"state":"closed","locked":false,"assignee":null,"assignees":[],"milestone":null,"comments":2,"created_at":"2016-10-30T16:37:29Z","updated_at":"2016-10-30T16:55:45Z","closed_at":"2016-10-30T16:55:45Z","body":"## EXPLANATION OF THE ISSUE\r\n\r\nI have notice during the upgrade of both Version 2.6.6 and 2.6.7 the following PHP notice in my logs, with debug on.\r\n\r\n```\r\n[28-Oct-2016 15:16:41 UTC] WordPress database error Duplicate key name 'location_type_code' for query ALTER TABLE wp_woocommerce_tax_rate_locations ADD KEY 'location_type_code' ('location_type'(40),'location_code'(90)) made by require_once('wp-load.php'), require_once('wp-config.php'), require_once('wp-settings.php'), do_action('init'), call_user_func_array, WC_Install::check_version, WC_Install::install, WC_Install::create_tables, dbDelta\r\n[28-Oct-2016 15:16:41 UTC] WordPress database error Duplicate key name 'location_type_code' for query ALTER TABLE wp_woocommerce_shipping_zone_locations ADD KEY 'location_type_code' ('location_type'(40),'location_code'(90)) made by require_once('wp-load.php'), require_once('wp-config.php'), require_once('wp-settings.php'), do_action('init'), call_user_func_array, WC_Install::check_version, WC_Install::install, WC_Install::create_tables, dbDelta\r\n```\r\nIt only happens during the update. During normal operations, there is no issue, but I don’t know whether this can have side effects.\r\nCan this be reproduce at your end?\r\n\r\n## STEPS TO REPRODUCE THE ISSUE\r\n\r\nUpgrade WooCommerce from 2.6.5 to 2.6.6 or from 2.6.6 to 2.6.7 at  Admin > Dashboard > Updates\r\n\r\n## SYSTEM STATUS REPORT\r\n\r\n`\r\n### WordPress Environment ###\r\n\r\nHome URL: https://virtualbox-mageia.carvalho-pc/wordpress\r\nSite URL: https://virtualbox-mageia.carvalho-pc/wordpress\r\nWC Version: 2.6.7\r\nLog Directory Writable: ✔\r\nWP Version: 4.6.1\r\nWP Multisite: –\r\nWP Memory Limit: 128 MB\r\nWP Debug Mode: ✔\r\nWP Cron: ✔\r\nLanguage: en_GB\r\n\r\n### Server Environment ###\r\n\r\nServer Info: Apache/2.4.10 (Mageia) OpenSSL/1.0.2j PHP/5.6.27\r\nPHP Version: 5.6.27\r\nPHP Post Max Size: 8 MB\r\nPHP Time Limit: 30\r\nPHP Max Input Vars: 1000\r\ncURL Version: 7.40.0\r\nOpenSSL/1.0.2j\r\n\r\nSUHOSIN Installed: –\r\nMax Upload Size: 8 MB\r\nDefault Timezone is UTC: ✔\r\nfsockopen/cURL: ✔\r\nSoapClient: ✔\r\nDOMDocument: ✔\r\nGZip: ✔\r\nMultibyte String: ✔\r\nRemote Post: ✔\r\nRemote Get: ✔\r\n\r\n### Database ###\r\n\r\nWC Database Version: 2.6.7\r\n: \r\nwoocommerce_sessions: ✔\r\nwoocommerce_api_keys: ✔\r\nwoocommerce_attribute_taxonomies: ✔\r\nwoocommerce_downloadable_product_permissions: ✔\r\nwoocommerce_order_items: ✔\r\nwoocommerce_order_itemmeta: ✔\r\nwoocommerce_tax_rates: ✔\r\nwoocommerce_tax_rate_locations: ✔\r\nwoocommerce_shipping_zones: ✔\r\nwoocommerce_shipping_zone_locations: ✔\r\nwoocommerce_shipping_zone_methods: ✔\r\nwoocommerce_payment_tokens: ✔\r\nwoocommerce_payment_tokenmeta: ✔\r\nMaxMind GeoIP Database: ✔\r\n\r\n### Active Plugins (33) ###\r\n\r\nPolylang: by Frédéric Demarle – 2.0.7\r\nAll In One SEO Pack: by Michael Torbert – 2.3.10.2\r\nALO EasyMail Newsletter: by Alessandro Massasso – 2.9.3\r\nWP Offload S3 Lite: by Delicious Brains – 1.1.1\r\nAmazon Web Services: by Delicious Brains – 1.0\r\nAutoptimize: by Frank Goossens (futtta) – 2.1.0\r\nBackWPup: by Inpsyde GmbH – 3.3.4\r\nContact Form 7: by Takayuki Miyoshi – 4.5.1\r\nCookie Notice: by dFactory – 1.2.36.1\r\nEvents Maker: by dFactory – 1.6.12\r\nHomepage Control: by WooThemes – 2.0.2\r\nLoco Translate: by Tim Whitlock – 2.0.9\r\nMaintenance Page: by ThemeGrill – 1.0.8\r\nPostman SMTP: by Jason Hendriks – 1.7.2\r\nRegenerate Thumbnails: by Alex Mills (Viper007Bond) – 2.2.6\r\nRemove query strings from static resources: by Your WP Expert – 1.3.1\r\nShariff Wrapper: by Jan-Peter Lambeck & 3UU – 4.3.0\r\nStorefront Footer Bar: by WooThemes – 1.0.3\r\nStorefront Parallax Hero Polylang Integration: by Antonio de Carvalho – 1.0.0\r\nStorefront Parallax Hero: by WooThemes – 1.5.3\r\nStorefront Reviews: by WooThemes – 1.0.2\r\nTipu Scroll To Top: by Zubair Mushtaq – 2.6\r\nHyyan WooCommerce Polylang Integration: by Hyyan Abo Fakher – 0.30 (Not released)\r\nWooCommerce PDF Invoices & Packing Slips: by Ewout Fernhout – 1.5.37\r\nWooCommerce PDF Invoices & Packing Slips Professional: by Ewout Fernhout – 1.4.6\r\nWooCommerce Product SKU Generator: by SkyVerge – 2.2.0\r\nWooCommerce Sequential Order Numbers: by SkyVerge – 1.7.0\r\nWooCommerce Shipping Estimates: by SkyVerge – 2.0.0\r\nWooCommerce: by WooThemes – 2.6.7\r\nWooCommerce Helper: by WooCommerce – 1.7.1\r\nWP-Lister Lite for eBay: by Matthias Krok – 2.0.13\r\nWP Smush: by WPMU DEV – 2.4.5\r\nWP Overnight Sidekick: by Jeremiah Prummer – 1.0.1\r\n\r\n### Settings ###\r\n\r\nForce SSL: –\r\nCurrency: EUR (€)\r\nCurrency Position: right_space\r\nThousand Separator: .\r\nDecimal Separator: ,\r\nNumber of Decimals: 2\r\n\r\n### API ###\r\n\r\nAPI Enabled: ✔\r\n\r\n### WC Pages ###\r\n\r\nShop Base: #8 - /en/shop/\r\nBasket: #9 - /en/cart/\r\nCheckout: #10 - /en/checkout/\r\nMy Account: #11 - /en/my-account/\r\n\r\n### Taxonomies ###\r\n\r\nProduct Types: external (external)\r\ngrouped (grouped)\r\nsimple (simple)\r\nvariable (variable)\r\n\r\n\r\n### Theme ###\r\n\r\nName: Storefront Child Theme\r\nVersion: 1.1.0\r\nAuthor URL: https://github.com/decarvalhoaa\r\nChild Theme: ✔\r\nParent Theme Name: Storefront\r\nParent Theme Version: 2.1.5\r\nParent Theme Author URL: https://woocommerce.com/\r\nWooCommerce Support: ✔\r\n\r\n### Templates ###\r\n\r\nOverrides: storefront-child-theme-master/woocommerce/checkout/terms.php\r\n`"}}
{"actor":{"display_login":"mikejolley"}}