# Sonata suite recordings - Database error in certain menu options

**URL:** https://forums.vitalpbx.org/t/sonata-suite-recordings-database-error-in-certain-menu-options/2705
**Category:** Sonata Suite
**Created:** [May 4, 2023, 5:28pm UTC](https://forums.vitalpbx.org/t/sonata-suite-recordings-database-error-in-certain-menu-options/2705 "2023-05-04T17:28:26Z")
**Posts on this page:** 3
**Page:** 1

<div class="post-metadata">

### Author: ![tarzan2003](https://forums.vitalpbx.org/letter_avatar_proxy/v4/letter/t/c89c15/32.png) [@tarzan2003](https://forums.vitalpbx.org/u/tarzan2003)
#### Post date: [May 4, 2023, 5:28pm UTC](https://forums.vitalpbx.org/t/sonata-suite-recordings-database-error-in-certain-menu-options/2705/1 "2023-05-04T17:28:26Z")

</div>

Hi.

I have 5 tenants im my vitalpbx (main + 4).  
In sonata suite recordings, I get a database error (it happens just in two of the tenants).  
That error appears while choosing menu options (in many of them). For example, menu-\>settings-\>users or menu-\>reports-\>filters.  
It makes impossible to access any recordings.

The error is:  
select `teams`.`team_id` as `team_id`,`teams`.`description` as `description`,`teams`.`flag_profile_id` as `flag_profile_id`,`teams`.`default` as `default`,`teams`.`tenant_id` as `tenant_id` from `telerec`.`rec_teams` as `teams` where `team_id` in ()SQLSTATE[42000]: Syntax error or access violation: 1064 You have an error in your SQL syntax; check the manual that corresponds to your MariaDB server version for the right syntax to use near ‘)’ at line 1

Can you help me.

Thanks

---

<div class="post-metadata">

### Author: ![miguel](https://forums.vitalpbx.org/user_avatar/forums.vitalpbx.org/miguel/32/415_2.png) [@miguel](https://forums.vitalpbx.org/u/miguel)
#### Post date: [May 4, 2023, 6:28pm UTC](https://forums.vitalpbx.org/t/sonata-suite-recordings-database-error-in-certain-menu-options/2705/2 "2023-05-04T18:28:24Z")

</div>

Does your user have a team allowed?

---

<div class="post-metadata">

### Author: ![tarzan2003](https://forums.vitalpbx.org/letter_avatar_proxy/v4/letter/t/c89c15/32.png) [@tarzan2003](https://forums.vitalpbx.org/u/tarzan2003)
#### Post date: [May 5, 2023, 11:00am UTC](https://forums.vitalpbx.org/t/sonata-suite-recordings-database-error-in-certain-menu-options/2705/3 "2023-05-05T11:00:04Z")

</div>

I’m using admin.  
Sorry… I watched today a little bit of the youtube movie about sonata suite recordings and, after doing things by correct order, the error didn’t came out again.  
Maybe the interface should be more user friendly.

Thanks