Re: [sqlite] SQLite>=3.5.6 does not open database file
On Apr 16, 2008, at 4:41 PM, Steve Topov wrote: > Any clues? > > -Original Message- > From: [EMAIL PROTECTED] > [mailto:[EMAIL PROTECTED] On Behalf Of Steve Topov > Sent: Monday, April 14, 2008 5:02 PM > To: 'General Discussion of SQLite Database' > Subject: Re: [sqlite] SQLite>=3.5.6 does not open database file > > I am on Windows XP using sqlite 3.5.6 dll created from the source. Why don't you try the pre-compiled DLLs off of the website. D. Richard Hipp [EMAIL PROTECTED] ___ sqlite-users mailing list sqlite-users@sqlite.org http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users
Re: [sqlite] SQLite>=3.5.6 does not open database file
Any clues? -Original Message- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] On Behalf Of Steve Topov Sent: Monday, April 14, 2008 5:02 PM To: 'General Discussion of SQLite Database' Subject: Re: [sqlite] SQLite>=3.5.6 does not open database file I am on Windows XP using sqlite 3.5.6 dll created from the source. I debugged the code - Sqlite3_open returns OK but any other function after that returns 1. For example sqlite3_prepare returns 1 when I do "Select * from sqlite_master". Same for sqlite3_execute. Tried different SQL statements - same error. If I switch to 3.3.5 dll the problem goes away. Regards. -Original Message- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] On Behalf Of D. Richard Hipp Sent: Monday, April 14, 2008 4:46 PM To: General Discussion of SQLite Database Subject: Re: [sqlite] SQLite>=3.5.6 does not open database file On Apr 14, 2008, at 4:30 PM, Steve Topov wrote: > I already reported this bug but did not receive any responds so I am > trying one more time. > The problem: > SQLite version 3.5.6 and up returns an error when opening some > database > files. The error is “SQL logic error or missing database”. > Version prior to version 3.5.6 works fine with these database files. > > I do not know the version of SQLite the database file in question was > created with. And I am talking about SQLite 3 database file – not > SQLite > 2, not Microsoft Access, > not any other file format. > > To make story short: SQLite 3.5.6 can not open SQLite 3 database file. > > I'm working with the file named "dpdshop.sl3" that you sent me, 5444608 bytes in size. MD5 checksum 9fa76c1610a5e7c826d2745191e7a401 I can open and read this file without problems on MacOSX using SQLite version 3.4.0, 3.5.6, 3.5.7 and the latest in CVS. I ran PRAGMA integrity_check using all four versions of SQLite and all return "ok". D. Richard Hipp [EMAIL PROTECTED] ___ sqlite-users mailing list sqlite-users@sqlite.org http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users ___ sqlite-users mailing list sqlite-users@sqlite.org http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users ___ sqlite-users mailing list sqlite-users@sqlite.org http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users
Re: [sqlite] SQLite>=3.5.6 does not open database file
I am on Windows XP using sqlite 3.5.6 dll created from the source. I debugged the code - Sqlite3_open returns OK but any other function after that returns 1. For example sqlite3_prepare returns 1 when I do "Select * from sqlite_master". Same for sqlite3_execute. Tried different SQL statements - same error. If I switch to 3.3.5 dll the problem goes away. Regards. -Original Message- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] On Behalf Of D. Richard Hipp Sent: Monday, April 14, 2008 4:46 PM To: General Discussion of SQLite Database Subject: Re: [sqlite] SQLite>=3.5.6 does not open database file On Apr 14, 2008, at 4:30 PM, Steve Topov wrote: > I already reported this bug but did not receive any responds so I am > trying one more time. > The problem: > SQLite version 3.5.6 and up returns an error when opening some > database > files. The error is “SQL logic error or missing database”. > Version prior to version 3.5.6 works fine with these database files. > > I do not know the version of SQLite the database file in question was > created with. And I am talking about SQLite 3 database file – not > SQLite > 2, not Microsoft Access, > not any other file format. > > To make story short: SQLite 3.5.6 can not open SQLite 3 database file. > > I'm working with the file named "dpdshop.sl3" that you sent me, 5444608 bytes in size. MD5 checksum 9fa76c1610a5e7c826d2745191e7a401 I can open and read this file without problems on MacOSX using SQLite version 3.4.0, 3.5.6, 3.5.7 and the latest in CVS. I ran PRAGMA integrity_check using all four versions of SQLite and all return "ok". D. Richard Hipp [EMAIL PROTECTED] ___ sqlite-users mailing list sqlite-users@sqlite.org http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users ___ sqlite-users mailing list sqlite-users@sqlite.org http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users
Re: [sqlite] SQLite>=3.5.6 does not open database file
On Apr 14, 2008, at 4:30 PM, Steve Topov wrote: > I already reported this bug but did not receive any responds so I am > trying one more time. > The problem: > SQLite version 3.5.6 and up returns an error when opening some > database > files. The error is “SQL logic error or missing database”. > Version prior to version 3.5.6 works fine with these database files. > > I do not know the version of SQLite the database file in question was > created with. And I am talking about SQLite 3 database file – not > SQLite > 2, not Microsoft Access, > not any other file format. > > To make story short: SQLite 3.5.6 can not open SQLite 3 database file. > > I'm working with the file named "dpdshop.sl3" that you sent me, 5444608 bytes in size. MD5 checksum 9fa76c1610a5e7c826d2745191e7a401 I can open and read this file without problems on MacOSX using SQLite version 3.4.0, 3.5.6, 3.5.7 and the latest in CVS. I ran PRAGMA integrity_check using all four versions of SQLite and all return "ok". D. Richard Hipp [EMAIL PROTECTED] ___ sqlite-users mailing list sqlite-users@sqlite.org http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users
Re: [sqlite] SQLite>=3.5.6 does not open database file
On 4/14/08, Steve Topov <[EMAIL PROTECTED]> wrote: > I do not have sqlite3 command line tool. I work with dlls. If you email > me sqlite3 I will create a dump. http://www.sqlite.org/sqlite-3_5_7.zip > Compressed database file is 1.8 Meg. > > > -Original Message- > From: [EMAIL PROTECTED] > > [mailto:[EMAIL PROTECTED] On Behalf Of D. Richard Hipp > Sent: Monday, April 14, 2008 1:59 PM > To: General Discussion of SQLite Database > > Cc: [EMAIL PROTECTED] > Subject: Re: [sqlite] SQLite>=3.5.6 does not open database file > > > > On Apr 14, 2008, at 4:53 PM, D. Richard Hipp wrote: > > > > On Apr 14, 2008, at 4:47 PM, Steve Topov wrote: > >> I can open the file with 3.3.5. I did not try to dump it and recreate > >> with 3.5.6. > >> > > > > With version 3.5.5, please do this: > > > > sqlite3 yourdatabasefile.db .schema >schema.txt > > > > then email me schema.txt file. > > > > If the database file is small enough, please send me the whole thing. > > D. Richard Hipp > [EMAIL PROTECTED] > > > > > ___ > sqlite-users mailing list > sqlite-users@sqlite.org > http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users > > > -- Puneet Kishor http://punkish.eidesis.org/ Nelson Institute for Environmental Studies http://www.nelson.wisc.edu/ Open Source Geospatial Foundation (OSGeo) http://www.osgeo.org/ ___ sqlite-users mailing list sqlite-users@sqlite.org http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users
Re: [sqlite] SQLite>=3.5.6 does not open database file
I do not have sqlite3 command line tool. I work with dlls. If you email me sqlite3 I will create a dump. Compressed database file is 1.8 Meg. -Original Message- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] On Behalf Of D. Richard Hipp Sent: Monday, April 14, 2008 1:59 PM To: General Discussion of SQLite Database Cc: [EMAIL PROTECTED] Subject: Re: [sqlite] SQLite>=3.5.6 does not open database file On Apr 14, 2008, at 4:53 PM, D. Richard Hipp wrote: > > On Apr 14, 2008, at 4:47 PM, Steve Topov wrote: >> I can open the file with 3.3.5. I did not try to dump it and recreate >> with 3.5.6. >> > > With version 3.5.5, please do this: > > sqlite3 yourdatabasefile.db .schema >schema.txt > > then email me schema.txt file. > If the database file is small enough, please send me the whole thing. D. Richard Hipp [EMAIL PROTECTED] ___ sqlite-users mailing list sqlite-users@sqlite.org http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users ___ sqlite-users mailing list sqlite-users@sqlite.org http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users
Re: [sqlite] SQLite>=3.5.6 does not open database file
On Apr 14, 2008, at 6:58 PM, Steve Topov wrote: > 1.8 Meg > email it to me, please. D. Richard Hipp [EMAIL PROTECTED] ___ sqlite-users mailing list sqlite-users@sqlite.org http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users
Re: [sqlite] SQLite>=3.5.6 does not open database file
1.8 Meg -Original Message- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] On Behalf Of Dennis Cote Sent: Monday, April 14, 2008 1:50 PM To: General Discussion of SQLite Database Subject: Re: [sqlite] SQLite>=3.5.6 does not open database file Steve Topov wrote: > I already reported this bug but did not receive any responds so I am > trying one more time. > The problem: > SQLite version 3.5.6 and up returns an error when opening some database > files. The error is “SQL logic error or missing database”. > Version prior to version 3.5.6 works fine with these database files. > > I do not know the version of SQLite the database file in question was > created with. And I am talking about SQLite 3 database file – not SQLite > 2, not Microsoft Access, > not any other file format. > > To make story short: SQLite 3.5.6 can not open SQLite 3 database file. > > Thanks for your time and possible help. > ___ > sqlite-users mailing list > sqlite-users@sqlite.org > http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users How large is a zipped (or better yet a 7z compressed) copy of the problematic database file? Dennis Cote ___ sqlite-users mailing list sqlite-users@sqlite.org http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users ___ sqlite-users mailing list sqlite-users@sqlite.org http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users
Re: [sqlite] SQLite>=3.5.6 does not open database file
On Apr 14, 2008, at 4:53 PM, D. Richard Hipp wrote: > > On Apr 14, 2008, at 4:47 PM, Steve Topov wrote: >> I can open the file with 3.3.5. I did not try to dump it and recreate >> with 3.5.6. >> > > With version 3.5.5, please do this: > > sqlite3 yourdatabasefile.db .schema >schema.txt > > then email me schema.txt file. > If the database file is small enough, please send me the whole thing. D. Richard Hipp [EMAIL PROTECTED] ___ sqlite-users mailing list sqlite-users@sqlite.org http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users
Re: [sqlite] SQLite>=3.5.6 does not open database file
On Apr 14, 2008, at 4:47 PM, Steve Topov wrote: > I can open the file with 3.3.5. I did not try to dump it and recreate > with 3.5.6. > With version 3.5.5, please do this: sqlite3 yourdatabasefile.db .schema >schema.txt then email me schema.txt file. D. Richard Hipp [EMAIL PROTECTED] ___ sqlite-users mailing list sqlite-users@sqlite.org http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users
Re: [sqlite] SQLite>=3.5.6 does not open database file
On 4/14/08, Steve Topov <[EMAIL PROTECTED]> wrote: > I can open the file with 3.3.5. I did not try to dump it and recreate > with 3.5.6. > well then. Do it and see if it works. > > -Original Message- > From: [EMAIL PROTECTED] > > [mailto:[EMAIL PROTECTED] On Behalf Of P Kishor > Sent: Monday, April 14, 2008 1:38 PM > To: General Discussion of SQLite Database > Subject: Re: [sqlite] SQLite>=3.5.6 does not open database file > > > On 4/14/08, Steve Topov <[EMAIL PROTECTED]> wrote: > > I already reported this bug but did not receive any responds so I am > > trying one more time. > > The problem: > > SQLite version 3.5.6 and up returns an error when opening some > database > > files. The error is "SQL logic error or missing database". > > Version prior to version 3.5.6 works fine with these database files. > > Which highest version of SQLite can you open the db with? That said, > have you tried dumping the db and building a 3.5.6 db with it? > > > > > I do not know the version of SQLite the database file in question was > > created with. And I am talking about SQLite 3 database file – not > SQLite > > 2, not Microsoft Access, > > not any other file format. > > > > To make story short: SQLite 3.5.6 can not open SQLite 3 database > file. > > > > Thanks for your time and possible help. > > ___ > > sqlite-users mailing list > > sqlite-users@sqlite.org > > http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users > > > > > -- > Puneet Kishor http://punkish.eidesis.org/ > Nelson Institute for Environmental Studies http://www.nelson.wisc.edu/ > Open Source Geospatial Foundation (OSGeo) http://www.osgeo.org/ > ___ > sqlite-users mailing list > sqlite-users@sqlite.org > http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users > > > -- Puneet Kishor http://punkish.eidesis.org/ Nelson Institute for Environmental Studies http://www.nelson.wisc.edu/ Open Source Geospatial Foundation (OSGeo) http://www.osgeo.org/ ___ sqlite-users mailing list sqlite-users@sqlite.org http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users
Re: [sqlite] SQLite>=3.5.6 does not open database file
Steve Topov wrote: > I already reported this bug but did not receive any responds so I am > trying one more time. > The problem: > SQLite version 3.5.6 and up returns an error when opening some database > files. The error is “SQL logic error or missing database”. > Version prior to version 3.5.6 works fine with these database files. > > I do not know the version of SQLite the database file in question was > created with. And I am talking about SQLite 3 database file – not SQLite > 2, not Microsoft Access, > not any other file format. > > To make story short: SQLite 3.5.6 can not open SQLite 3 database file. > > Thanks for your time and possible help. > ___ > sqlite-users mailing list > sqlite-users@sqlite.org > http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users How large is a zipped (or better yet a 7z compressed) copy of the problematic database file? Dennis Cote ___ sqlite-users mailing list sqlite-users@sqlite.org http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users
Re: [sqlite] SQLite>=3.5.6 does not open database file
I can open the file with 3.3.5. I did not try to dump it and recreate with 3.5.6. -Original Message- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] On Behalf Of P Kishor Sent: Monday, April 14, 2008 1:38 PM To: General Discussion of SQLite Database Subject: Re: [sqlite] SQLite>=3.5.6 does not open database file On 4/14/08, Steve Topov <[EMAIL PROTECTED]> wrote: > I already reported this bug but did not receive any responds so I am > trying one more time. > The problem: > SQLite version 3.5.6 and up returns an error when opening some database > files. The error is "SQL logic error or missing database". > Version prior to version 3.5.6 works fine with these database files. Which highest version of SQLite can you open the db with? That said, have you tried dumping the db and building a 3.5.6 db with it? > > I do not know the version of SQLite the database file in question was > created with. And I am talking about SQLite 3 database file – not SQLite > 2, not Microsoft Access, > not any other file format. > > To make story short: SQLite 3.5.6 can not open SQLite 3 database file. > > Thanks for your time and possible help. > ___ > sqlite-users mailing list > sqlite-users@sqlite.org > http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users > -- Puneet Kishor http://punkish.eidesis.org/ Nelson Institute for Environmental Studies http://www.nelson.wisc.edu/ Open Source Geospatial Foundation (OSGeo) http://www.osgeo.org/ ___ sqlite-users mailing list sqlite-users@sqlite.org http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users ___ sqlite-users mailing list sqlite-users@sqlite.org http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users
Re: [sqlite] SQLite>=3.5.6 does not open database file
I can open this file with version 3.3.5. I do not know the version this file was created with but I can guess it was some earliest versions of SQLite 3. File created with version 3.3.5 works fine with version 3.5.6. -Original Message- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] On Behalf Of Michael Ruck Sent: Monday, April 14, 2008 1:34 PM To: 'General Discussion of SQLite Database' Subject: Re: [sqlite] SQLite>=3.5.6 does not open database file Is there a previous version, which is able to open this database file? Which version of SQLite was the database file created with? -Ursprüngliche Nachricht- Von: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] Im Auftrag von Steve Topov Gesendet: Montag, 14. April 2008 22:31 An: sqlite-users@sqlite.org Betreff: [sqlite] SQLite>=3.5.6 does not open database file I already reported this bug but did not receive any responds so I am trying one more time. The problem: SQLite version 3.5.6 and up returns an error when opening some database files. The error is SQL logic error or missing database. Version prior to version 3.5.6 works fine with these database files. I do not know the version of SQLite the database file in question was created with. And I am talking about SQLite 3 database file not SQLite 2, not Microsoft Access, not any other file format. To make story short: SQLite 3.5.6 can not open SQLite 3 database file. Thanks for your time and possible help. ___ sqlite-users mailing list sqlite-users@sqlite.org http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users ___ sqlite-users mailing list sqlite-users@sqlite.org http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users ___ sqlite-users mailing list sqlite-users@sqlite.org http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users
Re: [sqlite] SQLite>=3.5.6 does not open database file
On 4/14/08, Steve Topov <[EMAIL PROTECTED]> wrote: > I already reported this bug but did not receive any responds so I am > trying one more time. > The problem: > SQLite version 3.5.6 and up returns an error when opening some database > files. The error is "SQL logic error or missing database". > Version prior to version 3.5.6 works fine with these database files. Which highest version of SQLite can you open the db with? That said, have you tried dumping the db and building a 3.5.6 db with it? > > I do not know the version of SQLite the database file in question was > created with. And I am talking about SQLite 3 database file – not SQLite > 2, not Microsoft Access, > not any other file format. > > To make story short: SQLite 3.5.6 can not open SQLite 3 database file. > > Thanks for your time and possible help. > ___ > sqlite-users mailing list > sqlite-users@sqlite.org > http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users > -- Puneet Kishor http://punkish.eidesis.org/ Nelson Institute for Environmental Studies http://www.nelson.wisc.edu/ Open Source Geospatial Foundation (OSGeo) http://www.osgeo.org/ ___ sqlite-users mailing list sqlite-users@sqlite.org http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users
Re: [sqlite] SQLite>=3.5.6 does not open database file
Is there a previous version, which is able to open this database file? Which version of SQLite was the database file created with? -Ursprüngliche Nachricht- Von: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] Im Auftrag von Steve Topov Gesendet: Montag, 14. April 2008 22:31 An: sqlite-users@sqlite.org Betreff: [sqlite] SQLite>=3.5.6 does not open database file I already reported this bug but did not receive any responds so I am trying one more time. The problem: SQLite version 3.5.6 and up returns an error when opening some database files. The error is SQL logic error or missing database. Version prior to version 3.5.6 works fine with these database files. I do not know the version of SQLite the database file in question was created with. And I am talking about SQLite 3 database file not SQLite 2, not Microsoft Access, not any other file format. To make story short: SQLite 3.5.6 can not open SQLite 3 database file. Thanks for your time and possible help. ___ sqlite-users mailing list sqlite-users@sqlite.org http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users ___ sqlite-users mailing list sqlite-users@sqlite.org http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users
[sqlite] SQLite>=3.5.6 does not open database file
I already reported this bug but did not receive any responds so I am trying one more time. The problem: SQLite version 3.5.6 and up returns an error when opening some database files. The error is “SQL logic error or missing database”. Version prior to version 3.5.6 works fine with these database files. I do not know the version of SQLite the database file in question was created with. And I am talking about SQLite 3 database file – not SQLite 2, not Microsoft Access, not any other file format. To make story short: SQLite 3.5.6 can not open SQLite 3 database file. Thanks for your time and possible help. ___ sqlite-users mailing list sqlite-users@sqlite.org http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users