Passa al contenuto
Odoo Menu
  • Accedi
  • Provalo gratis
  • App
    Finanze
    • Contabilità
    • Fatturazione
    • Note spese
    • Fogli di calcolo (BI)
    • Documenti
    • Firma
    Vendite
    • CRM
    • Vendite
    • Punto vendita Negozio
    • Punto vendita Ristorante
    • Abbonamenti
    • Noleggi
    Siti web
    • Configuratore sito web
    • E-commerce
    • Blog
    • Forum
    • Live chat
    • E-learning
    Supply chain
    • Magazzino
    • Produzione
    • PLM
    • Acquisti
    • Manutenzione
    • Qualità
    Risorse umane
    • Dipendenti
    • Assunzioni
    • Ferie
    • Valutazioni
    • Referral dipendenti
    • Parco veicoli
    Marketing
    • Social marketing
    • E-mail marketing
    • SMS marketing
    • Eventi
    • Marketing automation
    • Sondaggi
    Servizi
    • Progetti
    • Fogli ore
    • Assistenza sul campo
    • Helpdesk
    • Pianificazione
    • Appuntamenti
    Produttività
    • Comunicazioni
    • Approvazioni
    • IoT
    • VoIP
    • Knowledge
    • WhatsApp
    App di terze parti Odoo Studio Piattaforma cloud Odoo
  • Settori
    Retail
    • Libreria
    • Negozio di abbigliamento
    • Negozio di arredamento
    • Alimentari
    • Ferramenta
    • Negozio di giocattoli
    Cibo e ospitalità
    • Bar e pub
    • Ristorante
    • Fast food
    • Pensione
    • Grossista di bevande
    • Hotel
    Agenzia immobiliare
    • Agenzia immobiliare
    • Studio di architettura
    • Edilizia
    • Gestione immobiliare
    • Impresa di giardinaggio
    • Associazione di proprietari immobiliari
    Consulenza
    • Società di contabilità
    • Partner Odoo
    • Agenzia di marketing
    • Studio legale
    • Selezione del personale
    • Audit e certificazione
    Produzione
    • Tessile
    • Metallo
    • Arredamenti
    • Alimentare
    • Birrificio
    • Ditta di regalistica aziendale
    Benessere e sport
    • Club sportivo
    • Negozio di ottica
    • Centro fitness
    • Centro benessere
    • Farmacia
    • Parrucchiere
    Commercio
    • Tuttofare
    • Hardware e assistenza IT
    • Ditta di installazione di pannelli solari
    • Calzolaio
    • Servizi di pulizia
    • Servizi di climatizzazione
    Altro
    • Organizzazione non profit
    • Ente per la tutela ambientale
    • Agenzia di cartellonistica pubblicitaria
    • Studio fotografico
    • Punto noleggio di biciclette
    • Rivenditore di software
    Carica tutti i settori
  • Community
    Apprendimento
    • Tutorial
    • Documentazione
    • Certificazioni 
    • Formazione
    • Blog
    • Podcast
    Potenzia la tua formazione
    • Programma educativo
    • Scale Up! Business Game
    • Visita Odoo
    Ottieni il software
    • Scarica
    • Versioni a confronto
    • Note di versione
    Collabora
    • Github
    • Forum
    • Eventi
    • Traduzioni
    • Diventa nostro partner
    • Servizi per partner
    • Registra la tua società di contabilità
    Ottieni servizi
    • Trova un partner
    • Trova un contabile
    • Incontra un esperto
    • Servizi di implementazione
    • Testimonianze dei clienti
    • Supporto
    • Aggiornamenti
    GitHub Youtube Twitter Linkedin Instagram Facebook Spotify
    +1 (650) 691-3277
    Richiedi una demo
  • Prezzi
  • Aiuto

Odoo is the world's easiest all-in-one management software.
It includes hundreds of business apps:

  • CRM
  • e-Commerce
  • Contabilità
  • Magazzino
  • PoS
  • Progetti
  • MRP
