{"id":12779207,"date":"2020-05-04T16:33:16","date_gmt":"2020-05-04T16:33:16","guid":{"rendered":"https:\/\/wordpress.org\/support\/topic\/sql-error-45\/"},"modified":"2020-05-04T16:33:16","modified_gmt":"2020-05-04T16:33:16","slug":"sql-error-45","status":"publish","type":"topic","link":"https:\/\/wordpress.org\/support\/topic\/sql-error-45\/","title":{"rendered":"sql error"},"content":{"rendered":"<p>Dear sirs,<\/p>\n<p>I tried to duplicate my beta environment to production one and after a while the log shows this error:<\/p>\n<p>[04\/May\/2020:11:58:50] ERROR SQL ON : UPDATE <code>wp_3_options<\/code> SET <code>option_name<\/code> = &#8216;wp_3_user_roles&#8217; WHERE <code>option_name<\/code> = &#8216;wp_2_user_roles&#8217;<br \/>\n[04\/May\/2020:11:58:50] WPDB ERROR : Duplicate entry &#8216;wp_3_user_roles&#8217; for key &#8216;option_name&#8217;<br \/>\n[04\/May\/2020:11:58:50] Duplication interrupted on SQL ERROR<\/p>\n<p>Why there is this duplicate entry?<\/p>\n<p>Thanks for developing this awesome product and for your support!<\/p>\n<p>Kind regards,<\/p>\n<p>Frank<\/p>\n","protected":false},"template":"","class_list":["post-12779207","topic","type-topic","status-publish","hentry"],"jetpack_sharing_enabled":true,"_links":{"self":[{"href":"https:\/\/wordpress.org\/support\/wp-json\/wp\/v2\/topic\/12779207","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/wordpress.org\/support\/wp-json\/wp\/v2\/topic"}],"about":[{"href":"https:\/\/wordpress.org\/support\/wp-json\/wp\/v2\/types\/topic"}],"version-history":[{"count":0,"href":"https:\/\/wordpress.org\/support\/wp-json\/wp\/v2\/topic\/12779207\/revisions"}],"wp:attachment":[{"href":"https:\/\/wordpress.org\/support\/wp-json\/wp\/v2\/media?parent=12779207"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}