刚把oe5的产品数据升级到oe6,其他一切正常,只有一个问题。就是产品名称的翻译找不到了。我的产品名称有中文英文德文三种,升级完以后能找到的只有在product_template表里的中文名称。问题是,oe5把产品名称的翻译放在哪个表里了?ir_translation下面是没有(oe6好像是存在这个表里)。
还有一个问题 - oe6添加产品翻译可以有4个选择,分别是add to "fields", "labels", "relates"和"view"。这有什么区别?
lostino
-
Oe5的翻译存在哪里? -
[以解决]商品为何无法入库?发现问题了:
是在新建库位下设置了"盘存科目". 把它去掉问题就解决了.
多谢mrshelly指点.
不过这里延伸一个问题:
库存里的"盘存科目"是如何起作用的? -
[以解决]商品为何无法入库?在stock management->incoming products 里确定products received, 但在按下make picking后出现了错误提示框:
[b]Error!
There is no stock input account defined for this product: "商品名" (id: "id号")[/b]
看起来是商品的stock input account没有选择, 但这个默认是不用选择的. 之前的采购订单入库确认都没有发生这种情况. 科目列表也没有改动过. 只改动过内部库位 - 把内部库位"库存"改成了"库存/子库位1", 添加了新的"库存"和"库存/子库位2". 难道是这个引发的?
请教这个错误信息是从何引发的? -
求助: 操作模块出现UnicodeDecodeError问题找到了!
是数据库编码的问题!
postgres的默认编码是sql_ascii. 在创建数据库时要选择utf8字符集.
但在phppgadmin中创建的话, 会出现utf8不被兼容的错误. 解决办法是, 进入shell切换到postgres, 然后$ createdb -O user -E UTF8 -T template0 mydb
这应该是很常见的问题, 但oe官方的doc和论坛里都没有提及, 真是奇怪. -
求助: 操作模块出现UnicodeDecodeError我用的都是英文的, 没有换过语言包. 应该不会出现转码问题, 所以才感到很费解.
我已经反复确定了安装过程, 没有发现任何错误.
Errrorlog里也没有给出更多的信息. -
求助: 操作模块出现UnicodeDecodeError大家好, 初来乍到就碰到了不小的问题:
我在ubuntu server 10.04上装了openerp server 和 web 5.0.10, 用win7的客户端去连接. 一切都很顺利, 直到进入模块列表Modules时, 客户端出现了以下错误:
Environment Information :
System : Windows-32bit
OS Name : nt
Operating System Release :
Operating System Version : 32bit
Operating System Architecture : 32bit
Operating System Locale : zh_CN.cp936
Python Version : 2.5.2
OpenERP-Client Version : 5.0.10
Last revision No. & ID :Bazaar Package not Found !Traceback (most recent call last):
File "/root/erp/openerp-server-5.0.10/bin/netsvc.py", line 245, in dispatch
result = LocalService(service_name)(method, *params)
File "/root/erp/openerp-server-5.0.10/bin/netsvc.py", line 74, in call
return getattr(self, method)(*params)
File "/root/erp/openerp-server-5.0.10/bin/service/web_services.py", line 576, in execute
res = service.execute(db, uid, object, method, *args)
File "/root/erp/openerp-server-5.0.10/bin/osv/osv.py", line 58, in wrapper
return f(self, dbname, *args, **kwargs)
File "/root/erp/openerp-server-5.0.10/bin/osv/osv.py", line 119, in execute
res = pool.execute_cr(cr, uid, obj, method, *args, **kw)
File "/root/erp/openerp-server-5.0.10/bin/osv/osv.py", line 111, in execute_cr
return getattr(object, method)(cr, uid, *args, **kw)
File "/root/erp/openerp-server-5.0.10/bin/osv/orm.py", line 2225, in read
result = self._read_flat(cr, user, select, fields, context, load)
File "/root/erp/openerp-server-5.0.10/bin/osv/orm.py", line 2297, in _read_flat
res.extend(cr.dictfetchall())
File "/usr/lib/python2.6/dist-packages/psycopg2/psycopg1.py", line 83, in dictfetchall
rows = _2cursor.fetchall(self)
UnicodeDecodeError: 'ascii' codec can't decode byte 0xc3 in position 25: ordinal not in range(128)
服务器端的报错如下:
sh: bzr: not found
No LSB modules are available.
[2010-06-09 15:33:35,323] ERROR:web-services:[01]:
[2010-06-09 15:33:35,323] ERROR:web-services:[02]: Environment Information :
[2010-06-09 15:33:35,323] ERROR:web-services:[03]: System : Linux-2.6.32-22-generic-pae-i686-with-Ubuntu-10.04-lucid
[2010-06-09 15:33:35,323] ERROR:web-services:[04]: OS Name : posix
[2010-06-09 15:33:35,323] ERROR:web-services:[05]: Distributor ID: Ubuntu
[2010-06-09 15:33:35,324] ERROR:web-services:[06]: Description: Ubuntu 10.04 LTS
[2010-06-09 15:33:35,324] ERROR:web-services:[07]: Release: 10.04
[2010-06-09 15:33:35,324] ERROR:web-services:[08]: Codename: lucid
[2010-06-09 15:33:35,324] ERROR:web-services:[09]: Operating System Release : 2.6.32-22-generic-pae
[2010-06-09 15:33:35,324] ERROR:web-services:[10]: Operating System Version : #33-Ubuntu SMP Wed Apr 28 14:57:29 UTC 2010
[2010-06-09 15:33:35,324] ERROR:web-services:[11]: Operating System Architecture : 32bit
[2010-06-09 15:33:35,324] ERROR:web-services:[12]: Operating System Locale : zh_CN.UTF8
[2010-06-09 15:33:35,325] ERROR:web-services:[13]: Python Version : 2.6.5
[2010-06-09 15:33:35,325] ERROR:web-services:[14]: OpenERP-Server Version : 5.0.10
[2010-06-09 15:33:35,325] ERROR:web-services:[15]: Last revision No. & ID :
[2010-06-09 15:33:35,325] ERROR:web-services:[16]: Traceback (most recent call last):
[2010-06-09 15:33:35,325] ERROR:web-services:[17]: File "/root/erp/openerp-server-5.0.10/bin/osv/osv.py", line 58, in wrapper
[2010-06-09 15:33:35,325] ERROR:web-services:[18]: return f(self, dbname, *args, **kwargs)
[2010-06-09 15:33:35,325] ERROR:web-services:[19]: File "/root/erp/openerp-server-5.0.10/bin/osv/osv.py", line 119, in execute
[2010-06-09 15:33:35,326] ERROR:web-services:[20]: res = pool.execute_cr(cr, uid, obj, method, *args, **kw)
[2010-06-09 15:33:35,326] ERROR:web-services:[21]: File "/root/erp/openerp-server-5.0.10/bin/osv/osv.py", line 111, in execute_cr
[2010-06-09 15:33:35,326] ERROR:web-services:[22]: return getattr(object, method)(cr, uid, *args, **kw)
[2010-06-09 15:33:35,326] ERROR:web-services:[23]: File "/root/erp/openerp-server-5.0.10/bin/osv/orm.py", line 2225, in read
[2010-06-09 15:33:35,326] ERROR:web-services:[24]: result = self._read_flat(cr, user, select, fields, context, load)
[2010-06-09 15:33:35,326] ERROR:web-services:[25]: File "/root/erp/openerp-server-5.0.10/bin/osv/orm.py", line 2297, in _read_flat
[2010-06-09 15:33:35,327] ERROR:web-services:[26]: res.extend(cr.dictfetchall())
[2010-06-09 15:33:35,327] ERROR:web-services:[27]: File "/usr/lib/python2.6/dist-packages/psycopg2/psycopg1.py", line 83, in dictfetchall
[2010-06-09 15:33:35,327] ERROR:web-services:[28]: rows = _2cursor.fetchall(self)
[2010-06-09 15:33:35,327] ERROR:web-services:[29]: UnicodeDecodeError: 'ascii' codec can't decode byte 0xc3 in position 25: ordinal not in range(128)
一开始以为是python版本的问题, 后来被排除了. 在网上找了很久, 发现有类似的问题, 但没有解决的方法.
不知道是不是服务器字符集和客户端字符集不一致产生的问题? 但在web客户端下问题依然存在.
不知道大家有没有遇到过类似的情况, 又是如何解决的?