Register   Login
     
  Latest Posts  
RE: content and multiple roles
by SPulley on 10/10/2008 10:02 PM
RE: [RATING] doesn't show
by brit77 on 10/10/2008 9:37 PM
Property Agent Latest Module Carousel Example
by tmaler on 10/10/2008 8:19 PM
Localization
by sueboothby on 10/10/2008 7:55 PM
RE: Listing Item Template
by sueboothby on 10/10/2008 7:42 PM
RE: Is it possible to have the DNN menu POP-UP instead of Drop-Down?
by jmolhava on 10/10/2008 7:25 PM
RE: Listing Item Template
by sueboothby on 10/10/2008 6:52 PM
RE: sub categories question
by eureka on 10/10/2008 6:11 PM
RE: multi categories
by eureka on 10/10/2008 6:02 PM
RE: ENH: NA becomes the Article Manager and LA is the display module
by SteveJ on 10/10/2008 5:21 PM
  Forums  
Subject: Failure in Simple Gallery upgrade / install
Prev Next
You are not authorized to post a reply.

Author Messages
Bryan JarvisUser is Offline
Gold Membership

Posts:25

7/01/2008 7:16 AM  
StartJob Starting Installation
StartJob Reading files
Info Loading SimpleGallery.dnn
Info File SimpleGallery.dnn read successfully
Info Loading RSS.xsl
Info File RSS.xsl read successfully
Info Loading Resources.zip
Info File Resources.zip read successfully
Info Loading ResourcesRandom.zip
Info File ResourcesRandom.zip read successfully
Info Loading ResourcesTagCloud.zip
Info File ResourcesTagCloud.zip read successfully
Info Loading ImageHandler.ashx
Info File ImageHandler.ashx read successfully
Info Loading ImageHandlerLarge.ashx
Info File ImageHandlerLarge.ashx read successfully
Info Loading RSS.aspx
Info File RSS.aspx read successfully
Info Loading SlideShowPopup.aspx
Info File SlideShowPopup.aspx read successfully
Info Loading Uploader.aspx
Info File Uploader.aspx read successfully
Info Loading AddPhoto.ascx
Info File AddPhoto.ascx read successfully
Info Loading Approve.ascx
Info File Approve.ascx read successfully
Info Loading BulkEdit.ascx
Info File BulkEdit.ascx 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 EditSortOrder.ascx
Info File EditSortOrder.ascx read successfully
Info Loading EditTag.ascx
Info File EditTag.ascx read successfully
Info Loading EditTags.ascx
Info File EditTags.ascx read successfully
Info Loading EditTemplate.ascx
Info File EditTemplate.ascx read successfully
Info Loading Gallery.ascx
Info File Gallery.ascx read successfully
Info Loading RandomPhoto.ascx
Info File RandomPhoto.ascx read successfully
Info Loading RandomPhotoOptions.ascx
Info File RandomPhotoOptions.ascx read successfully
Info Loading SlideShow.ascx
Info File SlideShow.ascx read successfully
Info Loading TagCloud.ascx
Info File TagCloud.ascx read successfully
Info Loading TagCloudOptions.ascx
Info File TagCloudOptions.ascx read successfully
Info Loading Tags.ascx
Info File Tags.ascx read successfully
Info Loading ViewGallery.ascx
Info File ViewGallery.ascx read successfully
Info Loading ViewOptions.ascx
Info File ViewOptions.ascx read successfully
Info Loading ViewTag.ascx
Info File ViewTag.ascx read successfully
Info Loading module.css
Info File module.css read successfully
Info Loading web.config
Info File web.config read successfully
Info Loading 02.03.08.SqlDataProvider
Info File 02.03.08.SqlDataProvider read successfully
Info Loading 02.03.10.SqlDataProvider
Info File 02.03.10.SqlDataProvider read successfully
Info Loading 02.03.11.SqlDataProvider
Info File 02.03.11.SqlDataProvider read successfully
Info Loading 02.03.12.SqlDataProvider
Info File 02.03.12.SqlDataProvider read successfully
Info Loading 02.03.14.SqlDataProvider
Info File 02.03.14.SqlDataProvider 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 01.05.00.SqlDataProvider
Info File 01.05.00.SqlDataProvider read successfully
Info Loading 01.05.01.SqlDataProvider
Info File 01.05.01.SqlDataProvider read successfully
Info Loading 01.06.00.SqlDataProvider
Info File 01.06.00.SqlDataProvider read successfully
Info Loading 01.06.01.SqlDataProvider
Info File 01.06.01.SqlDataProvider read successfully
Info Loading 01.06.02.SqlDataProvider
Info File 01.06.02.SqlDataProvider read successfully
Info Loading 01.07.00.SqlDataProvider
Info File 01.07.00.SqlDataProvider read successfully
Info Loading 01.08.00.SqlDataProvider
Info File 01.08.00.SqlDataProvider read successfully
Info Loading 01.08.01.SqlDataProvider
Info File 01.08.01.SqlDataProvider read successfully
Info Loading 01.08.02.SqlDataProvider
Info File 01.08.02.SqlDataProvider read successfully
Info Loading 01.08.03.SqlDataProvider
Info File 01.08.03.SqlDataProvider read successfully
Info Loading 01.08.04.SqlDataProvider
Info File 01.08.04.SqlDataProvider read successfully
Info Loading 01.09.01.SqlDataProvider
Info File 01.09.01.SqlDataProvider read successfully
Info Loading 01.09.02.SqlDataProvider
Info File 01.09.02.SqlDataProvider read successfully
Info Loading 01.09.03.SqlDataProvider
Info File 01.09.03.SqlDataProvider read successfully
Info Loading 01.09.04.SqlDataProvider
Info File 01.09.04.SqlDataProvider read successfully
Info Loading 01.09.05.SqlDataProvider
Info File 01.09.05.SqlDataProvider read successfully
Info Loading 02.00.00.SqlDataProvider
Info File 02.00.00.SqlDataProvider read successfully
Info Loading 02.01.02.SqlDataProvider
Info File 02.01.02.SqlDataProvider read successfully
Info Loading 02.01.05.SqlDataProvider
Info File 02.01.05.SqlDataProvider read successfully
Info Loading 02.02.00.SqlDataProvider
Info File 02.02.00.SqlDataProvider read successfully
Info Loading 02.02.06.SqlDataProvider
Info File 02.02.06.SqlDataProvider read successfully
Info Loading 02.03.00.SqlDataProvider
Info File 02.03.00.SqlDataProvider read successfully
Info Loading 02.03.01.SqlDataProvider
Info File 02.03.01.SqlDataProvider read successfully
Info Loading 02.03.03.SqlDataProvider
Info File 02.03.03.SqlDataProvider read successfully
Info Loading 02.03.05.SqlDataProvider
Info File 02.03.05.SqlDataProvider read successfully
Info Loading Ventrian.SimpleGallery.SqlDataProvider.dll
Info File Ventrian.SimpleGallery.SqlDataProvider.dll read successfully
Info Loading Ventrian.SimpleGallery.dll
Info File Ventrian.SimpleGallery.dll read successfully
EndJob Reading files done.
 
