psycopg2.errors.UndefinedTable: relation "product_product_res_config_settings_rel" does not exist Odoo 15

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

CRM
e-Commerce
Accounting
Inventory
PoS
Project management
MRP

Take the tour

Posts People Badges

Tags View all

odoo accounting v7 pos invoice

About this forum

Help

psycopg2.errors.UndefinedTable: relation "product_product_res_config_settings_rel" does not exist Odoo 15

3 Replies

6306 Views

settings many2many odoo15

fudo

In odoo 15, i got the issue after trying to create Many2many field in settings:

psycopg2.errors.UndefinedTable: relation "product_product_res_config_settings_rel" does not exist

My code:

from odoo import api, fields, models
from ast import literal_eval

class SchoolSettings(models.TransientModel):
    _inherit = 'res.config.settings'

    product_default = fields.Many2many('product.product', string='Default Product')

    @api.model
    def get_values(self):
        res = super(SchoolSettings, self).get_values()
        if self.env['ir.config_parameter'].sudo().get_param('school.school_default_teacher'):
            product_default = self.env['ir.config_parameter'].sudo().get_param('school.product_default')
            res.update(
                product_default=[(6, 0, literal_eval(product_default))]
            )

        return res


    def set_values(self):
        super(SchoolSettings, self).set_values()
        self.env['ir.config_parameter'].set_param('school.product_default', self.product_default.ids)

Xml:

<div class="content-group">

    <label string="Default Product" for="product_default"/>

    <field name="product_default" widget="many2many_tags"/>

</div>

Please help, thanks.

Sehrish

many2many field in Odoo: https://learnopenerp.blogspot.com/2018/12/add-domain-on-many2many-field-in-odoo.html

fudo

Author Best Answer

I've found the answer based on "Kiran K" answer:

from odoo import api, fields, models
from ast import literal_eval

class SchoolSettings(models.TransientModel):
    _inherit = 'res.config.settings'

    # many2many will give you multiselect options, when many2one only give you select option
    # to use many2many, we must declare the middle table to connect 2 tables together.
    # in this example, i create a new table named 'config_product_rel'
    # with 2 column connect 2 table that is 'id' for the 'ir_config_parameter' table
    # and 'product_id' for 'product_product' table
    product_default_many2many = fields.Many2many('product.product', 'config_product_rel', 'id', 'product_id',
                  'Default Product Many2many')

    @api.model
    def get_values(self):
        res = super(SchoolSettings, self).get_values()

        # set values for many2many field
        if self.env['ir.config_parameter'].sudo().get_param('school.product_default_many2many'):
            product_default_many2many = self.env['ir.config_parameter'].sudo().get_param('school.product_default_many2many')
            res['product_default_many2many'] = [(6, 0, literal_eval(product_default_many2many))]

        return res


    def set_values(self):
        # get values for many2many field
        self.env['ir.config_parameter'].set_param('school.product_default_many2many', self.product_default_many2many.ids)

Thanks.

Kiran K

Hi fudo,

Try,

class ResCompany(models.Model):
    _inherit = 'res.company'

    def _active_products(self):
        return self.env['product.product'].search([]).ids

    product_ids = fields.Many2many('product.product', 'company_product_rel', 'company_id', 'product_id',
                  'Default Product',default=_active_products)


class ResConfigSettings(models.TransientModel):
    _inherit = 'res.config.settings'

    product_ids = fields.Many2many(related='company_id.product_ids', relation='product.product', readonly=False)

Hope it helps,
Kiran K