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

CRM
e-Commerce
Contabilitate
Inventar
PoS
Proiect
MRP

All apps

All Posts Oameni Insigne

Etichete (View all)

odoo accounting v14 pos v15

Despre acest forum

Suport

Error while trying to create new field for sale subscription

modules error fields subscription constraints

2 Răspunsuri

5124 Vizualizări

arthur

Hello,

I am trying to add a new field to the subscription module, to then display it on the subscription form view. However, I am getting an error while trying to update my module in order to insert the new field.

Here is my model code:

class SaleSubscription(models.Model):

_inherit = 'sale.subscription'

actual_next_delivery_date= fields.Date(string='Data da próxima entrega', default=fields.Date.today, help="Data da próxima entrega.")

And here is the .xml file:

<?xml version="1.0" encoding="utf-8"?>

<odoo>

<data>

<field name="name">actual_next_delivery_date</field>

</record>

</data>

</odoo>

The error thrown is the following:

2019-01-07 19:36:21,496 9183 ERROR RaizsOdoo werkzeug: Error on request:

Traceback (most recent call last):

File "/home/arthur/.local/lib/python3.5/site-packages/werkzeug/serving.py", line 177, in run_wsgi

execute(self.server.app)

File "/home/arthur/.local/lib/python3.5/site-packages/werkzeug/serving.py", line 165, in execute

application_iter = app(environ, start_response)

File "/usr/lib/python3/dist-packages/odoo/service/server.py", line 260, in app

return self.app(e, s)

File "/usr/lib/python3/dist-packages/odoo/service/wsgi_server.py", line 166, in application

return application_unproxied(environ, start_response)

File "/usr/lib/python3/dist-packages/odoo/service/wsgi_server.py", line 154, in application_unproxied

result = handler(environ, start_response)

File "/usr/lib/python3/dist-packages/odoo/http.py", line 1318, in __call__

return self.dispatch(environ, start_response)

File "/usr/lib/python3/dist-packages/odoo/http.py", line 1292, in __call__

return self.app(environ, start_wrapped)

File "/home/arthur/.local/lib/python3.5/site-packages/werkzeug/wsgi.py", line 588, in __call__

return self.app(environ, start_response)

File "/usr/lib/python3/dist-packages/odoo/http.py", line 1473, in dispatch

odoo.registry(db).check_signaling()

File "/usr/lib/python3/dist-packages/odoo/__init__.py", line 76, in registry

return modules.registry.Registry(database_name)

File "/usr/lib/python3/dist-packages/odoo/modules/registry.py", line 61, in __new__

return cls.new(db_name)

File "/usr/lib/python3/dist-packages/odoo/modules/registry.py", line 85, in new

odoo.modules.load_modules(registry._db, force_demo, status, update_module)

File "/usr/lib/python3/dist-packages/odoo/modules/loading.py", line 376, in load_modules

force, status, report, loaded_modules, update_module, models_to_check)

File "/usr/lib/python3/dist-packages/odoo/modules/loading.py", line 274, in load_marked_modules

perform_checks=perform_checks, models_to_check=models_to_check

File "/usr/lib/python3/dist-packages/odoo/modules/loading.py", line 181, in load_module_graph

_load_data(cr, module_name, idref, mode, kind='data')

File "/usr/lib/python3/dist-packages/odoo/modules/loading.py", line 95, in _load_data

tools.convert_file(cr, module_name, filename, idref, mode, noupdate, kind, report)

File "/usr/lib/python3/dist-packages/odoo/tools/convert.py", line 791, in convert_file

convert_xml_import(cr, module, fp, idref, mode, noupdate, report)

File "/usr/lib/python3/dist-packages/odoo/tools/convert.py", line 852, in convert_xml_import

obj.parse(doc.getroot(), mode=mode)

File "/usr/lib/python3/dist-packages/odoo/tools/convert.py", line 741, in parse

self.parse(rec, mode)

File "/usr/lib/python3/dist-packages/odoo/tools/convert.py", line 751, in parse

exc_info[2]

File "/usr/lib/python3/dist-packages/odoo/tools/pycompat.py", line 86, in reraise

raise value.with_traceback(tb)

File "/usr/lib/python3/dist-packages/odoo/tools/convert.py", line 744, in parse

self._tags[rec.tag](rec, de, mode=mode)

File "/usr/lib/python3/dist-packages/odoo/tools/convert.py", line 654, in _tag_record

