 |
|
|
 |
www.wesnetdesigns.com
Joined: 2/18/2005
Posts: 3253
|
|
|
Jon,
After looking at the code related to your File Manager issue, I don't believe that this error is related to the one involving the missing {databaseOwner} token when attempting to drop/re-create the foreign key constraint between the Files and Folders table.
Were there any other errors indicated during the upgrade?
Have you tested other file related operations, for example, to select and/or upload an image or other file using the document manager in the Html module editor?
Please confirm that the following section has been added to your installation's web.config file (near the very end of the file) during the upgrade:
<folder defaultProvider="StandardFolderProvider">
<providers>
<clear />
<add name="StandardFolderProvider" type="DotNetNuke.Services.FileSystem.StandardFolderProvider, DotNetNuke" />
<add name="SecureFolderProvider" type="DotNetNuke.Services.FileSystem.SecureFolderProvider, DotNetNuke" />
<add name="DatabaseFolderProvider" type="DotNetNuke.Services.FileSystem.DatabaseFolderProvider, DotNetNuke" />
</providers>
</folder>
Bill, WESNet Designs
Team Lead - DotNetNuke Gallery Module Project (Not Actively Being Developed)
Extensions Forge Projects . . .
Current: UserExport, ContentDeJour, ePrayer, DNN NewsTicker, By Invitation
Coming Soon: FRBO-For Rent By Owner
|
| |
|
|
 | |
