bug: votes query return null value

[ChaituVR]

Try the following query

query Votes {
    votes(first: 1000, where: { voter: "0x24F15402C6Bb870554489b2fd2049A85d75B982f" }) {
      proposal {
        id
        space {
          id
        }
        ipfs
      }
    }
  }

It will return a response that contains this

[wa0x6e]

I am not getting the same graphql response. Was the DB cleaned up in the meantime ?

[ChaituVR]

No change. can try again?

It is bit down in response, search for null

[wa0x6e]

How is that possible when we use DELETE FROM votes WHERE proposal = ?; when deleting proposals ?

Is it just bug, which can be resolve by consolidating the votes database ?

[wa0x6e]

This is a an issue with orphan proposals, where the proposals are not linked to a valid space anymore.

Either the space has been renamed, deleted, or something's wrong happened during the migration.

You can see the list of proposals without any valid space with

SELECT space from proposals where space NOT IN (select id from spaces) group by space;

There are currently 81 proposals in that situation