Welcome Guest Search | Active Topics | Members | Log In | Register
SQL upgrade script from GSP 2.2? Options
daveburke
Posted: Tuesday, June 30, 2009 2:46:39 PM
Rank: Member

Joined: 1/12/2009
Posts: 5
Location: Vermont
Roger,

I hate to bother you with this question, but I read the admin guide and quickstart and haven't seen anywhere that I need to run a GSP 2.2 to GSP 2.3 upgrade SQL Server script. I always upgrade via the SDK so I look for an upgrade script somewhere.

One other thing, I was curious how I'm seeing v2.3.3468 as my GSP version. I'm not complaining. I LIKE having the latest version! :-)

Thanks!
Dave
Roger Martin
Posted: Tuesday, June 30, 2009 3:05:49 PM
Rank: Administration

Joined: 8/3/2007
Posts: 1,993
Location: Fort Atkinson, WI
The first time an album is displayed after an application restart, GSP checks the data schema version and runs the SQL upgrade script if necessary. No user intervention required, and the script is embedded in the TIS.GSP.Data.SqlServer dll.

You can execute it manually if you want (probably too late for you now). Just this morning I added a note to the Admin Guide about where to find this SQL script. Look at page 14.

The dll version is automatically incremented each time you compile from the source. You have the same code that is in the compiled 2.3.3456 version.


Roger Martin
Creator and Lead Developer of Gallery Server Pro
daveburke
Posted: Tuesday, June 30, 2009 3:09:28 PM
Rank: Member

Joined: 1/12/2009
Posts: 5
Location: Vermont
Thanks for the speedy reply as always.

I didn't experience the auto-update, maybe because it's a second instance. Won't bother you with the details. I ran the 2.1 to 2.3 upgrade script. Got my gs_appError table and everything else I'll need. I'll check on page 14! Thanks for that.

Yeah, I figured that's how the build version was increasing. I've been compiling a lot of GSP code!

Have a great day!
Dave
Roger Martin
Posted: Tuesday, June 30, 2009 3:18:26 PM
Rank: Administration

Joined: 8/3/2007
Posts: 1,993
Location: Fort Atkinson, WI
Hmm, I would like to know why it didn't run by itself. Can you check the error log to see if there are any clues?


Roger Martin
Creator and Lead Developer of Gallery Server Pro
Roger Martin
Posted: Tuesday, June 30, 2009 3:19:13 PM
Rank: Administration

Joined: 8/3/2007
Posts: 1,993
Location: Fort Atkinson, WI
Oh, never mind. The previous version didn't HAVE an error log. Oh well...


Roger Martin
Creator and Lead Developer of Gallery Server Pro
daveburke
Posted: Tuesday, June 30, 2009 3:20:50 PM
Rank: Member

Joined: 1/12/2009
Posts: 5
Location: Vermont
Sorry, didn't mean to imply that your baby had a problem. :-) Will keep you posted. Thx.
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.

Main Forum RSS : RSS

YAFVision Theme Created by Jaben Cargman (Tiny Gecko)
Powered by Yet Another Forum.net version 1.9.1.2 (NET v2.0) - 9/27/2007
Copyright © 2003-2006 Yet Another Forum.net. All rights reserved.