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

Notification

Icon
Error

Installer gives error all the time
johanf
#1 Posted : Thursday, 19 November 2009 1:13:16 AM(UTC)
Rank: Newbie

Joined: 19/11/2009(UTC)
Posts: 1
Location: Gothenburg, Sweden

Hi!

I'm trying to install Gallery Server for the first time (ever) on a server with medium trust. Took the files installed localy via Web Platform Installer so they are for MS SQL. The connection string is adjusted and details verified by loging in thru SQL Server Management Studio OK. Well, I tried with the x86 binary files to but then i complains about SQLite is hanging around causing trouble.

What I get is 'Cannot find either column "dbo" or the user-defined function or aggregate "dbo.gs_GetVersion", or the name is ambiguous.'

No table data is added what so ever to the database.

Probably something I missed but some help would be very much appreciated :-)

Cheers,
Johan
Roger Martin
#2 Posted : Thursday, 19 November 2009 1:07:08 PM(UTC)
Roger Martin

Rank: Administration

Joined: 3/08/2007(UTC)
Posts: 3,300
Location: Fort Atkinson, WI

I did a test tonight on a freshly paved Win 2008 VM. I configured the server to force all web applications to run in medium trust and then clicked the install link on the download page. It installed SQL Server 2008, a couple other dependencies, and then GSP. When it was all done it ran without a hitch.

There should not be any SQLite references in the application or directories, so I am not sure why you got a message about that.

I don't know where you went wrong. If you find out please let us know.
Roger Martin
Creator and Lead Developer of Gallery Server Pro
AlexanderOnline
#3 Posted : Wednesday, 12 May 2010 11:25:49 PM(UTC)
Rank: Newbie

Joined: 12/05/2010(UTC)
Posts: 2
Location: NL

Hi,
I get the same error. My situation:

i'm trying to run GSP locally (because i want to integrate it later in our website), with VS2010 and the miniwebserver of VS. I use the source code (latest), where Website is the startup project.
I use SQL Server 2008 Dev edition, logging in wth the Mgmt tool works. I use it as well to test our website locally (different database). So i removed all references to SQLite, set the connectionstring in the web.config, and so on, but when i go to default.aspx?q=install, it throws an exception (The type initializer for 'GalleryServerPro.Web.Pages.GalleryPage' threw an exception.) with the info:
---
Inner Ex Type
System.Data.SqlClient.SqlException

Inner Ex Message
Cannot find either column "dbo" or the user-defined function or aggregate "dbo.gs_GetVersion", or the name is ambiguous.

Inner Ex Source
.Net SqlClient Data Provider

Inner Ex Target Site
Void OnError(System.Data.SqlClient.SqlException, Boolean)
---
The database i made for GSP is empty. I tried to debug is, but i can't find out what is wrong. If i set enable_setup to false, i get the same error. I wonder why it actually wants to do something with the SQL server when loading the installer for the first time?
When i start this with debugging, it breaks on line 130 of Gallery.cs (Control control = LoadControl(src);) (i'm not an experienced coder, but i guess that this is because it loads one of the usercontrols and one of those throws an exception so that's why the loadcontrol thing does it as well?)

Anyway, i wonder if you as 'godfather' of this code maybe can clarify a bit what happens, or guide me in a way of debugging this, or know if this issue is known :)

greetings
Alexander

ps. The guide you wrote is very good, nice!
ps2 when more info is needed, let me know
Roger Martin
#4 Posted : Monday, 24 May 2010 6:26:52 AM(UTC)
Roger Martin

Rank: Administration

Joined: 3/08/2007(UTC)
Posts: 3,300
Location: Fort Atkinson, WI

Sorry for the delay - I didn't notice your post until someone else pointed it out.

Check out this thread.

Also, in your post you mentioned navigating to "default.aspx?q=install". This is incorrect - the "q" should be a "g", like this: default.aspx?g=install. That may be the culprit in your case.
Roger Martin
Creator and Lead Developer of Gallery Server Pro
AlexanderOnline
#5 Posted : Tuesday, 5 July 2011 10:35:35 AM(UTC)
Rank: Newbie

Joined: 12/05/2010(UTC)
Posts: 2
Location: NL

Hey,

I just remembered somehow that I never replied to this. the confusion of q=install vs. g=install caused the problem, pretty stupid mistake that took me quite some hours debugging ;)
Thanks!

Alexander
roly666
#6 Posted : Thursday, 21 July 2011 5:05:14 AM(UTC)
Rank: Newbie

Joined: 21/07/2011(UTC)
Posts: 1
Location: buenos aires

Hello Roger, i have a trouble with a new installation in win server 2k3 x64. I install GSP from Web Platform Installer and when i open the page of the site i can see this error:

Server Error in '/' Application.


Configuration Error
Description: An error occurred during the processing of a configuration file required to service this request. Please review the specific error details below and modify your configuration file appropriately.

Parser Error Message: Unrecognized configuration section system.web.extensions.

Source Error:


Line 128: </location>
Line 129:
Line 130: <system.web.extensions>
Line 131: <scripting>
Line 132: <webServices

i have installed iis 7, netframework 2.0 and asp net 2.0 ajax extension. What can i do?
thanks.
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.