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.
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.
Ben Tiedt: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?
Yes, some do and some don't. It looks like the upgrade program didn't catch all of the files in /photo/storage and put them in the filestorage area. I tried running the upgrader again but it didn't catch it. So I manually renamed the files and mimiced the directory structure and now the missing pictures are there in the media gallery.
Since the pictures are in the media gallery, the links are also being updated automatically in the blogposts, so I can see the pictures again. However, the pictures are not being resized like how they used to using the old content selector, so eveything is being shown at the original resolution.
Also, when I try to import items from the media gallery into a blog entry, when I try to select the media gallery that has the files, there's + indicating there's a group, but when you click on it, it goes away and on the right side of the dialog it says there are no files in the folder and to pick another... but there are files in the folder...
djdigital:So I manually renamed the files and mimiced the directory structure and now the missing pictures are there in the media gallery.
Were the missed files in a unique location? Or were they older/newer than other photos? Do you notice any pattern for the missed files?
djdigital:However, the pictures are not being resized like how they used to using the old content selector, so eveything is being shown at the original resolution.
Unfortunately, the dimensions defined for the different photo sizes in CS2007- are no longer available to perform a similar resize in CS2008. One option would be to redirect to the static resized widths/heights (or the original defaults used in CS2007-). Would that help?
djdigital: Also, when I try to import items from the media gallery into a blog entry, when I try to select the media gallery that has the files, there's + indicating there's a group, but when you click on it, it goes away and on the right side of the dialog it says there are no files in the folder and to pick another... but there are files in the folder...
Could you provide screenshots or step-by-step directions for this? I'm not sure that I understand what you're explaining.
Ben Tiedt:Were the missed files in a unique location? Or were they older/newer than other photos? Do you notice any pattern for the missed files?
From what I can tell, the missed files were all imported from the 2007 content manager (similar control to the Insert Media control in 2008). Other than that it seemed like from that point forward, those pictures were not imported. At least the structure was easy to figure out, and that the manual way of doing it worked. Considering it got 80% of the galleries, it wasn't too bad -- just a little weird.
Ben Tiedt: Unfortunately, the dimensions defined for the different photo sizes in CS2007- are no longer available to perform a similar resize in CS2008. One option would be to redirect to the static resized widths/heights (or the original defaults used in CS2007-). Would that help?
I'm not sure if I understand what you mean here. You mean I would have to go into each blog post and edit down the picture sizes -- or redo the picture links to point to the old cache files that were presized? If it means the former, it would be a little more painful since the Media Selector isn't working right for me.
Ben Tiedt:Could you provide screenshots or step-by-step directions for this? I'm not sure that I understand what you're explaining.
The gallery group FFXI has galleries within them, but when you click on it, there's no listing (see above). The plus sign disappears when you click on it for that group.
Copyright© 2008 Telligent Systems Inc. All rights reserved CommunityServer.com • Telligent.com