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
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
Mitchell Vincent <[EMAIL PROTECTED]> writes:
> It looks like one of the tables in the db is corrupted, I see this in
> a .dump :
>
> I'm hoping this can be repaired or recovered in some way.. Any chance
> of that?
>
What about saving the dump (presuming it is complete) and restore in a
fresh
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,
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
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;
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
7 matches
Mail list logo