Sunday, July 19, 2009

Cannot resolve the collation conflict between XXXXXXX and YYYYYYYYY in the equal to operation

This error indicated that the strings in the join operation are from fields created in different collation. In general, it's better to recreate the fields with the same collation definition, but if you're just too lazy, and want to get things done, just cast to problematic field (in this example it's to 'SQL_Latin1_General_CP1_CI_AS'):

SELECT *
FROM A, B
WHERE A.F1 = B.F1 COLLATE SQL_Latin1_General_CP1_CI_AS

Monday, July 13, 2009

WordPress & GoDaddy Windows shared hosting

Wordpress works just fine in GoDaddy shared Windows hosting (IIS7), however when trying to install a plugin I get:

Downloading install package from http://downloads.wordpress.org/plugin/XXXXXX.zip.

Warning: touch() [function.touch]: Unable to create file D:\Hosting\XXXXX\html\XXXXXX.com\blog/wp-content/XXXXXX.zip because Permission denied in D:\Hosting\2804923\html\spassets.com\blog\wp-admin\includes\file.php on line 175

Download failed. Could not create Temporary file

Solution: since no solution can be found on the web, I used the good old method - manual install:
* Download the package from wordpress
* Uncompress and upload to /wp-content/plugins (I just copied from another wordpress I have).

And it works!

Sunday, July 12, 2009

Web.config & GoDaddy.com

I wrote a small ASP.NET application, which needed to read the web.config file. To open the Web.config file I used 'OpenWebConfiguration':
WebConfigurationManager.OpenWebConfiguration(...)

Since GoDaddy uses medium trust, I kept on getting:
'The application attempted to perform an operation not allowed by the security policy'

And in the detailed:
'System.Security.SecurityException: Request for the permission of type 'System.Security.Permissions.FileIOPermission, mscorlib, Version=2.0.0.0, Culture=neutral, PublicKeyToken=b77a5c561934e089' failed.

The resolution - use ConfigurationManager.ConnectionStrings instead.