{"action":"created","issue":{"url":"https://api.github.com/repos/GlotPress/GlotPress-WP/issues/342","repository_url":"https://api.github.com/repos/GlotPress/GlotPress-WP","labels_url":"https://api.github.com/repos/GlotPress/GlotPress-WP/issues/342/labels{/name}","comments_url":"https://api.github.com/repos/GlotPress/GlotPress-WP/issues/342/comments","events_url":"https://api.github.com/repos/GlotPress/GlotPress-WP/issues/342/events","html_url":"https://github.com/GlotPress/GlotPress-WP/issues/342","id":140891521,"number":342,"title":"PHP message: WordPress database error Duplicate key name 'warnings' for query ALTER TABLE rtc_wp_gp_translations ADD KEY warnings","user":{"login":"gau1991","id":1296181,"avatar_url":"https://avatars.githubusercontent.com/u/1296181?v=3","gravatar_id":"","url":"https://api.github.com/users/gau1991","html_url":"https://github.com/gau1991","followers_url":"https://api.github.com/users/gau1991/followers","following_url":"https://api.github.com/users/gau1991/following{/other_user}","gists_url":"https://api.github.com/users/gau1991/gists{/gist_id}","starred_url":"https://api.github.com/users/gau1991/starred{/owner}{/repo}","subscriptions_url":"https://api.github.com/users/gau1991/subscriptions","organizations_url":"https://api.github.com/users/gau1991/orgs","repos_url":"https://api.github.com/users/gau1991/repos","events_url":"https://api.github.com/users/gau1991/events{/privacy}","received_events_url":"https://api.github.com/users/gau1991/received_events","type":"User","site_admin":false},"labels":[{"url":"https://api.github.com/repos/GlotPress/GlotPress-WP/labels/bug","name":"bug","color":"fc2929"},{"url":"https://api.github.com/repos/GlotPress/GlotPress-WP/labels/has%20PR","name":"has PR","color":"bfe5bf"}],"state":"closed","locked":false,"assignee":{"login":"toolstack","id":9053749,"avatar_url":"https://avatars.githubusercontent.com/u/9053749?v=3","gravatar_id":"","url":"https://api.github.com/users/toolstack","html_url":"https://github.com/toolstack","followers_url":"https://api.github.com/users/toolstack/followers","following_url":"https://api.github.com/users/toolstack/following{/other_user}","gists_url":"https://api.github.com/users/toolstack/gists{/gist_id}","starred_url":"https://api.github.com/users/toolstack/starred{/owner}{/repo}","subscriptions_url":"https://api.github.com/users/toolstack/subscriptions","organizations_url":"https://api.github.com/users/toolstack/orgs","repos_url":"https://api.github.com/users/toolstack/repos","events_url":"https://api.github.com/users/toolstack/events{/privacy}","received_events_url":"https://api.github.com/users/toolstack/received_events","type":"User","site_admin":false},"milestone":{"url":"https://api.github.com/repos/GlotPress/GlotPress-WP/milestones/3","html_url":"https://github.com/GlotPress/GlotPress-WP/milestones/1.1","labels_url":"https://api.github.com/repos/GlotPress/GlotPress-WP/milestones/3/labels","id":1395669,"number":3,"title":"1.1","description":"","creator":{"login":"ocean90","id":617637,"avatar_url":"https://avatars.githubusercontent.com/u/617637?v=3","gravatar_id":"","url":"https://api.github.com/users/ocean90","html_url":"https://github.com/ocean90","followers_url":"https://api.github.com/users/ocean90/followers","following_url":"https://api.github.com/users/ocean90/following{/other_user}","gists_url":"https://api.github.com/users/ocean90/gists{/gist_id}","starred_url":"https://api.github.com/users/ocean90/starred{/owner}{/repo}","subscriptions_url":"https://api.github.com/users/ocean90/subscriptions","organizations_url":"https://api.github.com/users/ocean90/orgs","repos_url":"https://api.github.com/users/ocean90/repos","events_url":"https://api.github.com/users/ocean90/events{/privacy}","received_events_url":"https://api.github.com/users/ocean90/received_events","type":"User","site_admin":false},"open_issues":18,"closed_issues":75,"state":"open","created_at":"2015-11-05T14:38:26Z","updated_at":"2016-03-15T14:26:02Z","due_on":null,"closed_at":null},"comments":3,"created_at":"2016-03-15T07:04:33Z","updated_at":"2016-03-15T14:27:26Z","closed_at":"2016-03-15T14:26:01Z","body":"**Information:**\r\nPHP Version: PHP 5.6.19\r\nMariaDB Version: 10.1.12 \r\nWordPress Version:  4.4.2\r\n\r\n**Issue:**\r\nWhile converting a standalone install to the WordPress plugin getting error as:\r\n```\r\n2016/03/15 12:18:00 [error] 9781#9781: *180885 FastCGI sent in stderr: \"PHP message: WordPress database error Duplicate key name 'warnings' for query ALTER TABLE wp_gp_translations ADD KEY warnings (warnings (1)) made by activate_plugin, include_once('/plugins/glotpress/glotpress.php'), require_once('/plugins/glotpress/gp-settings.php'), gp_upgrade_db, dbDelta\r\nPHP message: WordPress database error Duplicate key name 'project_id_slug_locale' for query ALTER TABLE wp_gp_translation_sets ADD UNIQUE KEY project_id_slug_locale (project_id, slug(171), locale) made by activate_plugin, include_once('/plugins/glotpress/glotpress.php'), require_once('/plugins/glotpress/gp-settings.php'), gp_upgrade_db, dbDelta\r\nPHP message: WordPress database error You have an error in your SQL syntax; check the manual that corresponds to your MariaDB server version for the right syntax to use near 'references `references` TEXT DEFAULT NULL' at line 1 for query ALTER TABLE wp_gp_originals CHANGE COLUMN references `references` TEXT DEFAULT NULL made by activate_plugin, include_once('/plugins/glotpress/glotpress.php'), require_once('/plugins/glotpress/gp-settings.php'), gp_upgrade_db, dbDelta\r\nPHP message: WordPress database error Duplicate key name 'object_type__meta_key' for query ALTER TABLE wp_gp_meta ADD KEY object_type__meta_key (object_type, meta_key) made by activate_plugin, include_once('/plugins/glotpress/glotpress.php'), require_once('/plugins/glotpress/gp-settings.php'), gp_upgrade_db, dbDelta\r\nPHP message: WordPress database error Duplicate key name 'object_type__object_id__meta_key' for query ALTER TABLE wp_gp_meta ADD KEY object_type__object_id__meta_key (object_type, object_id, meta_key) made by activate_plugin, include_once('/plugins/glotpress/glotpress.php'), require_once('/plugins/glotpress/gp-settings.php'), gp_upgrade_db, dbDelta\" while reading response header from upstream, client: x.x.x.x, server: example.com, request: \"GET /wp-admin/plugins.php?action=activate&plugin=glotpress%2Fglotpress.php&_w\r\n```\r\n\r\nWe used https://github.com/GlotPress/GlotPress-WP/wiki/1.3-Convert-a-standalone-install-to-the-WordPress-plugin for conversion. "},"comment":{"url":"https://api.github.com/repos/GlotPress/GlotPress-WP/issues/comments/196844877","html_url":"https://github.com/GlotPress/GlotPress-WP/issues/342#issuecomment-196844877","issue_url":"https://api.github.com/repos/GlotPress/GlotPress-WP/issues/342","id":196844877,"user":{"login":"ocean90","id":617637,"avatar_url":"https://avatars.githubusercontent.com/u/617637?v=3","gravatar_id":"","url":"https://api.github.com/users/ocean90","html_url":"https://github.com/ocean90","followers_url":"https://api.github.com/users/ocean90/followers","following_url":"https://api.github.com/users/ocean90/following{/other_user}","gists_url":"https://api.github.com/users/ocean90/gists{/gist_id}","starred_url":"https://api.github.com/users/ocean90/starred{/owner}{/repo}","subscriptions_url":"https://api.github.com/users/ocean90/subscriptions","organizations_url":"https://api.github.com/users/ocean90/orgs","repos_url":"https://api.github.com/users/ocean90/repos","events_url":"https://api.github.com/users/ocean90/events{/privacy}","received_events_url":"https://api.github.com/users/ocean90/received_events","type":"User","site_admin":false},"created_at":"2016-03-15T14:27:26Z","updated_at":"2016-03-15T14:27:26Z","body":">  however the \"SQL syntax\" error is unfortunately not possible to fix at this time due to how dbDelta() handles backticks\r\n\r\nUpstream ticket: https://core.trac.wordpress.org/ticket/20263"}}