StartJob Reading Installation Manifest file
Info DNN file is in valid 3.0 format.
Info xml loaded.
Info Loading files info
Info Loading Modules info
Info Loading Control info for 'SimpleGallery' module
Info Loading files info
Info Loading Modules info
Info Loading Control info for 'SimpleGallery Random' module
Info Loading files info
Info Loading Modules info
Info Loading Control info for 'SimpleGallery Tag Cloud' module
EndJob Manifest file finished successfully
 
StartJob Begin Sql execution
Info Executing 02.03.08.SqlDataProvider
StartJob Start Sql execution: 02.03.08.SqlDataProvider file
EndJob End Sql execution: 02.03.08.SqlDataProvider file
 
Info Executing 02.03.10.SqlDataProvider
StartJob Start Sql execution: 02.03.10.SqlDataProvider file
EndJob End Sql execution: 02.03.10.SqlDataProvider file
 
Info Executing 02.03.11.SqlDataProvider
StartJob Start Sql execution: 02.03.11.SqlDataProvider file
EndJob End Sql execution: 02.03.11.SqlDataProvider file
 
Info Executing 02.03.12.SqlDataProvider
StartJob Start Sql execution: 02.03.12.SqlDataProvider file
EndJob End Sql execution: 02.03.12.SqlDataProvider file
 
