如何将odoo 8升级到odoo 9数据库? [英] How to upgrade odoo 8 to odoo 9 database?

问题描述

我正在尝试将odoo安装从8.0升级到9.0.到目前为止，我已经完成了以下工作:

I am trying to upgrade an odoo installation from 8.0 to 9.0. What I've done so far is the following:

• 从生产系统备份odoo数据库
• 在我的当前系统中安装了备份数据库作为测试
• 将odoo文件夹复制到我系统上的文件夹中
• 检查是否一切正常.可行！
• 已更新到最新的v8.0版本，仍然可以使用
• 先先git checkout 9.0，然后再git pull.
• 使用命令./openerp-server -d testDB -u all
启动odoo 9.0

• Backup the odoo database from the production system
• Installed the backup DB as test in my current system
• Copied the odoo folder in a folder on my system
• Checked, if everything works. It works!
• Updated to the latest v8.0 version, still works
• Did a git checkout 9.0 followed by a git pull.
• Started odoo 9.0 with the command ./openerp-server -d testDB -u all

此命令会因以下错误而中断，并且不会更新我的数据库:

This commands breaks with the following error and does not update my database:

LINE 1: select model, transient from ir_model where state='manual'
                      ^
, in query select model, transient from ir_model where state=%s
 2015-10-26 00:37:29,823 4501 CRITICAL testDB openerp.service.server:
Failed to initialize database `testDB`.
 Traceback (most recent call last):
  File "/opt/odoo/openerp/service/server.py", line 885, in preload_registries
    registry = RegistryManager.new(dbname, update_module=update_module)
File "/opt/odoo/openerp/modules/registry.py", line 385, in new
openerp.modules.load_modules(registry._db, force_demo, status, update_module)
File "/opt/odoo/openerp/modules/loading.py", line 279, in load_modules
loaded_modules, processed_modules = load_module_graph(cr, graph, status, perform_checks=update_module, report=report)
File "/opt/odoo/openerp/modules/loading.py", line 136, in load_module_graph
registry.setup_models(cr, partial=True)
File "/opt/odoo/openerp/modules/registry.py", line 185, in setup_models
cr.execute('select model, transient from ir_model where state=%s', ('manual',))
File "/opt/odoo/openerp/sql_db.py", line 139, in wrapper
   return f(self, *args, **kwargs)
File "/opt/odoo/openerp/sql_db.py", line 215, in execute
   res = self._obj.execute(query, params)

ProgrammingError: column "transient" does not exist
LINE 1: select model, transient from ir_model where state='manual'

我是否需要执行任何步骤来升级数据库，或者是否需要手工完成所有事情?如果是的话，我该怎么办?显然，它失败了，因为我的数据库中不存在特定的列.但是是否有任何更新脚本，因为我担心，如果我更改此脚本，将会出现下一个错误等待着我.

Are there any steps which I have to follow to upgrade the database or has everything to be done by hand? And if yes, what should I do? Obviously it failed because the specific column is non-existent in my database. But is there any update script because I fear, if I change this there will be the next error waiting for me.

谢谢.

推荐答案

您可以通过以下链接 但是，他们会为此收取费用.如果您可以自己做，这里是有关操作方法的文档， https://doc.therp.nl/openupgrade/intro.html

You can ask the odoo company to do that task for you by going to this link .But they will charge money for that. If you can do it yourself here is the documentation on how to do that, https://doc.therp.nl/openupgrade/intro.html

选项2:我们可以使用pgadmin(postgresql gui工具).只需选择数据库名称，然后在顶部可以看到启用了sql的数据库，单击它并发出sql查询以显示所有数据(您必须知道表名如果要恢复，则可以将其导出.导出的文件包含所有带有列标题的数据，我们可能必须根据odoo9 DB重新排列列.完成后选择odoo9数据库，右键单击您要使用的表名要导入数据并选择导入选项.可能要花一些时间，并显示成功导入数据"的消息.

Option 2: We can use pgadmin(postgresql gui tool).Just select your database name and in the top you can see sql enabled,click it and issue an sql query to display all data(you must know the table name which you want to retreive) after that you can export it.The exported file contains all the data with column headings,we may have to rearrange columns according to odoo9 DB.Once it is done select odoo9 database,right click on the table name which you want to import data to and select import option.It may take a while and it should give message as "data imported successfully".

这篇关于如何将odoo 8升级到odoo 9数据库?的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！