id = self.env(context=rec_context)['ir.model.data']._update(rec_model, self.module, res, rec_id or False, not self.isnoupdate(data_node), noupdate=self.isnoupdate(data_node), mode=self.mode)

File "/usr/lib/python3/dist-packages/odoo/addons/base/ir/ir_model.py", line 1488, in _update

record = record.create(values)

File "/usr/lib/python3/dist-packages/odoo/addons/sale_subscription/models/sale_subscription.py", line 208, in create

subscription = super(SaleSubscription, self).create(vals)

File "/usr/lib/python3/dist-packages/odoo/addons/mail/models/mail_thread.py", line 236, in create

thread = super(MailThread, self).create(values)

File "/usr/lib/python3/dist-packages/odoo/models.py", line 3372, in create

record = self.browse(self._create(old_vals))

File "/usr/lib/python3/dist-packages/odoo/models.py", line 3465, in _create

cr.execute(query, tuple(u[2] for u in updates if len(u) > 2))

File "/usr/lib/python3/dist-packages/odoo/sql_db.py", line 155, in wrapper

return f(self, *args, **kwargs)

File "/usr/lib/python3/dist-packages/odoo/sql_db.py", line 232, in execute

res = self._obj.execute(query, params)

odoo.tools.convert.ParseError: "null value in column "partner_id" violates not-null constraint

DETAIL: Failing row contains (253, actual_next_delivery_date, SUB253, draft, null, 1, null, 2019-01-07, null, null, 2019-01-07, null, null, null, null, null, null, null, null, 96e542d3-9c15-42d4-8895-511d1549cfb8, null, null, null, 1, 2019-01-07 19:36:21.228204, 1, 2019-01-07 19:36:21.228204, null, null, null, null, null, null, null, null, null, 2019-01-07).

" while parsing /home/arthur/theVelopment/raizs/raizs/vtex_subscription/views/subscriptions_fields.xml:4, near

<field name="name">actual_next_delivery_date</field>

</record>

Any idea on what I am missing here?

Thanks in advance!

Ray Carnes (ray)

Cel mai bun răspuns

Your XML file is actually trying to create a new sale.subscription record and failing because you need another value, the partner_id. You are telling Odoo that the name of the subscription is actual_next_delivery_date because that's the value you are sending to the name field.

Once you have added the field to the model (via Python) you need to add it to a VIEW via View Inheritance.

Your record tag needs to modify an existing ir.ui.view record rather than add a new sale.subscription record.

Take a look at the documentation, or some existing modules, to learn how to do this.

https://www.odoo.com/documentation/12.0/howtos/backend.html#view-inheritance

arthur

Autor

I missed the first part of the error, which is:

RaizsOdoo odoo.sql_db: bad query: b'INSERT INTO "sale_subscription" ("id", "uuid", "actual_next_delivery_date", "recurring_next_date", "date_start", "name", "state", "code", "company_id", "create_uid", "write_uid", "create_date", "write_date") VALUES(nextval(\'sale_subscription_id_seq\'), \'76e9f278-657e-44dd-b77a-46644b0df9bc\', \'2019-01-07\', \'2019-01-07\', \'2019-01-07\', \'actual_next_delivery_date\', \'draft\', \'SUB252\', 1, 1, 1, (now() at time zone \'UTC\'), (now() at time zone \'UTC\')) RETURNING id'

ERROR: null value in column "partner_id" violates not-null constraint

DETAIL: Failing row contains (252, actual_next_delivery_date, SUB252, draft, null, 1, null, 2019-01-07, null, null, 2019-01-07, null, null, null, null, null, null, null, null, 76e9f278-657e-44dd-b77a-46644b0df9bc, null, null, null, 1, 2019-01-07 19:36:20.214084, 1, 2019-01-07 19:36:20.214084, null, null, null, null, null, null, null, null, null, 2019-01-07).

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

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

Înscrie-te

Related Posts	Răspunsuri	Vizualizări
Field does not exist error on inherited view Rezolvat modules error fields inherit	8 iun. 18	49759
odoo custom modul update problem Rezolvat modules error fields install odoo10	7 oct. 18	11676
I cannot create a new database after paying subscription error subscription	1 dec. 23	2974
No module named pooler Rezolvat modules error	5 dec. 23	20327
invalid module names, ignored: invreport Rezolvat modules error importing	1 apr. 25	2085

Această întrebare a fost marcată

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