All Posts Lidé Odznaky

Štítky (View all)

O tomto fóru

Pomoc

website down. error 500.

500 DBexception

5 Odpovědi

5166 Zobrazení

Yann de Champlain

500 Internal Server Error

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.

-----

in /var/log/messages

this file

ERROR:  null value in column "name" violates not-null constraint
DETAIL: Failing row contains (732, null, null, null, 1, null, null, null, 1, 1, t, null, 2016-05-11 13:27:12.752903, 2016-05-11 13:27:12.752903, 753, t, t, null, null, null, null).
STATEMENT: INSERT INTO "crm_team" ("id", "alias_id", "company_id", "use_leads", "active", "use_opportunities", "create_uid", "write_uid", "create_date", "write_date") VALUES(nextval('crm_team_id_seq'), 753, 1, true, true, true, 1, 1, (now() at time zone 'UTC'), (now() at time zone 'UTC')) RETURNING id

There is issue with database query which insert value in table crm_team which column “name” has check for not null and insert query does not contain name so it throws not null exception.

Thanks for your help.

Ermin Trevisan

You have to provide your code which is causing the error.

Odoobot

If I ever know, i'll tell you.

ᐧ

Merci.

YANN DE CHAMPLAIN, PMP

Entrepreneur &

Conseiller en technologies
Bur.+1 (450) 312.11.10
Cel.+1 (438) 822-6370
Fax.+1 (450) 877.1029

*SVP Notez notre changement d'adresse (depuis le 1er janvier 2016): 13 rue de Chautagne, Terrebonne QC, J6Y 0G2

2016-05-11 11:01 GMT-04:00 Ermin Trevisan <trevi@twanda.com>:

You have to provide your code which is causing the error.

--
Ermin Trevisan

Sent by Odoo S.A. using Odoo

Ermin Trevisan

Then post the complete traceback to check where it comes from if not from code you have developed yourself.

GLM Conseil, Vincent Goineau

Any news on this ??? I do have the same issue. Anyhow, what I did is this, I commented out these lines :

<!--

        <record id="sales_team.team_sales_department" model="crm.team">

            <field name="use_leads">True</field>

            <field name="alias_name">sales</field>

        </record>

-->

Yann de Champlain

Autor

Here is all the log of 1 second, when I refresh the url form my browser:

You can download my paste from here:

http://www.heypasteit.com/download/2N9E

May 12 09:11:39 odoo odoo.py: 2016-05-12 13:11:39,470 18936 INFO admin openerp.modules.loading: loading 1 modules...

May 12 09:11:39 odoo odoo.py: 2016-05-12 13:11:39,480 18936 INFO admin openerp.modules.loading: 1 modules loaded in 0.01s, 0 queries

May 12 09:11:39 odoo odoo.py: 2016-05-12 13:11:39,535 18936 INFO admin openerp.modules.loading: loading 71 modules...

May 12 09:11:39 odoo odoo.py: 2016-05-12 13:11:39,739 18936 INFO admin openerp.modules.module: module crm: creating or updating database tables

May 12 09:11:39 odoo odoo.py: 2016-05-12 13:11:39,777 18936 INFO admin openerp.addons.auth_crypt.auth_crypt: Hashing passwords, may be slow for databases with many users...

May 12 09:11:40 odoo odoo.py: 2016-05-12 13:11:40,235 18936 INFO admin openerp.modules.loading: loading crm/data/crm_action_data.xml

May 12 09:11:40 odoo odoo.py: 2016-05-12 13:11:40,249 18936 INFO admin openerp.modules.loading: loading crm/crm_data.xml

May 12 09:11:40 odoo odoo.py: 2016-05-12 13:11:40,266 18936 ERROR admin openerp.modules.registry: Failed to load registry

May 12 09:11:40 odoo odoo.py: Traceback (most recent call last):

May 12 09:11:40 odoo odoo.py: File "/usr/lib/python2.7/site-packages/openerp/modules/registry.py", line 386, in new

May 12 09:11:40 odoo odoo.py: openerp.modules.load_modules(registry._db, force_demo, status, update_module)

May 12 09:11:40 odoo odoo.py: File "/usr/lib/python2.7/site-packages/openerp/modules/loading.py", line 334, in load_modules

May 12 09:11:40 odoo odoo.py: force, status, report, loaded_modules, update_module)

May 12 09:11:40 odoo odoo.py: File "/usr/lib/python2.7/site-packages/openerp/modules/loading.py", line 237, in load_marked_modules

