Internal Server Error after 9/3 git pull

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

CRM
e-Commerce
Accounting
Inventory
PoS
Project management
MRP

Take the tour

Posts People Badges

Tags View all

odoo accounting v7 pos invoice

About this forum

Help

Internal Server Error after 9/3 git pull

5 Replies

11638 Views

error 8.0

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...

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

aliasoft

Best Answer

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

Author

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

This question has been flagged