All apps
È necessario essere registrati per interagire con la community.
Tutti gli articoli Persone Badge
Etichette (Mostra tutto)
odoo accounting v14 pos v15
Sul forum
È necessario essere registrati per interagire con la community.
Tutti gli articoli Persone Badge
Etichette (Mostra tutto)
odoo accounting v14 pos v15
Sul forum
Assistenza

How can I migrate a database from Version 7 to Version8/Trunk with openupgrade?

Iscriviti

Ricevi una notifica quando c'è un'attività per questo post

La domanda è stata contrassegnata
v8migrationv7v7.0openupgrade
2 Risposte
14188 Visualizzazioni
Avatar
om

Hi all,

Hope this is the correct place to ask this (Tried the openupgarde launchpad thing but had no luck). As per the title, I am trying to migrate my openerp 7 database to version 8 as I really want to test the website builder. I set up a seperate (non-production) ubuntu server running openerp 7 and imported my existing database without any issues. I then tried 2 things (admittedly I was way out of my depth) :

1) I followed this guide on launchpad - https://answers.launchpad.net/openupgrade-server/+question/209721 without much success. I got to the stage where the migration actually ran but I suspect the details were outdated and I simply don't know enough to rectify this.

2) I did a git clone for openupgarde server and tried the migration script I however still get an error about bzrlib not found (or something in that line)

Could anybody kindly assist a noob with the step-by-step guide for the best route to take?

Thanks.

1
Avatar
Abbandona
gunnar

can it be that (v8 still under heavy construction I think) it is still a little too early for a migration? Maybe openugrade needs to look how v8 actually works and then they will have a huge workload on their plate ... and then, it's worth a shot? ... I am totally out of my league here myself and this is just a wild guess though

Avatar
eLBati
Risposta migliore

Hello,

try with the automated migration script

0
Avatar
Abbandona
om
Autore

Hi thanks for the response. I have tried various ways with openupgrade. When using the script and specifying "--run-migrations=8.0" it doesn't seem to recognise "8.0" However doing "7.0" seems to initiate without problems. Does openupgrade support migration to 8? or is this still pending. Thanks again.

eLBati

8.0 should be supported: https://github.com/OpenUpgrade/OpenUpgrade/blob/8.0/scripts/migrate.py#L63 but never tried for now

Yevgen Lysenko

eLBati, can you plase shed a bit more light on this? When i run the migrate.py, it stops with an error: copying database virus to virus_migrated... Traceback (most recent call last): File "migrate.py", line 303, in db_name = copy_database(conn_parms) File "migrate.py", line 26, in copy_database conn = psycopg2.connect(**conn_parms) File "/usr/lib/python2.7/dist-packages/psycopg2/__init__.py", line 179, in connect connection_factory=connection_factory, async=async) psycopg2.OperationalError: FATAL: Peer authentication failed for user "openerp"

eLBati

You have a configuration problem with the connection to postgresql

OdooBot
Thanks for your response!

But my OpenERP 7 installation works perfectly and the installation was done by its intsallation script which i haven't touched.

What can i do to fix this?

2014-09-24 15:04 GMT+03:00 eLBati <elbaddy-gmail-com@mail.odoo.com>:

You have a configuration problem with the connection to postgresql

--
eLBati
Sent by OpenERP S.A. using Odoo about Forum Post False

Avatar
Yevgen Lysenko
Risposta migliore

eLBati, can you plase shed a bit more light on this?

When i run the migrate.py, it stops with an error:

copying database virus to virus_migrated...
Traceback (most recent call last):
  File "migrate.py", line 303, in <module>
    db_name = copy_database(conn_parms)
  File "migrate.py", line 26, in copy_database
    conn = psycopg2.connect(**conn_parms)
  File "/usr/lib/python2.7/dist-packages/psycopg2/__init__.py", line 179, in connect
    connection_factory=connection_factory, async=async)
psycopg2.OperationalError: FATAL:  Peer authentication failed for user "openerp"

0
Avatar
Abbandona
George Mengelberg

Try updating your pg_hba.conf 'auth_method' for the migration and then revert. http://www.postgresql.org/docs/9.3/static/auth-pg-hba-conf.html

