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

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

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

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

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



  • 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.



  • 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.



  • 你是不是类型搞错了



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



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



  • 我是新手,出现同样的问题

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



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



  • >:(



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


登录后回复
 

与 Odoo 中文社区 的连接断开,我们正在尝试重连,请耐心等待