Products

Solutions

Resources

Partners

Community

Blog

About

QA

Ideas Test

New Community Website

Ordinarily, you'd be at the right spot, but we've recently launched a brand new community website... For the community, by the community.

Yay... Take Me to the Community!

Welcome to the DNN Community Forums, your preferred source of online community support for all things related to DNN.
In order to participate you must be a registered DNNizen

HomeHomeUsing DNN Platf...Using DNN Platf...Upgrading DNN P...Upgrading DNN P...File upload issue since upgrade to DNN 6.1.3File upload issue since upgrade to DNN 6.1.3
Previous
 
Next
New Post
4/25/2012 4:43 AM
 
I tried uploading in the ActiveForums module and it worked fine:
http://www.pokerdiy.com/Portals/6/activeforums_Attach/PTM_WP71_Landscape.png

Entrepreneur

PokerDIY Tournament Manager - PokerDIY Tournament Manager<
PokerDIY Game Finder - Mobile Apps powered by DNN
PokerDIY - Connecting Poker Players

 
New Post
4/26/2012 7:39 AM
 
I have been digging a bit deeper and I found that the upgrade script failed on 06.00.00.log.resources and it's to do with Folders - suspicious:


System.Data.SqlClient.SqlException (0x80131904): Cannot insert the value NULL into column 'FolderMappingID', table 'pokerdiy.dbo.Folders'; column does not allow nulls. UPDATE fails.
The statement has been terminated.
at System.Data.SqlClient.SqlConnection. (SqlException exception, Boolean breakConnection)
at System.Data.SqlClient.SqlInternalConnection. (SqlException exception, Boolean breakConnection)
at System.Data.SqlClient.TdsParser.ThrowExceptionAndWarning()
at System.Data.SqlClient.TdsParser.Run(RunBehavior runBehavior, SqlCommand cmdHandler, SqlDataReader dataStream, BulkCopySimpleResultSet bulkCopyHandler, TdsParserStateObject stateObj)
at System.Data.SqlClient.SqlCommand.RunExecuteNonQueryTds(String methodName, Boolean async)
at System.Data.SqlClient.SqlCommand.InternalExecuteNonQuery(DbAsyncResult result, String methodName, Boolean sendToPipe)
at System.Data.SqlClient.SqlCommand.ExecuteNonQuery()
at DotNetNuke.Data.SqlDataProvider.ExecuteADOScript(String SQL)
at DotNetNuke.Data.SqlDataProvider.ExecuteScript(String Script, Boolean UseTransactions)



ALTER TABLE dbo.[Folders] ALTER COLUMN [FolderMappingID] int NOT NULL


System.Data.SqlClient.SqlException (0x80131904): The ALTER TABLE statement conflicted with the FOREIGN KEY constraint "FK_Files_Portals". The conflict occurred in database "pokerdiy", table "dbo.Portals", column 'PortalID'.
at System.Data.SqlClient.SqlConnection. (SqlException exception, Boolean breakConnection)
at System.Data.SqlClient.SqlInternalConnection. (SqlException exception, Boolean breakConnection)
at System.Data.SqlClient.TdsParser.ThrowExceptionAndWarning()
at System.Data.SqlClient.TdsParser.Run(RunBehavior runBehavior, SqlCommand cmdHandler, SqlDataReader dataStream, BulkCopySimpleResultSet bulkCopyHandler, TdsParserStateObject stateObj)
at System.Data.SqlClient.SqlCommand.RunExecuteNonQueryTds(String methodName, Boolean async)
at System.Data.SqlClient.SqlCommand.InternalExecuteNonQuery(DbAsyncResult result, String methodName, Boolean sendToPipe)
at System.Data.SqlClient.SqlCommand.ExecuteNonQuery()
at DotNetNuke.Data.SqlDataProvider.ExecuteADOScript(String SQL)
at DotNetNuke.Data.SqlDataProvider.ExecuteScript(String Script, Boolean UseTransactions)



ALTER TABLE dbo.[Files] ADD
CONSTRAINT [FK_Files_Portals] FOREIGN KEY ([PortalId]) REFERENCES dbo.[Portals] ([PortalID]),
CONSTRAINT [FK_Files_Folders] FOREIGN KEY ([FolderID]) REFERENCES dbo.[Folders] ([FolderID]) ON DELETE CASCADE




