DFE-Digital / polis-whitelabel

:milky_way: Open Source AI for large scale open ended feedback
https://pol.is
GNU Affero General Public License v3.0
3 stars 0 forks source link

Crash when voting as anonymous participant using XID only #42

Closed brendanarnold closed 1 year ago

brendanarnold commented 1 year ago

Steps to recreate

Cause

This sequence hits sql.ts which has some fields defined in participants_extended table which don't exist in the current schema. E.g. permanent_cookie, origin, encrypted_ip_address, encrypted_x_forwarded_for

brendanarnold commented 1 year ago

There is a GDPR concern here as IP addreses appear to be being stored - in practice the encrypted_ip_address field is NULL in our tests but as far as I can tell this isn't used anywhere in the app. This adn the encrypted_x_forwarded_for should be removed as part of this ticket