This question has been flagged

I have Odoo Community source version installed, which shows an error when clicking on sequence. The error is listed below.

Initially I did not have such errors and had succefully set the sequence for Purchase Orders. Now I need to change the Sequence for Sales Order but I am unable to do it. 

When I accessed the database thru PGAdmin 4 I was able to change the Prefix and next increment number from the ir_sequence table. It changed the prefix but I am not able to change the next increment number.

I do not want to reinstall the Odoo and redo all the changes in the database. Please let me know whether the next increment number in the sequence(sales order) can be changed using PGadmin

https://github.com/odoo/odoo/issues/20269   This link also shows up such message received elsewhere who is using postgresl 10. I too have upgraded the database to Postgresql 10. Hope it is not causing such issue. Is it possible to downgrade if postgresql version is the issue.


Traceback (most recent call last):
  File "/odoon/odoon-server/odoo/http.py", line 640, in _handle_exception
    return super(JsonRequest, self)._handle_exception(exception)
  File "/odoon/odoon-server/odoo/http.py", line 677, in dispatch
    result = self._call_function(**self.params)
  File "/odoon/odoon-server/odoo/http.py", line 333, in _call_function
    return checked_call(self.db, *args, **kwargs)
  File "/odoon/odoon-server/odoo/service/model.py", line 101, in wrapper
    return f(dbname, *args, **kwargs)
  File "/odoon/odoon-server/odoo/http.py", line 326, in checked_call
    result = self.endpoint(*a, **kw)
  File "/odoon/odoon-server/odoo/http.py", line 935, in __call__
    return self.method(*args, **kw)
  File "/odoon/odoon-server/odoo/http.py", line 506, in response_wrap
    response = f(*args, **kw)
  File "/odoon/odoon-server/addons/web/controllers/main.py", line 827, in search_read
    return self.do_search_read(model, fields, offset, limit, domain, sort)
  File "/odoon/odoon-server/addons/web/controllers/main.py", line 849, in do_search_read
    offset=offset or 0, limit=limit or False, order=sort or False)
  File "/odoon/odoon-server/odoo/models.py", line 4695, in search_read
    result = records.read(fields)
  File "/odoon/odoon-server/odoo/models.py", line 3021, in read
    values[name] = field.convert_to_read(record[name], record, use_name_get)
  File "/odoon/odoon-server/odoo/models.py", line 5210, in __getitem__
    return self._fields[key].__get__(self, type(self))
  File "/odoon/odoon-server/odoo/fields.py", line 870, in __get__
    self.determine_value(record)
  File "/odoon/odoon-server/odoo/fields.py", line 982, in determine_value
    self.compute_value(recs)
  File "/odoon/odoon-server/odoo/fields.py", line 936, in compute_value
    self._compute_value(records)
  File "/odoon/odoon-server/odoo/fields.py", line 927, in _compute_value
    getattr(records, self.compute)()
  File "/odoon/odoon-server/odoo/addons/base/ir/ir_sequence.py", line 79, in _get_number_next_actual
    self._cr.execute(query)
  File "/odoon/odoon-server/odoo/sql_db.py", line 154, in wrapper
    return f(self, *args, **kwargs)
  File "/odoon/odoon-server/odoo/sql_db.py", line 231, in execute
    res = self._obj.execute(query, params)
ProgrammingError: column "increment_by" does not exist
LINE 1: SELECT last_value, increment_by, is_called FROM ir_sequence_...
                           ^


Avatar
Discard
Author

Finally after lot of work around and searches I was able to solve the set my Sales quotation sequence correctly by changing the current value of ir_sequence_042.

Still the above error exits but it is now not affecting my work.