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 » pour une base de donnée

By
POHU
on 10/31/15, 11:31 AM 389 views

Bonjour,

Ce matin j'étais sur Odoo V8 et aucun soucis (c'est en phase de test dans notre entreprise) et j'ai voulu installer le module de gestion de la paie française, et après le serveur Odoo était down. quand j'accède à Odoo via le port 8069 j'obtiens :

[QUOTE]

Internal Server Error

The server encountered an internal error and was unable to complete your request. Either the server is overloaded or there is an error in the application.

[/QUOTE]

Je peux encore accèder au choix des base via [url]http://IP/web/database/selector[/url]. J'ai donc créé une nouvelle base et la aucun soucis. sauf que vu tout le travail effectue dans la base actuel il faut vraiment que je récupère la base. J'ai tenté :

 
sudo service odoo restart
sudo service postgresql restart
 

Mais ça ne change rien donc j'ai réinstaller Odoo

sudo apt-get autoremove --purge odoo
sudo apt-get install odoo
[/CODE] 

ça ne change rien toujours le même problème

Je suis sous Debian 7

Voici le contenu du log de odoo quand je lance [url]http://IP:8069[/url]

[CODE]
2015-10-30 17:06:04,641 4624 ERROR odoo openerp.sql_db: Programming error: ERREUR: la colonne res_company.nombre_employes n'existe pas
LINE 1: ...any"."overdue_msg","res_company"."paperformat_id","res_compa...
 ^
, in query SELECT "res_company"."rml_footer","res_company"."email","res_company"."account_no","res_company"."custom_footer","res_company"."overdue_msg","res_company"."paperformat_id","res_company"."nombre_employes","res_company"."company_registry","res_company"."vat_check_vies","res_company"."cotisation_prevoyance","res_company"."security_lead","res_company"."rml_header1","res_company"."ape","res_company"."write_uid","res_company"."plafond_secu","res_company"."sale_note","res_company"."parent_id","res_company"."tax_calculation_rounding_method","res_company"."id","res_company"."rml_header","res_company"."manufacturing_lead","res_company"."po_lead","res_company"."expense_currency_exchange_account_id","res_company"."currency_id","res_company"."partner_id","res_company"."rml_header2","res_company"."create_date","res_company"."name","res_company"."phone","res_company"."font","res_company"."write_date","res_company"."project_time_mode_id","res_company"."rml_header3","res_company"."expects_chart_of_accounts","res_company"."org_ss","res_company"."conv_coll","res_company"."income_currency_exchange_account_id","res_company"."create_uid","res_company"."rml_paper_format","res_company"."propagation_minimum_delta","res_company"."paypal_account","res_company"."siret","res_company"."internal_transit_location_id" FROM "res_company"
 WHERE "res_company".id IN %s ORDER BY "res_company"."name"