I found a SQL script here: http://support.dotnetnuke.com/issue/ViewIssue.aspx?ID=15169&PROJID=2
that talks about this error but it does not work when I run it.


Entrepreneur

PokerDIY Tournament Manager - PokerDIY Tournament Manager<
PokerDIY Game Finder - Mobile Apps powered by DNN
PokerDIY - Connecting Poker Players

 
New Post
4/26/2012 7:48 AM
 
I then checked the Folder tables to make sure they had the latest columns and correct data
SELECT * FROM FolderMappings

SELECT * FROM Folders

SELECT * FROM Folders WHERE FolderPath like '%leagues%' (this is the folder where the files are uploaded)

It has the FolderMappingID of 4 which is the StandardFolderProvider for my portal (priority 1). Does this sound correct?

One of the problems I have is that I can't run Syncronise Files from the top level as I have over 50k of profiles and each one is an ActiveSocial directory so it always times out. I have syncronised recursively at the folder level.

Entrepreneur

PokerDIY Tournament Manager - PokerDIY Tournament Manager<
PokerDIY Game Finder - Mobile Apps powered by DNN
PokerDIY - Connecting Poker Players

 
New Post
4/26/2012 7:57 AM
 
Sorry - one more - I noticed that there were FolderMappings that were null so I made these all 1 (StorageLocation = 0). I then noticed that the script that failed changed the FolderMappingID to Not NULL altho mine was still null, so I changed this too - unfortunately it had no effect on the problem.

Entrepreneur

PokerDIY Tournament Manager - PokerDIY Tournament Manager<
PokerDIY Game Finder - Mobile Apps powered by DNN
PokerDIY - Connecting Poker Players

 
New Post
4/26/2012 5:23 PM
 

Looking at the 6,1,5 core code ( public virtual IFileInfo MoveFile(IFileInfo file, IFolderInfo destinationFolder)

I think that the CONTENT of the file is not being read and is returning null -  System.ArgumentNullException: Value cannot be null. Parameter name: content at DotNetNuke.Common.Requires.NotNull(String argName, Object argValue) at DotNetNuke.Services.FileSystem.StandardFolderProvider.AddFile


            using (var fileContent = GetFileContent(file))

            {
                try
                {
                    destinationFolderProvider.AddFile(destinationFolder, file.FileName, fileContent);
                }
                catch (Exception ex)
                {
                    DnnLog.Error(ex);
                    throw new FolderProviderException(Localization.Localization.GetExceptionMessage("UnderlyingSystemError", "The underlying system threw an exception."), ex);
                }
            }


Either that or the error is being thrown inside the GetFileContent method and gets bubbled up

throw new FolderProviderException(Localization.Localization.GetExceptionMessage("UnderlyingSystemError", "The underlying system threw an exception"), ex);


Entrepreneur

PokerDIY Tournament Manager - PokerDIY Tournament Manager<
PokerDIY Game Finder - Mobile Apps powered by DNN
PokerDIY - Connecting Poker Players

 
Previous
 
Next
HomeHomeUsing DNN Platf...Using DNN Platf...Upgrading DNN P...Upgrading DNN P...File upload issue since upgrade to DNN 6.1.3File upload issue since upgrade to DNN 6.1.3


These Forums are dedicated to discussion of DNN Platform and Evoq Solutions.

For the benefit of the community and to protect the integrity of the ecosystem, please observe the following posting guidelines:

  1. No Advertising. This includes promotion of commercial and non-commercial products or services which are not directly related to DNN.
  2. No vendor trolling / poaching. If someone posts about a vendor issue, allow the vendor or other customers to respond. Any post that looks like trolling / poaching will be removed.
  3. Discussion or promotion of DNN Platform product releases under a different brand name are strictly prohibited.
  4. No Flaming or Trolling.
  5. No Profanity, Racism, or Prejudice.
  6. Site Moderators have the final word on approving / removing a thread or post or comment.
  7. English language posting only, please.
What is Liquid Content?
Find Out
What is Liquid Content?
Find Out
What is Liquid Content?
Find Out