Info Executing 02.03.14.SqlDataProvider
StartJob Start Sql execution: 02.03.14.SqlDataProvider file
Failure SQL Execution resulted in following Exceptions: System.Data.SqlClient.SqlException: The SELECT item identified by the ORDER BY number 7 contains a variable as part of the expression identifying a column position. Variables are only allowed when ordering by an expression referencing a column name. The SELECT item identified by the ORDER BY number 7 contains a variable as part of the expression identifying a column position. Variables are only allowed when ordering by an expression referencing a column name. at System.Data.SqlClient.SqlConnection.OnError(SqlException exception, Boolean breakConnection) at System.Data.SqlClient.SqlInternalConnection.OnError(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) CREATE PROCEDURE dbo.DnnForge_SimpleGallery_AlbumListAll @ModuleID int, @ParentAlbumID int, @ShowPublicOnly bit, @ShowChildren bit, @SortBy int, @SortOrder int as IF( @ShowChildren = 0 ) BEGIN SELECT Album.[AlbumID], Album.[ModuleID], Album.[ParentAlbumID], Album.[Caption], Album.[Description], Album.[IsPublic], Album.[HomeDirectory], Album.[Password], Album.[AlbumOrder], Album.[CreateDate], (select count(*) from dbo.DnnForge_SimpleGallery_Photo where AlbumID = Album.AlbumID and IsApproved = 1) as 'NumberOfPhotos', (select count(*) from dbo.DnnForge_SimpleGallery_Album where ParentAlbumID = Album.AlbumID and IsPublic = 1) as 'NumberOfAlbums', (select count(*) from dbo.DnnForge_SimpleGallery_Album a, dbo.DnnForge_SimpleGallery_Photo p where a.ParentAlbumID = Album.AlbumID and a.AlbumID = p.AlbumID and a.IsPublic = 1 and p.IsApproved = 1) as 'NumberOfAlbumPhotos' FROM dbo.DnnForge_SimpleGallery_Album Album WHERE Album.[ModuleID] = @ModuleID AND Album.[ParentAlbumID] = @ParentAlbumID AND ([Album].[IsPublic] = @ShowPublicOnly OR [Album].[IsPublic] = 1) ORDER BY CASE WHEN @SortBy = 0 and @SortOrder = 0 THEN Album.[Caption] END DESC, CASE WHEN @SortBy = 0 and @SortOrder = 1 THEN Album.[Caption] END ASC, CASE WHEN @SortBy = 1 and @SortOrder = 0 THEN Album.[CreateDate] END DESC, CASE WHEN @SortBy = 1 and @SortOrder = 1 THEN Album.[CreateDate] END ASC, CASE WHEN @SortBy = 2 and @SortOrder = 0 THEN Album.[AlbumOrder] END DESC, CASE WHEN @SortBy = 2 and @SortOrder = 1 THEN Album.[AlbumOrder] END ASC, CASE WHEN @SortBy = 3 THEN newid() END END ELSE BEGIN SET NOCOUNT ON DECLARE @level int, @line int, @current int DECLARE @hierarchy TABLE(AlbumID int, level int) DECLARE @stack TABLE(item int, level int) INSERT INTO @stack VALUES (@ParentAlbumID, 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 IF( @ParentAlbumID = -1 OR @ParentAlbumID != @current ) BEGIN insert into @hierarchy(AlbumID, level) values(@current, @level) END DELETE FROM @stack WHERE level = @level AND item = @current INSERT @stack SELECT Album.AlbumID, @level + 1 FROM dbo.DnnForge_SimpleGallery_Album Album WHERE Album.parentAlbumID = @current and ModuleID = @ModuleID ORDER BY CASE WHEN @SortBy = 0 and @SortOrder = 1 THEN Album.[Caption] END DESC, CASE WHEN @SortBy = 0 and @SortOrder = 0 THEN Album.[Caption] END ASC, CASE WHEN @SortBy = 1 and @SortOrder = 1 THEN Album.[CreateDate] END DESC, CASE WHEN @SortBy = 1 and @SortOrder = 0 THEN Album.[CreateDate] END ASC, CASE WHEN @SortBy = 2 and @SortOrder = 1 THEN Album.[AlbumOrder] END DESC, CASE WHEN @SortBy = 2 and @SortOrder = 0 THEN Album.[AlbumOrder] END ASC, CASE WHEN @SortBy = 3 THEN newid() END --ORDER BY AlbumOrder desc, 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], Album.[AlbumOrder], Album.[CreateDate], (Select count(*) from dbo.DnnForge_SimpleGallery_Photo Photo where Photo.AlbumID = Album.AlbumID) as 'NumberOfPhotos', (select count(*) from dbo.DnnForge_SimpleGallery_Album where ParentAlbumID = Album.AlbumID and IsPublic = 1) as 'NumberOfAlbums', (select count(*) from dbo.DnnForge_SimpleGallery_Album a, dbo.DnnForge_SimpleGallery_Photo p where a.ParentAlbumID = Album.AlbumID and a.AlbumID = p.AlbumID and a.IsPublic = 1 and p.IsApproved = 1) as 'NumberOfAlbumPhotos', REPLICATE('.',(level-2)*2) + Album.[Caption] as 'CaptionIndented' FROM dbo.DnnForge_SimpleGallery_Album Album, @hierarchy h WHERE h.AlbumID = Album.AlbumID AND Album.[ModuleID] = @ModuleID AND ([Album].[IsPublic] = @ShowPublicOnly OR [Album].[IsPublic] = 1) END
EndJob End Sql execution: 02.03.14.SqlDataProvider file
 
EndJob Finished Sql execution
 
StartJob Creating files
StartJob Expanding Resource file
EndJob Resource Files created
 
