Re: [sqlite] Table was deleted on macOS

2019-10-23 Thread Eduardo Morras
On Tue, 15 Oct 2019 21:11:05 + "t...@qvgps.com" wrote: > Hi Group, > > here is a very strange and rare fault which one of our users > experienced on macOS . > > He was working in our app for a while creating a lot of new data. > So over several hours many INSERT INTO mytable > Without

Re: [sqlite] Table was deleted on macOS

2019-10-16 Thread Olaf Schmidt
Am 15.10.2019 um 23:53 schrieb Simon Slavin: ... There is no reason for a table to disappear. But sometimes intent... ;-) Maybe one of the App-Users is an xkcd-fan... https://xkcd.com/327/ @the OP Don't tell us now, that the table in question was indeed named "Students"... Olaf

Re: [sqlite] Table was deleted on macOS

2019-10-15 Thread Jens Alfke
Was the database in a folder managed by Dropbox or Google Drive or iCloud Drive, i.e. where some background agent could replace it with a 'newer' copy from another computer? —Jens ___ sqlite-users mailing list sqlite-users@mailinglists.sqlite.org

Re: [sqlite] Table was deleted on macOS

2019-10-15 Thread Peter da Silva
Check the local time machine backups? Even if you don't have a TM backup drive Mojave maintains on-drive backups. On Tue, 15 Oct 2019, 16:54 Simon Slavin, wrote: > Sorry, I have no other ideas. There is no reason for a table to disappear. > ___ >

Re: [sqlite] Table was deleted on macOS

2019-10-15 Thread Simon Slavin
Sorry, I have no other ideas. There is no reason for a table to disappear. ___ sqlite-users mailing list sqlite-users@mailinglists.sqlite.org http://mailinglists.sqlite.org/cgi-bin/mailman/listinfo/sqlite-users

Re: [sqlite] Table was deleted on macOS

2019-10-15 Thread t...@qvgps.com
-- Originalnachricht -- Von: "Simon Slavin" mailto:slav...@bigfraud.org>> An: "SQLite mailing list" mailto:sqlite-users@mailinglists.sqlite.org>> Gesendet: 15.10.2019 23:24:17 Betreff: Re: [sqlite] Table was deleted on macOS On 15 Oct 2019, at

Re: [sqlite] Table was deleted on macOS

2019-10-15 Thread Simon Slavin
On 15 Oct 2019, at 10:11pm, t...@qvgps.com wrote: > "no such table: mytable" > > The client sent us the database and the table "mytable" was really gone. The > database also seems to be fine, no errors. Do you mean by that that you ran integrity_check() ? Is everything else there, or did

[sqlite] Table was deleted on macOS

2019-10-15 Thread t...@qvgps.com
Hi Group, here is a very strange and rare fault which one of our users experienced on macOS . He was working in our app for a while creating a lot of new data. So over several hours many INSERT INTO mytable Without any errors. Then he did a query SELECT COUNT(*) FROM mytable WHERE