aboutsummaryrefslogtreecommitdiffhomepage
path: root/CHANGELOG.md
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 /CHANGELOG.md
parent751c8f68ec8124247b9249cd3ae6610ca6e0399e (diff)
downloadPeerTube-3ae0bbd23c6f1b2790975328d8eae6a8317c223d.tar.gz
PeerTube-3ae0bbd23c6f1b2790975328d8eae6a8317c223d.tar.zst
PeerTube-3ae0bbd23c6f1b2790975328d8eae6a8317c223d.zip
Improve SQL request doc
Diffstat (limited to 'CHANGELOG.md')
-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