Re: [sqlite] Vacuum Error with 2.8.16

2005-03-14 Thread Mitchell Vincent
D. Richard Hipp wrote: Your database schema became corrupted. I do not know how it happened. I am unable to reproduce the problem. Without additional information there is nothing more I can do. What additional information can I provide? Is there any chance at all to recover any of the data? --

Re: [sqlite] Vacuum Error with 2.8.16

2005-03-14 Thread D. Richard Hipp
On Mon, 2005-03-14 at 10:51 -0500, Mitchell Vincent wrote: > Mitchell Vincent wrote: > > D. Richard Hipp wrote: > >> > >> Can you tell me what the original schema is? > > > > > > Replied in private with the schema. I'm also happy to send the custom > > compiled DLL and the database if you need i

Re: [sqlite] Vacuum Error with 2.8.16

2005-03-14 Thread Mitchell Vincent
Mitchell Vincent wrote: D. Richard Hipp wrote: Can you tell me what the original schema is? Replied in private with the schema. I'm also happy to send the custom compiled DLL and the database if you need it. Thanks!!! Any additional thoughts on this? I'm happy to provide any additional informat

Re: [sqlite] Vacuum Error with 2.8.16

2005-03-10 Thread Mitchell Vincent
D. Richard Hipp wrote: On Thu, 2005-03-10 at 18:20 -0500, Mitchell Vincent wrote: D. Richard Hipp wrote: Were the blank lines in the original schema, or did they get inserted? Can you reproduce this problem? The blank lines got inserted. I can't reproduce this, Can you tell me what the original s

Re: [sqlite] Vacuum Error with 2.8.16

2005-03-10 Thread D. Richard Hipp
On Thu, 2005-03-10 at 18:20 -0500, Mitchell Vincent wrote: > D. Richard Hipp wrote: > > > > Were the blank lines in the original schema, or did they get > > inserted? Can you reproduce this problem? > > The blank lines got inserted. > > I can't reproduce this, Can you tell me what the original

Re: [sqlite] Vacuum Error with 2.8.16

2005-03-10 Thread Mitchell Vincent
D. Richard Hipp wrote: Were the blank lines in the original schema, or did they get inserted? Can you reproduce this problem? The blank lines got inserted. I can't reproduce this, no, it is straight from a customer. He insists that he is the only person accessing the database and that it happened

Re: [sqlite] Vacuum Error with 2.8.16

2005-03-10 Thread D. Richard Hipp
On Thu, 2005-03-10 at 17:23 -0500, Mitchell Vincent wrote: > It looks like one of the tables in the db is corrupted, I see this in a > .dump : > > CREATE TABLE payments(payment_id INTEGER PRIMARY KEY, > > invoice_id int4, > > customer_id int4, > > created timestamp, > > payment_type varchar,

Re: [sqlite] Vacuum Error with 2.8.16

2005-03-10 Thread Mitchell Vincent
D. Richard Hipp wrote: On Thu, 2005-03-10 at 16:37 -0500, Mitchell Vincent wrote: sqlite> vacuum; SQL error: near "varchaÃ": syntax error sqlite> These databases had been made with an earlier version of SQLite.. Ideas? Not much to go on I thought maybe it had something to do with the vacuum c

Re: [sqlite] Vacuum Error with 2.8.16

2005-03-10 Thread D. Richard Hipp
On Thu, 2005-03-10 at 16:37 -0500, Mitchell Vincent wrote: > sqlite> vacuum; > SQL error: near "varchaÃ": syntax error > sqlite> > > These databases had been made with an earlier version of SQLite.. Ideas? > Not much to go on -- D. Richard Hipp <[EMAIL PROTECTED]>

[sqlite] Vacuum Error with 2.8.16

2005-03-10 Thread Mitchell Vincent
sqlite> vacuum; SQL error: near "varchaä": syntax error sqlite> These databases had been made with an earlier version of SQLite.. Ideas? -- - Mitchell Vincent - kBilling - Invoices Made Easy! - http://www.k-billing.com