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

Notification

Icon
Error
SQL upgrade script from GSP 2.2?
Options
Previous Topic Next Topic
daveburke
#1 Posted : Tuesday, 30 June 2009 6:46:39 AM(UTC)
daveburke

Rank: Advanced Member

Joined: 12/01/2009(UTC)
Posts: 62
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
Back to top
WWW
Roger Martin
#2 Posted : Tuesday, 30 June 2009 7:05:49 AM(UTC)
Roger Martin

Rank: Administration

Joined: 3/08/2007(UTC)
Posts: 3,298
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
Back to top
WWW
daveburke
#3 Posted : Tuesday, 30 June 2009 7:09:28 AM(UTC)
daveburke

Rank: Advanced Member

Joined: 12/01/2009(UTC)
Posts: 62
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
Back to top
WWW
Roger Martin
#4 Posted : Tuesday, 30 June 2009 7:18:26 AM(UTC)
Roger Martin

Rank: Administration

Joined: 3/08/2007(UTC)
Posts: 3,298
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
Back to top
WWW
Roger Martin
#5 Posted : Tuesday, 30 June 2009 7:19:13 AM(UTC)
Roger Martin

Rank: Administration

Joined: 3/08/2007(UTC)
Posts: 3,298
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
Back to top
WWW
daveburke
#6 Posted : Tuesday, 30 June 2009 7:20:50 AM(UTC)
daveburke

Rank: Advanced Member

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