Update 2009.6.3: This bug has been fixed in version 2.3.3440.

The key message in there is "There is already an object named 'gs_AppError' in the database." There is a bug in the SQL upgrade script in the newest release that (I think) occurs when the database owner is not dbo. There are a few different ways of getting around this. If you are comfortable executing SQL using SQL Management Studio, try running the attached SQL - it contains the bug fix.

You can also try changing your database to be owned by dbo and then running the upgrade again.

No. Use this one for SQL Server 2000 / MSDE 2000.

Hi Roger,

I tried the upgrade and got the same error with 'gs_AppError'. Our test environment is using MS SQL 2000, so I tried the SQL 2000 script, and this is now the error I get when I try to view the gallery:

========================================================
Error Summary

Url


http://localhost/gs/default.aspx

Timestamp


5/20/2009 3:28:15 PM

Exception Type


System.TypeInitializationException

Message


The type initializer for 'GalleryServerPro.Web.Pages.GalleryPage' threw an exception.

Source


GalleryServerPro.Web

Target Site


Void .ctor()

Stack Trace


at GalleryServerPro.Web.Pages.GalleryPage..ctor()
at GalleryServerPro.Web.gs.pages.album..ctor()
at ASP.gs_pages_album_ascx..ctor()
at __ASP.FastObjectFactory_app_web_o1lhgpcg.Create_ASP_gs_pages_album_ascx()
at System.Web.Compilation.BuildResultCompiledType.CreateInstance()
at System.Web.UI.TemplateControl.LoadControl(IWebObjectFactory objectFactory, VirtualPath virtualPath, Type t, Object[] parameters)
at System.Web.UI.TemplateControl.LoadControl(VirtualPath virtualPath)
at System.Web.UI.TemplateControl.LoadControl(String virtualPath)
at GalleryServerPro.Web.Gallery.LoadRequestedPage()
at GalleryServerPro.Web.Gallery.Gallery_Init(Object sender, EventArgs e)
at System.Web.UI.Control.OnInit(EventArgs e)
at System.Web.UI.UserControl.OnInit(EventArgs e)
at System.Web.UI.Control.InitRecursive(Control namingContainer)
at System.Web.UI.Control.InitRecursive(Control namingContainer)
at System.Web.UI.Control.InitRecursive(Control namingContainer)
at System.Web.UI.Page.ProcessRequestMain(Boolean includeStagesBeforeAsyncPoint, Boolean includeStagesAfterAsyncPoint)

Exception Data


Error Handling Exception: The following error occurred while handling the exception: System.Data.SqlClient.SqlException - Could not find stored procedure 'dbo.gs_AppErrorSelect'. Stack trace: 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(TdsParserStateO bject 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(CommandBehavior behavior)
at GalleryServerPro.Data.SqlServer.SqlDataProvider.AppError_GetAppErrors() at GalleryServerPro.ErrorHandler.Error.GetAppErrors()
at GalleryServerPro.ErrorHandler.Error.ValidateLogSize()
at GalleryServerPro.ErrorHandler.Error.Record(Exception ex)
at GalleryServerPro.Web.Controller.AppErrorController.HandleGalleryExceptio n(Exception ex)

Inner Ex Type


System.Data.SqlClient.SqlException

Inner Ex Message


There is already an object named 'gs_AppError' in the database.

Inner Ex Source


.Net SqlClient Data Provider

Inner Ex Target Site


Void OnError(System.Data.SqlClient.SqlException, Boolean)

Inner Ex Stack Trace


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 GalleryServerPro.Data.SqlServer.SqlDataProvider.ExecuteSqlInStream(Stream stream)
at GalleryServerPro.Data.SqlServer.SqlDataProvider.ExecuteSqlUpgrade(GalleryDataSchemaUpgradeScript script)
at GalleryServerPro.Data.SqlServer.SqlDataProvider.VerifySchemaVersion()
at GalleryServerPro.Data.SqlServer.SqlDataProvider.InitializeDataStore()
at GalleryServerPro.Business.AppSetting.Initialize(ApplicationTrustLevel trustLevel, String physicalAppPath, String appName)
at GalleryServerPro.Web.Util.InitializeBusinessLayer()
at GalleryServerPro.Web.Util.InitializeApplication()
at GalleryServerPro.Web.Pages.GalleryPage..cctor()

App Error ID


-2147483648

Gallery ID


1

HTTP User Agent


Mozilla/5.0 (Windows; U; Windows NT 5.1; en-US; rv:1.9.0.10) Gecko/2009042316 Firefox/3.0.10 (.NET CLR 3.5.30729)
===================================================================

I'm not the best database person, but I was pretty sure that database owner was checked.

Thanks,
Robert

Since this is the Upgrade-section I found it fitting to place this post here:
I previously ran the 2.2 without any problems, SQL-Express on Server2003.


I didnt download the source, I have all the .DLL´s and get this error when trying to upgrade:

Server Error in '/gallery' Application.

---

Parser Error
Description: An error occurred during the parsing of a resource required to service this request. Please review the following specific parse error details and modify your source file appropriately.

Parser Error Message: Could not load type 'GalleryServerPro.Web.Global'.

Source Error:


Line 1: <%@ Application Codebehind="Global.asax.cs" Inherits="GalleryServerPro.Web.Global" Language="C#" %>



Source File: /gallery/global.asax Line: 1

---

Version Information: Microsoft .NET Framework Version:2.0.50727.3082; ASP.NET Version:2.0.50727.3082

(ASP.net I guess is correct with its version.... BUT I do have .NET Framework 3.5 since I just checked it out... I hope its ok it says 2.0.5 anyways)

Starting with 2.3, GSP no longer uses the Global.asax file, so as you discovered you must delete it from your previous installation. That is why my instructions talk about making backups of certain files, then wiping the entire directory and replacing it with the latest version. That helps ensure remnants of the previous version don't cause any issues.

Sorry, I don't know what is happening. If you haven't done it already, reboot to freshen things up. If it still doesn't work, try referencing a different user control to see if it is something specific to that control or if *all* controls cause the failure.