2015-10-30 17:06:04,643 4624 ERROR odoo openerp.addons.website.models.ir_http: 500 Internal Server Error:
Traceback (most recent call last):
 File "/usr/lib/python2.7/dist-packages/openerp/addons/website/models/ir_http.py", line 199, in _handle_exception
 response = super(ir_http, self)._handle_exception(exception)
 File "/usr/lib/python2.7/dist-packages/openerp/addons/base/ir/ir_http.py", line 145, in _handle_exception
 return request._handle_exception(exception)
 File "/usr/lib/python2.7/dist-packages/openerp/http.py", line 666, in _handle_exception
 return super(HttpRequest, self)._handle_exception(exception)
 File "/usr/lib/python2.7/dist-packages/openerp/http.py", line 1370, in get_response
 result.flatten()
 File "/usr/lib/python2.7/dist-packages/openerp/http.py", line 1241, in flatten
 self.response.append(self.render())
 File "/usr/lib/python2.7/dist-packages/openerp/http.py", line 1235, in render
 context=request.context)
 File "/usr/lib/python2.7/dist-packages/openerp/api.py", line 250, in wrapper
 return old_api(self, *args, **kwargs)
 File "/usr/lib/python2.7/dist-packages/openerp/addons/website/models/ir_ui_view.py", line 172, in render
 return super(view, self).render(cr, uid, id_or_xml_id, values=values, engine=engine, context=context)
 File "/usr/lib/python2.7/dist-packages/openerp/api.py", line 250, in wrapper
 return old_api(self, *args, **kwargs)
 File "/usr/lib/python2.7/dist-packages/openerp/addons/base/ir/ir_ui_view.py", line 1017, in render
 return self.pool[engine].render(cr, uid, id_or_xml_id, qcontext, loader=loader, context=context)
 File "/usr/lib/python2.7/dist-packages/openerp/api.py", line 250, in wrapper
 return old_api(self, *args, **kwargs)
 File "/usr/lib/python2.7/dist-packages/openerp/addons/base/ir/ir_qweb.py", line 262, in render
 return self.render_node(self.get_template(id_or_xml_id, qwebcontext), qwebcontext)
 File "/usr/lib/python2.7/dist-packages/openerp/addons/base/ir/ir_qweb.py", line 301, in render_node
 result = self.render_element(element, template_attributes, generated_attributes, qwebcontext)
 File "/usr/lib/python2.7/dist-packages/openerp/addons/base/ir/ir_qweb.py", line 322, in render_element
 g_inner.append(self.render_node(current_node, qwebcontext))
 File "/usr/lib/python2.7/dist-packages/openerp/addons/base/ir/ir_qweb.py", line 299, in render_node
 result = self._render_tag[t_render](self, element, template_attributes, generated_attributes, qwebcontext)
 File "/usr/lib/python2.7/dist-packages/openerp/addons/base/ir/ir_qweb.py", line 446, in render_tag_call
 return self.render(cr, uid, template, d)
 File "/usr/lib/python2.7/dist-packages/openerp/api.py", line 250, in wrapper
 return old_api(self, *args, **kwargs)
 File "/usr/lib/python2.7/dist-packages/openerp/addons/base/ir/ir_qweb.py", line 262, in render
 return self.render_node(self.get_template(id_or_xml_id, qwebcontext), qwebcontext)
 File "/usr/lib/python2.7/dist-packages/openerp/addons/base/ir/ir_qweb.py", line 301, in render_node
 result = self.render_element(element, template_attributes, generated_attributes, qwebcontext)
 File "/usr/lib/python2.7/dist-packages/openerp/addons/base/ir/ir_qweb.py", line 322, in render_element
 g_inner.append(self.render_node(current_node, qwebcontext))
 File "/usr/lib/python2.7/dist-packages/openerp/addons/base/ir/ir_qweb.py", line 299, in render_node
 result = self._render_tag[t_render](self, element, template_attributes, generated_attributes, qwebcontext)
 File "/usr/lib/python2.7/dist-packages/openerp/addons/base/ir/ir_qweb.py", line 446, in render_tag_call
 return self.render(cr, uid, template, d)
 File "/usr/lib/python2.7/dist-packages/openerp/api.py", line 250, in wrapper
 return old_api(self, *args, **kwargs)
 File "/usr/lib/python2.7/dist-packages/openerp/addons/base/ir/ir_qweb.py", line 262, in render
 return self.render_node(self.get_template(id_or_xml_id, qwebcontext), qwebcontext)
 File "/usr/lib/python2.7/dist-packages/openerp/addons/base/ir/ir_qweb.py", line 301, in render_node
 result = self.render_element(element, template_attributes, generated_attributes, qwebcontext)
 File "/usr/lib/python2.7/dist-packages/openerp/addons/base/ir/ir_qweb.py", line 322, in render_element
 g_inner.append(self.render_node(current_node, qwebcontext))
 File "/usr/lib/python2.7/dist-packages/openerp/addons/base/ir/ir_qweb.py", line 299, in render_node
 result = self._render_tag[t_render](self, element, template_attributes, generated_attributes, qwebcontext)
 File "/usr/lib/python2.7/dist-packages/openerp/addons/base/ir/ir_qweb.py", line 446, in render_tag_call
 return self.render(cr, uid, template, d)
 File "/usr/lib/python2.7/dist-packages/openerp/api.py", line 250, in wrapper
 return old_api(self, *args, **kwargs)
 File "/usr/lib/python2.7/dist-packages/openerp/addons/base/ir/ir_qweb.py", line 262, in render
 return self.render_node(self.get_template(id_or_xml_id, qwebcontext), qwebcontext)
 File "/usr/lib/python2.7/dist-packages/openerp/addons/base/ir/ir_qweb.py", line 301, in render_node
 result = self.render_element(element, template_attributes, generated_attributes, qwebcontext)
 File "/usr/lib/python2.7/dist-packages/openerp/addons/base/ir/ir_qweb.py", line 322, in render_element
 g_inner.append(self.render_node(current_node, qwebcontext))
 File "/usr/lib/python2.7/dist-packages/openerp/addons/base/ir/ir_qweb.py", line 284, in render_node
 for att, val in attrs:
 File "/usr/lib/python2.7/dist-packages/openerp/addons/website/models/ir_qweb.py", line 61, in render_att_att
 for att, val in super(QWeb, self).render_att_att(element, attribute_name, attribute_value, qwebcontext):
 File "/usr/lib/python2.7/dist-packages/openerp/addons/base/ir/ir_qweb.py", line 358, in render_att_att
 return [(attribute_name[6:], self.eval(attribute_value, qwebcontext))]
 File "/usr/lib/python2.7/dist-packages/openerp/addons/base/ir/ir_qweb.py", line 206, in eval
 raise_qweb_exception(message="Could not evaluate expression %r" % expr, expression=expr, template=template)
 File "/usr/lib/python2.7/dist-packages/openerp/addons/base/ir/ir_qweb.py", line 203, in eval
 return qwebcontext.safe_eval(expr)
 File "/usr/lib/python2.7/dist-packages/openerp/addons/base/ir/ir_qweb.py", line 89, in safe_eval
 return eval(expr, None, locals_dict, nocopy=True, locals_builtins=True)
 File "/usr/lib/python2.7/dist-packages/openerp/tools/safe_eval.py", line 314, in safe_eval
 return eval(c, globals_dict, locals_dict)
 File "", line 1, in <module>
 File "/usr/lib/python2.7/dist-packages/openerp/fields.py", line 819, in __get__
 self.determine_value(record)
 File "/usr/lib/python2.7/dist-packages/openerp/fields.py", line 912, in determine_value
 record._prefetch_field(self)
 File "/usr/lib/python2.7/dist-packages/openerp/api.py", line 248, in wrapper
 return new_api(self, *args, **kwargs)
 File "/usr/lib/python2.7/dist-packages/openerp/models.py", line 3241, in _prefetch_field
 result = records.read(list(fnames), load='_classic_write')
 File "/usr/lib/python2.7/dist-packages/openerp/api.py", line 248, in wrapper
 return new_api(self, *args, **kwargs)
 File "/usr/lib/python2.7/dist-packages/openerp/models.py", line 3178, in read
 self._read_from_database(stored, inherited)
 File "/usr/lib/python2.7/dist-packages/openerp/api.py", line 248, in wrapper
 return new_api(self, *args, **kwargs)
 File "/usr/lib/python2.7/dist-packages/openerp/models.py", line 3310, in _read_from_database
 cr.execute(query_str, [tuple(sub_ids)] + where_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)
