aboutsummaryrefslogtreecommitdiffhomepage
diff options
context:
space:
mode:
authorChocobozzz <me@florianbigard.com>2020-01-28 11:09:40 +0100
committerChocobozzz <me@florianbigard.com>2020-01-28 11:09:40 +0100
commit3ae0bbd23c6f1b2790975328d8eae6a8317c223d (patch)
tree38bc75c7b186168e275ec6dff8963ba218b1ce2b
parent751c8f68ec8124247b9249cd3ae6610ca6e0399e (diff)
downloadPeerTube-3ae0bbd23c6f1b2790975328d8eae6a8317c223d.tar.gz
PeerTube-3ae0bbd23c6f1b2790975328d8eae6a8317c223d.tar.zst
PeerTube-3ae0bbd23c6f1b2790975328d8eae6a8317c223d.zip
Improve SQL request doc
-rw-r--r--CHANGELOG.md2
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