c2c-oerpscenario team mailing list archive

[Thomas Dreiling <790243@xxxxxxxxxxxxxxxxxx>]

Public bug reported:

1) Install the sale_journal module, then try to install the magentoerpconnect module
2) Result:
INFO:init:module magentoerpconnect: creating or updating database tables
Traceback (most recent call last):
  File "./openerp-server.py", line 102, in <module>
    pooler.get_db_and_pool(db, update_module=tools.config['init'] or tools.config['update'])
  File "/usr/local/lib/python2.6/dist-packages/openerp-server/pooler.py", line 40, in get_db_and_pool
    addons.load_modules(db, force_demo, status, update_module)
  File "/usr/local/lib/python2.6/dist-packages/openerp-server/addons/__init__.py", line 736, in load_modules
    r = load_module_graph(cr, graph, status, report=report)
  File "/usr/local/lib/python2.6/dist-packages/openerp-server/addons/__init__.py", line 579, in load_module_graph
    init_module_objects(cr, package.name, modules)
  File "/usr/local/lib/python2.6/dist-packages/openerp-server/addons/__init__.py", line 362, in init_module_objects
    result = obj._auto_init(cr, {'module': module_name})
  File "/usr/local/lib/python2.6/dist-packages/openerp-server/addons/magentoerpconnect/sale.py", line 239, in _auto_init
    cr.execute("ALTER TABLE sale_order_line ALTER COLUMN discount TYPE numeric(16,6);")
  File "/usr/local/lib/python2.6/dist-packages/openerp-server/sql_db.py", line 78, in wrapper
    return f(self, *args, **kwargs)
  File "/usr/local/lib/python2.6/dist-packages/openerp-server/sql_db.py", line 123, in execute
    res = self._obj.execute(query, params)
psycopg2.NotSupportedError: FEHLER:  Typ einer Spalte, die von einer Sicht oder Regel verwendet wird, kann nicht geändert werden
DETAIL:  Regel _RETURN für Sicht sale_journal_picking_stats hängt von Spalte »discount« ab
4) Platform: Debian (Squeeze): Linux openerp 2.6.32-5-amd64 #1 SMP Wed Jan 12 03:40:32 UTC 2011 x86_64 GNU/Linux
5) INFO:server:version - 5.0.15

Culprit: Line no. 239 in sale.py: cr.execute("ALTER TABLE
sale_order_line ALTER COLUMN discount TYPE numeric(16,6);")

** Affects: openobject-addons
     Importance: Undecided
         Status: New

-- 
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/790243

Title:
  magentoerpconnect conflicts with sale_journal

Status in OpenERP Modules (addons):
  New

Bug description:
  1) Install the sale_journal module, then try to install the magentoerpconnect module
  2) Result:
  INFO:init:module magentoerpconnect: creating or updating database tables
  Traceback (most recent call last):
    File "./openerp-server.py", line 102, in <module>
      pooler.get_db_and_pool(db, update_module=tools.config['init'] or tools.config['update'])
    File "/usr/local/lib/python2.6/dist-packages/openerp-server/pooler.py", line 40, in get_db_and_pool
      addons.load_modules(db, force_demo, status, update_module)
    File "/usr/local/lib/python2.6/dist-packages/openerp-server/addons/__init__.py", line 736, in load_modules
      r = load_module_graph(cr, graph, status, report=report)
    File "/usr/local/lib/python2.6/dist-packages/openerp-server/addons/__init__.py", line 579, in load_module_graph
      init_module_objects(cr, package.name, modules)
    File "/usr/local/lib/python2.6/dist-packages/openerp-server/addons/__init__.py", line 362, in init_module_objects
      result = obj._auto_init(cr, {'module': module_name})
    File "/usr/local/lib/python2.6/dist-packages/openerp-server/addons/magentoerpconnect/sale.py", line 239, in _auto_init
      cr.execute("ALTER TABLE sale_order_line ALTER COLUMN discount TYPE numeric(16,6);")
    File "/usr/local/lib/python2.6/dist-packages/openerp-server/sql_db.py", line 78, in wrapper
      return f(self, *args, **kwargs)
    File "/usr/local/lib/python2.6/dist-packages/openerp-server/sql_db.py", line 123, in execute
      res = self._obj.execute(query, params)
  psycopg2.NotSupportedError: FEHLER:  Typ einer Spalte, die von einer Sicht oder Regel verwendet wird, kann nicht geändert werden
  DETAIL:  Regel _RETURN für Sicht sale_journal_picking_stats hängt von Spalte »discount« ab
  4) Platform: Debian (Squeeze): Linux openerp 2.6.32-5-amd64 #1 SMP Wed Jan 12 03:40:32 UTC 2011 x86_64 GNU/Linux
  5) INFO:server:version - 5.0.15

  Culprit: Line no. 239 in sale.py: cr.execute("ALTER TABLE
  sale_order_line ALTER COLUMN discount TYPE numeric(16,6);")