On 4/10/15, Gabriel Tiste <Gabriel.Tiste at hiq.se> wrote: > We have an application running on Apache 2.2 / PHP and Sqlite 2. Lately we > have heard from our customers regarding corrupt sqlite database files. We > can't figure out what in our application causing this and suspects that > something has happened when customer upgraded and ran our application on > Windows 7 instead of Windows XP. > > 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 and windows 7? How can I investigate > whats causing this error when I try to select * from the affected table? >
We are not aware of any problems. However, development work on sqlite2 stopped before windows7 came out and so sqlite2 was never actually tested on windows7. Sqlite3 was released and sqlite2 went into maintenance-only mode in 2004. The last bug-fix to sqlite2 was in early 2007. Windows7 came out in late 2009. There is a branch in the SQLite source tree for sqlite2. (https://www.sqlite.org/src/timeline?r=version_2&n=all) If you find a problem and submit a patch for Windows7, we'll be happy to check that in for you. -- D. Richard Hipp drh at sqlite.org
