This question has been flagged
1 Reply
5241 Views

Hi, I'm running my first instance of OpenErp V7. After adding Timesheet module I've got error messages so i restarted my instance and postgresql server. Now i'm trying to log in and I get this error message:

OpenERP Server Error Client Traceback (most recent call last): File "/usr/lib/pymodules/python2.7/openerp/addons/web/http.py", line 204, in dispatch response["result"] = method(self, **self.params) File "/usr/lib/pymodules/python2.7/openerp/addons/web/controllers/main.py", line 867, in authenticate req.session.authenticate(db, login, password, env) File "/usr/lib/pymodules/python2.7/openerp/addons/web/session.py", line 115, in authenticate uid = self.proxy('common').authenticate(db, login, password, env) File "/usr/lib/pymodules/python2.7/openerp/addons/web/session.py", line 30, in proxy_method result = self.session.send(self.service_name, method, *args) File "/usr/lib/pymodules/python2.7/openerp/addons/web/session.py", line 103, in send raise xmlrpclib.Fault(openerp.tools.ustr(e), formatted_info)

Server Traceback (most recent call last): File "/usr/lib/pymodules/python2.7/openerp/addons/web/session.py", line 89, in send return openerp.netsvc.dispatch_rpc(service_name, method, args) File "/usr/lib/pymodules/python2.7/openerp/netsvc.py", line 292, in dispatch_rpc result = ExportService.getService(service_name).dispatch(method, params) File "/usr/lib/pymodules/python2.7/openerp/service/web_services.py", line 433, in dispatch return fn(params) File "/usr/lib/pymodules/python2.7/openerp/service/web_services.py", line 444, in exp_authenticate res_users = pooler.get_pool(db).get('res.users') File "/usr/lib/pymodules/python2.7/openerp/pooler.py", line 49, in get_pool return get_db_and_pool(db_name, force_demo, status, update_module)[1] File "/usr/lib/pymodules/python2.7/openerp/pooler.py", line 33, in get_db_and_pool registry = RegistryManager.get(db_name, force_demo, status, update_module) File "/usr/lib/pymodules/python2.7/openerp/modules/registry.py", line 193, in get update_module) File "/usr/lib/pymodules/python2.7/openerp/modules/registry.py", line 219, in new openerp.modules.load_modules(registry.db, force_demo, status, update_module) File "/usr/lib/pymodules/python2.7/openerp/modules/loading.py", line 350, in load_modules force, status, report, loaded_modules, update_module) File "/usr/lib/pymodules/python2.7/openerp/modules/loading.py", line 256, in load_marked_modules loaded, processed = load_module_graph(cr, graph, progressdict, report=report, skip_modules=loaded_modules, perform_checks=perform_checks) File "/usr/lib/pymodules/python2.7/openerp/modules/loading.py", line 188, in load_module_graph load_data(module_name, idref, mode) File "/usr/lib/pymodules/python2.7/openerp/modules/loading.py", line 76, in <lambda> load_data = lambda *args: _load_data(cr, *args, kind='data') File "/usr/lib/pymodules/python2.7/openerp/modules/loading.py", line 124, in _load_data tools.convert_xml_import(cr, module_name, fp, idref, mode, noupdate, report) File "/usr/lib/pymodules/python2.7/openerp/tools/convert.py", line 954, in convert_xml_import obj.parse(doc.getroot()) File "/usr/lib/pymodules/python2.7/openerp/tools/convert.py", line 847, in parse self._tagsrec.tag File "/usr/lib/pymodules/python2.7/openerp/tools/convert.py", line 814, in _tag_record id = self.pool.get('ir.model.data')._update(cr, self.uid, rec_model, self.module, res, rec_id or False, not self.isnoupdate(data_node), noupdate=self.isnoupdate(data_node), mode=self.mode, context=rec_context ) File "/usr/lib/pymodules/python2.7/openerp/addons/base/ir/ir_model.py", line 940, in _update model_obj.write(cr, uid, [res_id], values, context=context) File "/usr/lib/pymodules/python2.7/openerp/addons/base/ir/ir_ui_view.py", line 214, in write return super(view, self).write(cr, uid, ids, vals, context) File "/usr/lib/pymodules/python2.7/openerp/osv/orm.py", line 4209, in write self._validate(cr, user, ids, context) File "/usr/lib/pymodules/python2.7/openerp/osv/orm.py", line 1531, in _validate if not fun(self, cr, uid, ids): File "/usr/lib/pymodules/python2.7/openerp/addons/base/ir/ir_ui_view.py", line 139, in _check_xml view_arch_utf8 = self._check_render_view(cr, uid, view, context=context) File "/usr/lib/pymodules/python2.7/openerp/addons/base/ir/ir_ui_view.py", line 129, in _check_render_view _logger.exception("Can't render view %s for model: %s", view.xml_id, view.model) File "/usr/lib/pymodules/python2.7/openerp/osv/orm.py", line 486, in __getattr__ return self[name] File "/usr/lib/pymodules/python2.7/openerp/osv/orm.py", line 401, in __getitem__ field_values = self._table.read(self._cr, self._uid, ids, field_names, context=self._context, load="_classic_write") File "/usr/lib/pymodules/python2.7/openerp/osv/orm.py", line 3612, in read result = self._read_flat(cr, user, select, fields, context, load) File "/usr/lib/pymodules/python2.7/openerp/osv/orm.py", line 3732, in _read_flat res2 = self._columns[f].get(cr, self, ids, f, user, context=context, values=res) File "/usr/lib/pymodules/python2.7/openerp/osv/fields.py", line 1139, in get result = self._fnct(obj, cr, uid, ids, name, self._arg, context) File "/usr/lib/pymodules/python2.7/openerp/osv/orm.py", line 5143, in get_external_id results = self._get_xml_ids(cr, uid, ids) File "/usr/lib/pymodules/python2.7/openerp/osv/orm.py", line 5116, in _get_external_ids data_ids = ir_model_data.search(cr, uid, [('model', '=', self._name), ('res_id', 'in', ids)]) File "/usr/lib/pymodules/python2.7/openerp/osv/orm.py", line 2358, in search return self._search(cr, user, args, offset=offset, limit=limit, order=order, context=context, count=count) File "/usr/lib/pymodules/python2.7/openerp/osv/orm.py", line 4870, in _search cr.execute('SELECT "%s".id FROM ' % self._table + from_clause + where_str + order_by + limit_str + offset_str, where_clause_params) File "/usr/lib/pymodules/python2.7/openerp/sql_db.py", line 161, in wrapper return f(self, *args, *kwargs) File "/usr/lib/pymodules/python2.7/openerp/sql_db.py", line 226, in execute res = self._obj.execute(query, params) InternalError: current transaction is aborted, commands ignored until end of transaction block

