← Back to team overview

c2c-oerpscenario team mailing list archive

  1. c2c-oerpscenario team
  2. Mailing list archive
  3. Message #35893

[Bug 882827] [NEW] Updating 6.0 database to expirimental branch missing attribute columns

  Thread Previous • Date Previous • • Thread Next 
Public bug reported:

When I migrated a large database to Seb, branches I get problems when
trying to load product.product form

2011-10-27 17:31:08,902][midwestsupplies] ERROR:db.cursor:Programming error: column product_template.x_js_magerp_x_beer_kit_activator does not exist
LINE 1: ...t_template.x_js_magerp_x_use_config_is_redeemable,product_te...
                                                             ^
, in query SELECT product_template.warranty,product_template.supply_method,product_template.uos_id,product_template.list_price,product_template.x_js_magerp_x_beer_kit_white_labs,product_template.standard_price,product_template.cost_method,product_template.x_js_magerp_x_open_amount_min,product_template.company_id,product_template.mes_type,product_template.uom_id,product_template.set,product_template.description_purchase,product_template.x_js_magerp_x_upsell_targetrule_position_behavior,product_template.code_generator,product_template.uos_coeff,product_template.x_js_magerp_x_recurring_profile,product_template.x_js_magerp_x_allow_open_amount,product_template.sale_ok,product_template.purchase_ok,product_template.product_manager,product_template.x_js_magerp_x_gift_wrapping_available,product_template.produce_delay,product_template.state,product_template.x_js_magerp_x_related_targetrule_position_behavior,product_template.loc_rack,product_template.x_js_magerp_x_is_recurring,product_template.uom_po_id,product_template.type,product_template.x_js_magerp_x_use_config_allow_message,product_template.x_js_magerp_x_is_redeemable,product_template.variant_model_name,product_template.description,product_template.variant_track_outgoing,product_template.weight_net,product_template.x_js_magerp_x_open_amount_max,product_template.weight,product_template.x_js_magerp_x_downloads_title,product_template.x_js_magerp_x_use_config_lifetime,product_template.variant_track_production,product_template.x_js_magerp_x_use_config_email_template,product_template.procure_method,product_template.x_js_magerp_x_is_imported,product_template.loc_row,product_template.variant_model_name_separator,product_template.x_js_magerp_x_gift_wrapping_price,product_template.rental,product_template.volume,product_template.x_js_magerp_x_upsell_targetrule_position_limit,product_template.sale_delay,product_template.loc_case,product_template.x_js_magerp_x_giftcard_type,product_template.x_js_magerp_x_lifetime,product_template.description_sale,product_template.x_js_magerp_x_email_template,product_template.x_js_magerp_x_allow_message,product_template.categ_id,product_template.magerp_tmpl,product_template.x_js_magerp_x_beer_kit_premium_dry,product_template.is_multi_variants,product_template.x_js_magerp_x_giftcard_amounts,product_template.x_js_magerp_x_related_targetrule_position_limit,product_template.variant_track_incoming,product_template.x_js_magerp_x_use_config_is_redeemable,product_template.x_js_magerp_x_beer_kit_activator,product_template.id FROM "product_template" WHERE product_template.id IN %s ORDER BY id
[2011-10-27 17:31:08,903][midwestsupplies] ERROR:web-services:Uncaught exception
Traceback (most recent call last):
  File "/usr/local/openerp/openerp-server/bin/osv/osv.py", line 122, in wrapper
    return f(self, dbname, *args, **kwargs)
  File "/usr/local/openerp/openerp-server/bin/osv/osv.py", line 176, in execute
    res = self.execute_cr(cr, uid, obj, method, *args, **kw)
  File "/usr/local/openerp/openerp-server/bin/osv/osv.py", line 167, in execute_cr
    return getattr(object, method)(cr, uid, *args, **kw)
  File "/usr/local/openerp/openerp-server/bin/osv/orm.py", line 2970, in read
    result = self._read_flat(cr, user, select, fields, context, load)
  File "/usr/local/openerp/openerp-server/bin/osv/orm.py", line 3090, in _read_flat
    res2 = self._columns[f].get(cr, self, ids, f, user, context=context, values=res)
  File "/usr/local/openerp/openerp-server/bin/osv/fields.py", line 815, in get
    res = self._fnct(obj, cr, user, ids, name, self._arg, context)
  File "/usr/local/openerp/addons/product_variant_multi/product_variant.py", line 496, in _product_lst_price
    result = super(product_product, self)._product_lst_price(cr, uid, ids, name, arg, context=context)
  File "/usr/local/openerp/addons/product/product.py", line 421, in _product_lst_price
    res[product.id] = product.list_price
  File "/usr/local/openerp/openerp-server/bin/osv/orm.py", line 292, in __getattr__
    return self[name]
  File "/usr/local/openerp/openerp-server/bin/osv/orm.py", line 205, in __getitem__
    field_values = self._table.read(self._cr, self._uid, ids, field_names, context=self._context, load="_classic_write")
  File "/usr/local/openerp/openerp-server/bin/osv/orm.py", line 2970, in read
    result = self._read_flat(cr, user, select, fields, context, load)
  File "/usr/local/openerp/openerp-server/bin/osv/orm.py", line 3049, in _read_flat
    res2 = self.pool.get(table).read(cr, user, [x[col] for x in res], cols, context, load)
  File "/usr/local/openerp/openerp-server/bin/osv/orm.py", line 2970, in read
    result = self._read_flat(cr, user, select, fields, context, load)
  File "/usr/local/openerp/openerp-server/bin/osv/orm.py", line 3029, in _read_flat
    cr.execute(query, (tuple(sub_ids),))
  File "/usr/local/openerp/openerp-server/bin/sql_db.py", line 78, in wrapper
    return f(self, *args, **kwargs)
  File "/usr/local/openerp/openerp-server/bin/sql_db.py", line 131, in execute
    res = self._obj.execute(query, params)
