Hi,
I have downloaded the upgrade files, replaced the web files and have tried to run the upgrade tool against my local files. When I do, I get the error mentioned at the end of this note.
I am hosted on GoDaddy, and my SQL server is hosted there as well. Will I be able to upgrade since I'm using GoDaddy as my hosting provider for my database file (and my web files)?
Thanks for any help you can provide.
Hunter
See the end of this message for details on invoking just-in-time (JIT) debugging instead of this dialog box.
************** Exception Text **************System.Data.SqlClient.SqlException: An error has occurred while establishing a connection to the server. When connecting to SQL Server 2005, this failure may be caused by the fact that under the default settings SQL Server does not allow remote connections. (provider: Named Pipes Provider, error: 40 - Could not open a connection to SQL Server) at System.Data.SqlClient.SqlInternalConnection.OnError(SqlException exception, Boolean breakConnection) at System.Data.SqlClient.TdsParser.ThrowExceptionAndWarning(TdsParserStateObject stateObj) at System.Data.SqlClient.TdsParser.Connect(ServerInfo serverInfo, SqlInternalConnectionTds connHandler, Boolean ignoreSniOpenTimeout, Int64 timerExpire, Boolean encrypt, Boolean trustServerCert, Boolean integratedSecurity, SqlConnection owningObject) at System.Data.SqlClient.SqlInternalConnectionTds.AttemptOneLogin(ServerInfo serverInfo, String newPassword, Boolean ignoreSniOpenTimeout, Int64 timerExpire, SqlConnection owningObject) at System.Data.SqlClient.SqlInternalConnectionTds.LoginNoFailover(String host, String newPassword, Boolean redirectedUserInstance, SqlConnection owningObject, SqlConnectionString connectionOptions, Int64 timerStart) at System.Data.SqlClient.SqlInternalConnectionTds.OpenLoginEnlist(SqlConnection owningObject, SqlConnectionString connectionOptions, String newPassword, Boolean redirectedUserInstance) at System.Data.SqlClient.SqlInternalConnectionTds..ctor(DbConnectionPoolIdentity identity, SqlConnectionString connectionOptions, Object providerInfo, String newPassword, SqlConnection owningObject, Boolean redirectedUserInstance) at System.Data.SqlClient.SqlConnectionFactory.CreateConnection(DbConnectionOptions options, Object poolGroupProviderInfo, DbConnectionPool pool, DbConnection owningConnection) at System.Data.ProviderBase.DbConnectionFactory.CreatePooledConnection(DbConnection owningConnection, DbConnectionPool pool, DbConnectionOptions options) at System.Data.ProviderBase.DbConnectionPool.CreateObject(DbConnection owningObject) at System.Data.ProviderBase.DbConnectionPool.UserCreateRequest(DbConnection owningObject) at System.Data.ProviderBase.DbConnectionPool.GetConnection(DbConnection owningObject) at System.Data.ProviderBase.DbConnectionFactory.GetConnection(DbConnection owningConnection) at System.Data.ProviderBase.DbConnectionClosed.OpenConnection(DbConnection outerConnection, DbConnectionFactory connectionFactory) at System.Data.SqlClient.SqlConnection.Open() at CommunityServer.Upgrader.Part2.Part2_Load(Object sender, EventArgs e) at System.Windows.Forms.Form.OnLoad(EventArgs e) at System.Windows.Forms.Form.OnCreateControl() at System.Windows.Forms.Control.CreateControl(Boolean fIgnoreVisible) at System.Windows.Forms.Control.CreateControl() at System.Windows.Forms.Control.WmShowWindow(Message& m) at System.Windows.Forms.Control.WndProc(Message& m) at System.Windows.Forms.ScrollableControl.WndProc(Message& m) at System.Windows.Forms.ContainerControl.WndProc(Message& m) at System.Windows.Forms.Form.WmShowWindow(Message& m) at System.Windows.Forms.Form.WndProc(Message& m) at System.Windows.Forms.Control.ControlNativeWindow.OnMessage(Message& m) at System.Windows.Forms.Control.ControlNativeWindow.WndProc(Message& m) at System.Windows.Forms.NativeWindow.Callback(IntPtr hWnd, Int32 msg, IntPtr wparam, IntPtr lparam)
************** Loaded Assemblies **************mscorlib Assembly Version: 2.0.0.0 Win32 Version: 2.0.50727.1434 (REDBITS.050727-1400) CodeBase: file:///C:/Windows/Microsoft.NET/Framework/v2.0.50727/mscorlib.dll----------------------------------------CommunityServer.Upgrader Assembly Version: 1.0.0.0 Win32 Version: 1.0.0.0 CodeBase: file:///C:/Users/hdonald/Desktop/CS2008_4.0.30417.1769.upgrade/CS2008_4.0.30417.1769.upgrade/CSUpgrader/CommunityServer.Upgrader.exe----------------------------------------System.Windows.Forms Assembly Version: 2.0.0.0 Win32 Version: 2.0.50727.1434 (REDBITS.050727-1400) CodeBase: file:///C:/Windows/assembly/GAC_MSIL/System.Windows.Forms/2.0.0.0__b77a5c561934e089/System.Windows.Forms.dll----------------------------------------System Assembly Version: 2.0.0.0 Win32 Version: 2.0.50727.1434 (REDBITS.050727-1400) CodeBase: file:///C:/Windows/assembly/GAC_MSIL/System/2.0.0.0__b77a5c561934e089/System.dll----------------------------------------System.Drawing Assembly Version: 2.0.0.0 Win32 Version: 2.0.50727.1434 (REDBITS.050727-1400) CodeBase: file:///C:/Windows/assembly/GAC_MSIL/System.Drawing/2.0.0.0__b03f5f7f11d50a3a/System.Drawing.dll----------------------------------------System.Xml Assembly Version: 2.0.0.0 Win32 Version: 2.0.50727.1434 (REDBITS.050727-1400) CodeBase: file:///C:/Windows/assembly/GAC_MSIL/System.Xml/2.0.0.0__b77a5c561934e089/System.Xml.dll----------------------------------------System.Data Assembly Version: 2.0.0.0 Win32 Version: 2.0.50727.1434 (REDBITS.050727-1400) CodeBase: file:///C:/Windows/assembly/GAC_32/System.Data/2.0.0.0__b77a5c561934e089/System.Data.dll----------------------------------------System.Configuration Assembly Version: 2.0.0.0 Win32 Version: 2.0.50727.1434 (REDBITS.050727-1400) CodeBase: file:///C:/Windows/assembly/GAC_MSIL/System.Configuration/2.0.0.0__b03f5f7f11d50a3a/System.Configuration.dll----------------------------------------System.Transactions Assembly Version: 2.0.0.0 Win32 Version: 2.0.50727.1434 (REDBITS.050727-1400) CodeBase: file:///C:/Windows/assembly/GAC_32/System.Transactions/2.0.0.0__b77a5c561934e089/System.Transactions.dll----------------------------------------System.EnterpriseServices Assembly Version: 2.0.0.0 Win32 Version: 2.0.50727.1434 (REDBITS.050727-1400) CodeBase: file:///C:/Windows/assembly/GAC_32/System.EnterpriseServices/2.0.0.0__b03f5f7f11d50a3a/System.EnterpriseServices.dll----------------------------------------
************** JIT Debugging **************To enable just-in-time (JIT) debugging, the .config file for thisapplication or computer (machine.config) must have thejitDebugging value set in the system.windows.forms section.The application must also be compiled with debuggingenabled.
For example:
<configuration> <system.windows.forms jitDebugging="true" /></configuration>
When JIT debugging is enabled, any unhandled exceptionwill be sent to the JIT debugger registered on the computerrather than be handled by this dialog box.
The error reports that you cannot connect to your GoDaddy-hosted database from the computer that you ran the upgrade tool on. You have a few options:
1. Request remote access to your database from GoDaddy (or ask them for a proper connection string if your account supports this)
2. Request a backup of your database from GoDaddy, install it locally, attach your local CS2008 installation to it, and run the upgrade tool... then, request that your updated database be restored on GoDaddy's servers.
3. Request that GoDaddy run the upgrade tool for you.
Ben Tiedt:I've logged this as a feature request (#789).
The support for the old resized photo URLs has been implemented and will be included in the first service pack to CS2008.
Thanks for the quick reply. Maybe it's time to start over... It's unfortunate that the upgrade story isn't easier for a hosted environment like GoDaddy.
Some hosts support remote access to databases and some don't. My personal site is run on a relatively inexpensive web host and I was able to use the upgrade tool just fine.
I managed to upgrade my site on GoDaddy by backing up the databse and running the upgrader program on the local copy, then reuploading the files back to the server.
The catch was that I had to do all the SQL Server updates manually using the SQL scripts (thanks for making them separate files, made putting it a little easier -- though grouping them together next time would be easier to visually remember which one I had already done).
The problem I'm having is that the photo galleries didn't port over, so it looks like I have to manually redo the entire photo section. Also, photos that were imported into blogs using the file manager tool in 2007 didn't port over at all in 2008. For those posts, the picture holder tag is there, but there's no image since it can't find the reference.
It's a bit unfortunate that GoDaddy doesn't let you connect remotely to their database servers nor do they let you restore a backup from another SQL Server backup set that wasn't created from their server -- else the upgrading would have been a lot easier.
djdigital:The problem I'm having is that the photo galleries didn't port over, so it looks like I have to manually redo the entire photo section. Also, photos that were imported into blogs using the file manager tool in 2007 didn't port over at all in 2008. For those posts, the picture holder tag is there, but there's no image since it can't find the reference.
Did you run the upgrade tool?
The upgrade tool (in the upgrade package) will migrate files (photos, files, post attachments, etc) from their CS2007 locations into the new Centralized File Storage location in CS2008 (the filestorage/ folder by default).
Yes I did, but it doesn't put those files in the new centralized filestorage into a media gallery. The files are there.
Also for the blog posts where i didn't use the new file manager in 2007, the pictures show up fine (the one where a secondary window pops up with multiple tabs and you pick the file you want). If I used that file manager, then the pictures are linked differently (not with the photo cache) so they don't show up.
For another issue... I've been playing around with the new Media gallery and noticed something strange. I uploaded a wmv video (file name has no spaces in it) and the embeded player shows up when you access it. I uploaded a few MP3s (file name has spaces in it) and for a short time it worked, but now anytime I upload a new file or try to access the mp3 files that I already uploaded the embeded player doesn't work. If you look at the error log on the embeded player, it says it can't find the file; but it is there in the centralized storage. The download link brings up the file just fine (well actually it loads it in quicktime instead of asking to download it). The only thing I can think of is that the embedded player doesn't like spaces in the file.
djdigital: If I used that file manager, then the pictures are linked differently (not with the photo cache) so they don't show up.
djdigital:Yes I did, but it doesn't put those files in the new centralized filestorage into a media gallery. The files are there.
I'm not sure what you mean by "... doesn't put those files in the new centralized filestorage into a media gallery" -- any existing photo and file galleries are updated to be media galleries by the database upgrade scripts. The files in the filestorage/ folder should be copied to your site.
For those files, you'll need to copy the blogs/ folder from your CS2007 site -- those files cannot be upgraded. The upgrader expects that the CS2008 files will be installed over the top of the CS2007 files... in which case the blog files would still exist.
When copying the old blogs/ folder's contents, be sure not to overwrite any existing files with the same name.
djdigital: I uploaded a few MP3s (file name has spaces in it) and for a short time it worked, but now anytime I upload a new file or try to access the mp3 files that I already uploaded the embeded player doesn't work
Could you provide the name (or the file) of an an MP3 file that doesn't work for you? Which browser/version are you using?
What I mean is that the files were updated to go into the centralized storage via the upgrader program. However since I had to manually upgrade the SQL portion of the applcation, it looks like the script that makes the new Media Galleries with the files that are now in centralizd storage didn't work correctly because I have no Media Galleries set up after the upgrade is complete.
I'll try copying the 2007 site over the 2008 for the blog pictures issue and let you know what happens there.
For the MP3 issue, I put it in a separate post in the Bug forum.
Thanks!
djdigital:What I mean is that the files were updated to go into the centralized storage via the upgrader program. However since I had to manually upgrade the SQL portion of the applcation, it looks like the script that makes the new Media Galleries with the files that are now in centralizd storage didn't work correctly because I have no Media Galleries set up after the upgrade is complete.
I've attached the SQL script that is used to merge the galleries. Normally, there would be a pre-check to ensure that there aren't any duplicate photo and file galleries (that none have the same application key). That check would not run if this script is executed directly.
Thanks for the SQL Script. That imported the gallery structure from the 2007 site to the 2008 site (less the nested galleries below the second level i.e. Gallery Name > Subgallery > Sub-Subgallery -- the sub-subgallery grouping isn't there, but the pictures are. Any plans on making multi-leveled (nested) sub-groupings...and sub-sub-sub-groupings etc, again? If not, it can be handled with tags.
The thing is, the gallery structure is there, but not all the pictures came over. It looks like the ones that were imported using 2007 didn't get trasnferred correctly. In these cases, the galery entry is there, but there's no picture displayed or available to download.
Also for the blog posts, there are no additional files that weren't already copied over when I did the installation. The only thing I can think of, is the blog posts with pictures missing are the ones that I used the Content Selector to put the pictures in, rather than the Insert Image. So the pictures are not in the blog area, but were linked from the gallery. The older posts were referencing the cache directory directly so those pictures still show up since I didn't delete the folder yet. The newer posts that used the content selector are referncing a webpage, which is now updated to reference the new media gallery after running that script; but the pictures aren't showing up in either place.
Thanks for the speedy replies.
djdigital:Any plans on making multi-leveled (nested) sub-groupings...and sub-sub-sub-groupings etc, again? If not, it can be handled with tags.
There is not currently a plan to support further categorization. I would suggest using tags.
djdigital:but not all the pictures came over. It looks like the ones that were imported using 2007 didn't get trasnferred correctly.
Do *some* pictures show up and some don't? Do you know if you used file storage or database storage in CS2007? Did you modify the file storage location in CS2007?
djdigital: The newer posts that used the content selector are referncing a webpage, which is now updated to reference the new media gallery after running that script; but the pictures aren't showing up in either place.
Can you provide a sample of the URL to this web page? There should be appropriate redirects in place for handling these URLs, but I can check again for the URL formats that you're having problems with.