Home Esplora Aiuto
Accedi
someonewithpc
/
gnusocial-issues
Segui 1
Vota 0
Forka 0
File Problemi 0 Pull Requests 0 Wiki
Ramo (Branch): master
Rami (Branch) Tag
gnusocial-is...
/
issues
/
notabug.org
/
200

200 2.4 KB
Permalink Cronologia Originale

12345678910111213141516171819202122232425262728293031 
  1. ---
    2. 

  2. title: Autocomplete: two suggestions for the same account
    3. 

  3. author: notabug.org/aab
    4. 

  4. time: Sun, 09 Aug 2020 09:28:38 UTC
    5. 

  5. status: open
    6. 

  6. ---
    7. 

  7. 

  8. author: notabug.org
    9. 

  9. time: Sun, 09 Aug 2020 09:28:38 UTC
    10. 

  10. content: -----
    11. 

  11. I guess it is not because of autocomplete, but i don't really know the origin of this; maybe the fix_duplicates script not removing duplicates of the same server where it is executed? It works fine for remote accounts (EDIT: no, it doesn't, read below).
    12. 

  12. -----
    13. 

  13. 

  14. author: notabug.org
    15. 

  15. time: Tue, 11 Aug 2020 15:44:42 UTC
    16. 

  16. content: -----
    17. 

  17. I've prepared a query that returns all remote profiles that have duplicates. PostgreSQL: ```sql SELECT ("profile"."nickname" || '@' || regexp_replace("profile"."profileurl", '^https?://([^/]+)/.*$', '\1')) COLLATE "C" AS "remote_profile", MAX("profile"."created") AS "most_recent", COUNT(*) AS "count" FROM "profile" LEFT JOIN "user" ON "profile"."id" = "user"."id" LEFT JOIN "user_group" ON "profile"."id" = "user_group"."profile_id" WHERE "profile"."nickname" <> '' AND "user"."id" IS NULL AND "user_group"."profile_id" IS NULL GROUP BY "remote_profile" HAVING COUNT(*) > 1 ORDER BY "count" DESC; ``` MariaDB: ```sql SELECT concat(`profile`.`nickname`, '@', regexp_substr(`profile`.`profileurl`, '(?:(?<=http://)|(?<=https://))([^/]+)')) AS `remote_profile`, MAX(`profile`.`created`) AS `most_recent`, COUNT(*) AS `count` FROM `profile` LEFT JOIN `user` ON `profile`.`id` = `user`.`id` LEFT JOIN `user_group` ON `profile`.`id` = `user_group`.`profile_id` WHERE `profile`.`nickname` <> '' AND `user`.`id` IS NULL AND `user_group`.`profile_id` IS NULL GROUP BY `remote_profile` HAVING COUNT(*) > 1 ORDER BY `count` DESC; ```
    18. 

  18. -----
    19. 

  19. 

  20. author: notabug.org
    21. 

  21. time: Fri, 14 Aug 2020 22:05:59 UTC
    22. 

  22. content: -----
    23. 

  23. Using that query (thanks!) i've seen that executing some of OStatus scripts and fix_duplicates.php again improves the situation (from 73 to 29 repeated profiles) and the count (from 14 to 3). Anyway, it seems that if the remote node is down (or dead), there's no way to de-duplicate profiles: FWIW: Unable to connect to tls://social.ingobernable.net:443. Error: Conexi?n rehusada
    24. 

  24. -----
    25. 

  25. 

  26. author: notabug.org
    27. 

  27. time: Sun, 16 Aug 2020 17:56:22 UTC
    28. 

  28. content: -----
    29. 

  29. Ok, deleting from "profile" the ones already dead, and with some more cleaning, fix_duplicates.php returns nothing :) I'm only seeing this now with local profiles, which kind of makes sense... or not? :)
    30. 

  30. -----
    31. 

  31.