Skip to Content
Odoo Menu
  • Sign in
  • Try it free
  • Apps
    Finance
    • Accounting
    • Invoicing
    • Expenses
    • Spreadsheet (BI)
    • Documents
    • Sign
    Sales
    • CRM
    • Sales
    • POS Shop
    • POS Restaurant
    • Subscriptions
    • Rental
    Websites
    • Website Builder
    • eCommerce
    • Blog
    • Forum
    • Live Chat
    • eLearning
    Supply Chain
    • Inventory
    • Manufacturing
    • PLM
    • Purchase
    • Maintenance
    • Quality
    Human Resources
    • Employees
    • Recruitment
    • Time Off
    • Appraisals
    • Referrals
    • Fleet
    Marketing
    • Social Marketing
    • Email Marketing
    • SMS Marketing
    • Events
    • Marketing Automation
    • Surveys
    Services
    • Project
    • Timesheets
    • Field Service
    • Helpdesk
    • Planning
    • Appointments
    Productivity
    • Discuss
    • Artificial Intelligence
    • IoT
    • VoIP
    • Knowledge
    • WhatsApp
    Third party apps Odoo Studio Odoo Cloud Platform
  • Industries
    Retail
    • Book Store
    • Clothing Store
    • Furniture Store
    • Grocery Store
    • Hardware Store
    • Toy Store
    Food & Hospitality
    • Bar and Pub
    • Restaurant
    • Fast Food
    • Guest House
    • Beverage Distributor
    • Hotel
    Real Estate
    • Real Estate Agency
    • Architecture Firm
    • Construction
    • Property Management
    • Gardening
    • Property Owner Association
    Consulting
    • Accounting Firm
    • Odoo Partner
    • Marketing Agency
    • Law firm
    • Talent Acquisition
    • Audit & Certification
    Manufacturing
    • Textile
    • Metal
    • Furnitures
    • Food
    • Brewery
    • Corporate Gifts
    Health & Fitness
    • Sports Club
    • Eyewear Store
    • Fitness Center
    • Wellness Practitioners
    • Pharmacy
    • Hair Salon
    Trades
    • Handyman
    • IT Hardware & Support
    • Solar Energy Systems
    • Shoe Maker
    • Cleaning Services
    • HVAC Services
    Others
    • Nonprofit Organization
    • Environmental Agency
    • Billboard Rental
    • Photography
    • Bike Leasing
    • Software Reseller
    Browse all Industries
  • Community
    Learn
    • Tutorials
    • Documentation
    • Certifications
    • Training
    • Blog
    • Podcast
    Empower Education
    • Education Program
    • Scale Up! Business Game
    • Visit Odoo
    Get the Software
    • Download
    • Compare Editions
    • Releases
    Collaborate
    • Github
    • Forum
    • Events
    • Translations
    • Become a Partner
    • Services for Partners
    • Register your Accounting Firm
    • Referral Program
    Get Services
    • Find a Partner
    • Find an Accountant
    • Meet an advisor
    • Implementation Services
    • Customer References
    • Support
    • Upgrades
    Github Youtube Twitter Linkedin Instagram Facebook Spotify
    +1 (650) 691-3277
    Get a demo
  • Pricing
  • Help
You need to be registered to interact with the community.
All Posts People Badges
Tags (View all)
odoo accounting v14 pos v15
About this forum
You need to be registered to interact with the community.
All Posts People Badges
Tags (View all)
odoo accounting v14 pos v15
About this forum
Help

add a certain amount of time to your start date

Subscribe

Get notified when there's activity on this post

This question has been flagged
datetimecomputepython3odoo12
1 Reply
6753 Views
Avatar
Jens Willemijn

how do i add a certain amount of time to my start date

i get this error:

Error:

Odoo Server Error


Traceback (most recent call last):

  File "/usr/lib/python3/dist-packages/odoo/api.py", line 1039, in get

    value = self._data[key][field][record.id]

KeyError: 1


During handling of the above exception, another exception occurred:


Traceback (most recent call last):

  File "/usr/lib/python3/dist-packages/odoo/fields.py", line 963, in __get__

    value = record.env.cache.get(record, self)

  File "/usr/lib/python3/dist-packages/odoo/api.py", line 1041, in get

    raise CacheMiss(record, field)

odoo.exceptions.CacheMiss: ('reservatie(1,).end_time', None)


During handling of the above exception, another exception occurred:


