Hi

I tried upgrading from 1.4 to 1.5 - oops

More than likely i did something wrong but now its totally dead. It wont allow me to uninstall the module and i cant get it to carry out the upgrade without errors.

The source distribution for 1.5 is also missing some DLL's acording to the installer.

The errors im getting when installing 1.5 are these;

Resource Upload Logs

Return

StartJob Starting Installation StartJob Reading files Info Loading ImageHandler.ashx Info File ImageHandler.ashx read successfully Info Loading EditAlbum.ascx Info File EditAlbum.ascx read successfully Info Loading EditAlbums.ascx Info File EditAlbums.ascx read successfully Info Loading EditPhoto.ascx Info File EditPhoto.ascx read successfully Info Loading Gallery.ascx Info File Gallery.ascx read successfully Info Loading SlideShow.ascx Info File SlideShow.ascx read successfully Info Loading ViewOptions.ascx Info File ViewOptions.ascx read successfully Info Loading SlideShowPopup.aspx Info File SlideShowPopup.aspx read successfully Info Loading module.css Info File module.css read successfully Info Loading Resources.zip Info File Resources.zip read successfully Info Loading SimpleGallery.dnn Info File SimpleGallery.dnn read successfully Info Loading uninstall.SqlDataProvider Info File uninstall.SqlDataProvider read successfully Info Loading 01.00.00.SqlDataProvider Info File 01.00.00.SqlDataProvider read successfully Info Loading 01.02.00.SqlDataProvider Info File 01.02.00.SqlDataProvider read successfully Info Loading DnnForge.SimpleGallery.dll Info File DnnForge.SimpleGallery.dll read successfully Info Loading DnnForge.SimpleGallery.SqlDataProvider.dll Info File DnnForge.SimpleGallery.SqlDataProvider.dll read successfully Info Loading 01.05.00.SqlDataProvider Info File 01.05.00.SqlDataProvider read successfully EndJob Reading files done.   StartJob Reading DNN file Info DNN file is in valid 3.0 format. Info ... Info Loading files info Info Loading Modules info Info Loading Control info for 'SimpleGallery' module EndJob Dnn load finished successfully   StartJob Begin Sql execution Info Executing 01.05.00.SqlDataProvider StartJob Start Sql execution: 01.05.00.SqlDataProvider file Failure SQL Execution resulted in following Exceptions: System.Data.SqlClient.SqlException: Cannot alter table 'dbo.DnnForge_SimpleGallery_Album' because this table does not exist in database 'mmsccuk'. 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) ALTER TABLE dbo.DnnForge_SimpleGallery_Album ADD ParentAlbumID int NOT NULL Default -1, Description nvarchar(255) NULL, Password nvarchar(50) NULL System.Data.SqlClient.SqlException: Cannot alter table 'dbo.DnnForge_SimpleGallery_Photo' because this table does not exist in database 'mmsccuk'. 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) ALTER TABLE dbo.DnnForge_SimpleGallery_Photo ADD IsDefault bit NOT NULL Default 0 System.Data.SqlClient.SqlException: There is already an object named 'DnnForge_SimpleGallery_SetDefaultPhoto' in the database. 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) CREATE PROCEDURE dbo.DnnForge_SimpleGallery_SetDefaultPhoto @PhotoID int, @AlbumID int AS UPDATE dbo.DnnForge_SimpleGallery_Photo SET [IsDefault] = 0 WHERE [AlbumID] = @AlbumID UPDATE dbo.DnnForge_SimpleGallery_Photo SET [IsDefault] = 1 WHERE [PhotoID] = @PhotoID System.Data.SqlClient.SqlException: There is already an object named 'DnnForge_SimpleGallery_AlbumListAll' in the database. 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) CREATE PROCEDURE dbo.DnnForge_SimpleGallery_AlbumListAll @ModuleID int, @current int, @ShowPublicOnly bit as SET NOCOUNT ON DECLARE @level int, @line int CREATE TABLE #hierarchy(AlbumID int, level int) CREATE TABLE #stack (item int, level int) INSERT INTO #stack VALUES (@current, 1) SELECT @level = 1 WHILE @level > 0 BEGIN IF EXISTS (SELECT * FROM #stack WHERE level = @level) BEGIN SELECT @current = item FROM #stack WHERE level = @level insert into #hierarchy(AlbumID, level) values(@current, @level) DELETE FROM #stack WHERE level = @level AND item = @current INSERT #stack SELECT AlbumID, @level + 1 FROM dbo.DnnForge_SimpleGallery_Album WHERE parentAlbumID = @current and ModuleID = @ModuleID ORDER BY Caption desc IF @@ROWCOUNT > 0 SELECT @level = @level + 1 END ELSE SELECT @level = @level - 1 END -- WHILE SELECT Album.[AlbumID], Album.[ModuleID], Album.[ParentAlbumID], Album.[Caption], Album.[Description], Album.[IsPublic], Album.[HomeDirectory], Album.[Password], (Select count(*) from dbo.DnnForge_SimpleGallery_Photo Photo where Photo.AlbumID = Album.AlbumID) as 'NumberOfPhotos', REPLICATE('.',(level-2)*2) + Album.[Caption] as 'CaptionIndented' FROM dbo.DnnForge_SimpleGallery_Album Album, #hierarchy WHERE #hierarchy.AlbumID = Album.AlbumID AND Album.[ModuleID] = @ModuleID AND ([Album].[IsPublic] = @ShowPublicOnly OR [Album].[IsPublic] = 1) drop table #hierarchy drop table #stack EndJob End Sql execution: 01.05.00.SqlDataProvider file   EndJob Finished Sql execution   StartJob Creating files StartJob Expanding Resource file EndJob Resource Files created   Failure ExceptionSystem.ArgumentException: Invalid File or Directory attributes value. at System.IO.File.SetAttributes(String path, FileAttributes fileAttributes) at DotNetNuke.Modules.Admin.ResourceInstaller.PaDnnInstallerBase.CreateFile(String FullFileName, Byte[] Buffer) at DotNetNuke.Modules.Admin.ResourceInstaller.PaDnnInstallerBase.CreateModuleFile(PaFile File, PaFolder Folder) at DotNetNuke.Modules.Admin.ResourceInstaller.PaDnnInstallerBase.CreateFiles(PaFolder Folder) at DotNetNuke.Modules.Admin.ResourceInstaller.PaDnnInstallerBase.Install(PaFolderCollection folders) at DotNetNuke.Modules.Admin.ResourceInstaller.PaInstaller.Install()

