Monica : erreur SQL



Si je parviens bien à atteindre la page d’accueil de mon instance Monica, un clic sur n’importe quel contact génère la page d’erreur présentant le message suivant :slight_smile:

SQLSTATE[42S22]: Column not found: 1054 Unknown column ‘number_of_views’ in ‘field list’ (SQL: update contacts set last_consulted_at = 2018-11-11 12:28:27, updated_at = 2018-11-11 17:28:27, number_of_views = 1 where id = 18)

Monica est mis à jour dans sa dernière version.

Merci pour l’aide :slight_smile:

Maybe try to update to latest version and check if it resolve the issue.

Thanks for your response.
I’ve already updated to latest version, but unfortunately it’s worse: I can no longer access to the main page. I get the following error message:

SQLSTATE[42S22]: Column not found: 1054 Unknown column ‘is_active’ in ‘where clause’ (SQL: select count(*) as aggregate from contacts where contacts.account_id = 1 and contacts.account_id is not null and is_partial = 0 and is_active = 1)

You should open issue on the Monica core app page. As long as you have database you data is safe.
I don’t know why the database migration has failed in your case. Take a backup of monica and try updating.