<div dir="ltr">I advice to add PK that associated with rowid for dropoff table. Because it can broke DB after .dump or Vacuum.<br><br><a href="http://www.sqlite.org/lang_createtable.html#rowid">http://www.sqlite.org/lang_createtable.html#rowid</a><br>
<br>As for me I had created new dropoff_tmp table with PK (see above link), migrated data to it and after that did .dump successfully.<br></div><div class="gmail_extra"><br><br><div class="gmail_quote">On Thu, Jun 6, 2013 at 1:36 PM, Artyom Aleksandrov <span dir="ltr"><<a href="mailto:mailing.list@tem4uk.ru" target="_blank">mailing.list@tem4uk.ru</a>></span> wrote:<br>
<blockquote class="gmail_quote" style="margin:0 0 0 .8ex;border-left:1px #ccc solid;padding-left:1ex"><div dir="ltr"><div>I found mistake!<br><br></div><div>I converted sqlite db from 2 to 3 using dump. <br>And because dID it's just rowid in dropoff tables, I lost all rows with deleted dropoff.<br>
</div><div><br></div>
</div><div class="HOEnZb"><div class="h5"><div class="gmail_extra"><br><br><div class="gmail_quote">On Thu, Jun 6, 2013 at 1:21 PM, Artyom Aleksandrov <span dir="ltr"><<a href="mailto:mailing.list@tem4uk.ru" target="_blank">mailing.list@tem4uk.ru</a>></span> wrote:<br>
<blockquote class="gmail_quote" style="margin:0 0 0 .8ex;border-left:1px #ccc solid;padding-left:1ex"><div dir="ltr"><div><div>Some debug info.<br><br></div>It doesn't use duplicate dID how I thought before.<br></div>
It is remapping dID for previously upload files.<br><br>For example: I created new dropoff (214) and add one file (887) and after that other files change their dID for new one.<br>
sqlite> select rowid,dID from file where dID='214';<br>727|214<br>728|214<br>...<br>739|214<br>740|214<br>741|214<br>887|214<br></div><div><div><div class="gmail_extra"><br><br><div class="gmail_quote">
On Thu, Jun 6, 2013 at 12:29 AM, Artyom Aleksandrov <span dir="ltr"><<a href="mailto:mailing.list@tem4uk.ru" target="_blank">mailing.list@tem4uk.ru</a>></span> wrote:<br>
<blockquote class="gmail_quote" style="margin:0 0 0 .8ex;border-left:1px #ccc solid;padding-left:1ex"><p dir="ltr">Hi, I migrated my zento installation from Ubuntu 8.04 to 12.04 and caught disgusting bug.</p><div>
<br>
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.</div><p></p><div>
<div>
<p dir="ltr">It looks like "Did" (dropoff id) is not unique and there isn't check for it.</p>
</div></div></blockquote></div><br></div>
</div></div></blockquote></div><br></div>
</div></div></blockquote></div><br></div>