コンテンツへスキップ
メニュー
この質問にフラグが付けられました
1046 ビュー

class MyProductTemplate(models.Model): _name="my.product" _inherit = "product.template"


name_of_the_prod = fields.Char(string="Product Name") taxes_id = fields.Many2many('account.tax', 'products_taxe_rel', 'prod_ids', 'tax_ids', help="Default taxes used when selling the product.", string='Customer Taxes', domain=[('type_tax_use', '=', 'sale')], default=lambda self: self.env.company.account_sale_tax_id,) supplier_taxes_id = fields.Many2many('account.tax', 'products_supplier_taxe_rel', 'prods_id', 'taxs_id', string='Vendor Taxes', help='Default taxes used when buying the product.', domain=[('type_tax_use', '=', 'purchase')], default=lambda self: self.env.company.account_purchase_tax_id) route_ids = fields.Many2many( 'stock.location.route', 'stocks_route_product_rel', 'products_id', 'routes_id', 'Routes', domain=[('product_selectable', '=', True)], help="Depending on the modules installed, this will allow you to define the route of the product: whether it will be bought, manufactured, replenished on order, etc.") alternative_product_ids = fields.Many2many( 'product.template', 'products_alternatives_rels', 'srcs_id', 'dests_id', check_company=True, string='Alternative Products', help='Suggest alternatives to your customer (upsell strategy). ' 'Those products show up on the product page.') accessory_product_ids = fields.Many2many( 'product.product', 'products_accessorys_rels', 'srcs_id', 'dests_id', string='Accessory Products', check_company=True, help='Accessories show up when the customer reviews the cart before payment (cross-sell strategy).')   


I am getting error like 

Odoo Server Error
Traceback (most recent call last):
  File "/home/localadmin/odoo-dev/odoo/odoo/addons/base/models/ir_http.py", line 237, in _dispatch
    result = request.dispatch()
  File "/home/localadmin/odoo-dev/odoo/odoo/http.py", line 684, in dispatch
    result = self._call_function(**self.params)
  File "/home/localadmin/odoo-dev/odoo/odoo/http.py", line 360, in _call_function
    return checked_call(self.db, *args, **kwargs)
  File "/home/localadmin/odoo-dev/odoo/odoo/service/model.py", line 94, in wrapper
    return f(dbname, *args, **kwargs)
  File "/home/localadmin/odoo-dev/odoo/odoo/http.py", line 348, in checked_call
    result = self.endpoint(*a, **kw)
  File "/home/localadmin/odoo-dev/odoo/odoo/http.py", line 913, in __call__
    return self.method(*args, **kw)
  File "/home/localadmin/odoo-dev/odoo/odoo/http.py", line 532, in response_wrap
    response = f(*args, **kw)
  File "/home/localadmin/odoo-dev/odoo/addons/web/controllers/main.py", line 1393, in call_button
    action = self._call_kw(model, method, args, kwargs)
  File "/home/localadmin/odoo-dev/odoo/addons/web/controllers/main.py", line 1381, in _call_kw
    return call_kw(request.env[model], method, args, kwargs)
  File "/home/localadmin/odoo-dev/odoo/odoo/api.py", line 399, in call_kw
    result = _call_kw_multi(method, model, args, kwargs)
  File "/home/localadmin/odoo-dev/odoo/odoo/api.py", line 386, in _call_kw_multi
    result = method(recs, *args, **kwargs)
  File "<decorator-gen-71>", line 2, in button_immediate_install
  File "/home/localadmin/odoo-dev/odoo/odoo/addons/base/models/ir_module.py", line 74, in check_and_log
    return method(self, *args, **kwargs)
  File "/home/localadmin/odoo-dev/odoo/odoo/addons/base/models/ir_module.py", line 475, in button_immediate_install
    return self._button_immediate_function(type(self).button_install)
  File "/home/localadmin/odoo-dev/odoo/odoo/addons/base/models/ir_module.py", line 593, in _button_immediate_function
    modules.registry.Registry.new(self._cr.dbname, update_module=True)
  File "/home/localadmin/odoo-dev/odoo/odoo/modules/registry.py", line 89, in new
    odoo.modules.load_modules(registry._db, force_demo, status, update_module)
  File "/home/localadmin/odoo-dev/odoo/odoo/modules/loading.py", line 459, in load_modules
    processed_modules += load_marked_modules(cr, graph,
  File "/home/localadmin/odoo-dev/odoo/odoo/modules/loading.py", line 347, in load_marked_modules
    loaded, processed = load_module_graph(
  File "/home/localadmin/odoo-dev/odoo/odoo/modules/loading.py", line 199, in load_module_graph
    registry.init_models(cr, model_names, {'module': package.name}, new_install)
  File "/home/localadmin/odoo-dev/odoo/odoo/modules/registry.py", line 419, in init_models
    self.check_foreign_keys(cr)
  File "/home/localadmin/odoo-dev/odoo/odoo/modules/registry.py", line 496, in check_foreign_keys
    sql.add_foreign_key(cr, table1, column1, table2, column2, ondelete)
  File "/home/localadmin/odoo-dev/odoo/odoo/tools/sql.py", line 170, in add_foreign_key
    cr.execute(query.format(tablename1, columnname1, tablename2, columnname2, ondelete))
  File "<decorator-gen-3>", line 2, in execute
  File "/home/localadmin/odoo-dev/odoo/odoo/sql_db.py", line 101, in check
    return f(self, *args, **kwargs)
  File "/home/localadmin/odoo-dev/odoo/odoo/sql_db.py", line 298, in execute
    res = self._obj.execute(query, params)
Exception

The above exception was the direct cause of the following exception:

Traceback (most recent call last):
  File "/home/localadmin/odoo-dev/odoo/odoo/http.py", line 640, in _handle_exception
    return super(JsonRequest, self)._handle_exception(exception)
  File "/home/localadmin/odoo-dev/odoo/odoo/http.py", line 316, in _handle_exception
    raise exception.with_traceback(None) from new_cause
psycopg2.errors.UndefinedColumn: column "my_product_id" referenced in foreign key constraint does not exist

Please help me to solve this 

アバター
破棄
関連投稿 返信 ビュー 活動
1
8月 24
4134
2
6月 24
3262
0
3月 23
1816
1
7月 23
1551
0
12月 23
1328