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 corruption problems.. I get a "database disk image is malformed" error when doing some queries, but not all.
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,
payment_amount int4,
check_number varchar,
cc_name varchaâ;
.... then it continues with another table...
I'm hoping this can be repaired or recovered in some way.. Any chance of that?
-- - Mitchell Vincent - kBilling - Invoices Made Easy! - http://www.k-billing.com