[ZendTo] Re: Duplicate dropoff id

[Artyom Aleksandrov]

I found mistake!

I converted sqlite db from 2 to 3 using dump.
And because dID it's just rowid in dropoff tables, I lost all rows with
deleted dropoff.



On Thu, Jun 6, 2013 at 1:21 PM, Artyom Aleksandrov
<mailing.list at tem4uk.ru>wrote:

> Some debug info.
>
> It doesn't use duplicate dID how I thought before.
> It is remapping dID for previously upload files.
>
> For example: I created new dropoff (214) and add one file (887) and after
> that other files change their dID for new one.
> sqlite> select rowid,dID from file where dID='214';
> 727|214
> 728|214
> ...
> 739|214
> 740|214
> 741|214
> 887|214
>
>
> On Thu, Jun 6, 2013 at 12:29 AM, Artyom Aleksandrov <
> mailing.list at tem4uk.ru> wrote:
>
>> Hi, I migrated my zento installation from Ubuntu 8.04 to 12.04 and caught
>> disgusting bug.
>>
>> Time to time when someone create new dropoff his/her files are including
>> to already exist dropoff. And on dropoff summary page we can see old
>> dropoff with download statistic  and old/new files.
>>
>>  It looks like "Did" (dropoff id) is not unique and there isn't check
>> for it.
>>
>
>
-------------- next part --------------
An HTML attachment was scrubbed...
URL: http://mailman.ecs.soton.ac.uk/pipermail/zendto/attachments/20130606/85b0e317/attachment.html