OdooBot
It worked! Many thanks!

2014-10-01 13:42 GMT+03:00 George Mengelberg <george-mengelberg-gmail-com@mail.odoo.com>:

Try updating your pg_hba.conf 'auth_method' for the migration and then revert. http://www.postgresql.org/docs/9.3/static/auth-pg-hba-conf.html

--
George Mengelberg
Sent by OpenERP S.A. using Odoo about Forum Post False

OdooBot
However, there's a further error during the upgrade, maybe you will be so kind to help me out on this as well?

/usr/lib/python2.7/dist-packages/babel/__init__.py:33: UserWarning: Module openerp was already imported from /var/tmp/openupgrade/8.0/server/openerp/__init__.py, but /usr/lib/pymodules/python2.7 is being added to sys.path
  from pkg_resources import get_distribution, ResolutionError
Traceback (most recent call last):
  File "/var/tmp/openupgrade/8.0/server/openerp-server", line 2, in <module>
    import openerp
  File "/var/tmp/openupgrade/8.0/server/openerp/__init__.py", line 72, in <module>
    import modules
  File "/var/tmp/openupgrade/8.0/server/openerp/modules/__init__.py", line 27, in <module>
    from . import db, graph, loading, migration, module, registry
  File "/var/tmp/openupgrade/8.0/server/openerp/modules/graph.py", line 32, in <module>
    import openerp.osv as osv
  File "/var/tmp/openupgrade/8.0/server/openerp/osv/__init__.py", line 22, in <module>
    import osv
  File "/var/tmp/openupgrade/8.0/server/openerp/osv/osv.py", line 23, in <module>
    from .orm import Model, TransientModel, AbstractModel
  File "/var/tmp/openupgrade/8.0/server/openerp/osv/orm.py", line 5, in <module>
    from ..models import (
  File "/var/tmp/openupgrade/8.0/server/openerp/models.py", line 62, in <module>
    from . import api
  File "/var/tmp/openupgrade/8.0/server/openerp/api.py", line 71, in <module>
    from openerp.tools import frozendict
  File "/var/tmp/openupgrade/8.0/server/openerp/tools/__init__.py", line 26, in <module>
    from misc import *
  File "/var/tmp/openupgrade/8.0/server/openerp/tools/misc.py", line 54, in <module>
    from cache import *
  File "/var/tmp/openupgrade/8.0/server/openerp/tools/cache.py", line 24, in <module>
    from decorator import decorator
ImportError: No module named decorator


2014-10-02 16:02 GMT+03:00 Yevgen 'Chief_MC' Lysenko <chiefmc.ua@gmail.com>:
It worked! Many thanks!

2014-10-01 13:42 GMT+03:00 George Mengelberg <george-mengelberg-gmail-com@mail.odoo.com>:

Try updating your pg_hba.conf 'auth_method' for the migration and then revert. http://www.postgresql.org/docs/9.3/static/auth-pg-hba-conf.html

--
George Mengelberg
Sent by OpenERP S.A. using Odoo about Forum Post False


OdooBot
I've fixed the problem, installing the needed Python modules and been able to launch the migration process, but it stubmled upon an error:
2014-10-03 12:23:42,099 1646 INFO ? openerp: OpenERP version 8.0
2014-10-03 12:23:42,100 1646 INFO ? openerp: addons paths: ['/home/chief_mc/.local/share/Odoo/addons/8.0', u'/var/tmp/openupgrade/8.0/server/openerp/addons', u'/var/tmp/openupgrade/8.0/addons']
2014-10-03 12:23:42,100 1646 INFO ? openerp: database hostname: localhost
2014-10-03 12:23:42,100 1646 INFO ? openerp: database port: 5432
2014-10-03 12:23:42,100 1646 INFO ? openerp: database user: openerp
2014-10-03 12:23:42,650 1646 INFO virus_migrated openerp.modules.loading: loading 1 modules...
2014-10-03 12:23:42,654 1646 INFO virus_migrated openerp.modules.migration: module base: Running migration [>8.0.1.3] pre-migration
2014-10-03 12:23:42,655 1646 INFO virus_migrated openerp.modules.migration: module base: Running migration [>8.0.1.3] pre-migration
2014-10-03 12:23:42,923 1646 INFO virus_migrated OpenUpgrade: base: pre-migration script called with version 7.0.1.3
2014-10-03 12:23:42,929 1646 ERROR virus_migrated OpenUpgrade: Invalid value 'tree_account_reconciliation' in the table 'ir_ui_view' for the field 'type'. (1 rows).
2014-10-03 12:23:43,310 1646 INFO virus_migrated openerp.modules.module: module base: creating or updating database tables
2014-10-03 12:23:47,481 1646 ERROR virus_migrated openerp.sql_db: bad query: ALTER TABLE "ir_attachment" ALTER COLUMN "datas_fname" TYPE VARCHAR
Traceback (most recent call last):
  File "/var/tmp/openupgrade/8.0/server/openerp/sql_db.py", line 234, in execute
    res = self._obj.execute(query, params)
NotSupportedError: cannot alter type of a column used by a view or rule
DETAIL:  rule _RETURN on view report_document_user depends on column "datas_fname"

2014-10-03 12:23:49,605 1646 INFO virus_migrated openerp.models: storing computed values of fields.function 'crud_model_name'
2014-10-03 12:23:49,613 1646 INFO virus_migrated openerp.models: storing computed values of fields.function 'wkf_model_name'
2014-10-03 12:23:49,614 1646 INFO virus_migrated openerp.models: storing computed values of fields.function 'commercial_partner_id'
2014-10-03 12:23:49,858 1646 INFO virus_migrated openerp.models: storing computed values of fields.function 'email'
2014-10-03 12:23:49,869 1646 INFO virus_migrated openerp.models: storing computed values of fields.function 'phone'
2014-10-03 12:23:50,056 1646 INFO virus_migrated openerp.modules.loading: loading base/base_data.xml
2014-10-03 12:23:50,357 1646 ERROR virus_migrated openerp.addons.base.ir.ir_ui_view: Field `menu_id` does not exist

Error context:
View `res.users.groups`
[view_id: 159, xml_id: base.user_groups_view, model: res.users, parent_id: 156]
2014-10-03 12:23:50,400 1646 CRITICAL virus_migrated openerp.service.server: Failed to initialize database `virus_migrated`.
Traceback (most recent call last):
  File "/var/tmp/openupgrade/8.0/server/openerp/service/server.py", line 901, in preload_registries
    registry = RegistryManager.new(dbname, update_module=update_module)
  File "/var/tmp/openupgrade/8.0/server/openerp/modules/registry.py", line 324, in new
    openerp.modules.load_modules(registry._db, force_demo, status, update_module)
  File "/var/tmp/openupgrade/8.0/server/openerp/modules/loading.py", line 337, in load_modules
    loaded_modules, processed_modules = load_module_graph(cr, graph, status, perform_checks=update_module, report=report, upg_registry=upg_registry)
  File "/var/tmp/openupgrade/8.0/server/openerp/modules/loading.py", line 205, in load_module_graph
    _load_data(cr, module_name, idref, mode, kind='data')
  File "/var/tmp/openupgrade/8.0/server/openerp/modules/loading.py", line 120, in _load_data
    tools.convert_file(cr, module_name, filename, idref, mode, noupdate, kind, report)
  File "/var/tmp/openupgrade/8.0/server/openerp/tools/convert.py", line 902, in convert_file
    convert_xml_import(cr, module, fp, idref, mode, noupdate, report)
  File "/var/tmp/openupgrade/8.0/server/openerp/tools/convert.py", line 988, in convert_xml_import
    obj.parse(doc.getroot(), mode=mode)
  File "/var/tmp/openupgrade/8.0/server/openerp/tools/convert.py", line 854, in parse
    self._tags[rec.tag](self.cr, rec, n, mode=mode)
  File "/var/tmp/openupgrade/8.0/server/openerp/tools/convert.py", line 768, in _tag_record
    id = self.pool['ir.model.data']._update(cr, self.uid, rec_model, self.module, res, rec_id or False, not self.isnoupdate(data_node), noupdate=self.isnoupdate(data_node), mode=self.mode, context=rec_context )
  File "/var/tmp/openupgrade/8.0/server/openerp/api.py", line 237, in wrapper
    return old_api(self, *args, **kwargs)
  File "/var/tmp/openupgrade/8.0/server/openerp/addons/base/ir/ir_model.py", line 1064, in _update
    res_id = model_obj.create(cr, uid, values, context=context)
  File "/var/tmp/openupgrade/8.0/server/openerp/api.py", line 237, in wrapper
    return old_api(self, *args, **kwargs)
  File "/var/tmp/openupgrade/8.0/server/openerp/addons/base/res/res_users.py", line 714, in create
    self.update_user_groups_view(cr, uid, context)
  File "/var/tmp/openupgrade/8.0/server/openerp/api.py", line 237, in wrapper
    return old_api(self, *args, **kwargs)
  File "/var/tmp/openupgrade/8.0/server/openerp/addons/base/res/res_users.py", line 755, in update_user_groups_view
    view.write({'arch': xml_content})
  File "/var/tmp/openupgrade/8.0/server/openerp/api.py", line 235, in wrapper
    return new_api(self, *args, **kwargs)
  File "/var/tmp/openupgrade/8.0/server/openerp/api.py", line 552, in new_api
    result = method(self._model, cr, uid, self.ids, *args, **kwargs)
  File "/var/tmp/openupgrade/8.0/server/openerp/addons/base/ir/ir_ui_view.py", line 282, in write
    context)
  File "/var/tmp/openupgrade/8.0/server/openerp/api.py", line 237, in wrapper
    return old_api(self, *args, **kwargs)
  File "/var/tmp/openupgrade/8.0/server/openerp/api.py", line 360, in old_api
    result = method(recs, *args, **kwargs)
  File "/var/tmp/openupgrade/8.0/server/openerp/models.py", line 3692, in write
    self._write(old_vals)
  File "/var/tmp/openupgrade/8.0/server/openerp/api.py", line 235, in wrapper
    return new_api(self, *args, **kwargs)
  File "/var/tmp/openupgrade/8.0/server/openerp/api.py", line 552, in new_api
    result = method(self._model, cr, uid, self.ids, *args, **kwargs)
  File "/var/tmp/openupgrade/8.0/server/openerp/models.py", line 3854, in _write
    recs._validate_fields(vals)
  File "/var/tmp/openupgrade/8.0/server/openerp/api.py", line 235, in wrapper
    return new_api(self, *args, **kwargs)
  File "/var/tmp/openupgrade/8.0/server/openerp/models.py", line 1297, in _validate_fields
    raise ValidationError('\n'.join(errors))
