Skip to Content
Menu
This question has been flagged
1 Reply
1604 Views

2024-06-29 20:03:11,447 75 ERROR  odoo.sql_db: bad query: 

        INSERT INTO "ir_model_fields" ("model", "name", "model_id", "field_description", "help", "ttype", "state", "relation", "index", "store", "copied", "on_delete", "related", "readonly", "required", "selectable", "size", "translate", "relation_field", "relation_table", "column1", "column2", "tracking") VALUES ('hr.contract.renew', 'sequence', 1077, '#', NULL, 'char', 'base', NULL, false, true, true, NULL, NULL, false, false, true, NULL, false, NULL, NULL, NULL, NULL, 'onchange'), ('hr.contract.renew', 'date_start', 1077, 'Start Date', NULL, 'date', 'base', NULL, false, true, true, NULL, NULL, false, false, true, NULL, false, NULL, NULL, NULL, NULL, 'onchange'), ('hr.contract.renew', 'date_end', 1077, 'End Date', NULL, 'date', 'base', NULL, false, true, true, NULL, NULL, false, false, true, NULL, false, NULL, NULL, NULL, NULL, 'onchange'), ('hr.contract.renew', 'date_renew', 1077, 'Renew Date', NULL, 'date', 'base', NULL, false, true, true, NULL, NULL, false, false, true, NULL, false, NULL, NULL, NULL, NULL, 'onchange'), ('hr.contract.renew', 'contract_period', 1077, 'Contract Period', NULL, 'char', 'base', NULL, false, true, true, NULL, NULL, false, false, true, NULL, false, NULL, NULL, NULL, NULL, 'onchange'), ('hr.contract', 'renew_date', 809, 'Renew Date', NULL, 'date', 'base', NULL, false, true, true, NULL, NULL, false, false, true, NULL, false, NULL, NULL, NULL, NULL, 'onchange'), ('hr.contract', 'renew_date_ids', 809, 'Renew Date', NULL, 'one2many', 'base', 'hr.contract.renew', false, true, false, NULL, NULL, false, false, true, NULL, false, 'contract_id', NULL, NULL, NULL, 'onchange'), ('hr.contract', 'contract_serial_number', 809, 'Contract Serial Number', NULL, 'char', 'base', NULL, true, true, false, NULL, NULL, true, true, true, NULL, false, NULL, NULL, NULL, NULL, 'onchange'), ('hr.contract', 'notice_period', 809, 'Notice Period', NULL, 'integer', 'base', NULL, false, true, true, NULL, NULL, false, false, true, NULL, false, NULL, NULL, NULL, NULL, 'onchange')

        ON CONFLICT (model, name) DO UPDATE SET ("model", "name", "model_id", "field_description", "help", "ttype", "state", "relation", "index", "store", "copied", "on_delete", "related", "readonly", "required", "selectable", "size", "translate", "relation_field", "relation_table", "column1", "column2", "tracking") = (EXCLUDED."model", EXCLUDED."name", EXCLUDED."model_id", EXCLUDED."field_description", EXCLUDED."help", EXCLUDED."ttype", EXCLUDED."state", EXCLUDED."relation", EXCLUDED."index", EXCLUDED."store", EXCLUDED."copied", EXCLUDED."on_delete", EXCLUDED."related", EXCLUDED."readonly", EXCLUDED."required", EXCLUDED."selectable", EXCLUDED."size", EXCLUDED."translate", EXCLUDED."relation_field", EXCLUDED."relation_table", EXCLUDED."column1", EXCLUDED."column2", EXCLUDED."tracking")

        RETURNING id

    

ERROR: invalid input syntax for type integer: "onchange"

LINE 2: ...false, true, NULL, false, NULL, NULL, NULL, NULL, 'onchange'...

                                                             ^


2024-06-29 20:03:11,454 75 WARNING a odoo.modules.loading: Transient module states were reset 

2024-06-29 20:03:11,456 75 ERROR -4950215 odoo.modules.registry: Failed to load registry 

