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
