Page MenuHomeSoftware Heritage

Fix double-encoded release.name entries
Closed, ResolvedPublic

Description

rDLDGd45f073 fixed an issue where some tag names have been passed as bytes to an underlying API expecting text.

This means those database fields are doubly-encoded.

We need to fix that.

Event Timeline

olasd created this task.Jan 21 2016, 4:38 PM
olasd added a comment.Jan 21 2016, 8:51 PM

Currentlly running

update release set name=convert_from(decode(substring(release.name from 3), 'hex'), 'utf-8') where release.name LIKE '\\x%';
olasd closed this task as Resolved.Jan 22 2016, 6:31 PM

This has now been done.

zack removed a project: Staff.Mar 10 2016, 5:49 PM
olasd changed the visibility from "All Users" to "Public (No Login Required)".May 13 2016, 5:08 PM