Everything was running fine but today I am getting this error though openerp and postgresql services are running fine.
When logged in OpenERP it shows this error -
Invalid username or password Username
admin Password
•••••••• Log in Manage Databases | Powered by OpenERP OpenERP OpenERP Server Error Client Traceback (most recent call last): File “/usr/lib/python2.6/site-packages/openerp-7.0_20130301_002301-py2.6.egg/openerp/addons/web/http.py”, line 195, in dispatch response[“result”] = method(self, **self.params) File “/usr/lib/python2.6/site-packages/openerp-7.0_20130301_002301-py2.6.egg/openerp/addons/web/controllers/main.py”, line 818, in authenticate req.session.authenticate(db, login, password, env) File “/usr/lib/python2.6/site-packages/openerp-7.0_20130301_002301-py2.6.egg/openerp/addons/web/session.py”, line 116, in authenticate uid = self.proxy(‘common’).authenticate(db, login, password, env) File “/usr/lib/python2.6/site-packages/openerp-7.0_20130301_002301-py2.6.egg/openerp/addons/web/session.py”, line 31, in proxy_method result = self.session.send(self.service_name, method, *args) File “/usr/lib/python2.6/site-packages/openerp-7.0_20130301_002301-py2.6.egg/openerp/addons/web/session.py”, line 104, in send raise xmlrpclib.Fault(openerp.tools.ustr(e), formatted_info)
Server Traceback (most recent call last): File “/usr/lib/python2.6/site-packages/openerp-7.0_20130301_002301-py2.6.egg/openerp/addons/web/session.py”, line 90, in send return openerp.netsvc.dispatch_rpc(service_name, method, args) File “/usr/lib/python2.6/site-packages/openerp-7.0_20130301_002301-py2.6.egg/openerp/netsvc.py”, line 295, in dispatch_rpc result = ExportService.getService(service_name).dispatch(method, params) File “/usr/lib/python2.6/site-packages/openerp-7.0_20130301_002301-py2.6.egg/openerp/service/web_services.py”, line 425, in dispatch return fn(*params) File “/usr/lib/python2.6/site-packages/openerp-7.0_20130301_002301-py2.6.egg/openerp/service/web_services.py”, line 436, in exp_authenticate res_users = pooler.get_pool(db).get(‘res.users’) File “/usr/lib/python2.6/site-packages/openerp-7.0_20130301_002301-py2.6.egg/openerp/pooler.py”, line 49, in get_pool return get_db_and_pool(db_name, force_demo, status, update_module)[1] File “/usr/lib/python2.6/site-packages/openerp-7.0_20130301_002301-py2.6.egg/openerp/pooler.py”, line 33, in get_db_and_pool registry = RegistryManager.get(db_name, force_demo, status, update_module) File “/usr/lib/python2.6/site-packages/openerp-7.0_20130301_002301-py2.6.egg/openerp/modules/registry.py”, line 192, in get update_module) File “/usr/lib/python2.6/site-packages/openerp-7.0_20130301_002301-py2.6.egg/openerp/modules/registry.py”, line 214, in new openerp.modules.load_modules(registry.db, force_demo, status, update_module) File “/usr/lib/python2.6/site-packages/openerp-7.0_20130301_002301-py2.6.egg/openerp/modules/loading.py”, line 343, in load_modules processed = load_marked_modules(cr, graph, states_to_load, force, status, report, loaded_modules, update_module) File “/usr/lib/python2.6/site-packages/openerp-7.0_20130301_002301-py2.6.egg/openerp/modules/loading.py”, line 258, 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/python2.6/site-packages/openerp-7.0_20130301_002301-py2.6.egg/openerp/modules/loading.py”, line 167, in load_module_graph init_module_models(cr, package.name, models) File “/usr/lib/python2.6/site-packages/openerp-7.0_20130301_002301-py2.6.egg/openerp/modules/module.py”, line 378, in init_module_models obj.init(cr) File “/usr/lib/python2.6/site-packages/openerp-7.0_20130301_002301-py2.6.egg/openerp/addons/bahmni_internal_stock_move/stock_report_prodlots.py”, line 85, in init left join stock_warehouse_orderpoint swo on (product_product.id=swo.product_id) and swo.active = true )""") File “/usr/lib/python2.6/site-packages/openerp-7.0_20130301_002301-py2.6.egg/openerp/sql_db.py”, line 162, in wrapper return f(self, *args, **kwargs) File “/usr/lib/python2.6/site-packages/openerp-7.0_20130301_002301-py2.6.egg/openerp/sql_db.py”, line 227, in execute res = self._obj.execute(query, params) ProgrammingError: column spl.sale_price does not exist LINE 15: …id, sm.location_id, sm.product_id, sm.prodlot_id, spl.sale_p… ^
Ok