QWebException: "ERREUR: la colonne res_company.nombre_employes n'existe pas
LINE 1: ...any"."overdue_msg","res_company"."paperformat_id","res_compa...
" while evaluating
'res_company.name'
2015-10-30 17:06:04,643 4624 ERROR odoo openerp.sql_db: bad query: SELECT id FROM "ir_ui_view" WHERE id IN (846)
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
2015-10-30 17:06:04,646 4624 INFO odoo werkzeug: 81.56.107.163 - - [30/Oct/2015 17:06:04] "GET /web/login?redirect=http%3A%2F%2Fcairn-devices.eu%3A8069%2Fweb%3Fdb%3Dodoo HTTP/1.1" 500 -
2015-10-30 17:06:04,683 4624 ERROR odoo 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 290, 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 1290, in __call__
 return self.dispatch(environ, start_response)
 File "/usr/lib/python2.7/dist-packages/openerp/http.py", line 1264, 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 1442, in dispatch
 response = self.get_response(httprequest, result, explicit_session)
 File "/usr/lib/python2.7/dist-packages/openerp/http.py", line 1373, 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 231, in _handle_exception
 views = view._views_get(request.cr, request.uid, exception.qweb['template'], request.context)
 File "/usr/lib/python2.7/dist-packages/openerp/api.py", line 250, in wrapper
 return old_api(self, *args, **kwargs)
 File "/usr/lib/python2.7/dist-packages/openerp/addons/website/models/ir_ui_view.py", line 48, in _views_get
 view = self._view_obj(cr, uid, view_id, context=context)
 File "/usr/lib/python2.7/dist-packages/openerp/api.py", line 250, in wrapper
 return old_api(self, *args, **kwargs)
 File "/usr/lib/python2.7/dist-packages/openerp/addons/website/models/ir_ui_view.py", line 29, in _view_obj
 cr, uid, view_id, raise_if_not_found=True, context=context
 File "/usr/lib/python2.7/dist-packages/openerp/api.py", line 250, in wrapper
 return old_api(self, *args, **kwargs)
 File "/usr/lib/python2.7/dist-packages/openerp/addons/base/ir/ir_model.py", line 930, in xmlid_to_object
 if record.exists():
 File "/usr/lib/python2.7/dist-packages/openerp/api.py", line 248, in wrapper
 return new_api(self, *args, **kwargs)
 File "/usr/lib/python2.7/dist-packages/openerp/models.py", line 4898, in exists
 self._cr.execute(query, [tuple(ids)])
 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
 

De ce que je comprend il manque une colonne dans la base, mais que faire ?

Merci de m'aider,

Gspohu

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

1 follower(s)

Stats

Asked: 10/31/15, 11:31 AM
Seen: 389 times
Last updated: 10/31/15, 11:34 AM