Re: [sqlite] Error: malformed database schema - near )

Hi Stephen, Many thanks for your response. The database had been working fine. It is actually the second time this has happened - but luckily our application is not in production yet. Yes, I saw that thread you are referring to. I think our problem might be different. When I do a select *

[sqlite] Error: malformed database schema - near )

Hi, We are using SQLite version 3.3.8 on Debian linux. Every now and again we are getting corrupted databases. We suspect it is because the computer is being turned off mid database operation. We have given full permissions to the folder the database is in and to the database itself. The most

Re: [sqlite] Error: malformed database schema - near )

On Sat, 9 Aug 2008 09:21:07 +1200, you wrote: The second question is what can I do to prevent this problem occurring? Is the database shared over NFS? Do you use any dangerous PRAGMA, like PRAGMA synchronous = OFF; ? -- ( Kees Nuyt ) c[_] ___

[sqlite] Possible View bug

Hey all, I think I managed to hit a bug with sqlite and views. I try to insert onto the view (I have a trigger setup to handle it), but sqlite gives me the following error: no such column: from_visit Here is test file that demonstrates the bug: http://files.shawnwilsher.com/2008/8/9/test-bug.c

Re: [sqlite] Possible View bug

Shawn Wilsher [EMAIL PROTECTED] wrote in message news:[EMAIL PROTECTED] I think I managed to hit a bug with sqlite and views. I try to insert onto the view (I have a trigger setup to handle it), but sqlite gives me the following error: no such column: from_visit Here is test file that