Title: Unique Key Constraints errors, WP 3.5.1
Last modified: August 20, 2016

---

# Unique Key Constraints errors, WP 3.5.1

 *  [mwoolums](https://wordpress.org/support/users/mwoolums/)
 * (@mwoolums)
 * [13 years, 1 month ago](https://wordpress.org/support/topic/unique-key-constraints-errors-wp-351/)
 * I updated a site to WP 3.5.1 and am now getting frequent errors “WordPress database
   error 23000”. Example copied below. We are running Windows Server 2008R2 and 
   SQL 2012. Using DB Abstraction 1.14 with corrections listed in this thread:
    
   [http://wordpress.org/support/topic/fresh-wp-35-install-not-compatible](http://wordpress.org/support/topic/fresh-wp-35-install-not-compatible)
 * Same error cropping up for various sites all running different themes, plugins.
   Any suggestions on where to look would be helpful. Thanks!
    Matthew
 * [03-Apr-2013 14:12:44 UTC] WordPress database error 23000 : [Microsoft][SQL Server
   Native Client 11.0][SQL Server]Violation of UNIQUE KEY constraint ‘wp_options_option_name’.
   Cannot insert duplicate key in object ‘dbo.wp_options’. The duplicate key value
   is (rewrite_rules). for query INSERT INTO wp_options (option_name, option_value,
   autoload) VALUES ( N’rewrite_rules’, N’a:91:{s:47:”category/(.+?)/feed/(feed|
   rdf|rss|rss2|atom)/?$”;s:52:”index.php?category_name=$matches[1]&feed=$matches[
   2]”;s:42:”category/(.+?)/(feed|rdf|rss|rss2|atom)/?$”;s:52:”index.php?category_name
   =$matches[1]&feed=$matches[2]”;s:35:”category/(.+?)/page/?([0-9]{1,})/?$”;s:53:”
   index.php?category_name=$matches[1]&paged=$matches[2]”;s:17:”category/(.+?)/?
   $”;s:35:”index.php?category_name=$matches[1]”;s:44:”tag/([^/]+)/feed/(feed|rdf
   |rss|rss2|atom)/?$”;s:42:”index.php?tag=$matches[1]&feed=$matches[2]”;s:39:”tag/([
   ^/]+)/(feed|rdf|rss|rss2|atom)/?$”;s:42:”index.php?tag=$matches[1]&feed=$matches[
   2]”;s:32:”tag/([^/]+)/page/?([0-9]{1,})/?$”;s:43:”index.php?tag=$matches[1]&paged
   =$matches[2]”;s:14:”tag/([^/]+)/?$”;s:25:”index.php?tag=$matches[1]”;s:45:”type/([
   ^/]+)/feed/(feed|rdf|rss|rss2|atom)/?$”;s:50:”index.php?post_format=$matches[
   1]&feed=$matches[2]”;s:40:”type/([^/]+)/(feed|rdf|rss|rss2|atom)/?$”;s:50:”index.
   php?post_format=$matches[1]&feed=$matches[2]”;s:33:”type/([^/]+)/page/?([0-9]{
   1,})/?$”;s:51:”index.php?post_format=$matches[1]&paged=$matches[2]”;s:15:”type/([
   ^/]+)/?$”;s:33:”index.php?post_format=$matches[1]”;s:37:”portfolio/[^/]+/attachment/([
   ^/]+)/?$”;s:32:”index.php?attachment=$matches[1]”;s:47:”portfolio/[^/]+/attachment/([
   ^/]+)/trackback/?$”;s:37:”index.php?attachment=$matches[1]&tb=1″;s:67:”portfolio/[
   ^/]+/attachment/([^/]+)/feed/(feed|rdf|rss|rss2|atom)/?$”;s:49:”index.php?attachment
   =$matches[1]&feed=$matches[2]”;s:62:”portfolio/[^/]+/attachment/([^/]+)/(feed
   |rdf|rss|rss2|atom)/?$”;s:49:”index.php?attachment=$matches[1]&feed=$matches[
   2]”;s:62:”portfolio/[^/]+/attachment/([^/]+)/comment-page-([0-9]{1,})/?$”;s:50:”
   index.php?attachment=$matches[1]&cpage=$matches[2]”;s:30:”portfolio/([^/]+)/trackback/?
   $”;s:51:”index.php?post_type=portfolio&name=$matches[1]&tb=1″;s:50:”portfolio/([
   ^/]+)/feed/(feed|rdf|rss|rss2|atom)/?$”;s:63:”index.php?post_type=portfolio&name
   =$matches[1]&feed=$matches[2]”;s:45:”portfolio/([^/]+)/(feed|rdf|rss|rss2|atom)/?
   $”;s:63:”index.php?post_type=portfolio&name=$matches[1]&feed=$matches[2]”;s:38:”
   portfolio/([^/]+)/page/?([0-9]{1,})/?$”;s:64:”index.php?post_type=portfolio&name
   =$matches[1]&paged=$matches[2]”;s:45:”portfolio/([^/]+)/comment-page-([0-9]{1,})/?
   $”;s:64:”index.php?post_type=portfolio&name=$matches[1]&cpage=$matches[2]”;s:
   30:”portfolio/([^/]+)(/[0-9]+)?/?$”;s:63:”index.php?post_type=portfolio&name=
   $matches[1]&page=$matches[2]”;s:26:”portfolio/[^/]+/([^/]+)/?$”;s:32:”index.php?
   attachment=$matches[1]”;s:36:”portfolio/[^/]+/([^/]+)/trackback/?$”;s:37:”index.
   php?attachment=$matches[1]&tb=1″;s:56:”portfolio/[^/]+/([^/]+)/feed/(feed|rdf
   |rss|rss2|atom)/?$”;s:49:”index.php?attachment=$matches[1]&feed=$matches[2]”;
   s:51:”portfolio/[^/]+/([^/]+)/(feed|rdf|rss|rss2|atom)/?$”;s:49:”index.php?attachment
   =$matches[1]&feed=$matches[2]”;s:51:”portfolio/[^/]+/([^/]+)/comment-page-([0-
   9]{1,})/?$”;s:50:”index.php?attachment=$matches[1]&cpage=$matches[2]”;s:12:”robots&#
   9 2;.txt$”;s:18:”index.php?robots=1″;s:48:”.*wp-(atom|rdf|rss|rss2|feed|commentsrss2)&#
   9 2;.php$”;s:18:”index.php?feed=old”;s:20:”.*wp-app& # 9 2;.php(/.*)?$”;s:19:”
   index.php?error=403″;s:18:”.*wp-register.php$”;s:23:”index.php?register=true”;
   s:32:”feed/(feed|rdf|rss|rss2|atom)/?$”;s:27:”index.php?&feed=$matches[1]”;s:
   27:”(feed|rdf|rss|rss2|atom)/?$”;s:27:”index.php?&feed=$matches[1]”;s:20:”page/?([
   0-9]{1,})/?$”;s:28:”index.php?&paged=$matches[1]”;s:27:”comment-page-([0-9]{1,})/?
   $”;s:40:”index.php?&page_id=430&cpage=$matches[1]”;s:41:”comments/feed/(feed|
   rdf|rss|rss2|atom)/?$”;s:42:”index.php?&feed=$matches[1]&withcomments=1″;s:36:”
   comments/(feed|rdf|rss|rss2|atom)/?$”;s:42:”index.php?&feed=$matches[1]&withcomments
   =1″;s:29:”comments/page/?([0-9]{1,})/?$”;s:28:”index.php?&paged=$matches[1]”;
   s:44:”search/(.+)/feed/(feed|rdf|rss|rss2|atom)/?$”;s:40:”index.php?s=$matches[
   1]&feed=$matches[2]”;s:39:”search/(.+)/(feed|rdf|rss|rss2|atom)/?$”;s:40:”index.
   php?s=$matches[1]&feed=$matches[2]”;s:32:”search/(.+)/page/?([0-9]{1,})/?$”;s:
   41:”index.php?s=$matches[1]&paged=$matches[2]”;s:14:”search/(.+)/?$”;s:23:”index.
   php?s=$matches[1]”;s:47:”author/([^/]+)/feed/(feed|rdf|rss|rss2|atom)/?$”;s:50:”
   index.php?author_name=$matches[1]&feed=$matches[2]”;s:42:”author/([^/]+)/(feed
   |rdf|rss|rss2|atom)/?$”;s:50:”index.php?author_name=$matches[1]&feed=$matches[
   2]”;s:35:”author/([^/]+)/page/?([0-9]{1,})/?$”;s:51:”index.php?author_name=$matches[
   1]&paged=$matches[2]”;s:17:”author/([^/]+)/?$”;s:33:”index.php?author_name=$matches[
   1]”;s:69:”([0-9]{4})/([0-9]{1,2})/([0-9]{1,2})/feed/(feed|rdf|rss|rss2|atom)/?
   $”;s:80:”index.php?year=$matches[1]&monthnum=$matches[2]&day=$matches[3]&feed
   =$matches[4]”;s:64:”([0-9]{4})/([0-9]{1,2})/([0-9]{1,2})/(feed|rdf|rss|rss2|atom)/?
   $”;s:80:”index.php?year=$matches[1]&monthnum=$matches[2]&day=$matches[3]&feed
   =$matches[4]”;s:57:”([0-9]{4})/([0-9]{1,2})/([0-9]{1,2})/page/?([0-9]{1,})/?$”;
   s:81:”index.php?year=$matches[1]&monthnum=$matches[2]&day=$matches[3]&paged=$
   matches[4]”;s:39:”([0-9]{4})/([0-9]{1,2})/([0-9]{1,2})/?$”;s:63:”index.php?year
   =$matches[1]&monthnum=$matches[2]&day=$matches[3]”;s:56:”([0-9]{4})/([0-9]{1,2})/
   feed/(feed|rdf|rss|rss2|atom)/?$”;s:64:”index.php?year=$matches[1]&monthnum=$
   matches[2]&feed=$matches[3]”;s:51:”([0-9]{4})/([0-9]{1,2})/(feed|rdf|rss|rss2
   |atom)/?$”;s:64:”index.php?year=$matches[1]&monthnum=$matches[2]&feed=$matches[
   3]”;s:44:”([0-9]{4})/([0-9]{1,2})/page/?([0-9]{1,})/?$”;s:65:”index.php?year=
   $matches[1]&monthnum=$matches[2]&paged=$matches[3]”;s:26:”([0-9]{4})/([0-9]{1,2})/?
   $”;s:47:”index.php?year=$matches[1]&monthnum=$matches[2]”;s:43:”([0-9]{4})/feed/(
   feed|rdf|rss|rss2|atom)/?$”;s:43:”index.php?year=$matches[1]&feed=$matches[2]”;
   s:38:”([0-9]{4})/(feed|rdf|rss|rss2|atom)/?$”;s:43:”index.php?year=$matches[1]&
   feed=$matches[2]”;s:31:”([0-9]{4})/page/?([0-9]{1,})/?$”;s:44:”index.php?year
   =$matches[1]&paged=$matches[2]”;s:13:”([0-9]{4})/?$”;s:26:”index.php?year=$matches[
   1]”;s:27:”.?.+?/attachment/([^/]+)/?$”;s:32:”index.php?attachment=$matches[1]”;
   s:37:”.?.+?/attachment/([^/]+)/trackback/?$”;s:37:”index.php?attachment=$matches[
   1]&tb=1″;s:57:”.?.+?/attachment/([^/]+)/feed/(feed|rdf|rss|rss2|atom)/?$”;s:49:”
   index.php?attachment=$matches[1]&feed=$matches[2]”;s:52:”.?.+?/attachment/([^/]
   +)/(feed|rdf|rss|rss2|atom)/?$”;s:49:”index.php?attachment=$matches[1]&feed=$
   matches[2]”;s:52:”.?.+?/attachment/([^/]+)/comment-page-([0-9]{1,})/?$”;s:50:”
   index.php?attachment=$matches[1]&cpage=$matches[2]”;s:20:”(.?.+?)/trackback/?
   $”;s:35:”index.php?pagename=$matches[1]&tb=1″;s:40:”(.?.+?)/feed/(feed|rdf|rss
   |rss2|atom)/?$”;s:47:”index.php?pagename=$matches[1]&feed=$matches[2]”;s:35:”(.?.
   +?)/(feed|rdf|rss|rss2|atom)/?$”;s:47:”index.php?pagename=$matches[1]&feed=$matches[
   2]”;s:28:”(.?.+?)/page/?([0-9]{1,})/?$”;s:48:”index.php?pagename=$matches[1]&
   paged=$matches[2]”;s:35:”(.?.+?)/comment-page-([0-9]{1,})/?$”;s:48:”index.php?
   pagename=$matches[1]&cpage=$matches[2]”;s:20:”(.?.+?)(/[0-9]+)?/?$”;s:47:”index.
   php?pagename=$matches[1]&page=$matches[2]”;s:31:”.+?/[^/]+/attachment/([^/]+)/?
   $”;s:32:”index.php?attachment=$matches[1]”;s:41:”.+?/[^/]+/attachment/([^/]+)/
   trackback/?$”;s:37:”index.php?attachment=$matches[1]&tb=1″;s:61:”.+?/[^/]+/attachment/([
   ^/]+)/feed/(feed|rdf|rss|rss2|atom)/?$”;s:49:”index.php?attachment=$matches[1]&
   feed=$matches[2]”;s:56:”.+?/[^/]+/attachment/([^/]+)/(feed|rdf|rss|rss2|atom)/?
   $”;s:49:”index.php?attachment=$matches[1]&feed=$matches[2]”;s:56:”.+?/[^/]+/attachment/([
   ^/]+)/comment-page-([0-9]{1,})/?$”;s:50:”index.php?attachment=$matches[1]&cpage
   =$matches[2]”;s:26:”(.+?)/([^/]+)/trackback/?$”;s:57:”index.php?category_name
   =$matches[1]&name=$matches[2]&tb=1″;s:46:”(.+?)/([^/]+)/feed/(feed|rdf|rss|rss2
   |atom)/?$”;s:69:”index.php?category_name=$matches[1]&name=$matches[2]&feed=$matches[
   3]”;s:41:”(.+?)/([^/]+)/(feed|rdf|rss|rss2|atom)/?$”;s:69:”index.php?category_name
   =$matches[1]&name=$matches[2]&feed=$matches[3]”;s:34:”(.+?)/([^/]+)/page/?([0-
   9]{1,})/?$”;s:70:”index.php?category_name=$matches[1]&name=$matches[2]&paged=
   $matches[3]”;s:41:”(.+?)/([^/]+)/comment-page-([0-9]{1,})/?$”;s:70:”index.php?
   category_name=$matches[1]&name=$matches[2]&cpage=$matches[3]”;s:26:”(.+?)/([^/]
   +)(/[0-9]+)?/?$”;s:69:”index.php?category_name=$matches[1]&name=$matches[2]&page
   =$matches[3]”;s:20:”.+?/[^/]+/([^/]+)/?$”;s:32:”index.php?attachment=$matches[
   1]”;s:30:”.+?/[^/]+/([^/]+)/trackback/?$”;s:37:”index.php?attachment=$matches[
   1]&tb=1″;s:50:”.+?/[^/]+/([^/]+)/feed/(feed|rdf|rss|rss2|atom)/?$”;s:49:”index.
   php?attachment=$matches[1]&feed=$matches[2]”;s:45:”.+?/[^/]+/([^/]+)/(feed|rdf
   |rss|rss2|atom)/?$”;s:49:”index.php?attachment=$matches[1]&feed=$matches[2]”;
   s:45:”.+?/[^/]+/([^/]+)/comment-page-([0-9]{1,})/?$”;s:50:”index.php?attachment
   =$matches[1]&cpage=$matches[2]”;s:38:”(.+?)/feed/(feed|rdf|rss|rss2|atom)/?$”;
   s:52:”index.php?category_name=$matches[1]&feed=$matches[2]”;s:33:”(.+?)/(feed
   |rdf|rss|rss2|atom)/?$”;s:52:”index.php?category_name=$matches[1]&feed=$matches[
   2]”;s:26:”(.+?)/page/?([0-9]{1,})/?$”;s:53:”index.php?category_name=$matches[
   1]&paged=$matches[2]”;s:33:”(.+?)/comment-page-([0-9]{1,})/?$”;s:53:”index.php?
   category_name=$matches[1]&cpage=$matches[2]”;s:8:”(.+?)/?$”;s:35:”index.php?category_name
   =$matches[1]”;}’, N’yes’) made by require(‘E:\wp-sqlsrv\schools\cec\wp-blog-header.
   php’), wp, WP->main, WP->parse_request, WP_Rewrite->wp_rewrite_rules, update_option,
   add_option, pdo_wpdb->query, pdo_wpdb->_post_query, pdo_wpdb->print_error
 * [http://wordpress.org/extend/plugins/wordpress-database-abstraction/](http://wordpress.org/extend/plugins/wordpress-database-abstraction/)

The topic ‘Unique Key Constraints errors, WP 3.5.1’ is closed to new replies.

 * ![](https://s.w.org/plugins/geopattern-icon/wordpress-database-abstraction.svg)
 * [WP Db Abstraction](https://wordpress.org/plugins/wordpress-database-abstraction/)
 * [Frequently Asked Questions](https://wordpress.org/plugins/wordpress-database-abstraction/#faq)
 * [Support Threads](https://wordpress.org/support/plugin/wordpress-database-abstraction/)
 * [Active Topics](https://wordpress.org/support/plugin/wordpress-database-abstraction/active/)
 * [Unresolved Topics](https://wordpress.org/support/plugin/wordpress-database-abstraction/unresolved/)
 * [Reviews](https://wordpress.org/support/plugin/wordpress-database-abstraction/reviews/)

## Tags

 * [rewrite_rules](https://wordpress.org/support/topic-tag/rewrite_rules/)

 * 0 replies
 * 1 participant
 * Last reply from: [mwoolums](https://wordpress.org/support/users/mwoolums/)
 * Last activity: [13 years, 1 month ago](https://wordpress.org/support/topic/unique-key-constraints-errors-wp-351/)
 * Status: not resolved