Info Created C:\DotNetNuke\DesktopModules\SimpleGallery\module.css
Info Created C:\DotNetNuke\DesktopModules\SimpleGallery\AddPhoto.ascx
Info Created C:\DotNetNuke\DesktopModules\SimpleGallery\Approve.ascx
Info Created C:\DotNetNuke\DesktopModules\SimpleGallery\BulkEdit.ascx
Info Created C:\DotNetNuke\DesktopModules\SimpleGallery\EditAlbum.ascx
Info Created C:\DotNetNuke\DesktopModules\SimpleGallery\EditAlbums.ascx
Info Created C:\DotNetNuke\DesktopModules\SimpleGallery\EditSortOrder.ascx
Info Created C:\DotNetNuke\DesktopModules\SimpleGallery\EditPhoto.ascx
Info Created C:\DotNetNuke\DesktopModules\SimpleGallery\EditTag.ascx
Info Created C:\DotNetNuke\DesktopModules\SimpleGallery\EditTags.ascx
Info Created C:\DotNetNuke\DesktopModules\SimpleGallery\EditTemplate.ascx
Info Created C:\DotNetNuke\DesktopModules\SimpleGallery\Gallery.ascx
Info Created C:\DotNetNuke\DesktopModules\SimpleGallery\ImageHandler.ashx
Info Created C:\DotNetNuke\DesktopModules\SimpleGallery\ImageHandlerLarge.ashx
Info Created C:\DotNetNuke\DesktopModules\SimpleGallery\RSS.aspx
Info Created C:\DotNetNuke\DesktopModules\SimpleGallery\RSS.xsl
Info Created C:\DotNetNuke\DesktopModules\SimpleGallery\SlideShow.ascx
Info Created C:\DotNetNuke\DesktopModules\SimpleGallery\SlideShowPopup.aspx
Info Created C:\DotNetNuke\DesktopModules\SimpleGallery\Tags.ascx
Info Created C:\DotNetNuke\DesktopModules\SimpleGallery\Uploader.aspx
Info Created C:\DotNetNuke\DesktopModules\SimpleGallery\ViewGallery.ascx
Info Created C:\DotNetNuke\DesktopModules\SimpleGallery\ViewOptions.ascx
Info Created C:\DotNetNuke\DesktopModules\SimpleGallery\ViewTag.ascx
Info Created C:\DotNetNuke\DesktopModules\SimpleGallery\web.config
Info Created C:\DotNetNuke\bin\Ventrian.SimpleGallery.dll
Info Created C:\DotNetNuke\bin\Ventrian.SimpleGallery.SqlDataProvider.dll
Info Created C:\DotNetNuke\DesktopModules\SimpleGallery\Providers\DataProviders\SqlDataProvider\01.00.00.SqlDataProvider
Info Created C:\DotNetNuke\DesktopModules\SimpleGallery\Providers\DataProviders\SqlDataProvider\01.02.00.SqlDataProvider
Info Created C:\DotNetNuke\DesktopModules\SimpleGallery\Providers\DataProviders\SqlDataProvider\01.05.00.SqlDataProvider
Info Created C:\DotNetNuke\DesktopModules\SimpleGallery\Providers\DataProviders\SqlDataProvider\01.05.01.SqlDataProvider
Info Created C:\DotNetNuke\DesktopModules\SimpleGallery\Providers\DataProviders\SqlDataProvider\01.06.00.SqlDataProvider
Info Created C:\DotNetNuke\DesktopModules\SimpleGallery\Providers\DataProviders\SqlDataProvider\01.06.01.SqlDataProvider
Info Created C:\DotNetNuke\DesktopModules\SimpleGallery\Providers\DataProviders\SqlDataProvider\01.06.02.SqlDataProvider
Info Created C:\DotNetNuke\DesktopModules\SimpleGallery\Providers\DataProviders\SqlDataProvider\01.07.00.SqlDataProvider
Info Created C:\DotNetNuke\DesktopModules\SimpleGallery\Providers\DataProviders\SqlDataProvider\01.08.00.SqlDataProvider
Info Created C:\DotNetNuke\DesktopModules\SimpleGallery\Providers\DataProviders\SqlDataProvider\01.08.01.SqlDataProvider
Info Created C:\DotNetNuke\DesktopModules\SimpleGallery\Providers\DataProviders\SqlDataProvider\01.08.02.SqlDataProvider
Info Created C:\DotNetNuke\DesktopModules\SimpleGallery\Providers\DataProviders\SqlDataProvider\01.08.03.SqlDataProvider
Info Created C:\DotNetNuke\DesktopModules\SimpleGallery\Providers\DataProviders\SqlDataProvider\01.08.04.SqlDataProvider
Info Created C:\DotNetNuke\DesktopModules\SimpleGallery\Providers\DataProviders\SqlDataProvider\01.09.01.SqlDataProvider
Info Created C:\DotNetNuke\DesktopModules\SimpleGallery\Providers\DataProviders\SqlDataProvider\01.09.02.SqlDataProvider
Info Created C:\DotNetNuke\DesktopModules\SimpleGallery\Providers\DataProviders\SqlDataProvider\01.09.03.SqlDataProvider
Info Created C:\DotNetNuke\DesktopModules\SimpleGallery\Providers\DataProviders\SqlDataProvider\01.09.04.SqlDataProvider
Info Created C:\DotNetNuke\DesktopModules\SimpleGallery\Providers\DataProviders\SqlDataProvider\01.09.05.SqlDataProvider
Info Created C:\DotNetNuke\DesktopModules\SimpleGallery\Providers\DataProviders\SqlDataProvider\02.00.00.SqlDataProvider
Info Created C:\DotNetNuke\DesktopModules\SimpleGallery\Providers\DataProviders\SqlDataProvider\02.01.02.SqlDataProvider
Info Created C:\DotNetNuke\DesktopModules\SimpleGallery\Providers\DataProviders\SqlDataProvider\02.01.05.SqlDataProvider
Info Created C:\DotNetNuke\DesktopModules\SimpleGallery\Providers\DataProviders\SqlDataProvider\02.02.00.SqlDataProvider
Info Created C:\DotNetNuke\DesktopModules\SimpleGallery\Providers\DataProviders\SqlDataProvider\02.02.06.SqlDataProvider
Info Created C:\DotNetNuke\DesktopModules\SimpleGallery\Providers\DataProviders\SqlDataProvider\02.03.00.SqlDataProvider
Info Created C:\DotNetNuke\DesktopModules\SimpleGallery\Providers\DataProviders\SqlDataProvider\02.03.01.SqlDataProvider
Info Created C:\DotNetNuke\DesktopModules\SimpleGallery\Providers\DataProviders\SqlDataProvider\02.03.03.SqlDataProvider
Info Created C:\DotNetNuke\DesktopModules\SimpleGallery\Providers\DataProviders\SqlDataProvider\02.03.05.SqlDataProvider
Info Created C:\DotNetNuke\DesktopModules\SimpleGallery\Providers\DataProviders\SqlDataProvider\02.03.08.SqlDataProvider
Info Created C:\DotNetNuke\DesktopModules\SimpleGallery\Providers\DataProviders\SqlDataProvider\02.03.10.SqlDataProvider
Info Created C:\DotNetNuke\DesktopModules\SimpleGallery\Providers\DataProviders\SqlDataProvider\02.03.11.SqlDataProvider
Info Created C:\DotNetNuke\DesktopModules\SimpleGallery\Providers\DataProviders\SqlDataProvider\02.03.12.SqlDataProvider
Info Created C:\DotNetNuke\DesktopModules\SimpleGallery\Providers\DataProviders\SqlDataProvider\02.03.14.SqlDataProvider
Info Created C:\DotNetNuke\DesktopModules\SimpleGallery\uninstall.SqlDataProvider
Info Created C:\DotNetNuke\DesktopModules\SimpleGallery\SimpleGallery.dnn.config
EndJob Files created
 
