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

Odoo中文社区可以通过以下三个域名访问：shine-it.net , odoocn.org，odoo.net.cn

原论坛用户的基本信息和发帖这里都予以保留，请注意：原论坛用户无需重新注册新用户，但是您的密码需要重置

开发人员可以登录gitter讨论组: http://gitter.im/odoo-china/Talk, 需要github账号

如果您登录系统碰到问题，请在微信公众号留言：

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

  • S

    openerp7.0 开发 ,添加字段 保存时出现错误(附件为图片),请各位老师看看,是什么原因?谢谢.<br /><br />OpenERP Server Error<br />Client Traceback (most recent call last):<br />  File "/home/odoo/source/web/addons/web/http.py", line 204, in dispatch<br />    response["result"] = method(self, **self.params)<br />  File "/home/odoo/source/web/addons/web/controllers/main.py", line 1121, in call_kw<br />    return self._call_kw(req, model, method, args, kwargs)<br />  File "/home/odoo/source/web/addons/web/controllers/main.py", line 1113, in _call_kw<br />    return getattr(req.session.model(model), method)(*args, **kwargs)<br />  File "/home/odoo/source/web/addons/web/session.py", line 42, in proxy<br />    result = self.proxy.execute_kw(self.session._db, self.session._uid, self.session._password, self.model, method, args, kw)<br />  File "/home/odoo/source/web/addons/web/session.py", line 30, in proxy_method<br />    result = self.session.send(self.service_name, method, *args)<br />  File "/home/odoo/source/web/addons/web/session.py", line 103, in send<br />    raise xmlrpclib.Fault(openerp.tools.ustr(e), formatted_info)<br /><br /><br />Server Traceback (most recent call last):<br />  File "/home/odoo/source/web/addons/web/session.py", line 89, in send<br />    return openerp.netsvc.dispatch_rpc(service_name, method, args)<br />  File "/home/odoo/source/server/openerp/netsvc.py", line 292, in dispatch_rpc<br />    result = ExportService.getService(service_name).dispatch(method, params)<br />  File "/home/odoo/source/server/openerp/service/web_services.py", line 626, in dispatch<br />    res = fn(db, uid, *params)<br />  File "/home/odoo/source/server/openerp/osv/osv.py", line 188, in execute_kw<br />    return self.execute(db, uid, obj, method, *args, **kw or {})<br />  File "/home/odoo/source/server/openerp/osv/osv.py", line 131, in wrapper<br />    return f(self, dbname, *args, **kwargs)<br />  File "/home/odoo/source/server/openerp/osv/osv.py", line 197, in execute<br />    res = self.execute_cr(cr, uid, obj, method, *args, **kw)<br />  File "/home/odoo/source/server/openerp/osv/osv.py", line 185, in execute_cr<br />    return getattr(object, method)(cr, uid, *args, **kw)<br />  File "/home/odoo/source/server/openerp/addons/base/ir/ir_model.py", line 185, in write<br />    return super(ir_model,self).write(cr, user, ids, vals, context)<br />  File "/home/odoo/source/server/openerp/osv/orm.py", line 4178, in write<br />    result += self._columns[field].set(cr, self, id, field, vals[field], user, context=rel_context) or []<br />  File "/home/odoo/source/server/openerp/osv/fields.py", line 557, in set<br />    id_new = obj.create(cr, user, act[2], context=context)<br />  File "/home/odoo/source/server/openerp/addons/base/ir/ir_model.py", line 357, in create<br />    self.pool.get(vals['model'])._auto_init(cr, ctx)<br />  File "/home/odoo/source/server/openerp/osv/orm.py", line 3007, in _auto_init<br />    self._m2m_raise_or_create_relation(cr, f)<br />  File "/home/odoo/source/server/openerp/osv/orm.py", line 3313, in _m2m_raise_or_create_relation<br />    self._save_relation_table(cr, m2m_tbl)<br />  File "/home/odoo/source/server/openerp/osv/orm.py", line 2874, in _save_relation_table<br />    """, (relation_table, self._module))<br />  File "/home/odoo/source/server/openerp/sql_db.py", line 161, in wrapper<br />    return f(self, *args, **kwargs)<br />  File "/home/odoo/source/server/openerp/sql_db.py", line 226, in execute<br />    res = self._obj.execute(query, params)<br />ProgrammingError: operator does not exist: character varying = boolean<br />LINE 5:                AND ir_module_module.name=false<br />                                                ^<br />HINT:  No operator matches the given name and argument type(s). You might need to add explicit type casts.

    0
  • C

    你是不是类型搞错了

    0
  • 1

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

    0
  • A

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

    0
  • U

    我是新手，出现同样的问题<br /><br />OpenERP<br />OpenERP Server Error<br />Client Traceback (most recent call last):<br />  File "C:\Program Files\OpenERP 7.0-20130812-231022\Server\server\openerp\addons\web\http.py", line 204, in dispatch<br />  File "C:\Program Files\OpenERP 7.0-20130812-231022\Server\server\openerp\addons\web\controllers\main.py", line 1128, in call_kw<br />  File "C:\Program Files\OpenERP 7.0-20130812-231022\Server\server\openerp\addons\web\controllers\main.py", line 1120, in _call_kw<br />  File "C:\Program Files\OpenERP 7.0-20130812-231022\Server\server\openerp\addons\web\session.py", line 42, in proxy<br />  File "C:\Program Files\OpenERP 7.0-20130812-231022\Server\server\openerp\addons\web\session.py", line 30, in proxy_method<br />  File "C:\Program Files\OpenERP 7.0-20130812-231022\Server\server\openerp\addons\web\session.py", line 103, in send<br /><br /><br />Server Traceback (most recent call last):<br />  File "C:\Program Files\OpenERP 7.0-20130812-231022\Server\server\openerp\addons\web\session.py", line 89, in send<br />  File "C:\Program Files\OpenERP 7.0-20130812-231022\Server\server.\openerp\netsvc.py", line 292, in dispatch_rpc<br />  File "C:\Program Files\OpenERP 7.0-20130812-231022\Server\server.\openerp\service\web_services.py", line 626, in dispatch<br />  File "C:\Program Files\OpenERP 7.0-20130812-231022\Server\server.\openerp\osv\osv.py", line 188, in execute_kw<br />  File "C:\Program Files\OpenERP 7.0-20130812-231022\Server\server.\openerp\osv\osv.py", line 131, in wrapper<br />  File "C:\Program Files\OpenERP 7.0-20130812-231022\Server\server.\openerp\osv\osv.py", line 197, in execute<br />  File "C:\Program Files\OpenERP 7.0-20130812-231022\Server\server.\openerp\osv\osv.py", line 185, in execute_cr<br />  File "C:\Program Files\OpenERP 7.0-20130812-231022\Server\server\openerp\addons\base\ir\ir_model.py", line 185, in write<br />  File "C:\Program Files\OpenERP 7.0-20130812-231022\Server\server.\openerp\osv\orm.py", line 4178, in write<br />  File "C:\Program Files\OpenERP 7.0-20130812-231022\Server\server.\openerp\osv\fields.py", line 560, in set<br />  File "C:\Program Files\OpenERP 7.0-20130812-231022\Server\server\openerp\addons\base\ir\ir_model.py", line 475, in write<br />  File "C:\Program Files\OpenERP 7.0-20130812-231022\Server\server.\openerp\osv\orm.py", line 3007, in _auto_init<br />  File "C:\Program Files\OpenERP 7.0-20130812-231022\Server\server.\openerp\osv\orm.py", line 3313, in _m2m_raise_or_create_relation<br />  File "C:\Program Files\OpenERP 7.0-20130812-231022\Server\server.\openerp\osv\orm.py", line 2874, in _save_relation_table<br />  File "C:\Program Files\OpenERP 7.0-20130812-231022\Server\server.\openerp\sql_db.py", line 161, in wrapper<br />  File "C:\Program Files\OpenERP 7.0-20130812-231022\Server\server.\openerp\sql_db.py", line 226, in execute<br />ProgrammingError: 错误:  操作符不存在: character varying = boolean<br />LINE 5:                AND ir_module_module.name=false<br />                                                ^<br />HINT:  没有匹配指定名称和参数类型的操作符. 您也许需要增加明确的类型转换.

    0
  • X

    这个错误 有高人可以解决吗?<br />

    0

  • 😠

    0
  • X

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

    0