Odoo Help

Welcome!

This community is for beginners and experts willing to share their Odoo knowledge. It's not a forum to discuss ideas, but a knowledge base of questions and their answers.

0

Problem restoring a database: did odoo data model changed since RC1 ?

By
flg
on 9/23/14, 5:55 PM 1,590 views

Hello

I have been playing with odoo 8 for 2 month now. I had an install of odoo8 RC1 from which I made a backup of the database through the web interface.

I tried to restore this database into a fresh instance of recently release odoo 8 that I installed on debian from the nightly built

This does not work and the log file gives me the error listed below.

The source of the problem seems to be: Programming error: ERREUR:  la colonne ir_ui_view.customize_show n'existe pas (colum ir_ui_view.customize_show does not exist)

did the data model changed between RC1 and final release ?

Do you have any idea to solve these issue ?

Many thanks

-------- Extract from log file -------

2014-09-23 21:50:46,388 2337 INFO odoo werkzeug: 192.168.43.180 - - [23/Sep/2014 21:50:46] "GET /web/login?db=test-restore HTTP/1.1" 302 -
2014-09-23 21:50:46,462 2337 INFO None werkzeug: 192.168.43.180 - - [23/Sep/2014 21:50:46] "GET /web/login?db=test-restore HTTP/1.1" 302 -
2014-09-23 21:50:46,541 2337 ERROR test-restore openerp.sql_db: Programming error: ERREUR:  la colonne ir_ui_view.customize_show n'existe pas
LINE 1: ..."id",ir_ui_view."write_uid",ir_ui_view."priority",ir_ui_view...
                                                             ^
, in query  SELECT ir_ui_view."create_uid",ir_ui_view."create_date",ir_ui_view."name",ir_ui_view."inherit_id",ir_ui_view."arch",ir_ui_view."id",ir_ui_view."write_uid",ir_ui_view."priority",ir_ui_view."customize_show",ir_ui_view."website_meta_description",ir_ui_view."website_meta_title",ir_ui_view."mode",ir_ui_view."write_date",ir_ui_view."active",ir_ui_view."website_meta_keywords",ir_ui_view."model",ir_ui_view."model_data_id",ir_ui_view."type",ir_ui_view."page",ir_ui_view."field_parent" FROM "ir_ui_view"
                    WHERE ir_ui_view.id IN %s AND (TRUE)
                    ORDER BY priority,name

2014-09-23 21:50:46,544 2337 ERROR test-restore openerp.sql_db: bad query: SELECT "ir_attachment".id FROM "ir_attachment" WHERE (("ir_attachment"."type" = 'binary')  AND  ("ir_attachment"."url" = '/web/login')) ORDER BY "ir_attachment"."id" desc
Traceback (most recent call last):
  File "/usr/lib/python2.7/dist-packages/openerp/sql_db.py", line 234, in execute
    res = self._obj.execute(query, params)
InternalError: ERREUR:  la transaction est annul��e, les commandes sont ignor��es jusqu'�� la fin du bloc
de la transaction

