Hi,
I just tried to upgrade from version 3.00.16 to the latest version. I get this error:
Info Executing 03.01.00.SqlDataProvider
StartJob Start Sql execution: 03.01.00.SqlDataProvider file
Failure SQL Execution resulted in following Exceptions: System.Data.SqlClient.SqlException: Subquery returned more than 1 value. This is not permitted when the subquery follows =, !=, <, <= , >, >= or when the subquery is used as an expression. The statement has been terminated. at System.Data.SqlClient.SqlCommand.ExecuteNonQuery() at Microsoft.ApplicationBlocks.Data.SqlHelper.ExecuteNonQuery(SqlConnection connection, CommandType commandType, String commandText, SqlParameter[] commandParameters) at Microsoft.ApplicationBlocks.Data.SqlHelper.ExecuteNonQuery(String connectionString, CommandType commandType, String commandText, SqlParameter[] commandParameters) at Microsoft.ApplicationBlocks.Data.SqlHelper.ExecuteNonQuery(String connectionString, CommandType commandType, String commandText) at DotNetNuke.Data.SqlDataProvider.ExecuteScript(String Script, Boolean UseTransactions) UPDATE dbo.grmRepositoryObjects SET CategoryId = (SELECT Cast(ItemID as varchar(2)) + ';' from dbo.grmRepositoryCategories WHERE dbo.grmRepositoryObjects.ModuleId=dbo.grmRepositoryCategories.ModuleID) if exists (select * from dbo.sysobjects where id = object_id(N'dbo.RepositoryObjects') and OBJECTPROPERTY(id, N'IsUserTable') = 1) BEGIN Declare @OldModuleID int Declare @NewModuleID int INSERT INTO dbo.DesktopModules (FriendlyName, Description, Version, isPremium, IsAdmin,BusinessControllerClass,FolderName,ModuleName,SupportedFeatures) VALUES ('Gooddogs Repository', 'This module is a download/resource module', '',0,0,'Gooddogs.Repository.RepositoryController, Gooddogs.Repository','Repository', 'Gooddogs Repository', 3) DECLARE myCursor CURSOR FOR SELECT DISTINCT DesktopModuleID from dbo.DesktopModules WHERE FriendlyName='Repository' OPEN myCursor FETCH NEXT FROM myCursor INTO @OldModuleID CLOSE myCursor DEALLOCATE myCursor DECLARE myCursor CURSOR FOR SELECT DISTINCT DesktopModuleID from dbo.DesktopModules WHERE FriendlyName='Gooddogs Repository' OPEN myCursor FETCH NEXT FROM myCursor INTO @NewModuleID CLOSE myCursor DEALLOCATE myCursor INSERT INTO dbo.ModuleDefinitions (FriendlyName, DesktopModuleID,DefaultCacheTime) VALUES ('Gooddogs Repository', @NewModuleID,0) DECLARE myCursor CURSOR FOR SELECT DISTINCT ModuleDefID from dbo.ModuleDefinitions WHERE FriendlyName='Repository' OPEN myCursor FETCH NEXT FROM myCursor INTO @OldModuleID CLOSE myCursor DEALLOCATE myCursor DECLARE myCursor CURSOR FOR SELECT DISTINCT ModuleDefID from dbo.ModuleDefinitions WHERE FriendlyName='Gooddogs Repository' OPEN myCursor FETCH NEXT FROM myCursor INTO @NewModuleID CLOSE myCursor DEALLOCATE myCursor UPDATE dbo.Modules SET ModuleDefID = @NewModuleID WHERE ModuleDefID = @OldModuleID DELETE FROM dbo.ModuleDefinitions WHERE FriendlyName = 'Repository' DELETE FROM dbo.ModuleControls WHERE ModuleDefID = @OldModuleID DELETE FROM dbo.DesktopModules WHERE FriendlyName = 'Repository' END
When I view the module, all seems ok, but when I try to Upload a new document, a blank screen appears. I don't know if this blank screen behaviour is a result of the above error.
Would you recommend I try to upgrade from my current version to this latest version (I looked around a little, but I haven't seen a new features list - maybe I missed it? If so, what can I do about the above error? I can't do a clean install, because we have many documents loaded and can't afford to re-upload them right now.
Thanks,
Rozanne