Forums (Obsolete)

Old Forums

Upgrades Questions on upgrading to version 5.x.

Version 5.x > Upgrades > Insert new file failed: [DataConnection.ExecuteQuery]

View modes:

Member

mr_phil - 7/20/2012 3:14:19 AM

Insert new file failed: [DataConnection.ExecuteQuery]

Hello,

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?

Thanks

Member

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.

Top