Welcome Guest! To enable all features please Login or Register.

Notification

Icon
Error
New install Error
Options
Previous Topic Next Topic
VIP
#1 Posted : Friday, 22 May 2009 9:26:53 AM(UTC)
Rank: Advanced Member

Joined: 6/09/2008(UTC)
Posts: 35
Man
Location: Seattle, WA
Hello guys,

I am trying to run the installer on a brand new WINDOWS 2008 STD server 32 bit with MSSQL Enterprise but after I click on the last step NEXT button then getting the following error:

An error occurred during configuration.

Cannot find the object "dbo.gs_AppError" because it does not exist or you do not have permissions.

Error executing SQL: /****** Object: Non-clustered index [dbo].[gs_AppError].[IDX_gs_AppError_FKGalleryId] ******/ IF NOT EXISTS (SELECT * FROM sys.indexes WHERE object_id = OBJECT_ID(N'[dbo].[gs_AppError]') AND name = N'IDX_gs_AppError_FKGalleryId') CREATE NONCLUSTERED INDEX [IDX_gs_AppError_FKGalleryId] ON [dbo].[gs_AppError] ([FKGalleryId] ASC ) WITH (PAD_INDEX = OFF, STATISTICS_NORECOMPUTE = OFF, SORT_IN_TEMPDB = OFF, IGNORE_DUP_KEY = OFF, DROP_EXISTING = OFF, ONLINE = OFF, ALLOW_ROW_LOCKS = ON, ALLOW_PAGE_LOCKS = ON)

Call stack: 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.Web.gs.pages.install.ExecuteSqlInStream(Stream stream) at GalleryServerPro.Web.gs.pages.install.ExecuteSqlInFile(String pathToSqlFile) at GalleryServerPro.Web.gs.pages.install.ConfigureGalleryServerSchemaForSqlServer() at GalleryServerPro.Web.gs.pages.install.ExecuteSqlServerInstallation() at GalleryServerPro.Web.gs.pages.install.ExecuteInstallation() at GalleryServerPro.Web.gs.pages.install.ShowNextPanel()


Any idea why?
Back to top
Roger Martin
#2 Posted : Friday, 22 May 2009 2:35:35 PM(UTC)
Roger Martin

Rank: Administration

Joined: 3/08/2007(UTC)
Posts: 3,300
Location: Fort Atkinson, WI
Update 2009.6.3: The bug has been fixed in version 2.3.3440.

There is a bug in the SQL script that occurs when the database owner is not dbo. To fix it, open the script file at gs\pages\installer\sql\InstallGalleryServerProSql2005.sql in a text editor such as Notepad. For SQL Server 2000 users, the file is named InstallGalleryServerProSql2000.sql. Look for this line:

Code:
CREATE TABLE [gs_AppError] (


Change it to this:

Code:
CREATE TABLE [dbo].[gs_AppError] (


Save the file and try the install wizard again.

Those of you reading this: If you are upgrading and experience a similar error, read this thread for the workaround.
Roger Martin
Creator and Lead Developer of Gallery Server Pro
Back to top
WWW
 |  Edit by user
ujupanmester
#3 Posted : Monday, 25 May 2009 4:54:41 PM(UTC)
Rank: Newbie

Joined: 25/05/2009(UTC)
Posts: 2
Location: Romania
Helolo i had problem with first instalation.
I download version src from home page an after that i upload file to my server at: httt://galerie-server.oradeatur.ro

But if i go to the installer folder(http://www.galerie-server.oradeatur.ro/gs/pages/installer) browser return erorr.
I also made extra permission to the App_Data, config and mediaobjects directories
I also create this http://www.galerie-server.oradeatur.ro from Plesk .
Back to top
WWW
Roger Martin
#4 Posted : Tuesday, 26 May 2009 12:04:15 AM(UTC)
Roger Martin

Rank: Administration

Joined: 3/08/2007(UTC)
Posts: 3,300
Location: Fort Atkinson, WI
The location of the installer changed starting in 2.2. It is at default.aspx?g=install, so in your case it would be http://www.galerie-serve...default.aspx?g=install.

By the way, when I tried that, I see an error - it appears the bin directory is missing ComponentArt.Web.UI.dll. Make sure all the dlls are copied to that directory.
Roger Martin
Creator and Lead Developer of Gallery Server Pro
Back to top
WWW
ujupanmester
#5 Posted : Wednesday, 27 May 2009 5:41:36 AM(UTC)
Rank: Newbie

Joined: 25/05/2009(UTC)
Posts: 2
Location: Romania
Roger Martin wrote:
The location of the installer changed starting in 2.2. It is at default.aspx?g=install, so in your case it would be http://www.galerie-serve...default.aspx?g=install.

By the way, when I tried that, I see an error - it appears the bin directory is missing ComponentArt.Web.UI.dll. Make sure all the dlls are copied to that directory.


On the server i find the missing DLL. This is locate in assmblies directory
Back to top
WWW
Rss Feed  Atom Feed
Users browsing this topic
Guest
You cannot post new topics in this forum.
You cannot reply to topics in this forum.
You cannot delete your posts in this forum.
You cannot edit your posts in this forum.
You cannot create polls in this forum.
You cannot vote in polls in this forum.

Powered by YAF 1.9.5.5 | YAF © 2003-2011, Yet Another Forum.NET