Skip to Content
Odoo Menu
  • Prihlásiť sa
  • Vyskúšajte zadarmo
  • Aplikácie
    Financie
    • Účtovníctvo
    • Fakturácia
    • Výdavky
    • Tabuľka (BI)
    • Dokumenty
    • Podpis
    Predaj
    • CRM
    • Predaj
    • POS Shop
    • POS Restaurant
    • Manažment odberu
    • Požičovňa
    Webstránky
    • Tvorca webstránok
    • eShop
    • Blog
    • Fórum
    • Živý chat
    • eLearning
    Supply Chain
    • Sklad
    • Výroba
    • Správa životného cyklu produktu
    • Nákup
    • Údržba
    • Manažment kvality
    Ľudské zdroje
    • Zamestnanci
    • Nábor zamestnancov
    • Voľné dni
    • Hodnotenia
    • Odporúčania
    • Vozový park
    Marketing
    • Marketing sociálnych sietí
    • Email marketing
    • SMS marketing
    • Eventy
    • Marketingová automatizácia
    • Prieskumy
    Služby
    • Projektové riadenie
    • Pracovné výkazy
    • Práca v teréne
    • Helpdesk
    • Plánovanie
    • Schôdzky
    Produktivita
    • Tímová komunikácia
    • Artificial Intelligence
    • IoT
    • VoIP
    • Znalosti
    • WhatsApp
    Third party apps Odoo Studio Odoo Cloud Platform
  • Priemyselné odvetvia
    Retail
    • Book Store
    • Clothing Store
    • Furniture Store
    • Grocery Store
    • Hardware Store
    • Toy Store
    Food & Hospitality
    • Bar and Pub
    • Reštaurácia
    • Fast Food
    • Guest House
    • Beverage distributor
    • Hotel
    Reality
    • Real Estate Agency
    • Architecture Firm
    • Konštrukcia
    • Property Management
    • Gardening
    • Property Owner Association
    Poradenstvo
    • Accounting Firm
    • Odoo Partner
    • Marketing Agency
    • Law firm
    • Talent Acquisition
    • Audit & Certification
    Výroba
    • Textile
    • Metal
    • Furnitures
    • Jedlo
    • Brewery
    • Corporate Gifts
    Health & Fitness
    • Sports Club
    • Eyewear Store
    • Fitness Center
    • Wellness Practitioners
    • Pharmacy
    • Hair Salon
    Trades
    • Handyman
    • IT Hardware and Support
    • Solar Energy Systems
    • Shoe Maker
    • Cleaning Services
    • HVAC Services
    Iní
    • Nonprofit Organization
    • Environmental Agency
    • Billboard Rental
    • Photography
    • Bike Leasing
    • Software Reseller
    Browse all Industries
  • Komunita
    Vzdelávanie
    • Tutoriály
    • Dokumentácia
    • Certifikácie
    • Školenie
    • Blog
    • Podcast
    Empower Education
    • Vzdelávací program
    • Scale Up! Business Game
    • Visit Odoo
    Softvér
    • Stiahnuť
    • Porovnanie Community a Enterprise vierzie
    • Releases
    Spolupráca
    • Github
    • Fórum
    • Eventy
    • Preklady
    • Staň sa partnerom
    • Services for Partners
    • Register your Accounting Firm
    Služby
    • Nájdite partnera
    • Nájdite účtovníka
    • Meet an advisor
    • Implementation Services
    • Zákaznícke referencie
    • Podpora
    • Upgrades
    ​Github Youtube Twitter Linkedin Instagram Facebook Spotify
    +1 (650) 691-3277
    Získajte demo
  • Cenník
  • Pomoc
You need to be registered to interact with the community.
All Posts People Badges
Tagy (View all)
odoo accounting v14 pos v15
About this forum
You need to be registered to interact with the community.
All Posts People Badges
Tagy (View all)
odoo accounting v14 pos v15
About this forum
Pomoc

Error with res.partner or hr.employee many2one

Odoberať

Get notified when there's activity on this post

This question has been flagged
pythonfieldsmany2oneopenerp7
2 Replies
8489 Zobrazenia
Avatar
Saghir A. Khatri

I am stuck in an error, which i am unable to figure out. I have field like this:

    'person':fields.char('Person')

It was working fine. I replaced it with:

    'person':fields.many2one('res.partner','Person')