May 12 09:11:40 odoo odoo.py: loaded, processed = load_module_graph(cr, graph, progressdict, report=report, skip_modules=loaded_modules, perform_checks=perform_checks)

May 12 09:11:40 odoo odoo.py: File "/usr/lib/python2.7/site-packages/openerp/modules/loading.py", line 156, in load_module_graph

May 12 09:11:40 odoo odoo.py: _load_data(cr, module_name, idref, mode, kind='data')

May 12 09:11:40 odoo odoo.py: File "/usr/lib/python2.7/site-packages/openerp/modules/loading.py", line 98, in _load_data

May 12 09:11:40 odoo odoo.py: tools.convert_file(cr, module_name, filename, idref, mode, noupdate, kind, report)

May 12 09:11:40 odoo odoo.py: File "/usr/lib/python2.7/site-packages/openerp/tools/convert.py", line 851, in convert_file

May 12 09:11:40 odoo odoo.py: convert_xml_import(cr, module, fp, idref, mode, noupdate, report)

May 12 09:11:40 odoo odoo.py: File "/usr/lib/python2.7/site-packages/openerp/tools/convert.py", line 938, in convert_xml_import

May 12 09:11:40 odoo odoo.py: obj.parse(doc.getroot(), mode=mode)

May 12 09:11:40 odoo odoo.py: File "/usr/lib/python2.7/site-packages/openerp/tools/convert.py", line 801, in parse

May 12 09:11:40 odoo odoo.py: self.parse(rec, mode)

May 12 09:11:40 odoo odoo.py: File "/usr/lib/python2.7/site-packages/openerp/tools/convert.py", line 804, in parse

May 12 09:11:40 odoo odoo.py: self._tags[rec.tag](self.cr, rec, de, mode=mode)

May 12 09:11:40 odoo odoo.py: File "/usr/lib/python2.7/site-packages/openerp/tools/convert.py", line 708, in _tag_record

May 12 09:11:40 odoo odoo.py: id = self.pool['ir.model.data']._update(cr, self.uid, rec_model, self.module, res, rec_id or False, not self.isnoupdate(data_node), noupdate=self.isnoupdate(data_node), mode=self.mode, context=rec_context )

May 12 09:11:40 odoo odoo.py: File "/usr/lib/python2.7/site-packages/openerp/api.py", line 250, in wrapper

May 12 09:11:40 odoo odoo.py: return old_api(self, *args, **kwargs)

May 12 09:11:40 odoo odoo.py: File "/usr/lib/python2.7/site-packages/openerp/addons/base/ir/ir_model.py", line 1142, in _update

May 12 09:11:40 odoo odoo.py: res_id = model_obj.create(cr, uid, values, context=context)

May 12 09:11:40 odoo odoo.py: File "/usr/lib/python2.7/site-packages/openerp/api.py", line 250, in wrapper

May 12 09:11:40 odoo odoo.py: return old_api(self, *args, **kwargs)

May 12 09:11:40 odoo odoo.py: File "/usr/lib/python2.7/site-packages/openerp/addons/crm/sales_team.py", line 101, in create

May 12 09:11:40 odoo odoo.py: team_id = super(crm_team, self).create(cr, uid, vals, context=create_context)

May 12 09:11:40 odoo odoo.py: File "/usr/lib/python2.7/site-packages/openerp/api.py", line 250, in wrapper

May 12 09:11:40 odoo odoo.py: return old_api(self, *args, **kwargs)

May 12 09:11:40 odoo odoo.py: File "/usr/lib/python2.7/site-packages/openerp/addons/sales_team/sales_team.py", line 54, in create

May 12 09:11:40 odoo odoo.py: return super(crm_team, self).create(cr, uid, values, context=context)

May 12 09:11:40 odoo odoo.py: File "/usr/lib/python2.7/site-packages/openerp/api.py", line 250, in wrapper

May 12 09:11:40 odoo odoo.py: return old_api(self, *args, **kwargs)

May 12 09:11:40 odoo odoo.py: File "/usr/lib/python2.7/site-packages/openerp/api.py", line 354, in old_api

May 12 09:11:40 odoo odoo.py: result = method(recs, *args, **kwargs)

May 12 09:11:40 odoo odoo.py: File "/usr/lib/python2.7/site-packages/openerp/addons/mail/models/mail_thread.py", line 232, in create

May 12 09:11:40 odoo odoo.py: thread = super(MailThread, self).create(values)

May 12 09:11:40 odoo odoo.py: File "/usr/lib/python2.7/site-packages/openerp/api.py", line 248, in wrapper

