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

CRM
e-Commerce
Comptabilité
Inventaire
PoS
Projet
MRP

All apps

Toutes les publications Personnes Badges

Étiquettes (Voir toutl)

odoo accounting v14 pos v15

À propos de ce forum

Aide

Internal Server Error after 9/3 git pull

error 8.0

5 Réponses

13479 Vues

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

KOUBA Aalaâ

Meilleure réponse

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

Auteur

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

Vous appréciez la discussion ? Ne vous contentez pas de lire, rejoignez-nous !

Créez un compte dès aujourd'hui pour profiter de fonctionnalités exclusives et échanger avec notre formidable communauté !

S'inscrire

Publications associées	Réponses	Vues
?"Your country might be blocked by our hosting provider" error when I create new website error	0 oct. 25	578
Payment Page Return Error with Razorpay on Mobile Devices error	0 sept. 25	1178
Error after installing "purchase" app in Odoo version 18 error	1 déc. 24	6690
error schema for TourStep Error error	0 nov. 24	2574
Can't modify manifest version of custom module [Odoo.sh] error	2 juil. 24	5220

Cette question a été signalée

Vous appréciez la discussion ? Ne vous contentez pas de lire, rejoignez-nous !