Error in Upgrade Application

rated by 0 users
Answered (Verified) This post has 1 verified answer | 4 Replies | 2 Followers

jeffesp
Top 75 Contributor
263 Posts
Points 3,880
By: jeffesp
Posted: Fri, May 9 2008 10:49 AM

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?

--
--Jeff (ATGi)
 
  • Post Points: 20 |

Answered (Verified) Verified Answers

Dave Donaldson
Top 500 Contributor
65 Posts
Points 985
CS Developers
Answered (Verified) By: Dave Donaldson
Posted: Tue, May 13 2008 4:21 PM In reply to

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.

 


 
Answered (Verified)
  • Post Points: 20 |

All Replies

Dave Donaldson
Top 500 Contributor
65 Posts
Points 985
CS Developers
Answered (Verified) By: Dave Donaldson
Posted: Tue, May 13 2008 4:21 PM In reply to

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.

 


 
Answered (Verified)
  • Post Points: 20 |
jeffesp
Top 75 Contributor
263 Posts
Points 3,880
By: jeffesp
Posted: Wed, May 14 2008 1:04 PM In reply to

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

--
--Jeff (ATGi)
 
  • Post Points: 20 |
Dave Donaldson
Top 500 Contributor
65 Posts
Points 985
CS Developers
By: Dave Donaldson
Posted: Wed, May 14 2008 1:13 PM In reply to

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


 
  • Post Points: 20 |
jeffesp
Top 75 Contributor
263 Posts
Points 3,880
By: jeffesp
Posted: Wed, May 14 2008 1:41 PM In reply to

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.

--
--Jeff (ATGi)
 
  • Post Points: 5 |
Page 1 of 1 (5 items) | RSS
Powered by Community Server (Commercial Edition), by Telligent Systems

Copyright© 2008 Telligent Systems Inc. All rights reserved
CommunityServer.com  •  Telligent.com