ProgrammingError: column product_template.x_js_magerp_x_beer_kit_activator does not exist
LINE 1: ...t_template.x_js_magerp_x_use_config_is_redeemable,product_te...


I had to manually create about 20 columns in product_template.

** Affects: magentoerpconnect
     Importance: Undecided
         Status: New

-- 
You received this bug notification because you are a member of C2C
OERPScenario, which is subscribed to OpenERP Project Group.
https://bugs.launchpad.net/bugs/882827

Title:
  Updating 6.0 database to expirimental branch missing attribute columns

Status in Magento OpenERP Connector:
  New

Bug description:
  When I migrated a large database to Seb, branches I get problems when
  trying to load product.product form

  2011-10-27 17:31:08,902][midwestsupplies] ERROR:db.cursor:Programming error: column product_template.x_js_magerp_x_beer_kit_activator does not exist
  LINE 1: ...t_template.x_js_magerp_x_use_config_is_redeemable,product_te...
                                                               ^
  , in query SELECT product_template.warranty,product_template.supply_method,product_template.uos_id,product_template.list_price,product_template.x_js_magerp_x_beer_kit_white_labs,product_template.standard_price,product_template.cost_method,product_template.x_js_magerp_x_open_amount_min,product_template.company_id,product_template.mes_type,product_template.uom_id,product_template.set,product_template.description_purchase,product_template.x_js_magerp_x_upsell_targetrule_position_behavior,product_template.code_generator,product_template.uos_coeff,product_template.x_js_magerp_x_recurring_profile,product_template.x_js_magerp_x_allow_open_amount,product_template.sale_ok,product_template.purchase_ok,product_template.product_manager,product_template.x_js_magerp_x_gift_wrapping_available,product_template.produce_delay,product_template.state,product_template.x_js_magerp_x_related_targetrule_position_behavior,product_template.loc_rack,product_template.x_js_magerp_x_is_recurring,product_template.uom_po_id,product_template.type,product_template.x_js_magerp_x_use_config_allow_message,product_template.x_js_magerp_x_is_redeemable,product_template.variant_model_name,product_template.description,product_template.variant_track_outgoing,product_template.weight_net,product_template.x_js_magerp_x_open_amount_max,product_template.weight,product_template.x_js_magerp_x_downloads_title,product_template.x_js_magerp_x_use_config_lifetime,product_template.variant_track_production,product_template.x_js_magerp_x_use_config_email_template,product_template.procure_method,product_template.x_js_magerp_x_is_imported,product_template.loc_row,product_template.variant_model_name_separator,product_template.x_js_magerp_x_gift_wrapping_price,product_template.rental,product_template.volume,product_template.x_js_magerp_x_upsell_targetrule_position_limit,product_template.sale_delay,product_template.loc_case,product_template.x_js_magerp_x_giftcard_type,product_template.x_js_magerp_x_lifetime,product_template.description_sale,product_template.x_js_magerp_x_email_template,product_template.x_js_magerp_x_allow_message,product_template.categ_id,product_template.magerp_tmpl,product_template.x_js_magerp_x_beer_kit_premium_dry,product_template.is_multi_variants,product_template.x_js_magerp_x_giftcard_amounts,product_template.x_js_magerp_x_related_targetrule_position_limit,product_template.variant_track_incoming,product_template.x_js_magerp_x_use_config_is_redeemable,product_template.x_js_magerp_x_beer_kit_activator,product_template.id FROM "product_template" WHERE product_template.id IN %s ORDER BY id
  [2011-10-27 17:31:08,903][midwestsupplies] ERROR:web-services:Uncaught exception
  Traceback (most recent call last):
    File "/usr/local/openerp/openerp-server/bin/osv/osv.py", line 122, in wrapper
      return f(self, dbname, *args, **kwargs)
    File "/usr/local/openerp/openerp-server/bin/osv/osv.py", line 176, in execute
      res = self.execute_cr(cr, uid, obj, method, *args, **kw)
    File "/usr/local/openerp/openerp-server/bin/osv/osv.py", line 167, in execute_cr
      return getattr(object, method)(cr, uid, *args, **kw)
    File "/usr/local/openerp/openerp-server/bin/osv/orm.py", line 2970, in read
      result = self._read_flat(cr, user, select, fields, context, load)
    File "/usr/local/openerp/openerp-server/bin/osv/orm.py", line 3090, in _read_flat
      res2 = self._columns[f].get(cr, self, ids, f, user, context=context, values=res)
    File "/usr/local/openerp/openerp-server/bin/osv/fields.py", line 815, in get
      res = self._fnct(obj, cr, user, ids, name, self._arg, context)
    File "/usr/local/openerp/addons/product_variant_multi/product_variant.py", line 496, in _product_lst_price
      result = super(product_product, self)._product_lst_price(cr, uid, ids, name, arg, context=context)
    File "/usr/local/openerp/addons/product/product.py", line 421, in _product_lst_price
      res[product.id] = product.list_price
    File "/usr/local/openerp/openerp-server/bin/osv/orm.py", line 292, in __getattr__
      return self[name]
    File "/usr/local/openerp/openerp-server/bin/osv/orm.py", line 205, in __getitem__
      field_values = self._table.read(self._cr, self._uid, ids, field_names, context=self._context, load="_classic_write")
    File "/usr/local/openerp/openerp-server/bin/osv/orm.py", line 2970, in read
      result = self._read_flat(cr, user, select, fields, context, load)
    File "/usr/local/openerp/openerp-server/bin/osv/orm.py", line 3049, in _read_flat
      res2 = self.pool.get(table).read(cr, user, [x[col] for x in res], cols, context, load)
    File "/usr/local/openerp/openerp-server/bin/osv/orm.py", line 2970, in read
      result = self._read_flat(cr, user, select, fields, context, load)
    File "/usr/local/openerp/openerp-server/bin/osv/orm.py", line 3029, in _read_flat
      cr.execute(query, (tuple(sub_ids),))
    File "/usr/local/openerp/openerp-server/bin/sql_db.py", line 78, in wrapper
      return f(self, *args, **kwargs)
    File "/usr/local/openerp/openerp-server/bin/sql_db.py", line 131, in execute
      res = self._obj.execute(query, params)
  ProgrammingError: column product_template.x_js_magerp_x_beer_kit_activator does not exist
  LINE 1: ...t_template.x_js_magerp_x_use_config_is_redeemable,product_te...

  
  I had to manually create about 20 columns in product_template.

To manage notifications about this bug go to:
https://bugs.launchpad.net/magentoerpconnect/+bug/882827/+subscriptions

Follow ups

References

  Thread Previous • Date Previous • • Thread Next