跳至內容
此問題已被標幟
error8.0
5 回覆
13434 瀏覽次數
頭像
Kyle Krenzer

2014-09-03 23:16:55,119 4304 ERROR eo-master-2 openerp.sql_db: Programming error: column ir_ui_view.customize_show does not exist

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-03 23:16:55,120 4304 ERROR eo-master-2 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 "/opt/odoo/odoo/openerp/sql_db.py", line 234, in execute

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

InternalError: current transaction is aborted, commands ignored until end of transaction block

 

2014-09-03 23:16:55,123 4304 INFO eo-master-2 werkzeug: 127.0.0.1 - - [03/Sep/2014 23:16:55] "GET /web/login?redirect=https%3A%2F%2F192.168.0.108%2Fweb%3Fdb%3Deo-master-2 HTTP/1.0" 500 -

2014-09-03 23:16:55,134 4304 ERROR eo-master-2 werkzeug: Error on request:

Traceback (most recent call last):

  File "/usr/lib/python2.7/dist-packages/werkzeug/serving.py", line 177, in run_wsgi

    execute(self.server.app)

  File "/usr/lib/python2.7/dist-packages/werkzeug/serving.py", line 165, in execute

    application_iter = app(environ, start_response)

  File "/opt/odoo/odoo/openerp/service/wsgi_server.py", line 216, in application

    return application_unproxied(environ, start_response)

  File "/opt/odoo/odoo/openerp/service/wsgi_server.py", line 202, in application_unproxied

    result = handler(environ, start_response)

  File "/opt/odoo/odoo/openerp/http.py", line 1218, in __call__

    return self.dispatch(environ, start_response)

  File "/opt/odoo/odoo/openerp/http.py", line 1192, in __call__

    return self.app(environ, start_wrapped)

  File "/usr/lib/python2.7/dist-packages/werkzeug/wsgi.py", line 579, in __call__

    return self.app(environ, start_response)

  File "/opt/odoo/odoo/openerp/http.py", line 1364, in dispatch

    response = self.get_response(httprequest, result, explicit_session)

  File "/opt/odoo/odoo/openerp/http.py", line 1299, in get_response

    result = request.registry['ir.http']._handle_exception(e)

  File "/opt/odoo/odoo/addons/website/models/ir_http.py", line 188, in _handle_exception

    attach = self._serve_attachment()

  File "/opt/odoo/odoo/addons/website/models/ir_http.py", line 162, in _serve_attachment

    attach = self.pool['ir.attachment'].search_read(request.cr, openerp.SUPERUSER_ID, domain, ['__last_update', 'datas', 'mimetype'], context=request.context)

  File "/opt/odoo/odoo/openerp/api.py", line 234, in wrapper

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

  File "/opt/odoo/odoo/openerp/models.py", line 4985, in search_read

    record_ids = self.search(cr, uid, domain or [], offset=offset, limit=limit, order=order, context=context)

  File "/opt/odoo/odoo/openerp/api.py", line 234, in wrapper

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

  File "/opt/odoo/odoo/addons/calendar/calendar.py", line 1691, in search

    return super(ir_attachment, self).search(cr, uid, args, offset=offset, limit=limit, order=order, context=context, count=count)

  File "/opt/odoo/odoo/openerp/api.py", line 234, in wrapper

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

  File "/opt/odoo/odoo/addons/document/document.py", line 87, in search

    ids = super(document_file, self).search(cr, uid, args, offset=offset, limit=limit, order=order, context=context, count=False)

  File "/opt/odoo/odoo/openerp/api.py", line 234, in wrapper

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

  File "/opt/odoo/odoo/openerp/models.py", line 1674, in search

    return self._search(cr, user, args, offset=offset, limit=limit, order=order, context=context, count=count)

  File "/opt/odoo/odoo/openerp/api.py", line 234, in wrapper

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

  File "/opt/odoo/odoo/openerp/addons/base/ir/ir_attachment.py", line 247, in _search

    access_rights_uid=access_rights_uid)

  File "/opt/odoo/odoo/openerp/api.py", line 234, in wrapper

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

  File "/opt/odoo/odoo/openerp/models.py", line 4515, in _search

    cr.execute(query_str, where_clause_params)

  File "/opt/odoo/odoo/openerp/sql_db.py", line 158, in wrapper

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

  File "/opt/odoo/odoo/openerp/sql_db.py", line 234, in execute

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

