c2c-oerpscenario team mailing list archive

[YannickB <yannick.buron@xxxxxxxxxxx>]

I confirm, it works with a minimal install. I have no idea what module
made the bug.

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

Title:
  Variable type error when trying to install on Version 6

Status in Magento Open ERP Connector:
  New

Bug description:
  When trying to install magento_connector module on Version 6, i get
  the following error

  [2010-10-08 18:13:46,439][magentotest] ERROR:db.cursor:bad query: ALTER TABLE sale_order_line ALTER COLUMN discount TYPE numeric(16,6);
  Traceback (most recent call last):
    File "/opt/openerp/openobject-server/bin/sql_db.py", line 122, in execute
      res = self._obj.execute(query, params)
  NotSupportedError: cannot alter type of a column used by a view or rule
  DETAIL:  rule _RETURN on view sale_journal_picking_report depends on column "discount"

  [2010-10-08 18:13:46,440][magentotest] ERROR:web-services:Uncaught exception
  Traceback (most recent call last):
    File "/opt/openerp/openobject-server/bin/osv/osv.py", line 57, in wrapper
      return f(self, dbname, *args, **kwargs)
    File "/opt/openerp/openobject-server/bin/osv/osv.py", line 140, in execute
      res = pool.execute_cr(cr, uid, obj, method, *args, **kw)
    File "/opt/openerp/openobject-server/bin/osv/osv.py", line 130, in execute_cr
      return getattr(object, method)(cr, uid, *args, **kw)
    File "/opt/openerp/openobject-server/bin/addons/base/module/wizard/base_module_upgrade.py", line 101, in upgrade_module
      db, pool = pooler.restart_pool(cr.dbname, update_module=True)
    File "/opt/openerp/openobject-server/bin/pooler.py", line 61, in restart_pool
      return get_db_and_pool(db_name, force_demo, status, update_module=update_module)
    File "/opt/openerp/openobject-server/bin/pooler.py", line 39, in get_db_and_pool
      addons.load_modules(db, force_demo, status, update_module)
    File "/opt/openerp/openobject-server/bin/addons/__init__.py", line 842, in load_modules
      r = load_module_graph(cr, graph, status, report=report)
    File "/opt/openerp/openobject-server/bin/addons/__init__.py", line 690, in load_module_graph
      init_module_objects(cr, package.name, modules)
    File "/opt/openerp/openobject-server/bin/addons/__init__.py", line 394, in init_module_objects
      result = obj._auto_init(cr, {'module': module_name})
    File "/opt/openerp/addons/magentoerpconnect/sale.py", line 184, in _auto_init
      cr.execute("ALTER TABLE sale_order_line ALTER COLUMN discount TYPE numeric(16,6);")
    File "/opt/openerp/openobject-server/bin/sql_db.py", line 75, in wrapper
      return f(self, *args, **kwargs)
    File "/opt/openerp/openobject-server/bin/sql_db.py", line 122, in execute
      res = self._obj.execute(query, params)
  NotSupportedError: cannot alter type of a column used by a view or rule
  DETAIL:  rule _RETURN on view sale_journal_picking_report depends on column "discount"