ParseError: "ValidateError
Field(s) `arch` failed against a constraint: Invalid view definition

Error details:
Field `menu_id` does not exist

Error context:
View `res.users.groups`
[view_id: 159, xml_id: base.user_groups_view, model: res.users, parent_id: 156]" while parsing /var/tmp/openupgrade/8.0/server/openerp/addons/base/base_data.xml:88, near
<record id="group_portal" model="res.groups">
            <field name="name">Portal</field>
            <field name="comment">Portal members have specific access rights (such as record rules and restricted menus).
                They usually do not belong to the usual OpenERP groups.</field>
        </record>
2014-10-03 12:23:50,486 1646 INFO virus_migrated openerp.service.server: Initiating shutdown
2014-10-03 12:23:50,487 1646 INFO virus_migrated openerp.service.server: Hit CTRL-C again or send a second signal to force the shutdown.

George Mengelberg

I would focus on what in the script is trying to convert the datatypes: 2014-10-03 12:23:47,481 1646 ERROR virus_migrated openerp.sql_db: bad query: ALTER TABLE "ir_attachment" ALTER COLUMN "datas_fname" TYPE VARCHAR Traceback (most recent call last): File "/var/tmp/openupgrade/8.0/server/openerp/sql_db.py", line 234, in execute res = self._obj.execute(query, params) NotSupportedError: cannot alter type of a column used by a view or rule DETAIL: rule _RETURN on view report_document_user depends on column "datas_fname"

