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" _______________________________________________ Mailing list: https://launchpad.net/~c2c-oerpscenario Post to : [email protected] Unsubscribe : https://launchpad.net/~c2c-oerpscenario More help : https://help.launchpad.net/ListHelp
