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.