OdooBot
Sorry for bothering, i'm not into Python at all, i'm an Objective C guy, but i think that the culprit is with an event of status 'CRITICAL', which was lower in the log, here the complete log:
2014-10-06 11:06:52,093 8968 INFO ? openerp: OpenERP version 8.0
2014-10-06 11:06:52,094 8968 INFO ? openerp: addons paths: ['/home/chief_mc/.local/share/Odoo/addons/8.0', u'/var/tmp/openupgrade/8.0/server/openerp/addons', u'/var/tmp/openupgrade/8.0/addons']
2014-10-06 11:06:52,094 8968 INFO ? openerp: database hostname: localhost
2014-10-06 11:06:52,094 8968 INFO ? openerp: database port: 5432
2014-10-06 11:06:52,095 8968 INFO ? openerp: database user: openerp
2014-10-06 11:06:52,612 8968 INFO virus_copy_migrated openerp.modules.loading: loading 1 modules...
2014-10-06 11:06:52,614 8968 INFO virus_copy_migrated openerp.modules.migration: module base: Running migration [>8.0.1.3] pre-migration
2014-10-06 11:06:52,615 8968 INFO virus_copy_migrated openerp.modules.migration: module base: Running migration [>8.0.1.3] pre-migration
2014-10-06 11:06:52,816 8968 INFO virus_copy_migrated OpenUpgrade: base: pre-migration script called with version 7.0.1.3
2014-10-06 11:06:53,218 8968 INFO virus_copy_migrated openerp.modules.module: module base: creating or updating database tables
2014-10-06 11:06:55,034 8968 ERROR virus_copy_migrated openerp.sql_db: bad query: ALTER TABLE "ir_attachment" ALTER COLUMN "datas_fname" TYPE VARCHAR
Traceback (most recent call last):
  File "/var/tmp/openupgrade/8.0/server/openerp/sql_db.py", line 234, in execute
    res = self._obj.execute(query, params)