StartJob Registering DesktopModule
Info Registering Definitions
Info Registering Controls
EndJob Registering finished
 
StartJob Begin Sql execution
EndJob Finished Sql execution
 
StartJob Creating files
StartJob Expanding Resource file
EndJob Resource Files created
 
Info Created C:\DotNetNuke\DesktopModules\SimpleGallery Random\ImageHandler.ashx
Info Created C:\DotNetNuke\DesktopModules\SimpleGallery Random\module.css
Info Created C:\DotNetNuke\DesktopModules\SimpleGallery Random\RandomPhoto.ascx
Info Created C:\DotNetNuke\DesktopModules\SimpleGallery Random\RandomPhotoOptions.ascx
Info Created C:\DotNetNuke\DesktopModules\SimpleGallery Random\SimpleGallery.dnn.config
EndJob Files created
 
StartJob Registering DesktopModule
Info Registering Definitions
Info Registering Controls
EndJob Registering finished
 
StartJob Begin Sql execution
EndJob Finished Sql execution
 
StartJob Creating files
StartJob Expanding Resource file
EndJob Resource Files created
 
Info Created C:\DotNetNuke\DesktopModules\SimpleGallery Tag Cloud\module.css
Info Created C:\DotNetNuke\DesktopModules\SimpleGallery Tag Cloud\TagCloud.ascx
Info Created C:\DotNetNuke\DesktopModules\SimpleGallery Tag Cloud\TagCloudOptions.ascx
Info Created C:\DotNetNuke\DesktopModules\SimpleGallery Tag Cloud\SimpleGallery.dnn.config
EndJob Files created
 
StartJob Registering DesktopModule
Info Registering Definitions
Info Registering Controls
EndJob Registering finished
 
EndJob Installation successful.
 
Scott McCullochUser is Offline
Administrators
Nuke Master
Nuke Master
Posts:12004


7/01/2008 7:27 AM  
Hmm, I didn't experience this on any of my installs.

What version of SQL Server? SQL 2000 or 2005?

Scott McCulloch
Site Administrator
Bryan JarvisUser is Offline
Gold Membership

Posts:25

7/01/2008 8:07 AM  

SQL Server 2000, I believe.  On Windows Server2000

Bryan JarvisUser is Offline
Gold Membership

Posts:25

7/01/2008 8:11 AM  

Yes, SQL2000 -

 

Microsoft SQL Server  2000 - 8.00.2040 (Intel X86)   May 13 2005 18:33:17   Copyright (c) 1988-2003 Microsoft Corporation  Standard Edition on Windows NT 5.0 (Build 2195: Service Pack 4)

Scott McCullochUser is Offline
Administrators
Nuke Master
Nuke Master
Posts:12004


7/01/2008 8:25 AM  
That looks to be an issue, I'll have to restructure the query to handle SQL 2000.

I'll release a new build when that is complete (~12-24 hours time)

Scott McCulloch
Site Administrator
Bryan JarvisUser is Offline
Gold Membership

Posts:25

7/01/2008 8:27 AM  
Thanks a lot! I'll be standing by.

Bryan
Scott McCullochUser is Offline
Administrators
Nuke Master
Nuke Master
Posts:12004


7/02/2008 6:39 AM  
Can you try the release I just posted?

Scott McCulloch
Site Administrator
Bryan JarvisUser is Offline
Gold Membership

Posts:25

7/02/2008 7:11 AM  
Thanks, Scott - that _appears_ to have worked, but I still got a failure message in the install/upgrade.


here's the trail:

