[sqlite] SQLite for Windows Phone bug
Hello, SQLite team, I would like to report a bug in the Windows Phone version of SQLite, that is already present for three releases in the row. The problem arises quite randomly, when SQLite refuses to insert or update some items into database and throws the following error: SQL logic error or missing database . I have checked the SQL and that database is well present, but the problem persists. The situation is even worse because the inserts and updates that fail seem to be completely random - if I compare an entry that fails and one that doesn’t, there is nothing that should be taken as a reason for the error. I’m not the only one experiencing this - http://stackoverflow.com/questions/20474253/sqlite-3-8-2-exception-on-update-statement . The interesting fact is that in the 3.8.1 version this never happened, so the cause must be some change between these the version 3.8.1 and version 3.8.2. Can you please check if anything can be done? My project is highly dependant on SQLite, but this way it is not reliable enough… Thank you very, very much Sincerely Martin Zikmund Sent from Surface Pro ___ sqlite-users mailing list sqlite-users@sqlite.org http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users
Re: [sqlite] SQLite for Windows Phone bug
On 19 Feb 2014, at 5:06am, Martin Zikmund martinzikm...@live.com wrote: SQL logic error or missing database The two usual causes of this under WinMob are both related to permissions and privileges. The folder the database file is stored in may be protected against the app opening the existing database file or creating a new journal file, or the permissions on the database file may be protected against the app. First make sure you are specifying the correct path. If you didn't specify a full path, try temporarily doing so in your test setup and see if anything changes. If that doesn't work try modifying your app to create a new text file (standard C file API) in the same folder as the database file normally lives. Does it succeed ? Simon. ___ sqlite-users mailing list sqlite-users@sqlite.org http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users
Re: [sqlite] SQLite for Windows Phone bug
Have you activated the error and warning log to see if it gives you any further diagnostics? http://www.sqlite.org/errlog.html On Wed, Feb 19, 2014 at 12:06 AM, Martin Zikmund martinzikm...@live.comwrote: Hello, SQLite team, I would like to report a bug in the Windows Phone version of SQLite, that is already present for three releases in the row. The problem arises quite randomly, when SQLite refuses to insert or update some items into database and throws the following error: SQL logic error or missing database . I have checked the SQL and that database is well present, but the problem persists. The situation is even worse because the inserts and updates that fail seem to be completely random - if I compare an entry that fails and one that doesn't, there is nothing that should be taken as a reason for the error. I'm not the only one experiencing this - http://stackoverflow.com/questions/20474253/sqlite-3-8-2-exception-on-update-statement. The interesting fact is that in the 3.8.1 version this never happened, so the cause must be some change between these the version 3.8.1 and version 3.8.2. Can you please check if anything can be done? My project is highly dependant on SQLite, but this way it is not reliable enough... Thank you very, very much Sincerely Martin Zikmund Sent from Surface Pro ___ sqlite-users mailing list sqlite-users@sqlite.org http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users -- D. Richard Hipp d...@sqlite.org ___ sqlite-users mailing list sqlite-users@sqlite.org http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users
