For 2 days I’ve got this extreme ugly dialog when deleting items after an upgrade from 5.3.0 to 5.3.1:
Today I’ve found out what was the problem. We are running on SQL 2000 here at the customer. First I’ve tested my upgrade on my local machine on SQL 2005 Express. And in that way I introduced the pain :(. Sitecore delivers databases for SQL Server 2005 with the field called ‘Blob’ with as datatype nvarchar(max) in the tables ‘VersionedFields’, ‘UnversionedFields’ and ‘SharedFields’.
Sitecore 5.3.0 on SQL 2000 uses ntext instead. Comparing ntext’s results in the above message. Alter your tables to nvarchar(max-length-sql2000=4000) and your problem will be resolved. 🙂 Altough I’m not really sure this is the 100% best solution, it works :).
For more information about this kind of length and type issues, take a look here.