StartJob Starting Installation
StartJob Reading files
Info Loading SimpleGallery.dnn
Info File SimpleGallery.dnn read successfully
Info Loading RSS.xsl
Info File RSS.xsl read successfully
Info Loading Resources.zip
Info File Resources.zip read successfully
Info Loading ResourcesRandom.zip
Info File ResourcesRandom.zip read successfully
Info Loading ResourcesTagCloud.zip
Info File ResourcesTagCloud.zip read successfully
Info Loading ImageHandler.ashx
Info File ImageHandler.ashx read successfully
Info Loading ImageHandlerLarge.ashx
Info File ImageHandlerLarge.ashx read successfully
Info Loading RSS.aspx
Info File RSS.aspx read successfully
Info Loading SlideShowPopup.aspx
Info File SlideShowPopup.aspx read successfully
Info Loading Uploader.aspx
Info File Uploader.aspx read successfully
Info Loading AddPhoto.ascx
Info File AddPhoto.ascx read successfully
Info Loading Approve.ascx
Info File Approve.ascx read successfully
Info Loading BulkEdit.ascx
Info File BulkEdit.ascx 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 EditSortOrder.ascx
Info File EditSortOrder.ascx read successfully
Info Loading EditTag.ascx
Info File EditTag.ascx read successfully
Info Loading EditTags.ascx
Info File EditTags.ascx read successfully
Info Loading EditTemplate.ascx
Info File EditTemplate.ascx read successfully
Info Loading Gallery.ascx
Info File Gallery.ascx read successfully
Info Loading RandomPhoto.ascx
Info File RandomPhoto.ascx read successfully
Info Loading RandomPhotoOptions.ascx
Info File RandomPhotoOptions.ascx read successfully
Info Loading SlideShow.ascx
Info File SlideShow.ascx read successfully
Info Loading TagCloud.ascx
Info File TagCloud.ascx read successfully
Info Loading TagCloudOptions.ascx
Info File TagCloudOptions.ascx read successfully
Info Loading Tags.ascx
Info File Tags.ascx read successfully
Info Loading ViewGallery.ascx
Info File ViewGallery.ascx read successfully
Info Loading ViewOptions.ascx
Info File ViewOptions.ascx read successfully
Info Loading ViewTag.ascx
Info File ViewTag.ascx read successfully
Info Loading module.css
Info File module.css read successfully
Info Loading web.config
Info File web.config 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 01.05.00.SqlDataProvider
Info File 01.05.00.SqlDataProvider read successfully
Info Loading 01.05.01.SqlDataProvider
Info File 01.05.01.SqlDataProvider read successfully
Info Loading 01.06.00.SqlDataProvider
Info File 01.06.00.SqlDataProvider read successfully
Info Loading 01.06.01.SqlDataProvider
Info File 01.06.01.SqlDataProvider read successfully
Info Loading 01.06.02.SqlDataProvider
Info File 01.06.02.SqlDataProvider read successfully
Info Loading 01.07.00.SqlDataProvider
Info File 01.07.00.SqlDataProvider read successfully
Info Loading 01.08.00.SqlDataProvider
Info File 01.08.00.SqlDataProvider read successfully
Info Loading 01.08.01.SqlDataProvider
Info File 01.08.01.SqlDataProvider read successfully
Info Loading 01.08.02.SqlDataProvider
Info File 01.08.02.SqlDataProvider read successfully
Info Loading 01.08.03.SqlDataProvider
Info File 01.08.03.SqlDataProvider read successfully
Info Loading 01.08.04.SqlDataProvider
Info File 01.08.04.SqlDataProvider read successfully
Info Loading 01.09.01.SqlDataProvider
Info File 01.09.01.SqlDataProvider read successfully
Info Loading 01.09.02.SqlDataProvider
Info File 01.09.02.SqlDataProvider read successfully
Info Loading 01.09.03.SqlDataProvider
Info File 01.09.03.SqlDataProvider read successfully
Info Loading 01.09.04.SqlDataProvider
Info File 01.09.04.SqlDataProvider read successfully
Info Loading 01.09.05.SqlDataProvider
Info File 01.09.05.SqlDataProvider read successfully
Info Loading 02.00.00.SqlDataProvider
Info File 02.00.00.SqlDataProvider read successfully
Info Loading 02.01.02.SqlDataProvider
Info File 02.01.02.SqlDataProvider read successfully
Info Loading 02.01.05.SqlDataProvider
Info File 02.01.05.SqlDataProvider read successfully
Info Loading 02.02.00.SqlDataProvider
Info File 02.02.00.SqlDataProvider read successfully
Info Loading 02.02.06.SqlDataProvider
Info File 02.02.06.SqlDataProvider read successfully
Info Loading 02.03.00.SqlDataProvider
Info File 02.03.00.SqlDataProvider read successfully
Info Loading 02.03.01.SqlDataProvider
Info File 02.03.01.SqlDataProvider read successfully
Info Loading 02.03.03.SqlDataProvider
Info File 02.03.03.SqlDataProvider read successfully
Info Loading 02.03.05.SqlDataProvider
Info File 02.03.05.SqlDataProvider read successfully
Info Loading 02.03.08.SqlDataProvider
Info File 02.03.08.SqlDataProvider read successfully
Info Loading 02.03.10.SqlDataProvider
Info File 02.03.10.SqlDataProvider read successfully
Info Loading 02.03.11.SqlDataProvider
Info File 02.03.11.SqlDataProvider read successfully
Info Loading 02.03.12.SqlDataProvider
Info File 02.03.12.SqlDataProvider read successfully
Info Loading 02.03.14.SqlDataProvider
Info File 02.03.14.SqlDataProvider read successfully
Info Loading 02.03.15.SqlDataProvider
Info File 02.03.15.SqlDataProvider read successfully
Info Loading Ventrian.SimpleGallery.SqlDataProvider.dll
Info File Ventrian.SimpleGallery.SqlDataProvider.dll read successfully
Info Loading Ventrian.SimpleGallery.dll
Info File Ventrian.SimpleGallery.dll read successfully
EndJob Reading files done.

StartJob Reading Installation Manifest file
Info DNN file is in valid 3.0 format.
Info xml loaded.
Info Loading files info
Info Loading Modules info
Info Loading Control info for 'SimpleGallery' module
Info Loading files info
Info Loading Modules info
Info Loading Control info for 'SimpleGallery Random' module
Info Loading files info
Info Loading Modules info
Info Loading Control info for 'SimpleGallery Tag Cloud' module
EndJob Manifest file finished successfully

