URL:
<http://gna.org/bugs/?func=detailitem&item_id=2850>
Summary: Binary attachements corrupted by UTF-8 conversion
Project: Savane
Submitted by: beuc
Submitted on: jeu 08.09.2005 à 07:53
Category: Database
Priority: A - Later
Severity: 4 - Important
Status: None
Privacy: Public
Assigned to: None
Originator Email:
Open/Closed: Open
Release: 1.0.7
Planned Release:
_______________________________________________________
Details:
User reported corrupted downloads at Savannah today.
Binary data was encoded utf-8 during the database conversion.
I reverted those using a backup I _luckily_ kept since the conversion. This
data might be restored using the reverse iconv transformation, but I haven't
tested. Downloads could not be reverted by simple users, because Savane
truncates the (bigger, if iso8859->utf8) data at file_size.
Apparently trackers attachments are the only binary data. There might be
issues with binary-encoded numbers, but apparently we don't use that.
We have a problem with the Savane upgrades: I got 2 issues with 1.0.7 and
another one with 1.0.8. In each case one need to be a Savane dev to fix the
issue so that's pretty bad for us.
As for fixing the utf8 upgrade procedure, I guess we should look at MySQL
tools to do the job, or else automate the attachment recovery.
_______________________________________________________
Reply to this item at:
<http://gna.org/bugs/?func=detailitem&item_id=2850>
_______________________________________________
Message posté via/par Gna!
http://gna.org/
_______________________________________________
Savane-dev mailing list
[email protected]
https://mail.gna.org/listinfo/savane-dev
