diff options
author | Chocobozzz <me@florianbigard.com> | 2020-01-28 11:09:40 +0100 |
---|---|---|
committer | Chocobozzz <me@florianbigard.com> | 2020-01-28 11:09:40 +0100 |
commit | 3ae0bbd23c6f1b2790975328d8eae6a8317c223d (patch) | |
tree | 38bc75c7b186168e275ec6dff8963ba218b1ce2b | |
parent | 751c8f68ec8124247b9249cd3ae6610ca6e0399e (diff) | |
download | PeerTube-3ae0bbd23c6f1b2790975328d8eae6a8317c223d.tar.gz PeerTube-3ae0bbd23c6f1b2790975328d8eae6a8317c223d.tar.zst PeerTube-3ae0bbd23c6f1b2790975328d8eae6a8317c223d.zip |
Improve SQL request doc
-rw-r--r-- | CHANGELOG.md | 2 |
1 files changed, 1 insertions, 1 deletions
diff --git a/CHANGELOG.md b/CHANGELOG.md index 6a5e29845..c573b12ed 100644 --- a/CHANGELOG.md +++ b/CHANGELOG.md | |||
@@ -8,7 +8,7 @@ | |||
8 | * `cd /var/www/peertube/peertube-latest && sudo -u peertube NODE_CONFIG_DIR=/var/www/peertube/config NODE_ENV=production node dist/scripts/migrations/peertube-2.1.js` | 8 | * `cd /var/www/peertube/peertube-latest && sudo -u peertube NODE_CONFIG_DIR=/var/www/peertube/config NODE_ENV=production node dist/scripts/migrations/peertube-2.1.js` |
9 | * **/!\ VERY IMPORTANT /!\\** In the next PeerTube release (v2.2.0), we'll add a unique index on actors usernames to fix some federation bugs. | 9 | * **/!\ VERY IMPORTANT /!\\** In the next PeerTube release (v2.2.0), we'll add a unique index on actors usernames to fix some federation bugs. |
10 | Please check now if you have conflicts using: | 10 | Please check now if you have conflicts using: |
11 | * Go inside your database using `psql` and run `select "preferredUsername" from actor where "serverId" is null group by "preferredUsername" having count(*) > 1` | 11 | * Go inside your database using `sudo -u postgres psql peertube_prod` and run `select "preferredUsername" from actor where "serverId" is null group by "preferredUsername" having count(*) > 1;` |
12 | * If you have some results, it seems you have duplicate channels/accounts. | 12 | * If you have some results, it seems you have duplicate channels/accounts. |
13 | For every entry, you'll have to change the preferredUsername of the entry you want (so they are unique). | 13 | For every entry, you'll have to change the preferredUsername of the entry you want (so they are unique). |
14 | The updated actors could have some federations issues | 14 | The updated actors could have some federations issues |