Whenever I try to upgrade the invoicing module, or inventory module, I get this wierd error because I did not make any changes in the module still I am getting this error Invalid input syntax for text integer 'pink'
Traceback (most recent call last):
File "/usr/lib/python3/dist-packages/odoo/http.py", line 1583, in _serve_db
return service_model.retrying(self._serve_ir_http, self.env)
File "/usr/lib/python3/dist-packages/odoo/service/model.py", line 134, in retrying
result = func()
File "/usr/lib/python3/dist-packages/odoo/http.py", line 1610, in _serve_ir_http
response = self.dispatcher.dispatch(rule.endpoint, args)
File "/usr/lib/python3/dist-packages/odoo/http.py", line 1807, in dispatch
result = self.request.registry['ir.http']._dispatch(endpoint)
File "/usr/lib/python3/dist-packages/odoo/addons/base/models/ir_http.py", line 154, in _dispatch
result = endpoint(**request.params)
File "/usr/lib/python3/dist-packages/odoo/http.py", line 696, in route_wrapper
result = endpoint(self, *args, **params_ok)
File "/usr/lib/python3/dist-packages/odoo/addons/web/controllers/dataset.py", line 46, in call_button
action = self._call_kw(model, method, args, kwargs)
File "/usr/lib/python3/dist-packages/odoo/addons/web/controllers/dataset.py", line 33, in _call_kw
return call_kw(request.env[model], method, args, kwargs)
File "/usr/lib/python3/dist-packages/odoo/api.py", line 461, in call_kw
result = _call_kw_multi(method, model, args, kwargs)
File "/usr/lib/python3/dist-packages/odoo/api.py", line 448, in _call_kw_multi
result = method(recs, *args, **kwargs)
File "", line 2, in button_immediate_upgrade
File "/usr/lib/python3/dist-packages/odoo/addons/base/models/ir_module.py", line 76, in check_and_log
return method(self, *args, **kwargs)
File "/usr/lib/python3/dist-packages/odoo/addons/base/models/ir_module.py", line 678, in button_immediate_upgrade
return self._button_immediate_function(type(self).button_upgrade)
File "/usr/lib/python3/dist-packages/odoo/addons/base/models/ir_module.py", line 615, in _button_immediate_function
registry = modules.registry.Registry.new(self._cr.dbname, update_module=True)
File "", line 2, in new
File "/usr/lib/python3/dist-packages/odoo/tools/func.py", line 87, in locked
return func(inst, *args, **kwargs)
File "/usr/lib/python3/dist-packages/odoo/modules/registry.py", line 90, in new
odoo.modules.load_modules(registry, force_demo, status, update_module)
File "/usr/lib/python3/dist-packages/odoo/modules/loading.py", line 483, in load_modules
processed_modules += load_marked_modules(cr, graph,
File "/usr/lib/python3/dist-packages/odoo/modules/loading.py", line 371, in load_marked_modules
loaded, processed = load_module_graph(
File "/usr/lib/python3/dist-packages/odoo/modules/loading.py", line 207, in load_module_graph
registry.init_models(cr, model_names, {'module': package.name}, new_install)
File "/usr/lib/python3/dist-packages/odoo/modules/registry.py", line 526, in init_models
model._auto_init()
File "/usr/lib/python3/dist-packages/odoo/models.py", line 2574, in _auto_init
new = field.update_db(self, columns)
File "/usr/lib/python3/dist-packages/odoo/fields.py", line 1006, in update_db
self.update_db_column(model, column)
File "/usr/lib/python3/dist-packages/odoo/fields.py", line 1042, in update_db_column
self._convert_db_column(model, column)
File "/usr/lib/python3/dist-packages/odoo/fields.py", line 1046, in _convert_db_column
sql.convert_column(model._cr, model._table, self.name, self.column_type[1])
File "/usr/lib/python3/dist-packages/odoo/tools/sql.py", line 128, in convert_column
_convert_column(cr, tablename, columnname, columntype, using)
File "/usr/lib/python3/dist-packages/odoo/tools/sql.py", line 147, in _convert_column
cr.execute(query, log_exceptions=False)
File "/usr/lib/python3/dist-packages/odoo/sql_db.py", line 313, in execute
res = self._obj.execute(query, params)
psycopg2.errors.InvalidTextRepresentation: invalid input syntax for type integer: "pink"
The above server error caused the following client error:
RPC_ERROR: Odoo Server Error
at makeErrorFromResponse (http://146.190.74.51:8069/web/assets/7984-929c687/web.assets_backend.min.js:977:163)
at XMLHttpRequest. (http://146.190.74.51:8069/web/assets/7984-929c687/web.assets_backend.min.js:985:13)