For me your sequence of commands clearly shows database file is badly managed by your Mac file system and/or network sharing mechanism. Apparently when you try to delete rows from table on Mac SQLite didn't understand that database was changed (probably because of some caching either on Mac side or on PC side). So SQLite tried to change database as if it wasn't changed already, hit some inconsistency with assumption somewhere in the middle of the process and it resulted in corrupted database...
AFAIK it's a general rule: don't use SQLite with database somewhere on network shared file system, otherwise bad things can happen. Pavel On Wed, Mar 24, 2010 at 5:42 PM, Dave Dyer <dd...@real-me.net> wrote: > I was able to reproduct the problem using a trivial set of commands > to the standard sqlite command tool: > > > On the Mac: > > gorp:~/2010 yeartech/yearbook tools/resource davedyer$ > /applications/utilities/sqlite3-shell actiontool2.sqlite > SQLite version 3.6.10 with the Encryption Extension > sqlite> attach database 'indexer.sqlite' as indexer; > sqlite> begin transaction; > > > On the PC: > > M:\2010 yeartech\yearbook tools\resource>sqlite3 actiontool2.sqlite > sqlite> attach database 'indexer.sqlite' as indexer; > sqlite> begin transaction; > sqlite> delete from indexer.preference_table; > sqlite> insert into indexer.preference_table select * from preference_table; > sqlite> commit; > > On the Mac: > > > sqlite> delete from indexer.preferences_table; > SQL error: no such table: indexer.preferences_table > sqlite> delete from indexer.preference_table; > sqlite> insert into indexer.preference_table select * from preference_table; > SQL error: database disk image is malformed > sqlite> > > _______________________________________________ > sqlite-users mailing list > sqlite-users@sqlite.org > http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users > _______________________________________________ sqlite-users mailing list sqlite-users@sqlite.org http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users