StartJob Begin Sql execution
Info Executing 02.03.15.SqlDataProvider
StartJob Start Sql execution: 02.03.15.SqlDataProvider file
Failure SQL Execution resulted in following Exceptions: System.Data.SqlClient.SqlException: Cannot drop the procedure 'dbo.DnnForge_SimpleGallery_AlbumListAll', because it does not exist in the system catalog. at System.Data.SqlClient.SqlConnection.OnError(SqlException exception, Boolean breakConnection) at System.Data.SqlClient.SqlInternalConnection.OnError(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) DROP PROCEDURE dbo.DnnForge_SimpleGallery_AlbumListAll
EndJob End Sql execution: 02.03.15.SqlDataProvider file

EndJob Finished Sql execution

StartJob Creating files
StartJob Expanding Resource file
EndJob Resource Files created

Info Created C:\DotNetNuke\DesktopModules\SimpleGallery\module.css
Info Created C:\DotNetNuke\DesktopModules\SimpleGallery\AddPhoto.ascx
Info Created C:\DotNetNuke\DesktopModules\SimpleGallery\Approve.ascx
Info Created C:\DotNetNuke\DesktopModules\SimpleGallery\BulkEdit.ascx
Info Created C:\DotNetNuke\DesktopModules\SimpleGallery\EditAlbum.ascx
Info Created C:\DotNetNuke\DesktopModules\SimpleGallery\EditAlbums.ascx
Info Created C:\DotNetNuke\DesktopModules\SimpleGallery\EditSortOrder.ascx
Info Created C:\DotNetNuke\DesktopModules\SimpleGallery\EditPhoto.ascx
Info Created C:\DotNetNuke\DesktopModules\SimpleGallery\EditTag.ascx
Info Created C:\DotNetNuke\DesktopModules\SimpleGallery\EditTags.ascx
Info Created C:\DotNetNuke\DesktopModules\SimpleGallery\EditTemplate.ascx
Info Created C:\DotNetNuke\DesktopModules\SimpleGallery\Gallery.ascx
Info Created C:\DotNetNuke\DesktopModules\SimpleGallery\ImageHandler.ashx
Info Created C:\DotNetNuke\DesktopModules\SimpleGallery\ImageHandlerLarge.ashx
Info Created C:\DotNetNuke\DesktopModules\SimpleGallery\RSS.aspx
Info Created C:\DotNetNuke\DesktopModules\SimpleGallery\RSS.xsl
Info Created C:\DotNetNuke\DesktopModules\SimpleGallery\SlideShow.ascx
Info Created C:\DotNetNuke\DesktopModules\SimpleGallery\SlideShowPopup.aspx
Info Created C:\DotNetNuke\DesktopModules\SimpleGallery\Tags.ascx
Info Created C:\DotNetNuke\DesktopModules\SimpleGallery\Uploader.aspx
Info Created C:\DotNetNuke\DesktopModules\SimpleGallery\ViewGallery.ascx
Info Created C:\DotNetNuke\DesktopModules\SimpleGallery\ViewOptions.ascx
Info Created C:\DotNetNuke\DesktopModules\SimpleGallery\ViewTag.ascx
Info Created C:\DotNetNuke\DesktopModules\SimpleGallery\web.config
Info Created C:\DotNetNuke\bin\Ventrian.SimpleGallery.dll
Info Created C:\DotNetNuke\bin\Ventrian.SimpleGallery.SqlDataProvider.dll
Info Created C:\DotNetNuke\DesktopModules\SimpleGallery\Providers\DataProviders\SqlDataProvider\01.00.00.SqlDataProvider
Info Created C:\DotNetNuke\DesktopModules\SimpleGallery\Providers\DataProviders\SqlDataProvider\01.02.00.SqlDataProvider
Info Created C:\DotNetNuke\DesktopModules\SimpleGallery\Providers\DataProviders\SqlDataProvider\01.05.00.SqlDataProvider
Info Created C:\DotNetNuke\DesktopModules\SimpleGallery\Providers\DataProviders\SqlDataProvider\01.05.01.SqlDataProvider
Info Created C:\DotNetNuke\DesktopModules\SimpleGallery\Providers\DataProviders\SqlDataProvider\01.06.00.SqlDataProvider
Info Created C:\DotNetNuke\DesktopModules\SimpleGallery\Providers\DataProviders\SqlDataProvider\01.06.01.SqlDataProvider
Info Created C:\DotNetNuke\DesktopModules\SimpleGallery\Providers\DataProviders\SqlDataProvider\01.06.02.SqlDataProvider
Info Created C:\DotNetNuke\DesktopModules\SimpleGallery\Providers\DataProviders\SqlDataProvider\01.07.00.SqlDataProvider
Info Created C:\DotNetNuke\DesktopModules\SimpleGallery\Providers\DataProviders\SqlDataProvider\01.08.00.SqlDataProvider
Info Created C:\DotNetNuke\DesktopModules\SimpleGallery\Providers\DataProviders\SqlDataProvider\01.08.01.SqlDataProvider
Info Created C:\DotNetNuke\DesktopModules\SimpleGallery\Providers\DataProviders\SqlDataProvider\01.08.02.SqlDataProvider
Info Created C:\DotNetNuke\DesktopModules\SimpleGallery\Providers\DataProviders\SqlDataProvider\01.08.03.SqlDataProvider
Info Created C:\DotNetNuke\DesktopModules\SimpleGallery\Providers\DataProviders\SqlDataProvider\01.08.04.SqlDataProvider
Info Created C:\DotNetNuke\DesktopModules\SimpleGallery\Providers\DataProviders\SqlDataProvider\01.09.01.SqlDataProvider
Info Created C:\DotNetNuke\DesktopModules\SimpleGallery\Providers\DataProviders\SqlDataProvider\01.09.02.SqlDataProvider
Info Created C:\DotNetNuke\DesktopModules\SimpleGallery\Providers\DataProviders\SqlDataProvider\01.09.03.SqlDataProvider
Info Created C:\DotNetNuke\DesktopModules\SimpleGallery\Providers\DataProviders\SqlDataProvider\01.09.04.SqlDataProvider
Info Created C:\DotNetNuke\DesktopModules\SimpleGallery\Providers\DataProviders\SqlDataProvider\01.09.05.SqlDataProvider
Info Created C:\DotNetNuke\DesktopModules\SimpleGallery\Providers\DataProviders\SqlDataProvider\02.00.00.SqlDataProvider
Info Created C:\DotNetNuke\DesktopModules\SimpleGallery\Providers\DataProviders\SqlDataProvider\02.01.02.SqlDataProvider
Info Created C:\DotNetNuke\DesktopModules\SimpleGallery\Providers\DataProviders\SqlDataProvider\02.01.05.SqlDataProvider
Info Created C:\DotNetNuke\DesktopModules\SimpleGallery\Providers\DataProviders\SqlDataProvider\02.02.00.SqlDataProvider
Info Created C:\DotNetNuke\DesktopModules\SimpleGallery\Providers\DataProviders\SqlDataProvider\02.02.06.SqlDataProvider
Info Created C:\DotNetNuke\DesktopModules\SimpleGallery\Providers\DataProviders\SqlDataProvider\02.03.00.SqlDataProvider
Info Created C:\DotNetNuke\DesktopModules\SimpleGallery\Providers\DataProviders\SqlDataProvider\02.03.01.SqlDataProvider
Info Created C:\DotNetNuke\DesktopModules\SimpleGallery\Providers\DataProviders\SqlDataProvider\02.03.03.SqlDataProvider
Info Created C:\DotNetNuke\DesktopModules\SimpleGallery\Providers\DataProviders\SqlDataProvider\02.03.05.SqlDataProvider
Info Created C:\DotNetNuke\DesktopModules\SimpleGallery\Providers\DataProviders\SqlDataProvider\02.03.08.SqlDataProvider
Info Created C:\DotNetNuke\DesktopModules\SimpleGallery\Providers\DataProviders\SqlDataProvider\02.03.10.SqlDataProvider
Info Created C:\DotNetNuke\DesktopModules\SimpleGallery\Providers\DataProviders\SqlDataProvider\02.03.11.SqlDataProvider
Info Created C:\DotNetNuke\DesktopModules\SimpleGallery\Providers\DataProviders\SqlDataProvider\02.03.12.SqlDataProvider
Info Created C:\DotNetNuke\DesktopModules\SimpleGallery\Providers\DataProviders\SqlDataProvider\02.03.14.SqlDataProvider
Info Created C:\DotNetNuke\DesktopModules\SimpleGallery\Providers\DataProviders\SqlDataProvider\02.03.15.SqlDataProvider
Info Created C:\DotNetNuke\DesktopModules\SimpleGallery\uninstall.SqlDataProvider
Info Created C:\DotNetNuke\DesktopModules\SimpleGallery\SimpleGallery.dnn.config
EndJob Files created

