# Security & setup warnings **URL:** \ **Category:** Access Issues\ **Created:** [26 August 2021 15:46 UTC](https://syncloud.discourse.group/t/security-setup-warnings/91 "2021-08-26T15:46:17Z")\ **Posts on this page:** 7\ **Page:** 1
**Author:** ![Christoph](https://avatars.discourse-cdn.com/v4/letter/c/eb8c5e/32.png) [@Christoph](https://syncloud.discourse.group/u/Christoph)\ **Post date:** [26 August 2021 15:46 UTC](https://syncloud.discourse.group/t/security-setup-warnings/91/1 "2021-08-26T15:46:17Z")
Do I have to do something myself or will this be corrected with an update? _There are some warnings regarding your setup._ \*\* Your installation has no default phone region set. This is required to validate phone numbers in the profile settings without a country code. To allow numbers without a country code, please add “default\_phone\_region” with the respective [ISO 3166-1 code ↗](https://en.wikipedia.org/wiki/ISO_3166-1_alpha-2#Officially_assigned_code_elements) of the region to your config file.\* \*\* The database is missing some primary keys. Due to the fact that adding primary keys on big tables could take some time they were not added automatically. By running “occ db:add-missing-primary-keys” those missing primary keys could be added manually while the instance keeps running.\* - - Missing primary key on table “oc\_federated\_reshares”.\* - - Missing primary key on table “oc\_systemtag\_object\_mapping”.\* - - Missing primary key on table “oc\_comments\_read\_markers”.\* - - Missing primary key on table “oc\_collres\_resources”.\* - - Missing primary key on table “oc\_collres\_accesscache”.\* - - Missing primary key on table “oc\_filecache\_extended”.\* \*\* Some columns in the database are missing a conversion to big int. Due to the fact that changing column types on big tables could take some time they were not changed automatically. By running ‘occ db:convert-filecache-bigint’ those pending changes could be applied manually. This operation needs to be made while the instance is offline. For further details read [the documentation page about this](https://docs.nextcloud.com/server/21/go.php?to=admin-bigint-conversion).\* - - federated\_reshares.share\_id\* - - share\_external.id\* - - share\_external.parent\* ---
**Author:** ![boris](https://avatars.discourse-cdn.com/v4/letter/b/74df32/32.png) [@boris](https://syncloud.discourse.group/u/boris)\ **Post date:** [30 August 2021 01:23 UTC](https://syncloud.discourse.group/t/security-setup-warnings/91/2 "2021-08-30T01:23:25Z")
1. Region code is unfortunately expected at the moment until Nextcloud moves it to UI from config.php or you need to edit it yourself. 2. Indeces are a manual step while upgrading from old versions. Run this command using SSH: ```auto snap run nextcloud.occ db:add-missing-primary-keys ``` ---
**Author:** ![pirboazo](https://avatars.discourse-cdn.com/v4/letter/p/a183cd/32.png) [@pirboazo](https://syncloud.discourse.group/u/pirboazo)\ **Post date:** [25 October 2021 10:51 UTC](https://syncloud.discourse.group/t/security-setup-warnings/91/3 "2021-10-25T10:51:27Z")
Hi Boris, > [@boris](#): > > Region code is unfortunately expected at the moment until Nextcloud moves it to UI from config.php or you need to edit it yourself. Where is the file ? Thanks ---
**Author:** ![boris](https://avatars.discourse-cdn.com/v4/letter/b/74df32/32.png) [@boris](https://syncloud.discourse.group/u/boris)\ **Post date:** [25 October 2021 22:18 UTC](https://syncloud.discourse.group/t/security-setup-warnings/91/4 "2021-10-25T22:18:28Z")
Looks like it is possible to set it using this command: ```auto snap run nextcloud.occ config:system:set default_phone_region --value="GB" ``` With two letter code (Alpha 2) from here: [List of ISO 3166 country codes - Wikipedia](https://en.m.wikipedia.org/wiki/List_of_ISO_3166_country_codes) ---
**Author:** ![pirboazo](https://avatars.discourse-cdn.com/v4/letter/p/a183cd/32.png) [@pirboazo](https://syncloud.discourse.group/u/pirboazo)\ **Post date:** [26 October 2021 10:21 UTC](https://syncloud.discourse.group/t/security-setup-warnings/91/5 "2021-10-26T10:21:13Z")
Thanks Boris There remains this problem > [@Christoph](#): > > - > - > - Some columns in the database are missing a conversion to big int. Due to the fact that changing column types on big tables could take some time they were not changed automatically. By running ‘occ db:convert-filecache-bigint’ those pending changes could be applied manually. This operation needs to be made while the instance is offline. For further details read [the documentation page about this](https://docs.nextcloud.com/server/21/go.php?to=admin-bigint-conversion).\* > > - > - federated\_reshares.share\_id\* > > - > - share\_external.id\* > > - > - share\_external.parent\* What is your advice ? Regards. Pierre ---
**Author:** ![Christoph](https://avatars.discourse-cdn.com/v4/letter/c/eb8c5e/32.png) [@Christoph](https://syncloud.discourse.group/u/Christoph)\ **Post date:** [26 October 2021 10:23 UTC](https://syncloud.discourse.group/t/security-setup-warnings/91/6 "2021-10-26T10:23:32Z")
👍 thank you Boris for this good solution ---
**Author:** ![boris](https://avatars.discourse-cdn.com/v4/letter/b/74df32/32.png) [@boris](https://syncloud.discourse.group/u/boris)\ **Post date:** [30 October 2021 16:44 UTC](https://syncloud.discourse.group/t/security-setup-warnings/91/7 "2021-10-30T16:44:39Z")
> Some columns in the database are missing a conversion to big int. try this: ```auto snap run nextcloud.occ db:convert-filecache-bigint ```