c2c-oerpscenario team mailing list archive

[photo7 <511979@xxxxxxxxxxxxxxxxxx>]

This is just a limitation on Postgres engine, that you can't alter
column if it is involved in any view. Obviously this can be dealt by
creating "discount" column with required type in the first place...

This is what needs to be done to bypass this error:

1. get the view definition schema
2. Drop the view
3. alter "dicount" column
4. recreate view
5. Comment the alter statement in sale.py
6. restart erp server
7. install magentoconnect

I did the pl/pgsql script for this - see attachment, but it will only
run as is on postgres 9. But it can be adopted to run on 8 as well or
you need to do it manually in psql.


** Attachment added: "DBA hotfix"
   https://bugs.launchpad.net/magentoerpconnect/+bug/511979/+attachment/1813720/+files/alter_invoice_line.sql

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

Title:
  Install ended with error

Status in Magento Open ERP Connector:
  Confirmed

Bug description:
  I tried to install it on a new Windows installation 5.06 but I getting
  the following error:

  Environment Information : 
  System : Windows-Vista-6.0.6002-SP2
  OS Name : nt
  Operating System Release : Vista
  Operating System Version : 6.0.6002
  Operating System Architecture : 32bit
  Operating System Locale : en_US.cp1252
  Python Version : 2.5.2
  OpenERP-Client Version : 5.0.6
  Last revision No. & ID :Bazaar Package not Found !Traceback (most recent call last):
    File "netsvc.pyo", line 244, in dispatch
    File "netsvc.pyo", line 73, in __call__
    File "service\web_services.pyo", line 639, in execute
    File "service\web_services.pyo", line 619, in _execute
    File "wizard\__init__.pyo", line 178, in execute
    File "wizard\__init__.pyo", line 74, in execute_cr
    File "C:\Program Files\OpenErp\OpenERP AllInOne\Server\addons\base\module\wizard\wizard_module_upgrade.py", line 92, in _upgrade_module
    File "pooler.pyo", line 62, in restart_pool
    File "pooler.pyo", line 40, in get_db_and_pool
    File "addons\__init__.pyo", line 728, in load_modules
    File "addons\__init__.pyo", line 581, in load_module_graph
    File "addons\__init__.pyo", line 366, in init_module_objects
    File "C:\Program Files\OpenErp\OpenERP AllInOne\Server\addons\magentoerpconnect_generic\sale.py", line 129, in _auto_init
    File "sql_db.pyo", line 76, in wrapper
    File "sql_db.pyo", line 120, in execute
  NotSupportedError: cannot alter type of a column used by a view or rule
  DETAIL:  rule _RETURN on view sale_journal_picking_stats depends on column "discount"