+1-888-365-2779
Try Now
More in this section

Forums / Deployment / Graphics and News broken after deployment

Graphics and News broken after deployment

10 posts, 0 answered
  1. Mitch Thraves
    Mitch Thraves avatar
    9 posts
    Registered:
    05 Feb 2006
    18 Apr 2008
    Link to this post
    Hi

    We're about to launch our first Sitefinity 3.2 website but we've run into some last minute glitches. We're currently running the evaluation version but apart from the occassional eveluation messages I believe it is the same as the fully licenced version. 

    Our website runs great on the development PC but after we load the site onto our web host we find that all of the graphics that are listed  in the Graphics Libraries are missing. Also all of the news article links don't work but you can edit the articles and create new ones.

    I've read about making path changes in sf_CmsControlProperty and sf_CmsTextContent but after experimenting with different paths things just seem to be getting worse.

    When I copied the site up to the live site, I noticed a lot of paths still reference \Redlin\, which is the name of the local project. When I ftp the site up to our host, the files have to be copied to the wwwroot folder. I tried removing /Redlin/ and replacing it with /wwwroot/, then tried using the domain name, then removed Redlin altogether and replaced with just  / and none of it works. 

    Everything else is running really well but I'm really out of ideas so I need your help.

    Many Thanks

    Mitch Thraves
  2. Nikifor
    Nikifor avatar
    232 posts
    Registered:
    18 May 2013
    22 Apr 2008
    Link to this post
    Hi Mitch Thraves,

    The information you read about is a bit old, because right now we have a link parser which changes the paths automatically when needed. It seems that the cause of the issue is somewhere else, so we would need your assistance for it. Could you please let us know where these links are - in a dynamic content or user control? Also, any kind of useful information would be highly appreciated.

    Sincerely yours,
    Nikifor
    the Telerik team

    Instantly find answers to your questions at the new Telerik Support Center
  3. Mitch Thraves
    Mitch Thraves avatar
    9 posts
    Registered:
    05 Feb 2006
    29 May 2008
    Link to this post
    We've now tried a different Sitefinity site and different host but we still get the same problem, broken links after deployment.

    We've setup the 3 ISAPI filters for .template, .sflb and .tmb and after this the templates all work correctly so we know that part is working ok.

    How do we go about changing the path between development server and production server, Is it in the web.config?
  4. Nikifor
    Nikifor avatar
    232 posts
    Registered:
    18 May 2013
    02 Jun 2008
    Link to this post
    Hi Mitch Thraves,

    We are aware of a problem with broken links for the Images and Documents module, but it applies only for Sitefinity version 3.2 Official Release. This is why it would be really helpful if you state which is the version of your project.
    As for changing the URL, it is enough to modify the mentioned filegroups (sf_CmsControlProperty and sf_CmsTextContent) by putting the updated information.

    Hope this helps.

    Sincerely yours,
    Nikifor
    the Telerik team

    Instantly find answers to your questions at the new Telerik Support Center
  5. Mitch Thraves
    Mitch Thraves avatar
    9 posts
    Registered:
    05 Feb 2006
    02 Jun 2008
    Link to this post
    Hi guys

    I'm using the Standard version 3.2 SP1. 

    GOOD NEWS! I've kinda got it working within the last hour. I downloaded SP2 this morning and now I can see the thumbnails in the Images library. The only remaining work that is required is to change the paths on the graphics.

    When I preview a page it shows a broken link to the graphic, if I try to fix this by browsing for a graphic on the production server, it works! By comparing the path before and after browsing , it shows

    /Athenaeum/Libraries/Header+Graphics/HeaderSaloon.sflb

    /Libraries/Header+Graphics/HeaderSaloon.sflb

    The first path works on development but not production.
    The second path works on production but not development.

    Is there an easy routine I can run on the DB to correct this?

    I'm really excited that we've got this working, thanks for your work with SP2.

    Mitch
  6. Vassil Daskalov
    Vassil Daskalov avatar
    261 posts
    Registered:
    18 May 2013
    05 Jun 2008
    Link to this post
    Hi Mitch Thraves,

    The reason why the first link works on the development machine, and not in the production and vice versa, is because the project has one name in development environment and a completely different one in production. As I can see, your development application name is "/Athenaeum" while in the production environment the site is set as a default and thus its application name is "/".

    When you create links in the development server, it attaches the application name before the link so that the links would work. Once you move your application (or change the app name), they become invalid. In order to fix this, you should run the flowing scripts and set the current application name of your application:

    UPDATE    sf_CmsControlProperty     
    SET              Value = REPLACE(Value, '/Athenaeum/''/')     
    WHERE     (Value LIKE '%/Athenaeum/%')   

    UPDATE    sf_CmsTextContent     
    SET              Content = REPLACE(Content, '/Athenaeum/''/')     
    WHERE     (Content LIKE '%/Athenaeum/%')   

    If you move the site once again from production to development environment, you would have to run the scripts again this time by putting the "/Athenaeum/" in every link.

    Hope this helps.

    Greetings,
    Vassil Daskalov
    the Telerik team

    Instantly find answers to your questions at the new Telerik Support Center
  7. Paul Dain
    Paul Dain avatar
    7 posts
    Registered:
    15 Mar 2006
    18 Jun 2008
    Link to this post
    When you say "..and set the current application name..." in the previous post, do you mean that this is a separate process from the 2 queries?

    Specifically, we have encountered the same problem. However, when we revert to a previous version of a piece of content, the old application name reappears. Is there another location to either: 1) set the application name; or 2) change these URLs for old versions?

    Thanks,

    - Paul
  8. Vassil Daskalov
    Vassil Daskalov avatar
    261 posts
    Registered:
    18 May 2013
    25 Jun 2008
    Link to this post
    Hi Paul Dain,

    Perhaps you would need to upgrade the version content table as well as all your old versions are preserved with paths set with the old application name. Use the following script:

    UPDATE sf_VrsTxtData        
    SET DataImpl = REPLACE(DataImpl, '/Athenaeum/''/')        
    WHERE (DataImpl LIKE '%/Athenaeum/%')     

    Let us know if this does not fix your problem.

    Greetings,
    Vassil Daskalov
    the Telerik team

    Instantly find answers to your questions at the new Telerik Support Center
  9. Chris
    Chris avatar
    9 posts
    Registered:
    17 Aug 2007
    08 Jul 2008
    Link to this post
    Hi,
    We are having the same issue here and the sql update queries look like they will solve the problem in SQL Server 2005.  However we have created the Sitefinity database in SQL2000 and as far as I know the Replace() function doesn't work on Text and NText fields in SQL 2000.

    Do you have any suggestions on how we could achieve the same result in sql2000? 

    Thanks

    Chris
  10. Pepi
    Pepi avatar
    981 posts
    Registered:
    28 Oct 2016
    09 Jul 2008
    Link to this post
    Hello Chris,

    You can cast ntext to varchar(8000) or nvarchar(4000) in order to use REPLACE function in SQL Server 2000. For example:

    UPDATE sf_VrsTxtData         
    SET DataImpl = REPLACE(CAST(DataImpl AS VARCHAR(8000)), '/Athenaeum/''/')         
    WHERE (DataImpl LIKE '%/Athenaeum/%'

    Hope this helps.


    Greetings,
    Pepi
    the Telerik team

    Instantly find answers to your questions at the new Telerik Support Center
Register for webinar
10 posts, 0 answered