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
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?
Thank for answering Mr. Van, the problem has been solved :)