|
|
Joined: 1/28/2010
Posts: 23
|
|
|
Bill
In looking at my Webconfig I do not have that structure in there. Should it be added within the tags?
I've uploaded within repositories and within Document Manager in the HTML editor.
Curiously a file uploaded through document manager is visable to the Repository upload but not vice versa.
Both the Simple File List Module and CFFileViewer modules started throwing errors. The former displays a file list but when clicking on the files cannot find them - the latter throws the following error when attempting to view a file list:
Procedure or function 'GetPortal' expects parameter '@CultureCode', which was not supplied. at System.Data.SqlClient.SqlConnection. (SqlException exception, Boolean breakConnection) at System.Data.SqlClient.SqlInternalConnection. (SqlException exception, Boolean breakConnection) at System.Data.SqlClient.TdsParser.ThrowExceptionAndWarning(TdsParserStateObject stateObj) at System.Data.SqlClient.TdsParser.Run(RunBehavior runBehavior, SqlCommand cmdHandler, SqlDataReader dataStream, BulkCopySimpleResultSet bulkCopyHandler, TdsParserStateObject stateObj) at System.Data.SqlClient.SqlDataReader.ConsumeMetaData() at System.Data.SqlClient.SqlDataReader.get_MetaData() at System.Data.SqlClient.SqlCommand.FinishExecuteReader(SqlDataReader ds, RunBehavior runBehavior, String resetOptionsString) at System.Data.SqlClient.SqlCommand.RunExecuteReaderTds(CommandBehavior cmdBehavior, RunBehavior runBehavior, Boolean returnStream, Boolean async) at System.Data.SqlClient.SqlCommand.RunExecuteReader(CommandBehavior cmdBehavior, RunBehavior runBehavior, Boolean returnStream, String method, DbAsyncResult result) at System.Data.SqlClient.SqlCommand.RunExecuteReader(CommandBehavior cmdBehavior, RunBehavior runBehavior, Boolean returnStream, String method) at System.Data.SqlClient.SqlCommand.ExecuteReader(CommandBehavior behavior, String method) at System.Data.SqlClient.SqlCommand.ExecuteReader() at YourCompany.Modules.CFFileViewer6.ViewCFFileViewer6.GetPortalInfo()Could not find a part of the path 'C:\inetpub\vhosts\d13cgaux.com\httpdocs\Repository\MT\Fileshare\AUXWEA'. at System.IO.__Error.WinIOError(Int32 errorCode, String maybeFullPath) at System.IO.Directory.InternalGetFileDirectoryNames(String path, String userPathOriginal, String searchPattern, Boolean includeFiles, Boolean includeDirs, SearchOption searchOption) at System.IO.DirectoryInfo.GetFiles(String searchPattern, SearchOption searchOption) at System.IO.DirectoryInfo.GetFiles() at YourCompany.Modules.CFFileViewer6.ViewCFFileViewer6.listDirectory(String thisDirectory, String strMyFolder)
With respect to other issues -there were several issues with the upgrade but most have involved skin issues which I've resolved, changing out the old menu, a couple of modules that didn't install, and going to the RADEditor. I've resolved all of those. With respect to errors those were the only ones in the SQLdataprovider logs. Back in the 5.05 upgrade I had the following error:
System.Data.SqlClient.SqlException: The DELETE statement conflicted with the REFERENCE constraint "FK_BizModules_UPG_AlbumModule_Modules". The conflict occurred in database "jumphrey_mssql72c99bff1ca2a58680b1026845fd0fe7", table "jumphrey_usra6bc80f541c5e90fbed457cfb25bb95a.BizModules_UPG_AlbumModule", column 'ModuleId'.
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(TdsParserStateObject stateObj)
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)
/************************************************************/
/***** SqlDataProvider *****/
/***** *****/
/***** *****/
/***** Note: To manually execute this script you must *****/
/***** perform a search and replace operation *****/
/***** for jumphrey_usra6bc80f541c5e90fbed457cfb25bb95a. and *****/
/***** *****/
/************************************************************/
/* Delete Orphaned Module*/
/*************************/
DELETE
FROM jumphrey_usra6bc80f541c5e90fbed457cfb25bb95a.Modules
WHERE ModuleID IN (SELECT ModuleID FROM jumphrey_usra6bc80f541c5e90fbed457cfb25bb95a.vw_modules WHERE TabModuleID IS NULL)
Should there be another location I should be looking for traces?
|
| |
|
|
| |
|
|
Joined: 1/28/2010
Posts: 23
|
|
|
Sorry. Looks like the editor stripped out part of my question. To recap Should it be added within the dotnetnuke tags?
|
| |
|
|
| |
|
|
|
www.wesnetdesigns.com
Joined: 2/18/2005
Posts: 3253
|
|
|
Jon,
The new <folder . . .> . . . </folder> provider section I indicated above should have been added to web.config just after the closing </sitemap> element and before the closing </dotnetnuke> element during the upgrade processing of the Install/Config/06.00.00.config xml file. A couple of other web.config changes should also have occurred at that time.
Please check if the following element which should have been added as the last one within the <sectionGroup name="DotNetNuke"> . . . </sectionGroup> nodes near the beginning of web.config. If that change is also missing and rather than attempting to manually make changes to web.config I would suggest (when logged in as host user) running the Host-->Configuration Manager utility on the Install/Config/06.00.00.config xml file. If an error occurs, we will at least have a better idea of why these modifications to web.config failed during the upgrade.
I am also concerned that there were other upgrade errors noted. Did you make a full backup of the filesystem and the MS SQL Server database prior to the upgrade and will it be possible for you to restore the installation back to these backups should the web.config changes not take care of this issue?
Also from what version of DotNetNuke did you upgrade to DotNetNuke 6.0?
Bill, WESNet Designs
Team Lead - DotNetNuke Gallery Module Project (Not Actively Being Developed)
Extensions Forge Projects . . .
Current: UserExport, ContentDeJour, ePrayer, DNN NewsTicker, By Invitation
Coming Soon: FRBO-For Rent By Owner
|
| |
|
|
| |
|
|
|
www.wesnetdesigns.com
Joined: 2/18/2005
Posts: 3253
|
|
|
Jon,
When checking within the <sectionGroup> . . . </sectionGroup> for another potentially missing modification, here's what you should be looking for:
<section name="folder" requirePermission="false" type="DotNetNuke.Framework.Providers.ProviderConfigurationHandler, DotNetNuke" />
I forgot to paste it into my previous reply.
Bill, WESNet Designs
Team Lead - DotNetNuke Gallery Module Project (Not Actively Being Developed)
Extensions Forge Projects . . .
Current: UserExport, ContentDeJour, ePrayer, DNN NewsTicker, By Invitation
Coming Soon: FRBO-For Rent By Owner
|
| |
|
|
| |