Anonymous - 2013-03-12

I'm getting the following errors on several installs on Azure, all connected to SQL Azure using the db-abstraction plugin. 

WordPress database error: [42000 : Incorrect syntax near '`'.]
UPDATE ia_options SET option_value = N'O:28:"GoogleSitemapGeneratorStatus":24:{s:10:"_startTime";d:1363116753.956033;s:8:"_endTime";i:0;s:11:"_hasChanged";b:1;s:12:"_memoryUsage";i:0;s:9:"_lastPost";i:0;s:9:"_lastTime";i:0;s:8:"_usedXml";b:1;s:11:"_xmlSuccess";b:0;s:8:"_xmlPath";s:72:"C:\DWASFiles\Sites\inside-afa\VirtualDirectory0\site\wwwroot/sitemap.xml";s:7:"_xmlUrl";s:47:"http://inside-afa.azurewebsites.net/sitemap.xml";s:8:"_usedZip";b:0;s:11:"_zipSuccess";b:0;s:8:"_zipPath";s:0:"";s:7:"_zipUrl";s:0:"";s:11:"_usedGoogle";b:0;s:10:"_googleUrl";s:0:"";s:15:"_gooogleSuccess";b:0;s:16:"_googleStartTime";i:0;s:14:"_googleEndTime";i:0;s:8:"_usedMsn";b:0;s:7:"_msnUrl";s:0:"";s:11:"_msnSuccess";b:0;s:13:"_msnStartTime";i:0;s:11:"_msnEndTime";i:0;}' WHERE `option_name` = N'sm_status'

WordPress database error: [42000 : Incorrect syntax near '`'.]
UPDATE ia_options SET option_value = N'O:28:"GoogleSitemapGeneratorStatus":24:{s:10:"_startTime";d:1363116753.956033;s:8:"_endTime";i:0;s:11:"_hasChanged";b:1;s:12:"_memoryUsage";i:0;s:9:"_lastPost";i:0;s:9:"_lastTime";i:0;s:8:"_usedXml";b:1;s:11:"_xmlSuccess";b:0;s:8:"_xmlPath";s:72:"C:\DWASFiles\Sites\inside-afa\VirtualDirectory0\site\wwwroot/sitemap.xml";s:7:"_xmlUrl";s:47:"http://inside-afa.azurewebsites.net/sitemap.xml";s:8:"_usedZip";b:1;s:11:"_zipSuccess";b:0;s:8:"_zipPath";s:75:"C:\DWASFiles\Sites\inside-afa\VirtualDirectory0\site\wwwroot/sitemap.xml.gz";s:7:"_zipUrl";s:50:"http://inside-afa.azurewebsites.net/sitemap.xml.gz";s:11:"_usedGoogle";b:0;s:10:"_googleUrl";s:0:"";s:15:"_gooogleSuccess";b:0;s:16:"_googleStartTime";i:0;s:14:"_googleEndTime";i:0;s:8:"_usedMsn";b:0;s:7:"_msnUrl";s:0:"";s:11:"_msnSuccess";b:0;s:13:"_msnStartTime";i:0;s:11:"_msnEndTime";i:0;}' WHERE `option_name` = N'sm_status'

WordPress database error: [42000 : Column "ia_posts.post_modified" is invalid in the ORDER BY clause because it is not contained in either an aggregate function or the GROUP BY clause.]
SELECT COUNT(*) AS cnt FROM ia_posts WHERE ( (post_status = 'publish' AND (post_type = 'post' OR post_type LIKE '')) OR (post_status = 'publish' AND post_type LIKE 'page') ) AND post_password LIKE'' ORDER BY post_modified DESC

The first two seem to be related to the ` characters around the column name it's trying to update and the 3rd is it's not stripping the order by clause.

I also get these warnings:

Warning: mysql_connect():  No connection could be made because the target machine actively refused it. (trying to connect via tcp://nbzpcw89do.database.windows.net:3306) in C:\DWASFiles\Sites\inside-afa\VirtualDirectory0\site\wwwroot\wp-content\plugins\google-sitemap-generator\sitemap-core.php on line 1795 Warning: mysql_connect(): No connection could be made because the target machine actively refused it. in C:\DWASFiles\Sites\inside-afa\VirtualDirectory0\site\wwwroot\wp-content\plugins\google-sitemap-generator\sitemap-core.php on line 1795 Notice: MySQL Connection failed: No connection could be made because the target machine actively refused it. in C:\DWASFiles\Sites\inside-afa\VirtualDirectory0\site\wwwroot\wp-content\plugins\google-sitemap-generator\sitemap-core.php on line 1797