but i am getting exception like this:

    

    OpenERP Server Error
    
    Client Traceback (most recent call last):
      File "/opt/openerp/server/openerp/addons/web/http.py", line 204, in dispatch
        response["result"] = method(self, **self.params)
      File "/opt/openerp/server/openerp/addons/web/controllers/main.py", line 1051, in search_read
        return self.do_search_read(req, model, fields, offset, limit, domain, sort)
      File "/opt/openerp/server/openerp/addons/web/controllers/main.py", line 1086, in do_search_read
        records = Model.read(ids, fields or False, req.context)
      File "/opt/openerp/server/openerp/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 "/opt/openerp/server/openerp/addons/web/session.py", line 30, in proxy_method
        result = self.session.send(self.service_name, method, *args)
      File "/opt/openerp/server/openerp/addons/web/session.py", line 103, in send
        raise xmlrpclib.Fault(openerp.tools.ustr(e), formatted_info)
    
    
    Server Traceback (most recent call last):
      File "/opt/openerp/server/openerp/addons/web/session.py", line 89, in send
        return openerp.netsvc.dispatch_rpc(service_name, method, args)
      File "/opt/openerp/server/openerp/netsvc.py", line 296, in dispatch_rpc
        result = ExportService.getService(service_name).dispatch(method, params)
      File "/opt/openerp/server/openerp/service/web_services.py", line 626, in dispatch
        res = fn(db, uid, *params)
      File "/opt/openerp/server/openerp/osv/osv.py", line 190, in execute_kw
        return self.execute(db, uid, obj, method, *args, **kw or {})
      File "/opt/openerp/server/openerp/osv/osv.py", line 132, in wrapper
        return f(self, dbname, *args, **kwargs)
      File "/opt/openerp/server/openerp/osv/osv.py", line 199, in execute
        res = self.execute_cr(cr, uid, obj, method, *args, **kw)
      File "/opt/openerp/server/openerp/osv/osv.py", line 187, in execute_cr
        return getattr(object, method)(cr, uid, *args, **kw)
      File "/opt/openerp/server/openerp/osv/orm.py", line 3679, in read
        result = self._read_flat(cr, user, select, fields, context, load)
      File "/opt/openerp/server/openerp/osv/orm.py", line 3800, in _read_flat
        res2 = self._columns[f].get(cr, self, ids, f, user, context=context, values=res)
      File "/opt/openerp/server/openerp/osv/fields.py", line 468, in get
        context=context))
      File "/opt/openerp/server/openerp/osv/orm.py", line 2393, in name_get
        load='_classic_write', context=context)]
      File "/opt/openerp/server/openerp/addons/base/res/res_users.py", line 830, in read
        res = super(users_view, self).read(cr, uid, ids, fields, context=context, load=load)
      File "/opt/openerp/server/openerp/addons/base/res/res_users.py", line 292, in read
        result = super(res_users, self).read(cr, uid, ids, fields=fields, context=context, load=load)
      File "/opt/openerp/server/openerp/osv/orm.py", line 3679, in read
        result = self._read_flat(cr, user, select, fields, context, load)
      File "/opt/openerp/server/openerp/osv/orm.py", line 3731, in _read_flat
        cr.execute(query, [tuple(sub_ids)] + rule_params)
      File "/opt/openerp/server/openerp/sql_db.py", line 161, in wrapper
        return f(self, *args, **kwargs)
      File "/opt/openerp/server/openerp/sql_db.py", line 226, in execute
        res = self._obj.execute(query, params)
    ProgrammingError: operator does not exist: integer = boolean
    LINE 1: ...,res_users.id FROM "res_users" WHERE res_users.id IN (false)...
                                                                 ^
    HINT:  No operator matches the given name and argument type(s). You might need to add explicit type casts.

I have used same syntax with other modules and they are working fine. I tried to replace `res.partner` with `hr.employee` and `res.users` but issue remains same. Kindly guide me to right direction.

Thanks

 

0
Avatar
Zrušiť
Ivan

Have you restarted the server and then upgrade your module?

Avatar
Michael Telahun
Best Answer

You didn't give the situation in which this error triggers. Does it happen when you load the module? Start odoo? When?

Never the less, I've seen this type of error before when the logged in user isn't linked to an employee record. In the employee record form near the bottom there is a field that says: "Related User". Make sure it's filled in.

0
Avatar
Zrušiť
Avatar
Med Said BARA
Best Answer

Maybe, you forgot to inherit from res.partner 

0
Avatar
Zrušiť
Enjoying the discussion? Don't just read, join in!

Create an account today to enjoy exclusive features and engage with our awesome community!

Registrácia
Related Posts Replies Zobrazenia Aktivita
Python - Populating many2one field on loading of form OpenERP
python many2one openerp7
Avatar
Avatar
1
mar 15
6733
OpenERP: getting values from first part of many2one field in second many2one field
python fields many2one one2many
Avatar
0
mar 15
9118
many2one field not showing field values
python fields many2one relationship
Avatar
Avatar
Avatar
2
mar 15
15227
many2one show all the fields
many2one openerp7
Avatar
Avatar
Avatar
2
feb 25
10488
Clear field many2one if a checkbox is deselected
fields many2one
Avatar
Avatar
1
jan 22
5320
Komunita
  • Tutoriály
  • Dokumentácia
  • Fórum
Open Source
  • Stiahnuť
  • Github
  • Runbot
  • Preklady
Služby
  • Odoo.sh hosting
  • Podpora
  • Vyššia verzia
  • Custom Developments
  • Vzdelávanie
  • Nájdite účtovníka
  • Nájdite partnera
  • Staň sa partnerom
O nás
  • Naša spoločnosť
  • Majetok značky
  • Kontaktujte nás
  • Pracovné ponuky
  • Eventy
  • Podcast
  • Blog
  • Zákazníci
  • Právne dokumenty • Súkromie
  • Bezpečnosť
الْعَرَبيّة Català 简体中文 繁體中文 (台灣) Čeština Dansk Nederlands English Suomi Français Deutsch हिंदी Bahasa Indonesia Italiano 日本語 한국어 (KR) Lietuvių kalba Język polski Português (BR) română русский язык Slovenský jazyk Slovenščina Español (América Latina) Español Svenska ภาษาไทย Türkçe українська Tiếng Việt

Odoo je sada podnikových aplikácií s otvoreným zdrojovým kódom, ktoré pokrývajú všetky potreby vašej spoločnosti: CRM, e-shop, účtovníctvo, skladové hospodárstvo, miesto predaja, projektový manažment atď.

Odoo prináša vysokú pridanú hodnotu v jednoduchom použití a súčasne plne integrovanými biznis aplikáciami.

Website made with

Odoo Experience on YouTube

1. Use the live chat to ask your questions.
2. The operator answers within a few minutes.

Live support on Youtube
Watch now