Traceback (most recent call last):

  File "/home/odoo/src/odoo/odoo/modules/registry.py", line 87, in new

    odoo.modules.load_modules(registry, force_demo, status, update_module)

  File "/home/odoo/src/odoo/odoo/modules/loading.py", line 470, in load_modules

    processed_modules += load_marked_modules(cr, graph,

  File "/home/odoo/src/odoo/odoo/modules/loading.py", line 363, in load_marked_modules

    loaded, processed = load_module_graph(

  File "/home/odoo/src/odoo/odoo/modules/loading.py", line 199, in load_module_graph

    registry.init_models(cr, model_names, {'module': package.name}, new_install)

  File "/home/odoo/src/odoo/odoo/modules/registry.py", line 432, in init_models

    env['ir.model.fields']._reflect_fields(model_names)

  File "/home/odoo/src/odoo/odoo/addons/base/models/ir_model.py", line 1091, in _reflect_fields

    ids = upsert(cr, self._table, cols, rows, ['model', 'name'])

  File "/home/odoo/src/odoo/odoo/addons/base/models/ir_model.py", line 124, in upsert

    cr.execute(query, rows)

  File "", line 2, in execute

  File "/home/odoo/src/odoo/odoo/sql_db.py", line 90, in check

    return f(self, *args, **kwargs)

  File "/home/odoo/src/odoo/odoo/sql_db.py", line 311, in execute

    res = self._obj.execute(query, params)

psycopg2.errors.InvalidTextRepresentation: invalid input syntax for type integer: "onchange"

LINE 2: ...false, true, NULL, false, NULL, NULL, NULL, NULL, 'onchange'...

                                                             ^


2024-06-29 20:03:11,458 75 ERROR -4950215 odoo.http: Exception during JSON request handling. 

Traceback (most recent call last):

  File "/home/odoo/src/odoo/odoo/addons/base/models/ir_http.py", line 242, in _dispatch

    result = request.dispatch()

  File "/home/odoo/src/odoo/odoo/http.py", line 702, in dispatch

    result = self._call_function(**self.params)

  File "/home/odoo/src/odoo/odoo/http.py", line 368, in _call_function

    return checked_call(self.db, *args, **kwargs)

  File "/home/odoo/src/odoo/odoo/service/model.py", line 94, in wrapper

    return f(dbname, *args, **kwargs)

  File "/home/odoo/src/odoo/odoo/http.py", line 357, in checked_call

    result = self.endpoint(*a, **kw)

  File "/home/odoo/src/odoo/odoo/http.py", line 925, in _call_

    return self.method(*args, **kw)

  File "/home/odoo/src/odoo/odoo/http.py", line 546, in response_wrap

    response = f(*args, **kw)

  File "/home/odoo/src/odoo/addons/web/controllers/main.py", line 1328, in call_button

    action = self._call_kw(model, method, args, kwargs)

File "/home/odoo/src/odoo/addons/web/controllers/main.py", line 1316, in _call_kw

    return call_kw(request.env[model], method, args, kwargs)

  File "/home/odoo/src/odoo/odoo/api.py", line 471, in call_kw

    result = _call_kw_multi(method, model, args, kwargs)

  File "/home/odoo/src/odoo/odoo/api.py", line 456, in _call_kw_multi

    result = method(recs, *args, **kwargs)

  File "", line 2, in button_immediate_upgrade

  File "/home/odoo/src/odoo/odoo/addons/base/models/ir_module.py", line 72, in check_and_log

    return method(self, *args, **kwargs)

  File "/home/odoo/src/odoo/odoo/addons/base/models/ir_module.py", line 650, in button_immediate_upgrade

    return self._button_immediate_function(self.env.registry[self._name].button_upgrade)

  File "/home/odoo/src/odoo/odoo/addons/base/models/ir_module.py", line 587, in _button_immediate_function

    registry = modules.registry.Registry.new(self._cr.dbname, update_module=True)

  File "/home/odoo/src/odoo/odoo/modules/registry.py", line 87, in new

    odoo.modules.load_modules(registry, force_demo, status, update_module)

  File "/home/odoo/src/odoo/odoo/modules/loading.py", line 470, in load_modules

    processed_modules += load_marked_modules(cr, graph,

  File "/home/odoo/src/odoo/odoo/modules/loading.py", line 363, in load_marked_modules

    loaded, processed = load_module_graph(

  File "/home/odoo/src/odoo/odoo/modules/loading.py", line 199, in load_module_graph

    registry.init_models(cr, model_names, {'module': package.name}, new_install)

  File "/home/odoo/src/odoo/odoo/modules/registry.py", line 432, in init_models

    env['ir.model.fields']._reflect_fields(model_names)

  File "/home/odoo/src/odoo/odoo/addons/base/models/ir_model.py", line 1091, in _reflect_fields

    ids = upsert(cr, self._table, cols, rows, ['model', 'name'])

  File "/home/odoo/src/odoo/odoo/addons/base/models/ir_model.py", line 124, in upsert

    cr.execute(query, rows)

  File "", line 2, in execute

  File "/home/odoo/src/odoo/odoo/sql_db.py", line 90, in check

    return f(self, *args, **kwargs)

  File "/home/odoo/src/odoo/odoo/sql_db.py", line 311, in execute

    res = self._obj.execute(query, params)

Exception


The above exception was the direct cause of the following exception:


Traceback (most recent call last):

  File "/home/odoo/src/odoo/odoo/http.py", line 658, in _handle_exception

    return super(JsonRequest, self)._handle_exception(exception)

  File "/home/odoo/src/odoo/odoo/http.py", line 301, in _handle_exception

    raise exception.with_traceback(None) from new_cause

psycopg2.errors.InvalidTextRepresentation: invalid input syntax for type integer: "onchange"

LINE 2: ...false, true, NULL, false, NULL, NULL, NULL, NULL, 'onchange'..

Avatar
Discard
Best Answer

Hi,
Actually there is no much information regarding the issue in the shared traceback. If you have custom codes in the database, ensure that it is not causing any issues.

If you are upgrading inventory module, monitor the log and see at what point the exception is coming.

Thanks

Avatar
Discard
Related Posts Replies Views Activity
2
Oct 25
2575
1
Sep 25
2569
3
Jul 25
4013
1
May 25
2121
4
May 25
3457