InternalError: current transaction is aborted, commands ignored until end of transaction block

2014-09-03 23:16:55,263 4303 ERROR eo-master-2 openerp.sql_db: Programming error: column ir_ui_view.customize_show does not exist

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-03 23:16:55,264 4303 ERROR eo-master-2 openerp.sql_db: bad query: SELECT MAX(CASE WHEN perm_write THEN 1 ELSE 0 END)   FROM ir_model_access a   JOIN ir_model m ON (m.id = a.model_id)   JOIN res_groups_users_rel gu ON (gu.gid = a.group_id)  WHERE m.model = 'ir.ui.view'    AND gu.uid = 3    AND a.active IS True 

Traceback (most recent call last):

  File "/opt/odoo/odoo/openerp/sql_db.py", line 234, in execute

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

InternalError: current transaction is aborted, commands ignored until end of transaction block

 

2014-09-03 23:16:55,316 4303 INFO eo-master-2 werkzeug: 127.0.0.1 - - [03/Sep/2014 23:16:55] "GET /favicon.ico HTTP/1.0" 500 -

2014-09-03 23:16:55,320 4303 ERROR eo-master-2 werkzeug: Error on request:

Traceback (most recent call last):

  File "/usr/lib/python2.7/dist-packages/werkzeug/serving.py", line 177, in run_wsgi

    execute(self.server.app)

  File "/usr/lib/python2.7/dist-packages/werkzeug/serving.py", line 165, in execute

    application_iter = app(environ, start_response)

  File "/opt/odoo/odoo/openerp/service/wsgi_server.py", line 216, in application

    return application_unproxied(environ, start_response)

  File "/opt/odoo/odoo/openerp/service/wsgi_server.py", line 202, in application_unproxied

    result = handler(environ, start_response)

  File "/opt/odoo/odoo/openerp/http.py", line 1218, in __call__

    return self.dispatch(environ, start_response)

  File "/opt/odoo/odoo/openerp/http.py", line 1192, in __call__

    return self.app(environ, start_wrapped)

  File "/usr/lib/python2.7/dist-packages/werkzeug/wsgi.py", line 579, in __call__

    return self.app(environ, start_response)

  File "/opt/odoo/odoo/openerp/http.py", line 1359, in dispatch

    result = ir_http._dispatch()

  File "/opt/odoo/odoo/addons/crm/ir_http.py", line 13, in _dispatch

    return super(ir_http, self)._dispatch()

  File "/opt/odoo/odoo/addons/website/models/ir_http.py", line 119, in _dispatch

    return super(ir_http, self)._dispatch()

  File "/opt/odoo/odoo/openerp/addons/base/ir/ir_http.py", line 113, in _dispatch

    return self._handle_exception(e)

  File "/opt/odoo/odoo/addons/website/models/ir_http.py", line 247, in _handle_exception

    html = request.website._render('website.http_error', values)

  File "/opt/odoo/odoo/openerp/api.py", line 232, in wrapper

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

  File "/opt/odoo/odoo/openerp/api.py", line 549, in new_api

    result = method(self._model, cr, uid, self.ids, *args, **kwargs)

  File "/opt/odoo/odoo/addons/website/models/website.py", line 287, in _render

    return self.pool['ir.ui.view'].render(cr, uid, template, values=values, context=context)

  File "/opt/odoo/odoo/openerp/api.py", line 234, in wrapper

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

  File "/opt/odoo/odoo/addons/website/models/ir_ui_view.py", line 153, in render

    editable=request.website.is_publisher(),

  File "/opt/odoo/odoo/openerp/api.py", line 232, in wrapper

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

  File "/opt/odoo/odoo/openerp/api.py", line 549, in new_api

    result = method(self._model, cr, uid, self.ids, *args, **kwargs)

  File "/opt/odoo/odoo/addons/website/models/website.py", line 268, in is_publisher

    is_website_publisher = Access.check(cr, uid, 'ir.ui.view', 'write', False, context=context)

  File "/opt/odoo/odoo/openerp/api.py", line 234, in wrapper

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

  File "<string>", line 2, in check

    

  File "/opt/odoo/odoo/openerp/tools/cache.py", line 75, in lookup

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

  File "/opt/odoo/odoo/openerp/addons/base/ir/ir_model.py", line 732, in check

    , (model_name, uid,)

  File "/opt/odoo/odoo/openerp/sql_db.py", line 158, in wrapper

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

  File "/opt/odoo/odoo/openerp/sql_db.py", line 234, in execute

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

