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

Forums / Set-up & Installation / 3.7 SP4 Patch Did Not Trigger DB Upgrade

3.7 SP4 Patch Did Not Trigger DB Upgrade

4 posts, 0 answered
  1. VectorLord
    VectorLord avatar
    24 posts
    Registered:
    28 Sep 2009
    10 Nov 2010
    Link to this post
    Hi,
        I have multiple sites that I'm upgrading using the 3.7 SP4 Patch files. My first site completed with a few minor glitches, but everything's working fine now. When I ran it for the first time after patching, it presented me with the database setup wizard and converted it over for SP4 use. However, one of my sites shares the news and blog content with the first site's database and has it's structure and pages defined in its own database. When I ran the second site after copying the patch files, it did not try to update the database, it just gave me the screen that says, "Thank you for visiting our web site. Please return soon for updates." I tried setting the news and blog connection to its structure and page database as well, and received the same result.

    Is there a way to run a SQL script or trigger the database to upgrade it manually?

    I have two other sites that each use their own databases - neither of them ran the database upgrade process before attempting to load, either.

    Thanks,
    VectorLord
  2. Ivan Dimitrov
    Ivan Dimitrov avatar
    16072 posts
    Registered:
    25 Nov 2016
    10 Nov 2010
    Link to this post
    Hi VectorLord,

    Database upgrades are performed internally and there is no script to do this. When an upgrade is performed? The upgrade is performed when you try to connect a website which dll versions are different from the SchemaVersion inside on of the tables like CmsVariables. You could see the welcome message if your website does not have a home page set or there are not pages. Another option is that you use not the proper database. Note that if you have several websites connected to the same database all of them should be the same version otherwise you will upgrade and downgrade the database automatically on each request.

    Sincerely yours,
    Ivan Dimitrov
    the Telerik team
    Do you want to have your say when we set our development plans? Do you want to know when a feature you care about is added or when a bug fixed? Explore the Telerik Public Issue Tracking system and vote to affect the priority of the items
  3. VectorLord
    VectorLord avatar
    24 posts
    Registered:
    28 Sep 2009
    11 Nov 2010
    Link to this post
    Thanks, Ivan. Maybe I can clarify a little more...

    I have two sites (an Intranet and a Customer site) that share content from a database called WEB_DEV. The Intranet site uses WEB_DEV as its primary and only database. The Customer site uses WEB_DEV only for Lists, Forums, Generic_Content, Blogs, Libraries, Events, Polls, Wiki, and News. It uses its own database called WEB_CUST_DEV for navigation, pages, site structure, and settings.

    In the Customer web.config, it defines two connection strings - one for WEB_DEV and another for WEB_CUST_DEV. For the purposes of the SP4 upgrade, I made both connection strings point to the WEB_CUST_DEV database because the Intranet and WEB_DEV have already been successfully upgraded to SP4. This means that during the upgrade process, the Customer site has its structure and pages defined but does not contain any content.

    I have applied all of the patch files, but when I run the application, I get the "Thank you for visiting..." message. It does not prompt me for the database information, nor does it try to upgrade it.

    Any ideas?

    Thanks,
    VectorLord
  4. Ivan Dimitrov
    Ivan Dimitrov avatar
    16072 posts
    Registered:
    25 Nov 2016
    11 Nov 2010
    Link to this post
    Hi VectorLord,

    That you see the default static page which says "Thank you for visiting our website" does not have to do anything with the upgrade process. During the upgrade you are not prompted for any database instance, because the upgrade is silent. Could you check the schema versions of your data base and website version - How to check your current version

    All the best,
    Ivan Dimitrov
    the Telerik team
    Do you want to have your say when we set our development plans? Do you want to know when a feature you care about is added or when a bug fixed? Explore the Telerik Public Issue Tracking system and vote to affect the priority of the items
Register for webinar
4 posts, 0 answered