StartJob Registering DesktopModule
Info Registering Definitions
Info Registering Controls
EndJob Registering finished

StartJob Begin Sql execution
EndJob Finished Sql execution

StartJob Creating files
StartJob Expanding Resource file
EndJob Resource Files created

Info Created C:\DotNetNuke\DesktopModules\SimpleGallery Random\ImageHandler.ashx
Info Created C:\DotNetNuke\DesktopModules\SimpleGallery Random\module.css
Info Created C:\DotNetNuke\DesktopModules\SimpleGallery Random\RandomPhoto.ascx
Info Created C:\DotNetNuke\DesktopModules\SimpleGallery Random\RandomPhotoOptions.ascx
Info Created C:\DotNetNuke\DesktopModules\SimpleGallery Random\SimpleGallery.dnn.config
EndJob Files created

StartJob Registering DesktopModule
Info Registering Definitions
Info Registering Controls
EndJob Registering finished

StartJob Begin Sql execution
EndJob Finished Sql execution

StartJob Creating files
StartJob Expanding Resource file
EndJob Resource Files created

Info Created C:\DotNetNuke\DesktopModules\SimpleGallery Tag Cloud\module.css
Info Created C:\DotNetNuke\DesktopModules\SimpleGallery Tag Cloud\TagCloud.ascx
Info Created C:\DotNetNuke\DesktopModules\SimpleGallery Tag Cloud\TagCloudOptions.ascx
Info Created C:\DotNetNuke\DesktopModules\SimpleGallery Tag Cloud\SimpleGallery.dnn.config
EndJob Files created

StartJob Registering DesktopModule
Info Registering Definitions
Info Registering Controls
EndJob Registering finished

EndJob Installation successful.
Scott McCullochUser is Offline
Administrators
Nuke Master
Nuke Master
Posts:12004


7/03/2008 7:22 AM  
Yep that's OK, it was because the previous install failed.

Scott McCulloch
Site Administrator
You are not authorized to post a reply.
Forums > General > Bugs & Problems > Failure in Simple Gallery upgrade / install



ActiveForums 3.7