NotSupportedError: cannot alter type of a column used by a view or rule
DETAIL:  rule _RETURN on view report_document_user depends on column "datas_fname"

2014-10-06 11:06:56,807 8968 INFO virus_copy_migrated openerp.models: storing computed values of fields.function 'crud_model_name'
2014-10-06 11:06:56,810 8968 INFO virus_copy_migrated openerp.models: storing computed values of fields.function 'wkf_model_name'
2014-10-06 11:06:56,811 8968 INFO virus_copy_migrated openerp.models: storing computed values of fields.function 'display_name'
2014-10-06 11:06:57,020 8968 INFO virus_copy_migrated openerp.models: storing computed values of fields.function 'commercial_partner_id'
2014-10-06 11:06:57,115 8968 INFO virus_copy_migrated openerp.models: storing computed values of fields.function 'email'
2014-10-06 11:06:57,124 8968 INFO virus_copy_migrated openerp.models: storing computed values of fields.function 'phone'
2014-10-06 11:06:57,290 8968 INFO virus_copy_migrated openerp.modules.loading: loading base/base_data.xml
2014-10-06 11:06:57,510 8968 ERROR virus_copy_migrated openerp.addons.base.ir.ir_ui_view: Field `menu_id` does not exist

Error context:
View `res.users.groups`
[view_id: 159, xml_id: base.user_groups_view, model: res.users, parent_id: 156]
2014-10-06 11:06:57,551 8968 CRITICAL virus_copy_migrated openerp.service.server: Failed to initialize database `virus_copy_migrated`.
Traceback (most recent call last):
  File "/var/tmp/openupgrade/8.0/server/openerp/service/server.py", line 901, in preload_registries
    registry = RegistryManager.new(dbname, update_module=update_module)
  File "/var/tmp/openupgrade/8.0/server/openerp/modules/registry.py", line 324, in new
    openerp.modules.load_modules(registry._db, force_demo, status, update_module)
  File "/var/tmp/openupgrade/8.0/server/openerp/modules/loading.py", line 337, in load_modules
    loaded_modules, processed_modules = load_module_graph(cr, graph, status, perform_checks=update_module, report=report, upg_registry=upg_registry)
  File "/var/tmp/openupgrade/8.0/server/openerp/modules/loading.py", line 205, in load_module_graph
    _load_data(cr, module_name, idref, mode, kind='data')
  File "/var/tmp/openupgrade/8.0/server/openerp/modules/loading.py", line 120, in _load_data
    tools.convert_file(cr, module_name, filename, idref, mode, noupdate, kind, report)
  File "/var/tmp/openupgrade/8.0/server/openerp/tools/convert.py", line 902, in convert_file
    convert_xml_import(cr, module, fp, idref, mode, noupdate, report)
  File "/var/tmp/openupgrade/8.0/server/openerp/tools/convert.py", line 988, in convert_xml_import
    obj.parse(doc.getroot(), mode=mode)
  File "/var/tmp/openupgrade/8.0/server/openerp/tools/convert.py", line 854, in parse
    self._tags[rec.tag](self.cr, rec, n, mode=mode)
  File "/var/tmp/openupgrade/8.0/server/openerp/tools/convert.py", line 768, in _tag_record
    id = self.pool['ir.model.data']._update(cr, self.uid, rec_model, self.module, res, rec_id or False, not self.isnoupdate(data_node), noupdate=self.isnoupdate(data_node), mode=self.mode, context=rec_context )
  File "/var/tmp/openupgrade/8.0/server/openerp/api.py", line 237, in wrapper
    return old_api(self, *args, **kwargs)
  File "/var/tmp/openupgrade/8.0/server/openerp/addons/base/ir/ir_model.py", line 1064, in _update
    res_id = model_obj.create(cr, uid, values, context=context)
  File "/var/tmp/openupgrade/8.0/server/openerp/api.py", line 237, in wrapper
    return old_api(self, *args, **kwargs)
  File "/var/tmp/openupgrade/8.0/server/openerp/addons/base/res/res_users.py", line 714, in create
    self.update_user_groups_view(cr, uid, context)
  File "/var/tmp/openupgrade/8.0/server/openerp/api.py", line 237, in wrapper
    return old_api(self, *args, **kwargs)
  File "/var/tmp/openupgrade/8.0/server/openerp/addons/base/res/res_users.py", line 755, in update_user_groups_view
    view.write({'arch': xml_content})
  File "/var/tmp/openupgrade/8.0/server/openerp/api.py", line 235, in wrapper
    return new_api(self, *args, **kwargs)
  File "/var/tmp/openupgrade/8.0/server/openerp/api.py", line 552, in new_api
    result = method(self._model, cr, uid, self.ids, *args, **kwargs)
  File "/var/tmp/openupgrade/8.0/server/openerp/addons/base/ir/ir_ui_view.py", line 282, in write
    context)
  File "/var/tmp/openupgrade/8.0/server/openerp/api.py", line 237, in wrapper
    return old_api(self, *args, **kwargs)
  File "/var/tmp/openupgrade/8.0/server/openerp/api.py", line 360, in old_api
    result = method(recs, *args, **kwargs)
  File "/var/tmp/openupgrade/8.0/server/openerp/models.py", line 3692, in write
    self._write(old_vals)
  File "/var/tmp/openupgrade/8.0/server/openerp/api.py", line 235, in wrapper
    return new_api(self, *args, **kwargs)
  File "/var/tmp/openupgrade/8.0/server/openerp/api.py", line 552, in new_api
    result = method(self._model, cr, uid, self.ids, *args, **kwargs)
  File "/var/tmp/openupgrade/8.0/server/openerp/models.py", line 3854, in _write
    recs._validate_fields(vals)
  File "/var/tmp/openupgrade/8.0/server/openerp/api.py", line 235, in wrapper
    return new_api(self, *args, **kwargs)
  File "/var/tmp/openupgrade/8.0/server/openerp/models.py", line 1297, in _validate_fields
    raise ValidationError('\n'.join(errors))
