Hi All

I wanted to tidy up my database so I uninstalled everything other than Sales. However when I now try to install Projects I get the errors below...

2017-12-19 10:11:32,031 2517 WARNING MASH_Live openerp.models.schema: Table 'pro ject_project': unable to set a NOT NULL constraint on column 'analytic_account_i d' !

If you want to have it, you should update the records and execute manually:

ALTER TABLE project_project ALTER COLUMN analytic_account_id SET NOT NULL 2017-12-19 10:11:32,045 2517 ERROR MASH_Live openerp.http: Exception during JSON request handling.

Traceback (most recent call last):

  File "/opt/odoo/openerp/http.py", line 530, in _handle_exception

    return super(JsonRequest, self)._handle_exception(exception)

  File "/opt/odoo/openerp/http.py", line 567, in dispatch

    result = self._call_function(**self.params)

  File "/opt/odoo/openerp/http.py", line 303, in _call_function

    return checked_call(self.db, *args, **kwargs)

  File "/opt/odoo/openerp/service/model.py", line 113, in wrapper

    return f(dbname, *args, **kwargs)

  File "/opt/odoo/openerp/http.py", line 300, in checked_call

    return self.endpoint(*a, **kw)

  File "/opt/odoo/openerp/http.py", line 796, in __call__

    return self.method(*args, **kw)

  File "/opt/odoo/openerp/http.py", line 396, in response_wrap

    response = f(*args, **kw)

  File "/opt/odoo/addons/web/controllers/main.py", line 953, in call_button

    action = self._call_kw(model, method, args, {})

  File "/opt/odoo/addons/web/controllers/main.py", line 941, in _call_kw

    return getattr(request.registry.get(model), method)(request.cr, request.uid, *args, **kwargs)

  File "/opt/odoo/openerp/api.py", line 241, in wrapper

    return old_api(self, *args, **kwargs)

  File "/opt/odoo/openerp/addons/base/module/module.py", line 450, in button_imm ediate_install

    return self._button_immediate_function(cr, uid, ids, self.button_install, co ntext=context)

  File "/opt/odoo/openerp/api.py", line 241, in wrapper

    return old_api(self, *args, **kwargs)

  File "/opt/odoo/openerp/addons/base/module/module.py", line 498, in _button_im mediate_function

    registry = openerp.modules.registry.RegistryManager.new(cr.dbname, update_mo dule=True)

  File "/opt/odoo/openerp/modules/registry.py", line 366, in new

    openerp.modules.load_modules(registry._db, force_demo, status, update_module )

  File "/opt/odoo/openerp/modules/loading.py", line 355, in load_modules

    loaded_modules, update_module)

  File "/opt/odoo/openerp/modules/loading.py", line 255, in load_marked_modules

    loaded, processed = load_module_graph(cr, graph, progressdict, report=report , skip_modules=loaded_modules, perform_checks=perform_checks)

  File "/opt/odoo/openerp/modules/loading.py", line 157, in load_module_graph

    init_module_models(cr, package.name, models)

  File "/opt/odoo/openerp/modules/module.py", line 286, in init_module_models

    result = obj._auto_init(cr, {'module': module_name})

  File "/opt/odoo/openerp/api.py", line 241, in wrapper

    return old_api(self, *args, **kwargs)

  File "/opt/odoo/addons/project/project.py", line 74, in _auto_init

    'project.task', self._columns['alias_id'], 'id', alias_prefix='project+', al ias_defaults={'project_id':'id'}, context=alias_context)

  File "/opt/odoo/openerp/api.py", line 241, in wrapper

    return old_api(self, *args, **kwargs)

  File "/opt/odoo/addons/mail/mail_alias.py", line 213, in migrate_to_alias

    alias_id = mail_alias.create(cr, SUPERUSER_ID, alias_vals, context=alias_cre ate_ctx)

  File "/opt/odoo/openerp/api.py", line 241

and

Traceback (most recent call last):
  File "/opt/odoo/openerp/http.py", line 530, in _handle_exception
    return super(JsonRequest, self)._handle_exception(exception)
  File "/opt/odoo/openerp/http.py", line 567, in dispatch
    result = self._call_function(**self.params)
  File "/opt/odoo/openerp/http.py", line 303, in _call_function
    return checked_call(self.db, *args, **kwargs)
  File "/opt/odoo/openerp/service/model.py", line 113, in wrapper
    return f(dbname, *args, **kwargs)
  File "/opt/odoo/openerp/http.py", line 300, in checked_call
    return self.endpoint(*a, **kw)
  File "/opt/odoo/openerp/http.py", line 796, in __call__
    return self.method(*args, **kw)
  File "/opt/odoo/openerp/http.py", line 396, in response_wrap
    response = f(*args, **kw)
  File "/opt/odoo/addons/web/controllers/main.py", line 953, in call_button
    action = self._call_kw(model, method, args, {})
  File "/opt/odoo/addons/web/controllers/main.py", line 941, in _call_kw
    return getattr(request.registry.get(model), method)(request.cr, request.uid, *args, **kwargs)
  File "/opt/odoo/openerp/api.py", line 241, in wrapper
    return old_api(self, *args, **kwargs)
  File "/opt/odoo/openerp/addons/base/module/wizard/base_module_upgrade.py", line 105, in upgrade_module
    openerp.modules.registry.RegistryManager.new(cr.dbname, update_module=True)
  File "/opt/odoo/openerp/modules/registry.py", line 366, in new
    openerp.modules.load_modules(registry._db, force_demo, status, update_module)
  File "/opt/odoo/openerp/modules/loading.py", line 355, in load_modules
    loaded_modules, update_module)
  File "/opt/odoo/openerp/modules/loading.py", line 255, in load_marked_modules
    loaded, processed = load_module_graph(cr, graph, progressdict, report=report, skip_modules=loaded_modules, perform_checks=perform_checks)
  File "/opt/odoo/openerp/modules/loading.py", line 157, in load_module_graph
    init_module_models(cr, package.name, models)
  File "/opt/odoo/openerp/modules/module.py", line 286, in init_module_models
    result = obj._auto_init(cr, {'module': module_name})
  File "/opt/odoo/openerp/api.py", line 241, in wrapper
    return old_api(self, *args, **kwargs)
  File "/opt/odoo/addons/project/project.py", line 74, in _auto_init
    'project.task', self._columns['alias_id'], 'id', alias_prefix='project+', alias_defaults={'project_id':'id'}, context=alias_context)
  File "/opt/odoo/openerp/api.py", line 241, in wrapper
    return old_api(self, *args, **kwargs)
  File "/opt/odoo/addons/mail/mail_alias.py", line 213, in migrate_to_alias
    alias_id = mail_alias.create(cr, SUPERUSER_ID, alias_vals, context=alias_create_ctx)
  File "/opt/odoo/openerp/api.py", line 241, in wrapper
    return old_api(self, *args, **kwargs)
  File "/opt/odoo/addons/mail/mail_alias.py", line 244, in create
    model_id = self.pool.get('ir.model').search(cr, uid, [('model', '=', model_name)], context=context)[0]
IndexError: list index out of range