Title: sql error
Last modified: May 4, 2020

---

# sql error

 *  [frankcast1e](https://wordpress.org/support/users/frankcast1e/)
 * (@frankcast1e)
 * [6 years, 1 month ago](https://wordpress.org/support/topic/sql-error-45/)
 * Dear sirs,
 * I tried to duplicate my beta environment to production one and after a while 
   the log shows this error:
 * [04/May/2020:11:58:50] ERROR SQL ON : UPDATE `wp_3_options` SET `option_name`
   = ‘wp_3_user_roles’ WHERE `option_name` = ‘wp_2_user_roles’
    [04/May/2020:11:
   58:50] WPDB ERROR : Duplicate entry ‘wp_3_user_roles’ for key ‘option_name’ [
   04/May/2020:11:58:50] Duplication interrupted on SQL ERROR
 * Why there is this duplicate entry?
 * Thanks for developing this awesome product and for your support!
 * Kind regards,
 * Frank
 * The page I need help with: _[[log in](https://login.wordpress.org/?redirect_to=https%3A%2F%2Fwordpress.org%2Fsupport%2Ftopic%2Fsql-error-45%2F%3Foutput_format%3Dmd&locale=en_US)
   to see the link]_

The topic ‘sql error’ is closed to new replies.

 * ![](https://ps.w.org/multisite-clone-duplicator/assets/icon-256x256.png?rev=1011466)
 * [MultiSite Clone Duplicator](https://wordpress.org/plugins/multisite-clone-duplicator/)
 * [Frequently Asked Questions](https://wordpress.org/plugins/multisite-clone-duplicator/#faq)
 * [Support Threads](https://wordpress.org/support/plugin/multisite-clone-duplicator/)
 * [Active Topics](https://wordpress.org/support/plugin/multisite-clone-duplicator/active/)
 * [Unresolved Topics](https://wordpress.org/support/plugin/multisite-clone-duplicator/unresolved/)
 * [Reviews](https://wordpress.org/support/plugin/multisite-clone-duplicator/reviews/)

 * 0 replies
 * 1 participant
 * Last reply from: [frankcast1e](https://wordpress.org/support/users/frankcast1e/)
 * Last activity: [6 years, 1 month ago](https://wordpress.org/support/topic/sql-error-45/)
 * Status: not resolved