SQL 2000 and 2005 are causing problems with 5.3.1

For 2 days I’ve got this extreme ugly dialog when deleting items after an upgrade from 5.3.0 to 5.3.1:

scerror

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.

2 thoughts on “SQL 2000 and 2005 are causing problems with 5.3.1”

  1. Yep, we discover as well problems with 2000. Seems like the latest patch is not working on 2000. Sitecore is working right now on quick fix for this. Lets hope they come out patch very soon.

  2. When I look your problem in more depth I notice that you may not have a same problem that we encounter on 2000. Anyway, watch out July patch with SQL 2000 it gives nasty RTE’s.

Comments are closed.