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