ParseError: "ValidateError
Field(s) `arch` failed against a constraint: Invalid view definition

Error details:
Field `menu_id` does not exist

Error context:
View `res.users.groups`
[view_id: 159, xml_id: base.user_groups_view, model: res.users, parent_id: 156]" while parsing /var/tmp/openupgrade/8.0/server/openerp/addons/base/base_data.xml:88, near
<record id="group_portal" model="res.groups">
            <field name="name">Portal</field>
            <field name="comment">Portal members have specific access rights (such as record rules and restricted menus).
                They usually do not belong to the usual OpenERP groups.</field>
        </record>
2014-10-06 11:06:57,616 8968 INFO virus_copy_migrated openerp.service.server: Initiating shutdown
2014-10-06 11:06:57,616 8968 INFO virus_copy_migrated openerp.service.server: Hit CTRL-C again or send a second signal to force the shutdown.


2014-10-03 16:14 GMT+03:00 George Mengelberg <george-mengelberg-gmail-com@mail.odoo.com>:

I would focus on what in the script is trying to convert the datatypes: 2014-10-03 12:23:47,481 1646 ERROR virus_migrated openerp.sql_db: bad query: ALTER TABLE "ir_attachment" ALTER COLUMN "datas_fname" TYPE VARCHAR Traceback (most recent call last): File "/var/tmp/openupgrade/8.0/server/openerp/sql_db.py", line 234, in execute res = self._obj.execute(query, params) NotSupportedError: cannot alter type of a column used by a view or rule DETAIL: rule _RETURN on view report_document_user depends on column "datas_fname"

