Re: [sqlite] Strange problem with different sqlite versions accessing the same database
> Any idea? Apparently you have problematic implementation of network drive. Generally it's a very bad idea to use SQLite with file on network drive because SQLite uses file system locking mechanisms which are pretty bad working on network drives. Pavel On Tue, Nov 10, 2009 at 8:00 PM, Yuzem wrote: > > Ok, I have replaced the older version and now I have the same sqlite version > on both computers but the problem persist. Changes don't get saved on the > computer that access the database trough the network. > > Any idea? > -- > View this message in context: > http://old.nabble.com/Strange-problem-with-different-sqlite-versions-accessing-the-same-database-tp26257575p26294299.html > Sent from the SQLite mailing list archive at Nabble.com. > > ___ > 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
Re: [sqlite] Strange problem with different sqlite versions accessing the same database
Ok, I have replaced the older version and now I have the same sqlite version on both computers but the problem persist. Changes don't get saved on the computer that access the database trough the network. Any idea? -- View this message in context: http://old.nabble.com/Strange-problem-with-different-sqlite-versions-accessing-the-same-database-tp26257575p26294299.html Sent from the SQLite mailing list archive at Nabble.com. ___ sqlite-users mailing list sqlite-users@sqlite.org http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users
[sqlite] Strange problem with different sqlite versions accessing the same database
I have one database on a shared folder across the network. The database is accessed by two different computers with different sqlite versions. There was no problem until I updated the OS on one of the computer. Now I have: 1: Ubuntu Hardy - sqlite3 3.4.2 2: Ubuntu Karmic - sqlite3 3.6.16 The newest version works correctly but the older doesn't save any changes. If I do an update and then a select in the same connection I can see the changes but they don't get saved. Some times when accessing the database with one version the database was different than when accessing with the other, and I know that it was the same database, I even check the size. After some time, the database goes back to be the same for the two versions. I have no idea why this is happening... Any help is welcome and sorry for my english. -- View this message in context: http://old.nabble.com/Strange-problem-with-different-sqlite-versions-accessing-the-same-database-tp26257575p26257575.html Sent from the SQLite mailing list archive at Nabble.com. ___ sqlite-users mailing list sqlite-users@sqlite.org http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users