I updated the faulty column to an empty string and noticed that I could select all records in that table. That must be a sign that something was written to that column that sqlite could not parse.
Question: Are there a way to dump the database without any validation or error checking? Can I access the content in the sqlite file somehow to see what really resides in that column that makes it corrupt? Best regards, GT -----Ursprungligt meddelande----- Fr?n: sqlite-users-bounces at mailinglists.sqlite.org [mailto:sqlite-users-bounces at mailinglists.sqlite.org] F?r Gabriel Tiste Skickat: den 10 april 2015 14:35 Till: General Discussion of SQLite Database ?mne: Re: [sqlite] Sqlite 2 and Windows 7 Your assumption regarding versions are not accurate unfortunatly. We are actually using a sqlite2 database(old application...). When I use the sqlite.exe tool I got from sqlite.org CMD: sqlite.exe db.sqlite -> PRAGMA integrity_check; I get OK. Is it possible that we have written something to that table that SQL can't handle? Best regards, GT -----Ursprungligt meddelande----- Fr?n: sqlite-users-bounces at mailinglists.sqlite.org [mailto:sqlite-users-bounces at mailinglists.sqlite.org] F?r Simon Slavin Skickat: den 10 april 2015 14:27 Till: General Discussion of SQLite Database ?mne: Re: [sqlite] Sqlite 2 and Windows 7 On 10 Apr 2015, at 12:33pm, Gabriel Tiste <Gabriel.Tiste at hiq.se> wrote: > We can do a select on columns but not select * on affected table except the > last column. Including that in the select cause the client to say that table > is missing or logic is not correct. > > Are there any known issues with sqlite2 Are you absolutely positively sure you're using SQLite2 and not SQLite3 ? I'm going to assume you actually mean you're using SQLite3 which was released in 2004. > and windows 7? How can I investigate whats causing this error when I try to > select * from the affected table? Please execute the following: PRAGMA database.integrity_check and give us some idea about what it returns. You can run the command using your own program, or make a copy of the database (on another computer ?) and use the SQLite shell tool. Simon. _______________________________________________ sqlite-users mailing list sqlite-users at mailinglists.sqlite.org http://mailinglists.sqlite.org/cgi-bin/mailman/listinfo/sqlite-users _______________________________________________ sqlite-users mailing list sqlite-users at mailinglists.sqlite.org http://mailinglists.sqlite.org/cgi-bin/mailman/listinfo/sqlite-users