On my postgresql log i get the following:

2013-11-18 12:30:49 UTC ERROR: column res_company.timesheet_max_difference does not exist at character 58 2013-11-18 12:30:49 UTC STATEMENT: SELECT res_company."rml_footer",res_company."rml_header",res_company."timesheet_max_difference",res_company."currency_id",res_company."partner_id",res_company."expects_chart_of_accounts",res_company."account_no",res_company."timesheet_range",res_company."expense_currency_exchange_account_id",res_company."name",res_company."parent_id",res_company."custom_footer",res_company."rml_header2",res_company."rml_header3",res_company."rml_header1",res_company."project_time_mode_id",res_company."paypal_account",res_company."company_registry",res_company."paper_format",res_company."overdue_msg",res_company."tax_calculation_rounding_method",res_company."income_currency_exchange_account_id",res_company.id FROM "res_company" WHERE res_company.id IN (1) ORDER BY name 2013-11-18 12:30:49 UTC ERROR: current transaction is aborted, commands ignored until end of transaction block 2013-11-18 12:30:49 UTC STATEMENT: SELECT "ir_model_data".id FROM "ir_model_data" WHERE (("ir_model_data"."model" = 'ir.ui.view') AND ("ir_model_data"."res_id" in (568,662))) ORDER BY "ir_model_data"."module" ,"ir_model_data"."model" ,"ir_model_data"."name

Any idea what can be the problem?

Avatar
Discard
Best Answer

timesheet_max_difference is not on your database. Did you installed your module and then added a new field?

Avatar
Discard
Author

I wasn't able to install the module. Is there any way to uninstall a module from a config file? bacause I can not get access to the web configuration, the login process shows this error I posted.

Yes, I know... this is something that happens... You have to remove the code, or maybe the module from addons folder and then restart your server. Is it a community addon?

Author

No, is an official addon. But I'm running other db in that server, I don't want to mess things up, is there a way to remove module only for the database I'm getting the error?