# Monica HQ error on upgrade - SQL unknown column

**URL:** https://forum.yunohost.org/t/monica-hq-error-on-upgrade-sql-unknown-column/23563
**Category:** Support apps
**Tags:** monica, english
**Created:** [February 10, 2023, 1:03am UTC](https://forum.yunohost.org/t/monica-hq-error-on-upgrade-sql-unknown-column/23563 "2023-02-10T01:03:20Z")
**Posts on this page:** 2
**Page:** 1

<div class="post-metadata">

### Author: ![mcint](https://forum.yunohost.org/user_avatar/forum.yunohost.org/mcint/32/13794_2.png) [@mcint](https://forum.yunohost.org/u/mcint)
#### Post date: [February 10, 2023, 1:03am UTC](https://forum.yunohost.org/t/monica-hq-error-on-upgrade-sql-unknown-column/23563/1 "2023-02-10T01:03:20Z")

</div>

Hi 👋. I don’t find similar issues mentioned in the forum. I’ve previously debugged and manually fixed issues with apps. This issue seems more application-specific.

### My YunoHost server

**Hardware:** On own hardware, in LXC container  
**YunoHost version:** 11.0.11 (stable)  
**I have access to my server :** ssh & lxc shell / pty  
**Are you in a special context or did you perform some particular tweaking on your YunoHost instance ?** : no  
**If yes, please explain:** running app upgrades, perhaps triggered  
**If your request is related to an app, specify its name and version:** monica 3.7.0~ynh2

### Description of my issue

> SQLSTATE[42S22]: Column not found: 1054 Unknown column ‘address\_book\_id’ in ‘where clause’ (SQL: select `accounts`._, (select count(_) from `contacts` where `accounts`.`id` = `contacts`.`account_id` and `address_book_id` is null and `contacts`.`deleted_at` is null) as `contacts_count`, (select count(_) from `reminders` where `accounts`.`id` = `reminders`.`account_id`) as `reminders_count`, (select count(_) from `notes` where `accounts`.`id` = `notes`.`account_id`) as `notes_count`, (select count(_) from `activities` where `accounts`.`id` = `activities`.`account_id`) as `activities_count`, (select count(_) from `gifts` where `accounts`.`id` = `gifts`.`account_id`) as `gifts_count`, (select count(\*) from `tasks` where `accounts`.`id` = `tasks`.`account_id`) as `tasks_count` from `accounts` where `accounts`.`id` = 1 limit 1)

---

<div class="post-metadata">

### Author: ![system](https://forum.yunohost.org/uploads/default/original/2X/f/f59fe8e3ee6b100b4f574d30d6e30479c68b89f0.png) [@system](https://forum.yunohost.org/u/system)
#### Post date: [February 25, 2023, 1:03am UTC](https://forum.yunohost.org/t/monica-hq-error-on-upgrade-sql-unknown-column/23563/2 "2023-02-25T01:03:36Z")

</div>

This topic was automatically closed 15 days after the last reply. New replies are no longer allowed.