Openerp7.0 开发 ,添加字段 保存时出现错误(附件为图片),请各位老师看看,是什么原因?谢谢.

[spring55156]

openerp7.0 开发 ,添加字段 保存时出现错误(附件为图片),请各位老师看看,是什么原因?谢谢.

OpenERP Server Error
Client Traceback (most recent call last):
  File "/home/odoo/source/web/addons/web/http.py", line 204, in dispatch
    response["result"] = method(self, **self.params)
  File "/home/odoo/source/web/addons/web/controllers/main.py", line 1121, in call_kw
    return self._call_kw(req, model, method, args, kwargs)
  File "/home/odoo/source/web/addons/web/controllers/main.py", line 1113, in _call_kw
    return getattr(req.session.model(model), method)(*args, **kwargs)
  File "/home/odoo/source/web/addons/web/session.py", line 42, in proxy
    result = self.proxy.execute_kw(self.session._db, self.session._uid, self.session._password, self.model, method, args, kw)
  File "/home/odoo/source/web/addons/web/session.py", line 30, in proxy_method
    result = self.session.send(self.service_name, method, *args)
  File "/home/odoo/source/web/addons/web/session.py", line 103, in send
    raise xmlrpclib.Fault(openerp.tools.ustr(e), formatted_info)


Server Traceback (most recent call last):
  File "/home/odoo/source/web/addons/web/session.py", line 89, in send
    return openerp.netsvc.dispatch_rpc(service_name, method, args)
  File "/home/odoo/source/server/openerp/netsvc.py", line 292, in dispatch_rpc
    result = ExportService.getService(service_name).dispatch(method, params)
  File "/home/odoo/source/server/openerp/service/web_services.py", line 626, in dispatch
    res = fn(db, uid, *params)
  File "/home/odoo/source/server/openerp/osv/osv.py", line 188, in execute_kw
    return self.execute(db, uid, obj, method, *args, **kw or {})
  File "/home/odoo/source/server/openerp/osv/osv.py", line 131, in wrapper
    return f(self, dbname, *args, **kwargs)
  File "/home/odoo/source/server/openerp/osv/osv.py", line 197, in execute
    res = self.execute_cr(cr, uid, obj, method, *args, **kw)
  File "/home/odoo/source/server/openerp/osv/osv.py", line 185, in execute_cr
    return getattr(object, method)(cr, uid, *args, **kw)
  File "/home/odoo/source/server/openerp/addons/base/ir/ir_model.py", line 185, in write
    return super(ir_model,self).write(cr, user, ids, vals, context)
  File "/home/odoo/source/server/openerp/osv/orm.py", line 4178, in write
    result += self._columns[field].set(cr, self, id, field, vals[field], user, context=rel_context) or []
  File "/home/odoo/source/server/openerp/osv/fields.py", line 557, in set
    id_new = obj.create(cr, user, act[2], context=context)
  File "/home/odoo/source/server/openerp/addons/base/ir/ir_model.py", line 357, in create
    self.pool.get(vals['model'])._auto_init(cr, ctx)
  File "/home/odoo/source/server/openerp/osv/orm.py", line 3007, in _auto_init
    self._m2m_raise_or_create_relation(cr, f)
  File "/home/odoo/source/server/openerp/osv/orm.py", line 3313, in _m2m_raise_or_create_relation
    self._save_relation_table(cr, m2m_tbl)
  File "/home/odoo/source/server/openerp/osv/orm.py", line 2874, in _save_relation_table
    """, (relation_table, self._module))
  File "/home/odoo/source/server/openerp/sql_db.py", line 161, in wrapper
    return f(self, *args, **kwargs)
  File "/home/odoo/source/server/openerp/sql_db.py", line 226, in execute
    res = self._obj.execute(query, params)
ProgrammingError: operator does not exist: character varying = boolean
LINE 5:                AND ir_module_module.name=false
                                                ^
HINT:  No operator matches the given name and argument type(s). You might need to add explicit type casts.

[ChanInOpenERP]

你是不是类型搞错了

[10111101]

添加char字段 时 ，大小 不能为0

[aornor]

注意： 添加字段时，必须为ASCII码，包括注视，否则在添加，修改，甚至显示的时候都会有错误信息弹出

[uu_ckh]

我是新手，出现同样的问题

OpenERP
OpenERP Server Error
Client Traceback (most recent call last):
  File "C:\Program Files\OpenERP 7.0-20130812-231022\Server\server\openerp\addons\web\http.py", line 204, in dispatch
  File "C:\Program Files\OpenERP 7.0-20130812-231022\Server\server\openerp\addons\web\controllers\main.py", line 1128, in call_kw
  File "C:\Program Files\OpenERP 7.0-20130812-231022\Server\server\openerp\addons\web\controllers\main.py", line 1120, in _call_kw
  File "C:\Program Files\OpenERP 7.0-20130812-231022\Server\server\openerp\addons\web\session.py", line 42, in proxy
  File "C:\Program Files\OpenERP 7.0-20130812-231022\Server\server\openerp\addons\web\session.py", line 30, in proxy_method
  File "C:\Program Files\OpenERP 7.0-20130812-231022\Server\server\openerp\addons\web\session.py", line 103, in send


Server Traceback (most recent call last):
  File "C:\Program Files\OpenERP 7.0-20130812-231022\Server\server\openerp\addons\web\session.py", line 89, in send
  File "C:\Program Files\OpenERP 7.0-20130812-231022\Server\server.\openerp\netsvc.py", line 292, in dispatch_rpc
  File "C:\Program Files\OpenERP 7.0-20130812-231022\Server\server.\openerp\service\web_services.py", line 626, in dispatch
  File "C:\Program Files\OpenERP 7.0-20130812-231022\Server\server.\openerp\osv\osv.py", line 188, in execute_kw
  File "C:\Program Files\OpenERP 7.0-20130812-231022\Server\server.\openerp\osv\osv.py", line 131, in wrapper
  File "C:\Program Files\OpenERP 7.0-20130812-231022\Server\server.\openerp\osv\osv.py", line 197, in execute
  File "C:\Program Files\OpenERP 7.0-20130812-231022\Server\server.\openerp\osv\osv.py", line 185, in execute_cr
  File "C:\Program Files\OpenERP 7.0-20130812-231022\Server\server\openerp\addons\base\ir\ir_model.py", line 185, in write
  File "C:\Program Files\OpenERP 7.0-20130812-231022\Server\server.\openerp\osv\orm.py", line 4178, in write
  File "C:\Program Files\OpenERP 7.0-20130812-231022\Server\server.\openerp\osv\fields.py", line 560, in set
  File "C:\Program Files\OpenERP 7.0-20130812-231022\Server\server\openerp\addons\base\ir\ir_model.py", line 475, in write
  File "C:\Program Files\OpenERP 7.0-20130812-231022\Server\server.\openerp\osv\orm.py", line 3007, in _auto_init
  File "C:\Program Files\OpenERP 7.0-20130812-231022\Server\server.\openerp\osv\orm.py", line 3313, in _m2m_raise_or_create_relation
  File "C:\Program Files\OpenERP 7.0-20130812-231022\Server\server.\openerp\osv\orm.py", line 2874, in _save_relation_table
  File "C:\Program Files\OpenERP 7.0-20130812-231022\Server\server.\openerp\sql_db.py", line 161, in wrapper
  File "C:\Program Files\OpenERP 7.0-20130812-231022\Server\server.\openerp\sql_db.py", line 226, in execute
ProgrammingError: 错误:  操作符不存在: character varying = boolean
LINE 5:                AND ir_module_module.name=false
                                                ^
HINT:  没有匹配指定名称和参数类型的操作符. 您也许需要增加明确的类型转换.

[xiexiao04]

这个错误 有高人可以解决吗?

[ieitzyb]

[xiaokang_214]

这个可能和openerp7这个bug有关，请按照http://bazaar.launchpad.net/~openerp-dev/openobject-server/trunk-bug-1161881-ishwar/revision/4853/openerp/osv/orm.py#openerp/osv/orm.py指示，修改下代码试试