Title: Errors Logged
Last modified: August 21, 2016

---

# Errors Logged

 *  [fouimette](https://wordpress.org/support/users/fouimette/)
 * (@fouimette)
 * [13 years, 1 month ago](https://wordpress.org/support/topic/errors-logged/)
 * I recently tried to install multi-site and was having problems. When I looked
   into my php_errors.log I see A LOT of the following errors:
 * `[15-Apr-2013 21:26:40 UTC] WordPress database error [Microsoft][SQL Server Native
   Client 11.0][SQL Server]Incorrect syntax near the keyword 'LIKE'. for query SELECT
   COUNT(NULLIF(meta_value LIKE '%"administrator"%', false) as Computed), COUNT(
   NULLIF(meta_value LIKE '%"editor"%', false) as Computed), COUNT(NULLIF(meta_value
   LIKE '%"author"%', false) as Computed), COUNT(NULLIF(meta_value LIKE '%"contributor"%',
   false) as Computed), COUNT(NULLIF(meta_value LIKE '%"subscriber"%', false) as
   Computed), COUNT(NULLIF(meta_value LIKE 'bbp\_keymaster"%6$sbbp\_spectator"%7
   $sbbp\_blocked"%8$swp_crossfitcapabilities' made by wp_version_check, count_users,
   sqlsrv_wpdb->query, sqlsrv_wpdb->_post_query, sqlsrv_wpdb->print_error`
 * and
 * `[15-Apr-2013 21:26:39 UTC] WordPress database error [Microsoft][SQL Server Native
   Client 11.0][SQL Server]Violation of UNIQUE KEY constraint 'wp_crossfitoptions_option_name'.
   Cannot insert duplicate key in object 'dbo.wp_crossfitoptions'. The duplicate
   key value is (_site_transient_update_plugins). for query INSERT INTO wp_crossfitoptions(
   option_name, option_value, autoload) VALUES ( N'_site_transient_update_plugins',
   N'O:8:"stdClass":1:{s:12:"last_checked";i:1366061199;}', N'yes') made by require_once('
   C:\DWASFiles\Sites\crossfitutah\VirtualDirectory0\site\wwwroot\wp-admin\admin.
   php'), do_action('admin_init'), call_user_func_array, _maybe_update_plugins, 
   wp_update_plugins, set_site_transient, add_site_option, add_option, sqlsrv_wpdb-
   >query, sqlsrv_wpdb->_post_query, sqlsrv_wpdb->print_error`
 * `[15-Apr-2013 21:57:43 UTC] PHP Warning: mysql_free_result(): supplied resource
   is not a valid MySQL result resource in C:\DWASFiles\Sites\crossfitutah\VirtualDirectory0\
   site\wwwroot\wp-includes\wp-db.php on line 1125` **I see this one the most in
   the log file**
 * and
 * `[15-Apr-2013 21:58:08 UTC] WordPress database error [Microsoft][SQL Server Native
   Client 11.0][SQL Server]Incorrect syntax near 'wp_crossfitsite'. for query SELECT
   TABLE_NAME FROM INFORMATION_SCHEMA.TABLES WHERE TABLE_NAME LIKE ''wp_crossfitsite''
   made by network_step1, get_clean_basedomain, network_domain_check, sqlsrv_wpdb-
   >query, sqlsrv_wpdb->_post_query, sqlsrv_wpdb->print_error`
 * Please advise.
 * Frank
 * [http://wordpress.org/extend/plugins/wordpress-database-abstraction/](http://wordpress.org/extend/plugins/wordpress-database-abstraction/)

The topic ‘Errors Logged’ 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

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

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