--
George Mengelberg
Sent by OpenERP S.A. using Odoo about Forum Post False

Ti stai godendo la conversazione? Non leggere soltanto, partecipa anche tu!

Crea un account oggi per scoprire funzionalità esclusive ed entrare a far parte della nostra fantastica community!

Registrati
Post correlati Risposte Visualizzazioni Attività
How to: Migration to Odoo 8 using OpenUpgrade
migration v7 openupgrade
Avatar
Avatar
1
mar 15
5292
Asset Management migration V12.0 to new versions
migration openupgrade
Avatar
0
mag 23
3074
How to set up 2 OpenUpgrade Servers Risolto
migration openupgrade
Avatar
1
ago 19
5344
how to migrate from v7. saas5 to v8? Is it possible?
v8 migration
Avatar
0
ott 15
3783
Loading wrong configuration file? Risolto
v8 v7
Avatar
Avatar
1
apr 15
9385
Community
  • Tutorial
  • Documentazione
  • Forum
Open source
  • Scarica
  • Github
  • Runbot
  • Traduzioni
Servizi
  • Hosting Odoo.sh
  • Supporto
  • Aggiornamenti
  • Sviluppi personalizzati
  • Formazione
  • Trova un contabile
  • Trova un partner
  • Diventa nostro partner
Chi siamo
  • La nostra azienda
  • Branding
  • Contattaci
  • Lavora con noi
  • Eventi
  • Podcast
  • Blog
  • Clienti
  • Note legali • Privacy
  • Sicurezza
الْعَرَبيّة Català 简体中文 繁體中文 (台灣) Čeština Dansk Nederlands English Suomi Français Deutsch हिंदी Bahasa Indonesia Italiano 日本語 한국어 (KR) Lietuvių kalba Język polski Português (BR) română русский язык Slovenský jazyk slovenščina Español (América Latina) Español ภาษาไทย Türkçe українська Tiếng Việt

Odoo è un gestionale di applicazioni aziendali open source pensato per coprire tutte le esigenze della tua azienda: CRM, Vendite, E-commerce, Magazzino, Produzione, Fatturazione elettronica, Project Management e molto altro.

Il punto di forza di Odoo è quello di offrire un ecosistema unico di app facili da usare, intuitive e completamente integrate tra loro.

Website made with

Odoo Experience on YouTube

1. Use the live chat to ask your questions.
2. The operator answers within a few minutes.

Live support on Youtube
Watch now