从 umbraco 7.6 升级到 7.15.1 的最佳方法是什么(包括数据库升级) [英] What's the best way to upgrade from umbraco 7.6 to 7.15.1 (including db upgrade)

问题描述

我正在尝试将网站从 v 7.6 升级到 v. 7.15.1.

I am trying to upgrade the site from v 7.6 to v. 7.15.1.

我已经在本地主机上进行了升级，包括更新数据库.

I have done the upgrade on localhost which included updating the db.

现在我从本地主机或测试站点传输了我的文件，然后我在日志中收到错误:

Now I transferred my files from localhost o the test site and on there I am getting an error in log:

ERROR Umbraco.Core.UmbracoApplicationBase - An unhandled exception occurred
System.Data.SqlClient.SqlException (0x80131904): Invalid object name 'umbracoUserLogin'.

我无法登录后台.

它似乎在测试中寻找 umbracoUserLogin 而它尚不存在，因为在测试中数据库尚未更新.

It seems to be looking for umbracoUserLogin on test while it doesn't exist yet because on test the db is not updated yet.

在这种情况下，当文件已经在本地主机上更新并传输到测试站点时，如何更新测试数据库?

How to update the db on test in this case while the files have already been updated on localhost and transferred to test site?

推荐答案

我最近做了 2 个 umbraco 升级；一个是从 7.5.7 到 7.13.1，最近一个是从 7.13.1 到 7.15.1.

I have done 2 umbraco upgrades recently; one is from 7.5.7 to 7.13.1 and the recent one is from 7.13.1 to 7.15.1.

在我升级期间；我见过这个问题，修复这个问题可以帮助你解决问题(再次升级后我没有再次看到这个问题，但这次检查所有自动更改文件并一次接受一个 - 请参阅下面的详细信息)但回到您的问题；从 umbraco 7.6 升级到 7.15.1(包括数据库升级)的最佳方法是什么"；以下是您应该遵循的步骤；

During my upgrade; I have seen this problem and fix in this issue can help you for your problem(and I didn't see this problem again after doing the upgrade again, but this time checking all the auto changing files and accepting them one at a time-see details below for this) but coming back to your question; "What's the best way to upgrade from umbraco 7.6 to 7.15.1(including db upgrade)"; here are the steps that you should follow;

1. 在开始之前为您的项目和 umbraco 数据库创建一个备份.如果您使用的是 Git，那么事情会变得非常简单.
2. 为您的 Umbraco 项目打开 Nuget 包管理器，并使用 Nuget 包管理器窗口或控制台进行包升级.为您的案例搜索 UmbracoCms 7.15.1 版.
3. 开始升级后，您会看到一些弹出窗口，要求您批准一些自动文件更改(包括一些配置文件更改).由于您不想丢失一些升级前的设置，所以不要全部接受或全部丢弃，一一检查，作为一般规则；如果您没有对这些文件进行任何自定义更改，则只需批准更改即可，否则，请检查您的更改并确保您没有丢失任何内容并因此丢弃其中一些文件更改.
4. 完成 UmbracoCms 升级(它会自动进行一些依赖包升级)后，构建您的项目，确保一切正常，然后转到您本地项​​目的 umbraco 后台 URL，这将触发其余部分umbraco 升级过程，只需按照屏幕完成升级步骤 - 此时您的 umbraco db 更改将自动完成，并且您可能会遇到一些旧的损坏缓存文件的问题，如果发生这种情况，那么只需删除 App_Data/TEMP 文件和 App_Data umbraco.config 文件，然后重试.如果您在安装过程中发现其他问题，请查看日志(浏览器开发工具可以方便地了解这种情况下的问题)，并一次修复它们.您可能不需要一些旧的 web.config 设置，它们可能会导致一些问题，只需将这些行注释掉，看看这是否会解决一些问题.
5. 完成本地升级后，将代码部署到测试环境，然后转到测试环境的 umbraco url 并按照屏幕操作完成测试环境的安装.如果您发现任何问题，请查看我上面第 4 步的注释.
6. 为其他测试环境(QA、UAT、培训等)进行 umbraco 升级并完成您的 umbraco 升级测试.测试完成后，您就可以上线了.实时部署后，您必须最后一次完成 umbraco 升级，但这次是为实时系统.
7. 在升级之前始终为每个环境获取备份，因此如果出现问题，您将准备好回滚您的更改(这可能在您执行 umbraco 大升级).
8. 最后一点；有 一些不错的文章，请看一下以更好地了解该过程.祝你好运！

1. Create a backup for your project and your umbraco db before you start. If you are using Git, then things will be super easy for this.
2. Open up Nuget Package Manager for your Umbraco project and do the package upgrade using the Nuget Package Manger window or the consol. Search for UmbracoCms version 7.15.1 for your case.
3. Once you start doing the upgrade, you will see some popup windows that will ask you to approve some auto file changes(including some config files changes). As you don't want to lose some of your pre-upgrade settings, don't accept them all or discard them all, check all of them one by one, and as a general rule; if you don't have any custom changes for those files, then simply approve the change, otherwise, check your changes and make sure you don't loose anything and discard some of these file changes as a result.
4. Once you're done with your UmbracoCms upgrade(which will automatically do some dependency package upgrades), build your project, make sure all is looking good then go to your local project's umbraco back-office url, this will trigger the rest of the umbraco upgrade process and simply complete the upgrade steps by following the screens- at this point your umbraco db changes will be done automatically and it is possible that you might have some issues with some old corrupt cached files, if this happens, then simply delete App_Data/TEMP files and App_Data umbraco.config file and try again. If you see some other problems during the installation, check the logs(browser developer tools can be handy to understand the problems in this case), and fix them one at a time. It is possible that you don'T need some of your old web.config settings and they might cause some issues, simply comment out those lines and see if this will fix some of the issues.
5. Once you are done with you local upgrade, deploy your code to your testing environment, and go to the umbraco url of your test environment and follow the screens to complete the installation for your testing environment. If you see any problems, please check my notes for step 4 above.
6. Do your umbraco upgrade for other testing environments(QA, UAT, Training etc) and complete your umbraco upgrade tests. Once the tests are done, then you are ready to go live. After the live deployment, you will have to complete the umbraco upgrade one last time, but this time for the live system.
7. Always get your back-ups for each environment before you do the upgrade, so you will be ready to rollback your changes if things go wrong(which might happen as you're doing a big umbraco upgrade).
8. Final note; there are some good articles for this, please take a look to understand the process better. Good luck!

这篇关于从 umbraco 7.6 升级到 7.15.1 的最佳方法是什么(包括数据库升级)的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！