Last week we set up an installation hosted in Windows Azure using the Brandoo distro from the Windows Azure gallery. It’s using SQL Azure for the DB. It also has some typical plugins installed, such as Jetpack and Yoast.
While just about everything works as expected, we’re getting no search results. A look at the log provides a message like the following for each query:
[15-Dec-2013 02:15:20 UTC] WordPress database error 42000 : [Microsoft][SQL Server Native Client 11.0][SQL Server]Incorrect syntax near the keyword 'LIKE'. for query SELECT TOP 10 * FROM wp_posts WHERE 1=1 AND (((wp_posts.post_title LIKE '%korea%') OR (wp_posts.post_content LIKE '%korea%'))) AND wp_posts.post_type IN ('post', 'page', 'attachment') AND (wp_posts.post_status = 'publish' OR wp_posts.post_author = 1 AND wp_posts.post_status LIKE 'private') ORDER BY wp_posts.post_title, LIKE, '%korea%' DESC, wp_posts.post_date DESC made by require('C:\DWASFiles\Sites\voyajitsu\VirtualDirectory0\site\wwwroot\wp-blog-header.php'), wp, WP->main, WP->query_posts, WP_Query->query, WP_Query->get_posts, pdo_wpdb->query, pdo_wpdb->_post_query, pdo_wpdb->print_error
There are also a bunch of other SQL errors for various things that have happened, but we haven’t noticed any problems otherwise. Any thoughts?
- The topic ‘SQL Server query errors for search’ is closed to new replies.