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

Internal Server Error after 9/3 git pull

By
Kyle Krenzer
on 9/3/14, 7:18 PM 5,489 views

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

2
aliasoft
On 9/26/14, 9:32 AM

 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

1
Yves Goldberg
On 9/4/14, 6:21 PM

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?

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.

Ygol InternetWork, Yves Goldberg
on 9/5/14, 4:42 PM
0
Huseyin Guner
On 9/13/14, 1:47 AM

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

 

0

Ben Bernard

--Ben Bernard--
1083
| 4 3 6
Jakarta, Indonesia
--Ben Bernard--
Ben Bernard
On 9/4/14, 1:03 AM

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.

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

Kyle Krenzer
on 9/4/14, 1:49 PM
0
Vũ Quốc Hoàng
On 9/12/14, 4:16 AM

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.

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

3 follower(s)

Stats

Asked: 9/3/14, 7:18 PM
Seen: 5489 times
Last updated: 3/16/15, 8:10 AM