Return

Thanks in advance for your help

Hi,

You should be installing the PA not the source version... You might have to manually remove the tables and stored procs if it won't uninstall, and then install from scratch. You will have to re-upload your photo(s) though.

Hi

I tried removing the tables/sp from the db and deleted all the module files off the server and then attempted to re-install here are the results;

Resource Upload Logs

Return

StartJob Starting Installation StartJob Reading files Info Loading ImageHandler.ashx Info File ImageHandler.ashx read successfully Info Loading EditAlbum.ascx Info File EditAlbum.ascx read successfully Info Loading EditAlbums.ascx Info File EditAlbums.ascx read successfully Info Loading EditPhoto.ascx Info File EditPhoto.ascx read successfully Info Loading Gallery.ascx Info File Gallery.ascx read successfully Info Loading SlideShow.ascx Info File SlideShow.ascx read successfully Info Loading ViewOptions.ascx Info File ViewOptions.ascx read successfully Info Loading SlideShowPopup.aspx Info File SlideShowPopup.aspx read successfully Info Loading module.css Info File module.css read successfully Info Loading Resources.zip Info File Resources.zip read successfully Info Loading SimpleGallery.dnn Info File SimpleGallery.dnn read successfully Info Loading uninstall.SqlDataProvider Info File uninstall.SqlDataProvider read successfully Info Loading 01.00.00.SqlDataProvider Info File 01.00.00.SqlDataProvider read successfully Info Loading 01.02.00.SqlDataProvider Info File 01.02.00.SqlDataProvider read successfully Info Loading DnnForge.SimpleGallery.dll Info File DnnForge.SimpleGallery.dll read successfully Info Loading DnnForge.SimpleGallery.SqlDataProvider.dll Info File DnnForge.SimpleGallery.SqlDataProvider.dll read successfully Info Loading 01.05.00.SqlDataProvider Info File 01.05.00.SqlDataProvider read successfully EndJob Reading files done.   StartJob Reading DNN file Info DNN file is in valid 3.0 format. Info ... Info Loading files info Info Loading Modules info Info Loading Control info for 'SimpleGallery' module EndJob Dnn load finished successfully   StartJob Begin Sql execution Info Executing 01.00.00.SqlDataProvider StartJob Start Sql execution: 01.00.00.SqlDataProvider file EndJob End Sql execution: 01.00.00.SqlDataProvider file   Info Executing 01.02.00.SqlDataProvider StartJob Start Sql execution: 01.02.00.SqlDataProvider file EndJob End Sql execution: 01.02.00.SqlDataProvider file   Info Executing 01.05.00.SqlDataProvider StartJob Start Sql execution: 01.05.00.SqlDataProvider file EndJob End Sql execution: 01.05.00.SqlDataProvider file   EndJob Finished Sql execution   StartJob Creating files StartJob Expanding Resource file EndJob Resource Files created   Info Created D:\Inetpub\mmsccuk.co.uk\www\DesktopModules\SimpleGallery\module.css Info Created D:\Inetpub\mmsccuk.co.uk\www\DesktopModules\SimpleGallery\EditAlbum.ascx Info Created D:\Inetpub\mmsccuk.co.uk\www\DesktopModules\SimpleGallery\EditAlbums.ascx Info Created D:\Inetpub\mmsccuk.co.uk\www\DesktopModules\SimpleGallery\EditPhoto.ascx Info Created D:\Inetpub\mmsccuk.co.uk\www\DesktopModules\SimpleGallery\Gallery.ascx Info Created D:\Inetpub\mmsccuk.co.uk\www\DesktopModules\SimpleGallery\SlideShow.ascx Info Created D:\Inetpub\mmsccuk.co.uk\www\DesktopModules\SimpleGallery\SlideShowPopup.aspx Info Created D:\Inetpub\mmsccuk.co.uk\www\DesktopModules\SimpleGallery\ImageHandler.ashx Info Created D:\Inetpub\mmsccuk.co.uk\www\DesktopModules\SimpleGallery\ViewOptions.ascx Failure ExceptionSystem.ArgumentException: Invalid File or Directory attributes value. at System.IO.File.SetAttributes(String path, FileAttributes fileAttributes) at DotNetNuke.Modules.Admin.ResourceInstaller.PaDnnInstallerBase.CreateFile(String FullFileName, Byte[] Buffer) at DotNetNuke.Modules.Admin.ResourceInstaller.PaDnnInstallerBase.CreateBinFile(PaFile File) at DotNetNuke.Modules.Admin.ResourceInstaller.PaDnnInstallerBase.CreateFiles(PaFolder Folder) at DotNetNuke.Modules.Admin.ResourceInstaller.PaDnnInstallerBase.Install(PaFolderCollection folders) at DotNetNuke.Modules.Admin.ResourceInstaller.PaInstaller.Install()

????

Thanks for the quick response

 numpty, when i moved it from one server to another i didnt reset these permissions. Duly done and all systems go again.

Thank you