error uninstalling/updating report_timesheet

[Eric Caudal - www.elico-corp.com]

When upgrading account I have the following error:

[2010-04-21 19:25:31,796] INFO:init:module base: loading objects
[2010-04-21 19:25:31,919] INFO:init:module c2c_reporting_tools: loading objects
[2010-04-21 19:25:31,920] INFO:init:module board: loading objects
[2010-04-21 19:25:31,928] INFO:init:module base_partner_gender: loading objects
[2010-04-21 19:25:31,933] INFO:init:module multi_company_sequence: loading objects
[2010-04-21 19:25:31,935] INFO:init:module crm: loading objects
[2010-04-21 19:25:31,943] INFO:init:module base_report_designer: loading objects
[2010-04-21 19:25:31,944] INFO:init:module multi_company_category: loading objects
[2010-04-21 19:25:31,946] INFO:init:module c2c_currency_rate_update: loading objects
[2010-04-21 19:25:31,953] INFO:init:module city: loading objects
[2010-04-21 19:25:31,960] INFO:init:module multi_company_currency: loading objects
[2010-04-21 19:25:31,965] INFO:init:module base_language: loading objects
[2010-04-21 19:25:31,967] INFO:init:module process: loading objects
[2010-04-21 19:25:31,978] INFO:init:module base_report_unicode: loading objects
[2010-04-21 19:25:31,978] INFO:init:module base_setup: loading objects
[2010-04-21 19:25:31,978] INFO:init:module google_map: loading objects
[2010-04-21 19:25:31,981] INFO:init:module multi_company: loading objects
[2010-04-21 19:25:31,981] INFO:init:module base_partner_sequence: loading objects
[2010-04-21 19:25:31,984] INFO:init:module base_crypt: loading objects
[2010-04-21 19:25:31,987] INFO:init:module base_report_creator: loading objects
[2010-04-21 19:25:31,993] INFO:init:module hr: loading objects
[2010-04-21 19:25:32,008] INFO:init:module document: loading objects
[2010-04-21 19:25:32,019] INFO:init:module product: loading objects
[2010-04-21 19:25:32,031] INFO:init:module report_crm: loading objects
[2010-04-21 19:25:32,035] INFO:init:module base_contact: loading objects
[2010-04-21 19:25:32,037] INFO:init:module report_document: loading objects
[2010-04-21 19:25:32,041] INFO:init:module crm_configuration: loading objects
[2010-04-21 19:25:32,047] INFO:init:module account: loading objects
[2010-04-21 19:25:32,098] INFO:init:module account: creating or updating database tables
[2010-04-21 19:25:32,384] INFO:orm:column company_id (Company) in table account_journal removed: converted to a function !
[2010-04-21 19:25:34,674] INFO:init:module document_extension: loading objects
[2010-04-21 19:25:34,680] INFO:init:module product_catalog_report: loading objects
[2010-04-21 19:25:34,680] INFO:init:module product_variant_multi: loading objects
[2010-04-21 19:25:34,690] INFO:init:module multi_company_product: loading objects
[2010-04-21 19:25:34,700] INFO:init:module base_contact_city: loading objects
[2010-04-21 19:25:34,700] INFO:init:module hr_attendance: loading objects
[2010-04-21 19:25:34,707] INFO:init:module account_simulation: loading objects
[2010-04-21 19:25:34,715] INFO:init:module account_simulation: creating or updating database tables
[2010-04-21 19:25:34,970] INFO:init:module account_budget: loading objects
[2010-04-21 19:25:34,982] INFO:init:module account_budget: creating or updating database tables
[2010-04-21 19:25:35,165] INFO:init:module account_financial_report: loading objects
[2010-04-21 19:25:35,166] INFO:init:module account_financial_report: creating or updating database tables
[2010-04-21 19:25:35,166] INFO:init:module board_document: loading objects
[2010-04-21 19:25:35,166] INFO:init:module board_crm_configuration: loading objects
[2010-04-21 19:25:35,166] INFO:init:module account_chart: loading objects
[2010-04-21 19:25:35,167] INFO:init:module account_chart: creating or updating database tables
[2010-04-21 19:25:35,167] INFO:init:module event: loading objects
[2010-04-21 19:25:35,180] INFO:init:module event: creating or updating database tables
[2010-04-21 19:25:35,381] INFO:init:module account_report: loading objects
[2010-04-21 19:25:35,386] INFO:init:module account_report: creating or updating database tables
[2010-04-21 19:25:35,461] INFO:init:module account_payment: loading objects
[2010-04-21 19:25:35,475] INFO:init:module account_payment: creating or updating database tables
[2010-04-21 19:25:35,903] INFO:init:module document_ics: loading objects
[2010-04-21 19:25:35,910] INFO:init:module account_invoice_analytic_required: loading objects
[2010-04-21 19:25:35,913] INFO:init:module account_invoice_analytic_required: creating or updating database tables
[2010-04-21 19:25:36,001] INFO:init:module account_balance_reporting: loading objects
[2010-04-21 19:25:36,015] INFO:init:module account_balance_reporting: creating or updating database tables
[2010-04-21 19:25:36,228] INFO:init:module account_reporting: loading objects
[2010-04-21 19:25:36,233] INFO:init:module account_reporting: creating or updating database tables
[2010-04-21 19:25:36,290] INFO:init:module hr_timesheet: loading objects
[2010-04-21 19:25:36,295] INFO:init:module hr_timesheet: creating or updating database tables
[2010-04-21 19:25:36,399] INFO:init:module invoice_sequence: loading objects
[2010-04-21 19:25:36,402] INFO:init:module invoice_sequence: creating or updating database tables
[2010-04-21 19:25:36,460] INFO:init:module base_vat: loading objects
[2010-04-21 19:25:36,463] INFO:init:module base_vat: creating or updating database tables
[2010-04-21 19:25:36,531] INFO:init:module project: loading objects
[2010-04-21 19:25:36,543] INFO:init:module project: creating or updating database tables
[2010-04-21 19:25:36,799] INFO:init:module account_base: loading objects
[2010-04-21 19:25:36,802] INFO:init:module account_base: creating or updating database tables
[2010-04-21 19:25:36,897] INFO:init:module report_account: loading objects
[2010-04-21 19:25:36,906] INFO:init:module report_account: creating or updating database tables
[2010-04-21 19:25:36,977] INFO:init:module stock: loading objects
[2010-04-21 19:25:37,016] INFO:init:module stock: creating or updating database tables
[2010-04-21 19:25:37,643] INFO:orm:column list_price (Sale Price) in table product_template removed: converted to a function !
[2010-04-21 19:25:37,654] INFO:orm:column standard_price (Cost Price) in table product_template removed: converted to a function !
[2010-04-21 19:25:37,789] INFO:init:module account_balance: loading objects
[2010-04-21 19:25:37,795] INFO:init:module account_balance: creating or updating database tables
[2010-04-21 19:25:37,942] INFO:init:module l10n_fr: loading objects
[2010-04-21 19:25:37,947] INFO:init:module l10n_fr: creating or updating database tables
[2010-04-21 19:25:37,985] INFO:init:module hr_timesheet_invoice: loading objects
[2010-04-21 19:25:37,998] INFO:init:module hr_timesheet_invoice: creating or updating database tables
[2010-04-21 19:25:38,303] INFO:init:module l10n_chart_us_general: loading objects
[2010-04-21 19:25:38,303] INFO:init:module l10n_chart_us_general: creating or updating database tables
[2010-04-21 19:25:38,303] INFO:init:module google_calendar: loading objects
[2010-04-21 19:25:38,309] INFO:init:module google_calendar: creating or updating database tables
[2010-04-21 19:25:38,414] INFO:init:module account_payment_extension: loading objects
[2010-04-21 19:25:38,433] INFO:init:module account_payment_extension: creating or updating database tables
[2010-04-21 19:25:39,067] INFO:init:module multi_company_account: loading objects
[2010-04-21 19:25:39,091] INFO:init:module multi_company_account: creating or updating database tables
[2010-04-21 19:25:39,906] INFO:init:module account_asset: loading objects
[2010-04-21 19:25:39,925] INFO:init:module account_asset: creating or updating database tables
[2010-04-21 19:25:40,488] INFO:init:module purchase: loading objects
[2010-04-21 19:25:40,501] INFO:init:module purchase: creating or updating database tables
[2010-04-21 19:25:40,963] INFO:init:module multi_company_purchase: loading objects
[2010-04-21 19:25:40,966] INFO:init:module multi_company_purchase: creating or updating database tables
[2010-04-21 19:25:41,101] INFO:init:module multi_company_account_ifrs: loading objects
[2010-04-21 19:25:41,107] INFO:init:module multi_company_account_ifrs: creating or updating database tables
[2010-04-21 19:25:41,228] INFO:init:module account_analytic_analysis: loading objects
[2010-04-21 19:25:41,235] INFO:init:module account_analytic_analysis: creating or updating database tables
[2010-04-21 19:25:41,421] INFO:init:module report_timesheet: loading objects
[2010-04-21 19:25:41,435] INFO:init:module report_timesheet: creating or updating database tables
sh: bzr: not found
No LSB modules are available.
[2010-04-21 19:25:41,632] ERROR:web-services:[01]:
[2010-04-21 19:25:41,633] ERROR:web-services:[02]: Environment Information :
[2010-04-21 19:25:41,633] ERROR:web-services:[03]: System : Linux-2.6.31-20-server-x86_64-with-Ubuntu-9.10-karmic
[2010-04-21 19:25:41,633] ERROR:web-services:[04]: OS Name : posix
[2010-04-21 19:25:41,633] ERROR:web-services:[05]: Distributor ID: Ubuntu
[2010-04-21 19:25:41,633] ERROR:web-services:[06]: Description: Ubuntu 9.10
[2010-04-21 19:25:41,634] ERROR:web-services:[07]: Release: 9.10
[2010-04-21 19:25:41,634] ERROR:web-services:[08]: Codename: karmic
[2010-04-21 19:25:41,634] ERROR:web-services:[09]: Operating System Release : 2.6.31-20-server
[2010-04-21 19:25:41,634] ERROR:web-services:[10]: Operating System Version : #58-Ubuntu SMP Fri Mar 12 05:40:05 UTC 2010
[2010-04-21 19:25:41,634] ERROR:web-services:[11]: Operating System Architecture : 64bit
[2010-04-21 19:25:41,634] ERROR:web-services:[12]: Operating System Locale : en_US.UTF8
[2010-04-21 19:25:41,635] ERROR:web-services:[13]: Python Version : 2.5.4
[2010-04-21 19:25:41,635] ERROR:web-services:[14]: OpenERP-Server Version : 5.0.7
[2010-04-21 19:25:41,635] ERROR:web-services:[15]: Last revision No. & ID :
[2010-04-21 19:25:41,635] ERROR:web-services:[16]: Traceback (most recent call last):
[2010-04-21 19:25:41,635] ERROR:web-services:[17]: File "/usr/lib/python2.5/site-packages/openerp-server/osv/osv.py", line 56, in wrapper
[2010-04-21 19:25:41,635] ERROR:web-services:[18]: if not pooler.get_pool(dbname)._ready:
[2010-04-21 19:25:41,636] ERROR:web-services:[19]: File "/usr/lib/python2.5/site-packages/openerp-server/pooler.py", line 81, in get_pool
[2010-04-21 19:25:41,636] ERROR:web-services:[20]: pool = get_db_and_pool(db_name, force_demo, status, update_module)[1]
[2010-04-21 19:25:41,636] ERROR:web-services:[21]: File "/usr/lib/python2.5/site-packages/openerp-server/pooler.py", line 40, in get_db_and_pool
[2010-04-21 19:25:41,636] ERROR:web-services:[22]: addons.load_modules(db, force_demo, status, update_module)
[2010-04-21 19:25:41,636] ERROR:web-services:[23]: File "/usr/lib/python2.5/site-packages/openerp-server/addons/__init__.py", line 740, in load_modules
[2010-04-21 19:25:41,637] ERROR:web-services:[24]: r = load_module_graph(cr, graph, status, report=report)
[2010-04-21 19:25:41,637] ERROR:web-services:[25]: File "/usr/lib/python2.5/site-packages/openerp-server/addons/__init__.py", line 584, in load_module_graph
[2010-04-21 19:25:41,637] ERROR:web-services:[26]: init_module_objects(cr, package.name, modules)
[2010-04-21 19:25:41,637] ERROR:web-services:[27]: File "/usr/lib/python2.5/site-packages/openerp-server/addons/__init__.py", line 373, in init_module_objects
[2010-04-21 19:25:41,637] ERROR:web-services:[28]: obj.init(cr)
[2010-04-21 19:25:41,637] ERROR:web-services:[29]: File "/usr/lib/python2.5/site-packages/openerp-server/addons/report_timesheet/report_timesheet.py", line 154, in init
[2010-04-21 19:25:41,638] ERROR:web-services:[30]: """)
[2010-04-21 19:25:41,638] ERROR:web-services:[31]: File "/usr/lib/python2.5/site-packages/openerp-server/sql_db.py", line 77, in wrapper
[2010-04-21 19:25:41,638] ERROR:web-services:[32]: return f(self, *args, **kwargs)
[2010-04-21 19:25:41,638] ERROR:web-services:[33]: File "/usr/lib/python2.5/site-packages/openerp-server/sql_db.py", line 122, in execute
[2010-04-21 19:25:41,638] ERROR:web-services:[34]: res = self._obj.execute(query, params)
[2010-04-21 19:25:41,638] ERROR:web-services:[35]: ProgrammingError: column t.list_price does not exist
[2010-04-21 19:25:41,639] ERROR:web-services:[36]: LINE 9: sum(l.unit_amount * t.list_price) as amo...
[2010-04-21 19:25:41,639] ERROR:web-services:[37]: ^

It seems ersponsible is :

[2010-04-21 19:25:37,643] INFO:orm:column list_price (Sale Price) in table product_template removed: converted to a function !
[2010-04-21 19:25:37,654] INFO:orm:column standard_price (Cost Price) in table product_template removed: converted to a function !

[Jay Vora (Serpent Consulting Services) (jayvora)]

Hello Elicoidal,

I saw the root of the error and that is the multi_company_product module.
The module is not a certified addon and obviously its not a good practice to convert a field of DB into an unstorable field.

Combining the use of both,is not advisable I suppose.

There will be such modules which are totally incompatible and can throw errors like this.

However, if you want to get rid of this issue and want to move ahead of the scenarion;you may simply set store=True to the field in multi_company_product module.

Hope this helps.

Thanks.