Hello, I just tried odoo and have installed several modules, then I tried to run some functions such as making a purchase then making a payment.
After the data is input on the purchase module, then I press the confirm order button, but an error appears like this
Error:
Odoo Server Error
Traceback (most recent call last):
File "/opt/odoo13/odoo/odoo/http.py", line 624, in _handle_exception
return super(JsonRequest, self)._handle_exception(exception)
File "/opt/odoo13/odoo/odoo/http.py", line 310, in _handle_exception
raise pycompat.reraise(type(exception), exception, sys.exc_info()[2])
File "/opt/odoo13/odoo/odoo/tools/pycompat.py", line 14, in reraise
raise value
File "/opt/odoo13/odoo/odoo/http.py", line 669, in dispatch
result = self._call_function(**self.params)
File "/opt/odoo13/odoo/odoo/http.py", line 350, in _call_function
return checked_call(self.db, *args, **kwargs)
File "/opt/odoo13/odoo/odoo/service/model.py", line 93, in wrapper
return f(dbname, *args, **kwargs)
File "/opt/odoo13/odoo/odoo/http.py", line 339, in checked_call
result = self.endpoint(*a, **kw)
File "/opt/odoo13/odoo/odoo/http.py", line 915, in __call__
return self.method(*args, **kw)
File "/opt/odoo13/odoo/odoo/http.py", line 515, in response_wrap
response = f(*args, **kw)
File "/opt/odoo13/odoo/addons/web/controllers/main.py", line 1326, in call_button
action = self._call_kw(model, method, args, kwargs)
File "/opt/odoo13/odoo/addons/web/controllers/main.py", line 1314, in _call_kw
return call_kw(request.env[model], method, args, kwargs)
File "/opt/odoo13/odoo/odoo/api.py", line 387, in call_kw
result = _call_kw_multi(method, model, args, kwargs)
File "/opt/odoo13/odoo/odoo/api.py", line 374, in _call_kw_multi
result = method(recs, *args, **kwargs)
File "/opt/odoo13/odoo/addons/purchase/models/purchase.py", line 362, in button_confirm
order.button_approve()
File "/opt/odoo13/odoo/addons/purchase_stock/models/purchase.py", line 89, in button_approve
self._create_picking()
File "/opt/odoo13/odoo/addons/purchase_stock/models/purchase.py", line 217, in _create_picking
picking = StockPicking.create(res)
File "<decorator-gen-137>", line 2, in create
File "/opt/odoo13/odoo/odoo/api.py", line 314, in _model_create_single
return create(self, arg)
File "/opt/odoo13/odoo/addons/stock/models/stock_picking.py", line 556, in create
vals['name'] = picking_type.sequence_id.next_by_id()
File "/opt/odoo13/odoo/odoo/addons/base/models/ir_sequence.py", line 260, in next_by_id
return self._next(sequence_date=sequence_date)
File "/opt/odoo13/odoo/odoo/addons/base/models/ir_sequence.py", line 249, in _next
return self._next_do()
File "/opt/odoo13/odoo/odoo/addons/base/models/ir_sequence.py", line 191, in _next_do
number_next = _update_nogap(self, self.number_increment)
File "/opt/odoo13/odoo/odoo/addons/base/models/ir_sequence.py", line 52, in _update_nogap
self._cr.execute("SELECT number_next FROM %s WHERE id=%s FOR UPDATE NOWAIT" % (self._table, self.id))
File "/opt/odoo13/odoo/odoo/sql_db.py", line 164, in wrapper
return f(self, *args, **kwargs)
File "/opt/odoo13/odoo/odoo/sql_db.py", line 241, in execute
res = self._obj.execute(query, params)
psycopg2.errors.UndefinedFunction: operator does not exist: integer = boolean
LINE 1: SELECT number_next FROM ir_sequence WHERE id=False FOR UPDAT...
^
HINT: No operator matches the given name and argument type(s). You might need to add explicit type casts.
please help to explain what really happened and if possible a solution to solve it,
Thank you for your help
It appears whatever bit of code is trying to access a sequence cannot be found.
As you can see "WHERE id = False", False is usually returned in python when something cannot be found.
These modules, are they standard Odoo or 3rd party?
Thanks,
it is odoo standard module, purchase module, but I have changed the prefix in the sequence,at technical menu in the settings, does that have any effect?