May 12 09:11:40 odoo odoo.py: return new_api(self, *args, **kwargs)

May 12 09:11:40 odoo odoo.py: File "/usr/lib/python2.7/site-packages/openerp/models.py", line 4151, in create

May 12 09:11:40 odoo odoo.py: record = self.browse(self._create(old_vals))

May 12 09:11:40 odoo odoo.py: File "/usr/lib/python2.7/site-packages/openerp/api.py", line 248, in wrapper

May 12 09:11:40 odoo odoo.py: return new_api(self, *args, **kwargs)

May 12 09:11:40 odoo odoo.py: File "/usr/lib/python2.7/site-packages/openerp/api.py", line 490, in new_api

May 12 09:11:40 odoo odoo.py: result = method(self._model, cr, uid, *args, **old_kwargs)

May 12 09:11:40 odoo odoo.py: File "/usr/lib/python2.7/site-packages/openerp/models.py", line 4289, in _create

May 12 09:11:40 odoo odoo.py: tuple([u[2] for u in updates if len(u) > 2])

May 12 09:11:40 odoo odoo.py: File "/usr/lib/python2.7/site-packages/openerp/sql_db.py", line 141, in wrapper

May 12 09:11:40 odoo odoo.py: return f(self, *args, **kwargs)

May 12 09:11:40 odoo odoo.py: File "/usr/lib/python2.7/site-packages/openerp/sql_db.py", line 220, in execute

May 12 09:11:40 odoo odoo.py: res = self._obj.execute(query, params)

May 12 09:11:40 odoo odoo.py: ParseError: "null value in column "name" violates not-null constraint

May 12 09:11:40 odoo odoo.py: DETAIL:  Failing row contains (749, null, null, null, 1, null, null, null, 1, 1, t, null, 2016-05-12 13:11:40.204732, 2016-05-12 13:11:40.204732, 770, t, t, null, null, null, null).

May 12 09:11:40 odoo odoo.py: " while parsing /usr/lib/python2.7/site-packages/openerp/addons/crm/crm_data.xml:16, near

May 12 09:11:40 odoo odoo.py: <record model="crm.team" id="sales_team.team_sales_department">

May 12 09:11:40 odoo odoo.py: <field name="use_leads">True</field>

May 12 09:11:40 odoo odoo.py: <field name="alias_name">sales</field>

May 12 09:11:40 odoo odoo.py: </record>

May 12 09:11:40 odoo odoo.py: 2016-05-12 13:11:40,271 18936 INFO admin werkzeug: 127.0.0.1 - - [12/May/2016 13:11:40] "GET / HTTP/1.0" 500 -

May 12 09:11:40 odoo odoo.py: 2016-05-12 13:11:40,290 18936 ERROR admin werkzeug: Error on request:

May 12 09:11:40 odoo odoo.py: Traceback (most recent call last):

May 12 09:11:40 odoo odoo.py: File "/usr/lib/python2.7/site-packages/werkzeug/serving.py", line 177, in run_wsgi

May 12 09:11:40 odoo odoo.py: execute(self.server.app)

May 12 09:11:40 odoo odoo.py: File "/usr/lib/python2.7/site-packages/werkzeug/serving.py", line 165, in execute

May 12 09:11:40 odoo odoo.py: application_iter = app(environ, start_response)

May 12 09:11:40 odoo odoo.py: File "/usr/lib/python2.7/site-packages/openerp/service/server.py", line 246, in app

May 12 09:11:40 odoo odoo.py: return self.app(e, s)

May 12 09:11:40 odoo odoo.py: File "/usr/lib/python2.7/site-packages/openerp/service/wsgi_server.py", line 184, in application

May 12 09:11:40 odoo odoo.py: return application_unproxied(environ, start_response)

May 12 09:11:40 odoo odoo.py: File "/usr/lib/python2.7/site-packages/openerp/service/wsgi_server.py", line 170, in application_unproxied

May 12 09:11:40 odoo odoo.py: result = handler(environ, start_response)

May 12 09:11:40 odoo odoo.py: File "/usr/lib/python2.7/site-packages/openerp/http.py", line 1488, in __call__

May 12 09:11:40 odoo odoo.py: return self.dispatch(environ, start_response)

May 12 09:11:40 odoo odoo.py: File "/usr/lib/python2.7/site-packages/openerp/http.py", line 1462, in __call__

May 12 09:11:40 odoo odoo.py: return self.app(environ, start_wrapped)

May 12 09:11:40 odoo odoo.py: File "/usr/lib/python2.7/site-packages/werkzeug/wsgi.py", line 579, in __call__