Traceback (most recent call last):

  File "/usr/lib/python3/dist-packages/odoo/http.py", line 654, in _handle_exception

    return super(JsonRequest, self)._handle_exception(exception)

  File "/usr/lib/python3/dist-packages/odoo/http.py", line 312, in _handle_exception

    raise pycompat.reraise(type(exception), exception, sys.exc_info()[2])

  File "/usr/lib/python3/dist-packages/odoo/tools/pycompat.py", line 87, in reraise

    raise value

  File "/usr/lib/python3/dist-packages/odoo/http.py", line 696, in dispatch

    result = self._call_function(**self.params)

  File "/usr/lib/python3/dist-packages/odoo/http.py", line 344, in _call_function

    return checked_call(self.db, *args, **kwargs)

  File "/usr/lib/python3/dist-packages/odoo/service/model.py", line 97, in wrapper

    return f(dbname, *args, **kwargs)

  File "/usr/lib/python3/dist-packages/odoo/http.py", line 337, in checked_call

    result = self.endpoint(*a, **kw)

  File "/usr/lib/python3/dist-packages/odoo/http.py", line 939, in __call__

    return self.method(*args, **kw)

  File "/usr/lib/python3/dist-packages/odoo/http.py", line 517, in response_wrap

    response = f(*args, **kw)

  File "/usr/lib/python3/dist-packages/odoo/addons/web/controllers/main.py", line 962, in call_kw

    return self._call_kw(model, method, args, kwargs)

  File "/usr/lib/python3/dist-packages/odoo/addons/web/controllers/main.py", line 954, in _call_kw

    return call_kw(request.env[model], method, args, kwargs)

  File "/usr/lib/python3/dist-packages/odoo/api.py", line 749, in call_kw

    return _call_kw_multi(method, model, args, kwargs)

  File "/usr/lib/python3/dist-packages/odoo/api.py", line 736, in _call_kw_multi

    result = method(recs, *args, **kwargs)

  File "/usr/lib/python3/dist-packages/odoo/models.py", line 2780, in read

    data[record][name] = convert(record[name], record, use_name_get)

  File "/usr/lib/python3/dist-packages/odoo/models.py", line 5065, in __getitem__

    return self._fields[key].__get__(self, type(self))

  File "/usr/lib/python3/dist-packages/odoo/fields.py", line 967, in __get__

    self.determine_value(record)

  File "/usr/lib/python3/dist-packages/odoo/fields.py", line 1078, in determine_value

    self.compute_value(recs)

  File "/usr/lib/python3/dist-packages/odoo/fields.py", line 1034, in compute_value

    self._compute_value(records)

  File "/usr/lib/python3/dist-packages/odoo/fields.py", line 1025, in _compute_value

    getattr(records, self.compute)()

  File "<decorator-gen-192>", line 2, in _compute_end_time

  File "/usr/lib/python3/dist-packages/odoo/api.py", line 372, in loop

    result = [method(rec, *args, **kwargs) for rec in self]

  File "/usr/lib/python3/dist-packages/odoo/api.py", line 372, in <listcomp>

    result = [method(rec, *args, **kwargs) for rec in self]

  File "/usr/lib/python3/dist-packages/odoo/addons/WellbeingReservaties/models/reservatie.py", line 26, in _compute_end_time

    self.end_time = self.start_time + timedelta(hours=self.uren, minutes=self.minuten)

TypeError: unsupported operand type(s) for +: 'bool' and 'datetime.timedelta'

this is my current code:

treatment_duur = fields.Integer(related='treatment_id.duur')

start_time = fields.Datetime(string='My date')

@api.one
def _compute_uren(self):
self.uren = self.treatment_duur // 60

@api.one
def _compute_minuten(self):
self.minuten = self.treatment_duur % 60

@api.one
def _compute_end_time(self):
self.end_time = self.start_time + timedelta(hours=self.uren, minutes=self.minuten)

uren = fields.Integer(compute='_compute_uren')
minuten = fields.Integer(compute='_compute_minuten')

end_time = fields.Datetime(compute='_compute_end_time')
0
Avatar
Discard
Avatar
Pablo Guerra
Best Answer

This happened b/c the start_time field is empty. Make sure that you have input the start_date from the front end form view. To assert that start_time is always input you can make the start_date as a required field, like

start_time = fields.Datetime(string="My date", required=True)

1
Avatar
Discard
Jens Willemijn
Author

we found the issues, apparently a clean database fixed this issue, thx for your help anyway :).

Enjoying the discussion? Don't just read, join in!

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

Sign up
Related Posts Replies Views Activity
Odoo compute field Integer // int Solved
compute python3
Avatar
Avatar
1
May 23
16711
I want to populate Customer/Vendor Many2one field based on Selection Field which has two selection 1.Sale Order, 2.Purchase Order. If it is Sale Order then Many2one field should have Customers from sale.order model and if it is Purchase Order then Many2one field should have Vendors from purchase.order model. v:odoo12 Solved
python3 odoo12
Avatar
Avatar
Avatar
3
Dec 22
5053
How to make sign up menu in website? Solved
python3 odoo12
Avatar
Avatar
2
Apr 20
6333
Multi Assign to one task?
python3 odoo12
Avatar
Avatar
1
Apr 20
5386
How to run code in the background for longer period of time without blocking UI? Solved
python3 odoo12
Avatar
Avatar
Avatar
2
Mar 26
11483
Community
  • Tutorials
  • Documentation
  • Forum
Open Source
  • Download
  • Github
  • Runbot
  • Translations
Services
  • Odoo.sh Hosting
  • Support
  • Upgrade
  • Custom Developments
  • Education
  • Find an Accountant
  • Find a Partner
  • Become a Partner
About us
  • Our company
  • Brand Assets
  • Contact us
  • Jobs
  • Events
  • Podcast
  • Blog
  • Customers
  • Legal • Privacy
  • Security
الْعَرَبيّة 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 is a suite of open source business apps that cover all your company needs: CRM, eCommerce, accounting, inventory, point of sale, project management, etc.

Odoo's unique value proposition is to be at the same time very easy to use and fully integrated.

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