Skip to Content
Menu
This question has been flagged

Traceback (most recent call last):
  File "C: \ projects \ odoo12 \ odoo \ http.py", line 656, in _handle_exception
    return super (JsonRequest, self) ._ handle_exception (exception)
  File "C: \ projects \ odoo12 \ odoo \ http.py", line 314, in _handle_exception
    raise pycompat.reraise (type (exception), exception, sys.exc_info () [2])
  File "C: \ projects \ odoo12 \ odoo \ tools \ pycompat.py", line 87, in reraise
    raise value
  File "C: \ projects \ odoo12 \ odoo \ http.py", line 698, in dispatch
    result = self._call_function (** self.params)
  File "C: \ projects \ odoo12 \ odoo \ http.py", line 346, in _call_function
    return checked_call (self.db, * args, ** kwargs)
  File "C: \ projects \ odoo12 \ odoo \ service \ model.py", line 97, in wrapper
    return f (dbname, * args, ** kwargs)
  File "C: \ projects \ odoo12 \ odoo \ http.py", line 339, in checked_call
    result = self.endpoint (* a, ** kw)
  File "C: \ projects \ odoo12 \ odoo \ http.py", line 941, in __call__
    return self.method (* args, ** kw)
  File "C: \ projects \ odoo12 \ odoo \ http.py", line 519, in response_wrap
    response = f (* args, ** kw)
  File "c: \ projects \ odoo12 \ addons \ web \ controllers \ main.py", line 962, in call_kw
    return self._call_kw (model, method, args, kwargs)
  File "c: \ projects \ odoo12 \ addons \ web \ controllers \ main.py", line 954, in _call_kw
    return call_kw (request.env [model], method, args, kwargs)
  File "C: \ projects \ odoo12 \ odoo \ api.py", line 747, in call_kw
    return _call_kw_model_create (method, model, args, kwargs)
  File "C: \ projects \ odoo12 \ odoo \ api.py", line 727, in _call_kw_model_create
    result = method (recs, * args, ** kwargs)
  File "<decorator-gen-3>", line 2, in create
  File "C: \ projects \ odoo12 \ odoo \ api.py", line 451, in _model_create_multi
    return create (self, [arg])
  File "C: \ projects \ odoo12 \ odoo \ models.py", line 3566, in create
    records = self._create (data_list)
  File "C: \ projects \ odoo12 \ odoo \ models.py", line 3666, in _create
    cr.execute (query, params)
  File "C: \ projects \ odoo12 \ odoo \ sql_db.py", line 148, in wrapper
    return f (self, * args, ** kwargs)
  File "C: \ projects \ odoo12 \ odoo \ sql_db.py", line 225, in execute
    res = self._obj.execute (query, params)
psycopg2.errors.InvalidTextRepresentation: invalid input syntax for integer: "Test"
LINE 1: ..., (now () at time zone 'UTC'), 0.0, 0.0, 0.0, 0.0, 'Test', 0 ....
                                                             ^
What does this error mean, when i clicked the button it has this error? I removed the .now in date field, this is the function of the button


@ api.multi
def action_start (self, route, date_start, date_end, date):
product_ids = self._get_product_ids ()
date_start = date + "00:00:00"
date_end = date + "23:55:55"
for shrinkage in self.filtered (lambda x: x.state not in ('done', 'cancel')):
vals = {'state': 'confirm', 'date': fields.Date.today ()}
if not shrinkage. line_ids:
for product_id in product_ids:
vals.update ({'line_ids': [(0, 0, line_values) for line_values ​​in shrinkage._get_shrinkage_lines_values ​​(product_id, route, date_start, date_end)]})
shrinkage.write (vals)
return True

Avatar
Discard

You're trying to insert 'test' as an ID, which won't work. I don't see this specific code in your pasted code though, perhaps you've set a default or something somewhere else?

Author

Thank for answering Mr. Van, the problem has been solved :)

Related Posts Replies Views Activity
2
Jan 22
3246
2
Jan 20
4675
1
Jan 24
12763
2
Mar 18
3867
2
Jan 18
5225