May 12 09:11:40 odoo odoo.py: return self.app(environ, start_response)

May 12 09:11:40 odoo odoo.py: File "/usr/lib/python2.7/site-packages/openerp/http.py", line 1637, in dispatch

May 12 09:11:40 odoo odoo.py: ir_http = request.registry['ir.http']

May 12 09:11:40 odoo odoo.py: File "/usr/lib/python2.7/site-packages/openerp/http.py", line 360, in registry

May 12 09:11:40 odoo odoo.py: return openerp.modules.registry.RegistryManager.get(self.db) if self.db else None

May 12 09:11:40 odoo odoo.py: File "/usr/lib/python2.7/site-packages/openerp/modules/registry.py", line 355, in get

May 12 09:11:40 odoo odoo.py: update_module)

May 12 09:11:40 odoo odoo.py: File "/usr/lib/python2.7/site-packages/openerp/modules/registry.py", line 386, in new

May 12 09:11:40 odoo odoo.py: openerp.modules.load_modules(registry._db, force_demo, status, update_module)

May 12 09:11:40 odoo odoo.py: File "/usr/lib/python2.7/site-packages/openerp/modules/loading.py", line 334, in load_modules

May 12 09:11:40 odoo odoo.py: force, status, report, loaded_modules, update_module)

May 12 09:11:40 odoo odoo.py: File "/usr/lib/python2.7/site-packages/openerp/modules/loading.py", line 237, in load_marked_modules

May 12 09:11:40 odoo odoo.py: loaded, processed = load_module_graph(cr, graph, progressdict, report=report, skip_modules=loaded_modules, perform_checks=perform_checks)

May 12 09:11:40 odoo odoo.py: File "/usr/lib/python2.7/site-packages/openerp/modules/loading.py", line 156, in load_module_graph

May 12 09:11:40 odoo odoo.py: _load_data(cr, module_name, idref, mode, kind='data')

May 12 09:11:40 odoo odoo.py: File "/usr/lib/python2.7/site-packages/openerp/modules/loading.py", line 98, in _load_data

May 12 09:11:40 odoo odoo.py: tools.convert_file(cr, module_name, filename, idref, mode, noupdate, kind, report)

May 12 09:11:40 odoo odoo.py: File "/usr/lib/python2.7/site-packages/openerp/tools/convert.py", line 851, in convert_file

May 12 09:11:40 odoo odoo.py: convert_xml_import(cr, module, fp, idref, mode, noupdate, report)

May 12 09:11:40 odoo odoo.py: File "/usr/lib/python2.7/site-packages/openerp/tools/convert.py", line 938, in convert_xml_import

May 12 09:11:40 odoo odoo.py: obj.parse(doc.getroot(), mode=mode)

May 12 09:11:40 odoo odoo.py: File "/usr/lib/python2.7/site-packages/openerp/tools/convert.py", line 801, in parse

May 12 09:11:40 odoo odoo.py: self.parse(rec, mode)

May 12 09:11:40 odoo odoo.py: File "/usr/lib/python2.7/site-packages/openerp/tools/convert.py", line 804, in parse

May 12 09:11:40 odoo odoo.py: self._tags[rec.tag](self.cr, rec, de, mode=mode)

May 12 09:11:40 odoo odoo.py: File "/usr/lib/python2.7/site-packages/openerp/tools/convert.py", line 708, in _tag_record

May 12 09:11:40 odoo odoo.py: id = self.pool['ir.model.data']._update(cr, self.uid, rec_model, self.module, res, rec_id or False, not self.isnoupdate(data_node), noupdate=self.isnoupdate(data_node), mode=self.mode, context=rec_context )

May 12 09:11:40 odoo odoo.py: File "/usr/lib/python2.7/site-packages/openerp/api.py", line 250, in wrapper

May 12 09:11:40 odoo odoo.py: return old_api(self, *args, **kwargs)

May 12 09:11:40 odoo odoo.py: File "/usr/lib/python2.7/site-packages/openerp/addons/base/ir/ir_model.py", line 1142, in _update

May 12 09:11:40 odoo odoo.py: res_id = model_obj.create(cr, uid, values, context=context)

May 12 09:11:40 odoo odoo.py: File "/usr/lib/python2.7/site-packages/openerp/api.py", line 250, in wrapper

May 12 09:11:40 odoo odoo.py: return old_api(self, *args, **kwargs)

May 12 09:11:40 odoo odoo.py: File "/usr/lib/python2.7/site-packages/openerp/addons/crm/sales_team.py", line 101, in create

