Error in Upgrade Application

Reply

jeffesp Posted: Fri, May 9 2008 10:49 AM

rated by 0 users

When running the upgrade app, I get the following error.

5/9/2008 10:40:38 AM -- Executing Step 6: Move existing files into centralized storage
5/9/2008 10:40:38 AM -- Upgrading file galleries
5/9/2008 10:40:38 AM -- Moved 0 of 0 files into centralized storage
5/9/2008 10:40:38 AM -- Upgrading photo galleries
5/9/2008 10:40:49 AM -- EXCEPTION: Object reference not set to an instance of an object.
   at CommunityServer.Upgrader.FileUpgrader.UpgradePhotoGalleries()
   at CommunityServer.Upgrader.Part4.MoveFilesToCfs()

Looking at the SQL profiler trace, the last thing executed was:

SELECT s.SettingsID, pa.SectionID, pa.PostID, pa.FileName, pa.Content FROM cs_PostAttachments pa INNER JOIN cs_Sections s on pa.SectionID = s.SectionID WHERE IsRemote = 0 AND pa.SectionID IN (SELECT SectionID FROM cs_Sections WHERE ApplicationType = 2)

Running that statement gets me back the list of photos on the site. 

Any thoughts on what can be causing this?

Reply

Dave Donaldson replied on Tue, May 13 2008 4:21 PM

rated by 0 users

It's possible you have some dangling files in your CS database. Try running the script from this blog post (http://windowscoding.com/blogs/blake/archive/2008/04/27/how-to-delete-dangling-files-from-a-community-server-database.aspx) and then re-run the upgrade and let us know the results.

Reply

jeffesp replied on Wed, May 14 2008 1:04 PM

rated by 0 users

 I'm up and running in 08 at this point.  Thanks for the help.

Reply

Dave Donaldson replied on Wed, May 14 2008 1:13 PM

rated by 0 users

So did running that script help, or did you do something else?

Reply

jeffesp replied on Wed, May 14 2008 1:41 PM

rated by 0 users

The best I can tell there was an error when I copied the 2008 Web files into the 2007 web dir.  Once I copied the 2008 files again it worked.  I verified that the new 2008 files were there before recopying them, so I don't know what was different.