Upgrades Questions on upgrading to version 5.x.
Version 5.x > Upgrades > Insert new file failed: [DataConnection.ExecuteQuery] View modes: 
User avatar
mr_phil - 7/20/2012 3:14:19 AM
Insert new file failed: [DataConnection.ExecuteQuery]

I have followed the upgrade guides closely and have upgraded from 4.1 to 5.5R2. Now when I try to upload files in CMSDesk I get the following error:

Insert new file failed: [DataConnection.ExecuteQuery]: Query: INSERT INTO CONTENT_File ([FileName], [FileDescription], [FileAttachment], [RecomendedDoc], [PopularDoc], [Extension] ) VALUES ( @FileName, @FileDescription, @FileAttachment, @RecomendedDoc, @PopularDoc, @Extension); SELECT @@identity AS [FileID] : caused exception: Cannot insert the value NULL into column 'RecomendedDoc', table 'KDB.dbo.CONTENT_File'; column does not allow nulls. INSERT fails. The statement has been terminated.

Any ideas?


User avatar
mr_phil - 7/20/2012 6:44:42 AM
RE:Insert new file failed: [DataConnection.ExecuteQuery]
Ok I fixed this one myself.

There was a discrepancy between the XML in the CMS_Class.ClassFormDefinition field for the "CMS.File" ClassName in the database. My original database defined some extra fields in the XML but the upgrade process wiped them.

I replaced the new XML with the old XML and the problem is gone.

Hope this helps someone else.