May 12 09:11:40 odoo odoo.py: team_id = super(crm_team, self).create(cr, uid, vals, context=create_context)

May 12 09:11:40 odoo odoo.py: File "/usr/lib/python2.7/site-packages/openerp/api.py", line 250, in wrapper

May 12 09:11:40 odoo odoo.py: return old_api(self, *args, **kwargs)

May 12 09:11:40 odoo odoo.py: File "/usr/lib/python2.7/site-packages/openerp/addons/sales_team/sales_team.py", line 54, in create

May 12 09:11:40 odoo odoo.py: return super(crm_team, self).create(cr, uid, values, context=context)

May 12 09:11:40 odoo odoo.py: File "/usr/lib/python2.7/site-packages/openerp/api.py", line 250, in wrapper

May 12 09:11:40 odoo odoo.py: return old_api(self, *args, **kwargs)

May 12 09:11:40 odoo odoo.py: File "/usr/lib/python2.7/site-packages/openerp/api.py", line 354, in old_api

May 12 09:11:40 odoo odoo.py: result = method(recs, *args, **kwargs)

May 12 09:11:40 odoo odoo.py: File "/usr/lib/python2.7/site-packages/openerp/addons/mail/models/mail_thread.py", line 232, in create

May 12 09:11:40 odoo odoo.py: thread = super(MailThread, self).create(values)

May 12 09:11:40 odoo odoo.py: File "/usr/lib/python2.7/site-packages/openerp/api.py", line 248, in wrapper

May 12 09:11:40 odoo odoo.py: return new_api(self, *args, **kwargs)

May 12 09:11:40 odoo odoo.py: File "/usr/lib/python2.7/site-packages/openerp/models.py", line 4151, in create

May 12 09:11:40 odoo odoo.py: record = self.browse(self._create(old_vals))

May 12 09:11:40 odoo odoo.py: File "/usr/lib/python2.7/site-packages/openerp/api.py", line 248, in wrapper

May 12 09:11:40 odoo odoo.py: return new_api(self, *args, **kwargs)

May 12 09:11:40 odoo odoo.py: File "/usr/lib/python2.7/site-packages/openerp/api.py", line 490, in new_api

May 12 09:11:40 odoo odoo.py: result = method(self._model, cr, uid, *args, **old_kwargs)

May 12 09:11:40 odoo odoo.py: File "/usr/lib/python2.7/site-packages/openerp/models.py", line 4289, in _create

May 12 09:11:40 odoo odoo.py: tuple([u[2] for u in updates if len(u) > 2])

May 12 09:11:40 odoo odoo.py: File "/usr/lib/python2.7/site-packages/openerp/sql_db.py", line 141, in wrapper

May 12 09:11:40 odoo odoo.py: return f(self, *args, **kwargs)

May 12 09:11:40 odoo odoo.py: File "/usr/lib/python2.7/site-packages/openerp/sql_db.py", line 220, in execute

May 12 09:11:40 odoo odoo.py: res = self._obj.execute(query, params)

May 12 09:11:40 odoo odoo.py: ParseError: "null value in column "name" violates not-null constraint

May 12 09:11:40 odoo odoo.py: DETAIL:  Failing row contains (749, null, null, null, 1, null, null, null, 1, 1, t, null, 2016-05-12 13:11:40.204732, 2016-05-12 13:11:40.204732, 770, t, t, null, null, null, null).

May 12 09:11:40 odoo odoo.py: " while parsing /usr/lib/python2.7/site-packages/openerp/addons/crm/crm_data.xml:16, near

May 12 09:11:40 odoo odoo.py: <record model="crm.team" id="sales_team.team_sales_department">

May 12 09:11:40 odoo odoo.py: <field name="use_leads">True</field>

May 12 09:11:40 odoo odoo.py: <field name="alias_name">sales</field>

May 12 09:11:40 odoo odoo.py: </record>

Enjoying the discussion? Don't just read, join in!

Create an account today to enjoy exclusive features and engage with our awesome community!

Přihlásit se

Related Posts	Odpovědi	Zobrazení
500: Internal Server Error 500	4 zář 24	3122
odoo 500 error connecting to postgresql server 500	0 čvc 20	6377
¿How i can solve a 500 Internal Server Error after create Data base? 500	2 bře 15	11952
500: Internal Server Error - website.layout 500 website.layout	2 bře 24	4034
Error 500 on Ubuntu - Odoo Server 15.0 Vyřešeno 500 error-500	1 pro 21	5024

This question has been flagged

Internal Server Error

Enjoying the discussion? Don't just read, join in!