I did some further cleanup of old folders left by Gallery module (which I removed)
now I am getting this error:
System.Data.SqlClient.SqlException: Cannot insert the value NULL into column 'LastUpdated', table 'DNN311UPGRADE.dbo.Folders'; column does not allow nulls. INSERT fails.
but when I look at the sproc it doesn't look like it's trying to insert null:
CREATE PROCEDURE [dbo].[AddFolder]
@PortalID int,
@FolderPath varchar(300),
@StorageLocation int,
@IsProtected bit,
@IsCached bit,
@LastUpdated datetime
AS
INSERT INTO dbo.Folders (
PortalID,
FolderPath,
StorageLocation,
IsProtected,
IsCached,
LastUpdated
)
VALUES (
@PortalID,
@FolderPath,
@StorageLocation,
@IsProtected,
@IsCached,
@LastUpdated
)
This is an upgrade from 3.1.1 to 3.7 and then to 4.5.3. I looked at and dealt with all errors in the upgrade, which was primarily a matter of cleaning up and getting folders and files tables in synch with the physical file system, and getting the newer constraints on each table in place, which they are.
Help? :)