Post 9nZyBpscPro7M9DVQG by mhamzahkhan@intahnet.co.uk
 (DIR) More posts by mhamzahkhan@intahnet.co.uk
 (DIR) Post #9nZxRNyNqFAnU1lRZ2 by snder@quey.org
       2019-10-04T10:26:16Z
       
       0 likes, 2 repeats
       
       HELP! Yesterday I migrated pixfed.com from YunoHost to a standalone install of #Pixelfed.I migrated the v0.10.0 version but when I'm upgrading to the latest version I get a database error. (see screenshot)Does anyone know how to fix this?#pixfed #pixelfed #help
       
 (DIR) Post #9nZxhgX2bj1JfzkNo8 by mhamzahkhan@intahnet.co.uk
       2019-10-04T10:28:56Z
       
       0 likes, 1 repeats
       
       @snder Find the offending row that is duplicate, and delete it?
       
 (DIR) Post #9nZxlODUe42u1yN1Gq by snder@quey.org
       2019-10-04T10:29:53Z
       
       0 likes, 1 repeats
       
       Hm, that's what I thought indeed but there are 7 apparently and I'm not that good with postgre on cli yet haha@mhamzahkhan
       
 (DIR) Post #9nZyBpscPro7M9DVQG by mhamzahkhan@intahnet.co.uk
       2019-10-04T10:34:42Z
       
       0 likes, 1 repeats
       
       @snder I don't have a PixelFed instance running atm so I'm not sure of the table structure or I could try to help. Maybe delete it using a graphical tool like  https://dbeaver.io/ or https://www.sequel.tech/
       
 (DIR) Post #9na8hPNDV8TPxLDr7o by snder@quey.org
       2019-10-04T12:32:25Z
       
       0 likes, 1 repeats
       
       @mhamzahkhan Hm, let's see if that works. Thank you!
       
 (DIR) Post #9naEWVD23ysuawdqU4 by snder@quey.org
       2019-10-04T13:37:40Z
       
       0 likes, 1 repeats
       
       @dansup Maybe?
       
 (DIR) Post #9naEYp5Z7eTSpUFuq0 by snder@quey.org
       2019-10-04T13:38:07Z
       
       0 likes, 1 repeats
       
       @mhamzahkhan I tried to remove the duplicates through the interface but it doesn't seem to work :(
       
 (DIR) Post #9naHLAbwbeDLO6a9Fw by snder@quey.org
       2019-10-04T14:09:13Z
       
       0 likes, 1 repeats
       
       Fixed the issue! One by one deleting the records haha@mhamzahkhan
       
 (DIR) Post #9naHU67cfL8Y4UekuO by mhamzahkhan@intahnet.co.uk
       2019-10-04T14:10:51Z
       
       0 likes, 1 repeats
       
       @snder haha yay!
       
 (DIR) Post #9nafX5MQLmnjTlXMVU by devporto@misskey.io
       2019-10-04T18:37:56.481Z
       
       0 likes, 0 repeats
       
       @snder@quey.org hopefully it worked out for you
       
 (DIR) Post #9nafX5sKRAK14iSqEi by snder@quey.org
       2019-10-04T18:40:20Z
       
       0 likes, 1 repeats
       
       @devporto Haha no worries mate! I guess we need to wait on updates ;-)If you also want to test it out you can signup on https://pixfed.com