Skip to Content
This question has been flagged
1 Reply
2458 Views
Avatar
filouzito

hi,

I nedd to migration/update from one old openerp 6.1 to odoo 11 on debian stretch.

i have install oddo package change the user run odoo to a same user role of my old database.

 when i run  the update command : (fh is my user/role , fh_dons is my db

sudo -u fh /usr/bin/odoo -u all -d fh_dons 

I have this result:

2017-11-15 09:19:07,278 189754 INFO ? odoo: Odoo version 11.0-20171114 2017-11-15 09:19:07,280 189754 INFO ? odoo: addons paths: ['/opt/fh/.local/share/Odoo/addons/11.0', '/usr/lib/python3/dist-packages/odoo/addons']

2017-11-15 09:19:07,281 189754 INFO ? odoo: database: default@default:default 2017-11-15 09:19:07,314 189754 INFO ? odoo.service.server: HTTP service (werkzeug) running on 0.0.0.0:8069 2017-11-15 09:19:07,332 189754 INFO fh_dons odoo.modules.loading: loading 1 modules...

2017-11-15 09:19:07,534 189754 INFO fh_dons odoo.addons.base.ir.ir_actions_report: Will use the Wkhtmltopdf binary at /usr/bin/wkhtmltopdf 2017-11-15 09:19:08,053 189754 INFO fh_dons odoo.modules.registry: module base: creating or updating database tables 2017-11-15 09:19:09,144 189754 INFO fh_dons odoo.models: Computing parent left and right for table ir_ui_menu...

2017-11-15 09:19:09,510 189754 ERROR fh_dons odoo.modules.registry: Failed to load registry Traceback (most recent call last):

  File "/usr/lib/python3/dist-packages/odoo/modules/registry.py", line 84, in new

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

  File "/usr/lib/python3/dist-packages/odoo/modules/loading.py", line 284, in load_modules

    loaded_modules, processed_modules = load_module_graph(cr, graph, status, perform_checks=update_module, report=report)

  File "/usr/lib/python3/dist-packages/odoo/modules/loading.py", line 135, in load_module_graph

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

  File "/usr/lib/python3/dist-packages/odoo/modules/registry.py", line 302, in init_models

    model._auto_init()

  File "/usr/lib/python3/dist-packages/odoo/models.py", line 2136, in _auto_init

    new = field.update_db(self, columns)

  File "/usr/lib/python3/dist-packages/odoo/fields.py", line 852, in update_db

    self.update_db_column(model, column)

  File "/usr/lib/python3/dist-packages/odoo/fields.py", line 1387, in update_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 92, in convert_column

    log_exceptions=False)

  File "/usr/lib/python3/dist-packages/odoo/sql_db.py", line 155, in wrapper

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

  File "/usr/lib/python3/dist-packages/odoo/sql_db.py", line 232, in execute

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

psycopg2.ProgrammingError: ERREUR: ne peut pas modifier la colonne héritée « usage »


Any solution??


thx in advance



Avatar
Discard
Avatar
Yenthe Van Ginneken (Mainframe Monkey)
Best Answer

Hi filouzito,

I think you might have misunderstood the upgrading of Odoo. It is not as simple as installing a new Odoo version and then changing the database to the other user (which is linked to your new Odoo instance).
When you want to migrate an Odoo instance you will need to do the following things:

  • Migrate the custom developent, if there is any, from the old API to the new API

  • Install a new Odoo 11

  • Migrate your database from V6.1 to V11.

For upgrading the database itself you will have two options. You can use the open source scripts from OpenUpgrade (see https://github.com/OCA/OpenUpgrade) or you can use the official upgrade services from Odoo (see https://upgrade.odoo.com/database/upload).
Since your Odoo is very old Odoo won't even update your database from V6.1 to V11 as Odoo 6.1, 7.0 and 8.0 are end of life. You'll most likely have to pay an extra fee in order to get your database upgraded.
I hope this clarifies enough for you.


About the error itself: could you please post the commands you ran into your question? I believe you've done something wrong there.

Regards,
Yenthe

Avatar
Discard