Skip to content

[Bug] Pagination crash in Followers/Following list when Pixelfed DB has id as integer #359

@xhabih

Description

@xhabih

I have a Pixelfed instance and found tha some users of my instance using Pixelix get a Server Error when trying to load Followers/Following list on certain profiles:

Image

This is only happening with Pixelix, I can see the Followers/Following list without problems from web and with the official Pixelfed App.

It looks like the error occurs because on my intance db the "id" column is set as integer but Pixelix is trying to requests the next page of followers, with a query with max_id too high without needing to.

My instance public.followers table:

    Column      |              Type              | Collation | Nullable |                Default
-----------------+--------------------------------+-----------+----------+---------------------------------------
id              | integer                        |           | not null | nextval('followers_id_seq'::regclass)
profile_id      | bigint                         |           | not null |
following_id    | bigint                         |           | not null |
created_at      | timestamp(0) without time zone |           |          |
updated_at      | timestamp(0) without time zone |           |          |
local_profile   | boolean                        |           | not null | true
local_following | boolean                        |           | not null | true
show_reblogs    | boolean                        |           | not null | true
notify          | boolean                        |           | not null | false

Metadata

Metadata

Assignees

No one assigned

    Labels

    No labels
    No labels

    Type

    No type

    Projects

    No projects

    Milestone

    No milestone

    Relationships

    None yet

    Development

    No branches or pull requests

    Issue actions