1. Home
  2. Categories
  3. Odoo 开发与实施交流
  4. Openerp7.0 开发 ,添加字段 保存时出现错误(附件为图片),请各位老师看看,是什么原因?谢谢.

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

由于系统升迁的原因，本论坛部分较早期的内容存在格式和链接损坏失效的问题，并非本论坛系统本身的缺陷，望谅解

本社区没有维护任何QQ群讨论组，任何与本社区同名的QQ群讨论组的言论与本社区无关!

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

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

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

  • S

    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.

    0
  • C

    你是不是类型搞错了

    0
  • 1

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

    0
  • A

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

    0
  • U

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

    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:  没有匹配指定名称和参数类型的操作符. 您也许需要增加明确的类型转换.

    0
  • X

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

    0
  • ieitzyb

    😠

    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
Log in to reply