Skip to Content
This question has been flagged
500DBexception
5 Replies
3724 Views
Avatar
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.

Avatar
Discard
Ermin Trevisan

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

OdooBot
If I ever know, i'll tell you.
ᐧ

Merci.

           Yann.
https://e-soft.ca
Linkedin Twitter Facebook Google+


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.

Avatar
Vincent Goineau
Best Answer

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>

-->
Avatar
Discard
Avatar
Yann de Champlain
Author Best Answer

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>
Avatar
Discard
Related Posts Replies Views Activity
500: Internal Server Error
500
Avatar
Avatar
Avatar
Avatar
4
Sep 24
320
odoo 500 error connecting to postgresql server
500
Avatar
0
Jul 20
3738
¿How i can solve a 500 Internal Server Error after create Data base?
500
Avatar
Avatar
2
Mar 15
9534
500: Internal Server Error - website.layout
500 website.layout
Avatar
Avatar
2
Mar 24
846
Error 500 on Ubuntu - Odoo Server 15.0 Solved
500 error-500
Avatar
Avatar
1
Dec 21
2430