推荐这篇日记的豆列
&&&&&&&&&&&&Access denied | www.odoochina.net used Cloudflare to restrict access
Please enable cookies.
What happened?
The owner of this website (www.odoochina.net) has banned your access based on your browser's signature (3c0da2-ua98).How to upgrade odoo 8 to odoo 9 database? - Stack Overflow
Learn, Share, Build
Each month, over 50 million developers come to Stack Overflow to learn, share their knowledge, and build their careers.
Join the world’s largest developer community.
Display name
Email address
By registering, you agree to the
I am trying to upgrade an odoo installation from 8.0 to 9.0. What I've done so far is the following:
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
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.
Thanks in advance.
You can ask the odoo company to do that task for you by going to this
.But they will charge money for that. If you can do it yourself here is the documentation on how to do that,
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".
I found the answer on .
The trick is to create a field called transient which is Boolean with the default value false in the table ir_model.
As I expected, this is not the complete solution as there are other problem with the database needing adjustments.
You are trying to run a Odoo 8.0 database on Odoo 9.0.
The column 'transient' is in the code base for 9.0 and not in the 8.0 code base. Hence the 8.0 database is being ran on the 9.0 code base. Hence, the database has not been upgraded properly.
As stated in the previous answer. You can either get Odoo to do it or can do it yourself as well.
Your Answer
Sign up or
Sign up using Google
Sign up using Facebook
Sign up using Email and Password
Post as a guest
Post as a guest
By posting your answer, you agree to the
Not the answer you're looking for?
Browse other questions tagged
Stack Overflow works best with JavaScript enabled摘译自Odoo Help Forum上Odoo官方人士Yenthe对相关问题的答复,包括如下3点:
(原贴地址:)
1.主要路线图(main roadmap):
40% 可用性(usability)
20% 会计(Accounting)
20% 建站系统/电子商务(CMS/eCommerce)
10% 新设计(New design)
10% 框架(Framework)
Odoo9的预计发布日期为2015年6月。
（实际发布日期为日）。
2.本身没有很多可用的特性但将有一个新的VoIP(在线语音)模块
(1)在Odoo V8中已新增了im_chat模块, 用于用户间在线文字聊天, 目前尚不支持群聊;
(2)要新增的VoIP模块, 虽算不上新技术,但有了此功能绝对很赞，可通过系统给客户拨打电话、安排/管理通话.
经查, 这个VoIP模块(crm_voip: )已经并入Odoo V8, 但要收费, 官网标价为399欧元,
(3)不知新增的VoIP模块是否使用SIP协议或P2PSIP协议,目前SIP协议有成熟的Python库.
3.正如V8主要专注于重写仓库模块，V9将重写会计模块。
本文已收录于以下专栏：
相关文章推荐
今天群里有网友上传了一个模块，就是在非debug状态下，右上角的登录用户位置同时显示出数据库的名称，但网友反映安装此模块后，原来的聊天按钮会不见了，然后查看了一下源码，经过调试后，大致找到问题所在。
...
1、stock.incoterms
贸易术语表
2、stock.location
3、stock.location.route
库位路线表
4、stock.quant
库存数量表
SearchSearch view 与之前的几个都不同，它不是用来显示 record 的。作用与制定的 model，并且用来筛选其他 view的内容。root element 是
不接受属性。子节点...
对于此版本，我们大部分的努力集中在改进API上，以便运行速度更快，更易于开发人员使用。这并不是说终端用户的使用体验没有任何改变，我们对许多应用程序进行了小的更改，使其更直观，更有用。 Odoo V11...
1、链接默认指向原生form中。
2、如果想让该链接跳转到自定义的form中，需要配置context，在其中增加
form_view_ref属性，比如context="{'form_vie...
构建Odoo模块
业务对象声明为Python类, 由Odoo自动载入.
XML或CSV文件格式, 在其中声明了元数据(视图或工作流)...
创建简单自定义模块
参考:/python/odoo/odoo.html#sec-5-3-3
odoo有很多现有的模块(应用),也能够添加...
备份策略：阶段性备份+特定事件备份。周期性自动备份+手动检查+自动通知。
官方参考：/forum/help-1/question/how-to-setup-a-...
9、预测功能
新增需要方法的预测功能：Auto-ARIMA预测、VAR预测。
一、Auto-ARIMA预测
Auto-ARIMA预测是基于ARIMA模型之上，系统的预测方法。Eviews ...
9.2 估计功能
一、自回归分布滞后模型
EViews 9提供了ARDL，自回归分布滞后模型的工具，变量包括了滞后变量和常规解释变量。
其中，EViews 9有三大新功能：
内置了滞后阶数的...
他的最新文章
讲师：董岩
您举报文章：
举报原因：
原文地址：
原因补充：
(最多只允许输入30个字)