Pictures disappearing from archive

[GoogleCodeExporter]

If a picture is deleted in original thread on 4chon, but post retains, it
will also be deleted in archive.

Original issue reported on code.google.com by andrey.o...@gmail.com on 2 Mar 2009 at 5:07

[GoogleCodeExporter]

This and issue 19 are the only two fuuka bugs that can be considered "pretty 
bad." I honestly should try to find the time to tackle this.

Original comment by eksopl on 9 Mar 2011 at 2:20

• Changed title: Pictures disappearing from archive
• Added labels: Priority-High
• Removed labels: Priority-Medium

[GoogleCodeExporter]

Original comment by eksopl on 19 Mar 2011 at 4:56

[GoogleCodeExporter]

Found a way to fix this by complete accident, when struggling with 
auto_increment columns and the REPLACE statement.

Using ON DUPLICATE KEY UPDATE, we can tell it to only update the columns 
`comment` and `deleted`. So the other columns keep their first (good) data.

So good.

Issue 36 still stands, but I don't really care about any of the points I made 
there anymore. It would be nice to not reinsert comments unless they contain a 
(USER WAS BANNED FOR THIS POST) message, as that'd save a lot of work at 
constantly updating the comment field, but I can live with that. It's not too 
hard to handle that case, to be fair, I could give it a shot after fixing the 
rest of the stuff I still want to fix.

Original comment by eksopl on 4 Jul 2011 at 5:24

• Changed state: Fixed