2014-09-23 21:50:46,554 2337 INFO test-restore werkzeug: 192.168.43.180 - - [23/Sep/2014 21:50:46] "GET /web/login?db=test-restore HTTP/1.1" 500 -
2014-09-23 21:50:46,593 2337 ERROR test-restore werkzeug: Error on request:
Traceback (most recent call last):
  File "/usr/share/pyshared/werkzeug/serving.py", line 159, in run_wsgi
    execute(app)
  File "/usr/share/pyshared/werkzeug/serving.py", line 146, in execute
    application_iter = app(environ, start_response)
  File "/usr/lib/python2.7/dist-packages/openerp/service/server.py", line 280, in app
    return self.app(e, s)
  File "/usr/lib/python2.7/dist-packages/openerp/service/wsgi_server.py", line 216, in application
    return application_unproxied(environ, start_response)
  File "/usr/lib/python2.7/dist-packages/openerp/service/wsgi_server.py", line 202, in application_unproxied
    result = handler(environ, start_response)
  File "/usr/lib/python2.7/dist-packages/openerp/http.py", line 1214, in __call__
    return self.dispatch(environ, start_response)
  File "/usr/lib/python2.7/dist-packages/openerp/http.py", line 1188, in __call__
    return self.app(environ, start_wrapped)
  File "/usr/share/pyshared/werkzeug/wsgi.py", line 411, in __call__
    return self.app(environ, start_response)
  File "/usr/lib/python2.7/dist-packages/openerp/http.py", line 1188, in __call__
    return self.app(environ, start_wrapped)
  File "/usr/share/pyshared/werkzeug/wsgi.py", line 411, in __call__
    return self.app(environ, start_response)
  File "/usr/lib/python2.7/dist-packages/openerp/http.py", line 1188, in __call__
    return self.app(environ, start_wrapped)
  File "/usr/share/pyshared/werkzeug/wsgi.py", line 411, in __call__
    return self.app(environ, start_response)
  File "/usr/lib/python2.7/dist-packages/openerp/http.py", line 1360, in dispatch
    response = self.get_response(httprequest, result, explicit_session)
  File "/usr/lib/python2.7/dist-packages/openerp/http.py", line 1295, in get_response
    result = request.registry['ir.http']._handle_exception(e)
  File "/usr/lib/python2.7/dist-packages/openerp/addons/website/models/ir_http.py", line 194, in _handle_exception
    attach = self._serve_attachment()
  File "/usr/lib/python2.7/dist-packages/openerp/addons/website/models/ir_http.py", line 168, in _serve_attachment
    attach = self.pool['ir.attachment'].search_read(request.cr, openerp.SUPERUSER_ID, domain, ['__last_update', 'datas', 'mimetype'], context=request.context)
  File "/usr/lib/python2.7/dist-packages/openerp/api.py", line 237, in wrapper
    return old_api(self, *args, **kwargs)
  File "/usr/lib/python2.7/dist-packages/openerp/models.py", line 5014, in search_read
    record_ids = self.search(cr, uid, domain or [], offset=offset, limit=limit, order=order, context=context)
  File "/usr/lib/python2.7/dist-packages/openerp/api.py", line 237, in wrapper
    return old_api(self, *args, **kwargs)
  File "/usr/lib/python2.7/dist-packages/openerp/addons/calendar/calendar.py", line 1724, in search
    return super(ir_attachment, self).search(cr, uid, args, offset=offset, limit=limit, order=order, context=context, count=count)
  File "/usr/lib/python2.7/dist-packages/openerp/api.py", line 237, in wrapper
    return old_api(self, *args, **kwargs)
  File "/usr/lib/python2.7/dist-packages/openerp/models.py", line 1679, in search
    return self._search(cr, user, args, offset=offset, limit=limit, order=order, context=context, count=count)
  File "/usr/lib/python2.7/dist-packages/openerp/api.py", line 237, in wrapper
    return old_api(self, *args, **kwargs)
  File "/usr/lib/python2.7/dist-packages/openerp/addons/base/ir/ir_attachment.py", line 253, in _search
    access_rights_uid=access_rights_uid)
  File "/usr/lib/python2.7/dist-packages/openerp/api.py", line 237, in wrapper
    return old_api(self, *args, **kwargs)
  File "/usr/lib/python2.7/dist-packages/openerp/models.py", line 4544, in _search
    cr.execute(query_str, where_clause_params)
  File "/usr/lib/python2.7/dist-packages/openerp/sql_db.py", line 158, in wrapper
    return f(self, *args, **kwargs)
  File "/usr/lib/python2.7/dist-packages/openerp/sql_db.py", line 234, in execute
    res = self._obj.execute(query, params)
InternalError: ERREUR:  la transaction est annulée, les commandes sont ignorées jusqu'à la fin du bloc
de la transaction

 

 

0
Martin Temmink
On 9/27/14, 8:37 PM

Try to update the database after the import, you can do this with the following command.

first stop the running odoo services (for ubuntu: service odoo-server stop).

 

/opt/odoo/odoo/./openerp-server -d odoo -u all

the parameter -d odoo  is the the actual database to update (in this case odoo).

The system will then try to update the database to the new version, this will take some time (minuts). Keep an eye on the screen, because if it can't be updated, there will be some more information on it.

If this helps, please give me a thumbs up vote.

 

0
Martin Temmink
On 9/27/14, 8:33 PM

Try to update the database after the import, you can do this with the following command.

first stop the running odoo services (for ubuntu: service odoo-server stop).

 

/opt/odoo/odoo/./openerp-server -d odoo -u all

the parameter -d odoo  is the the actual database to update (in this case odoo).

The system will then try to update the database to the new version, this will take some time (minuts). Keep an eye on the screen, because if it can't be updated, there will be some more information on it.

If this helps, please give me a thumbs up vote.

 

Your Answer

Please try to give a substantial answer. If you wanted to comment on the question or answer, just use the commenting tool. Please remember that you can always revise your answers - no need to answer the same question twice. Also, please don't forget to vote - it really helps to select the best questions and answers!

About This Community

This community is for professionals and enthusiasts of our products and services. Read Guidelines

Question tools

1 follower(s)

Stats

Asked: 9/23/14, 5:55 PM
Seen: 1590 times
Last updated: 3/16/15, 8:10 AM