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:<\/p>\n
and<\/p>\n and<\/p>\n Please advise.<\/p>\n Frank<\/p>\n https:\/\/wordpress.org\/extend\/plugins\/wordpress-database-abstraction\/<\/p>\n","protected":false},"template":"","class_list":["post-3661818","topic","type-topic","status-closed","hentry","topic-tag-database-errors"],"jetpack_sharing_enabled":true,"_links":{"self":[{"href":"https:\/\/wordpress.org\/support\/wp-json\/wp\/v2\/topic\/3661818","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\/3661818\/revisions"}],"wp:attachment":[{"href":"https:\/\/wordpress.org\/support\/wp-json\/wp\/v2\/media?parent=3661818"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}[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<\/code><\/p>\n[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<\/code><\/p>\n[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<\/code> I see this one the most in the log file<\/strong><\/p>\n[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<\/code><\/p>\n