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

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

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

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

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