InternalError: current transaction is aborted, commands ignored until end of transaction block

頭像
捨棄
頭像
KOUBA Aalaâ
最佳答案

 update all modules by using this commande

 ./openerp-server -u all -d DATABASENAME

then, you'll see problems like 'GROUP BY ....' in crm_report and task_report , so you'll need to correct request directly in :

addons/project/report/project_report.py

and

addons/crm/report/crm_opportunity_report.py

and

addons/crm/report/crm_lead_report.py

you have just to add some selected fields after 'GROUP BY', you'll understand by yourself it's easy to see the bugs related to database request

and at least you'll see some problem related to Website module and 'theme.xml', then you can see this link, it's helpful:

https://github.com/odoo/odoo/issues/2152

頭像
捨棄
頭像
Yves Goldberg
最佳答案

Does Anyone has a solution/idea how this can be fixed?

Isn't it doable to launch the server with a flag to upgrade the module?

頭像
捨棄
Yves Goldberg

ok. Here's the solution I used: 1. Using "git reflog --date=iso" I selected a commit before the last "git pull" that broke the instance. 2. used "git reset --hard HEAD where HEAD is replaced by the one selected in point 1.

頭像
Ben Bernard
最佳答案

I'm not shocked and not try to debug it if I found this kind of error from github repo branch 8.0. Odoo 8.0 is not stable yet.

"2014-09-03 23:16:55,263 4303 ERROR eo-master-2 openerp.sql_db: Programming error: column ir_ui_view.customize_show does not exist

This log shows that the table ir_ui_view scheme changed by adding new customize_show column.

頭像
捨棄
Kyle Krenzer
作者

I thought the database schema was frozen with the rc1 release... Wish Odoo would keep us in the loop

頭像
Vũ Quốc Hoàng
最佳答案

Hello,

Odoo did something with web module so they add new field in ir_ui_view.

To fix this issue u can update module website first

For me I edited the openerp-server (--update=website) and deploy again.

頭像
捨棄
頭像
Huseyin Guner
最佳答案

running update all modules on command line fixed the issue for me. 

su odoo  || cd /opt/odoo/odoo-server

./openerp-server -u all

exit || sudo reboot

 

頭像
捨棄
相關帖文 回覆 瀏覽次數 活動
?"Your country might be blocked by our hosting provider" error when I create new website
error
頭像
0
10月 25
436
Payment Page Return Error with Razorpay on Mobile Devices
error
頭像
0
9月 25
1055
Error after installing "purchase" app in Odoo version 18
error
頭像
頭像
1
12月 24
6437
error schema for TourStep Error
error
頭像
0
11月 24
2496
Can't modify manifest version of custom module [Odoo.sh]
error
頭像
頭像
頭像
2
7月 24
5061