[sqlite] Getting Error SQLITE_NOTADB
Hi I am using Sqlite for my project and getting Error like -SQLITE_NOTADB whenever i am trying below scenario- 1- Open and create the database 2- Execute Sqlite_Exec to Insert the record in the database table 3- Close the database 4- Confirm by opening the .db file in sqlite browser tht dtabase table insert the records 5- Again Open the the database 6- Whenever Executing Sqlite_Exec to Update the colum value of database table . .Getting the Errror in Sqlite3_Prepare()---lockBtree(BtShared *pBt)-- if( memcmp(page1, zMagicHeader, 16)!=0 ){ goto page1_init_failed; Everytimes above if condition True hence page1_init_failed and returns rc = SQLITE_NOTADB; Anybody have any idea what would be the reason if db table is creating properly then why does failing in this condition . Cheers kritesh I am getting Error lockBtree -- Regards kritesh tripathi ___ sqlite-users mailing list sqlite-users@sqlite.org http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users
Re: [sqlite] Getting Error SQLITE_NOTADB
I assume you have some program doing the sqlite_exec? Care to show us your code? I just ran a test doing what you describe with SQLite Database Browser Version 2.0b1 and the following program compiled against 3.7.13; After the 2nd run of this program there are 2 records in test.db which the browser showsno errors occur. #include stdio.h #include sqlite3.h int main() { sqlite3 *db; int rc; rc=sqlite3_open(test.db,db); if (rc != SQLITE_OK) { puts(sqlite3_errmsg(db)); } sqlite3_exec(db,create table t (i integer);,NULL,NULL,NULL); rc=sqlite3_exec(db,insert into t values(1);,NULL,NULL,NULL); if (rc != SQLITE_OK) { puts(sqlite3_errmsg(db)); } sqlite3_close(db); } Michael D. Black Senior Scientist Advanced Analytics Directorate Advanced GEOINT Solutions Operating Unit Northrop Grumman Information Systems From: sqlite-users-boun...@sqlite.org [sqlite-users-boun...@sqlite.org] on behalf of kritesh tripathi [tripathi.krit...@gmail.com] Sent: Tuesday, October 23, 2012 11:58 AM To: sqlite-users@sqlite.org Subject: EXT :[sqlite] Getting Error SQLITE_NOTADB Hi I am using Sqlite for my project and getting Error like -SQLITE_NOTADB whenever i am trying below scenario- 1- Open and create the database 2- Execute Sqlite_Exec to Insert the record in the database table 3- Close the database 4- Confirm by opening the .db file in sqlite browser tht dtabase table insert the records 5- Again Open the the database 6- Whenever Executing Sqlite_Exec to Update the colum value of database table . .Getting the Errror in Sqlite3_Prepare()---lockBtree(BtShared *pBt)-- if( memcmp(page1, zMagicHeader, 16)!=0 ){ goto page1_init_failed; Everytimes above if condition True hence page1_init_failed and returns rc = SQLITE_NOTADB; Anybody have any idea what would be the reason if db table is creating properly then why does failing in this condition . Cheers kritesh I am getting Error lockBtree -- Regards kritesh tripathi ___ 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] Getting Error SQLITE_NOTADB
On 23 Oct 2012, at 5:58pm, kritesh tripathi tripathi.krit...@gmail.com wrote: 4- Confirm by opening the .db file in sqlite browser tht dtabase table insert the records 5- Again Open the the database 6- Whenever Executing Sqlite_Exec to Update the colum value of database table . .Getting the Errror in Sqlite3_Prepare()---lockBtree(BtShared *pBt)-- if( memcmp(page1, zMagicHeader, 16)!=0 ){ goto page1_init_failed; Everytimes above if condition True hence page1_init_failed and returns rc = SQLITE_NOTADB; Try it without step 4. Do you still have the problem ? Try it with steps 3, 4, or 5. Do you still have the problem ? What SQL command results in the SQLITE_NOTADB ? Simon. ___ sqlite-users mailing list sqlite-users@sqlite.org http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users
Re: [sqlite] Getting Error SQLITE_NOTADB
hi michale there is no problem in creating and inserting the records in table ...but after tht i am trying to update the coloum value of table and using update command with where clause ..here every time sqlite_exec command failing and rc returns in sqlite3_prepare such as SQLITE_NOTADB CHEERS KRITESH On Oct 24, 2012 2:10 AM, Black, Michael (IS) michael.bla...@ngc.com wrote: I assume you have some program doing the sqlite_exec? Care to show us your code? I just ran a test doing what you describe with SQLite Database Browser Version 2.0b1 and the following program compiled against 3.7.13; After the 2nd run of this program there are 2 records in test.db which the browser showsno errors occur. #include stdio.h #include sqlite3.h int main() { sqlite3 *db; int rc; rc=sqlite3_open(test.db,db); if (rc != SQLITE_OK) { puts(sqlite3_errmsg(db)); } sqlite3_exec(db,create table t (i integer);,NULL,NULL,NULL); rc=sqlite3_exec(db,insert into t values(1);,NULL,NULL,NULL); if (rc != SQLITE_OK) { puts(sqlite3_errmsg(db)); } sqlite3_close(db); } Michael D. Black Senior Scientist Advanced Analytics Directorate Advanced GEOINT Solutions Operating Unit Northrop Grumman Information Systems From: sqlite-users-boun...@sqlite.org [sqlite-users-boun...@sqlite.org] on behalf of kritesh tripathi [tripathi.krit...@gmail.com] Sent: Tuesday, October 23, 2012 11:58 AM To: sqlite-users@sqlite.org Subject: EXT :[sqlite] Getting Error SQLITE_NOTADB Hi I am using Sqlite for my project and getting Error like -SQLITE_NOTADB whenever i am trying below scenario- 1- Open and create the database 2- Execute Sqlite_Exec to Insert the record in the database table 3- Close the database 4- Confirm by opening the .db file in sqlite browser tht dtabase table insert the records 5- Again Open the the database 6- Whenever Executing Sqlite_Exec to Update the colum value of database table . .Getting the Errror in Sqlite3_Prepare()---lockBtree(BtShared *pBt)-- if( memcmp(page1, zMagicHeader, 16)!=0 ){ goto page1_init_failed; Everytimes above if condition True hence page1_init_failed and returns rc = SQLITE_NOTADB; Anybody have any idea what would be the reason if db table is creating properly then why does failing in this condition . Cheers kritesh I am getting Error lockBtree -- Regards kritesh tripathi ___ 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] Getting Error SQLITE_NOTADB
hi simon i am not using step 4 in my program...after step 1 to 3 ,db file create in external sd card . then i am trying to update the colum value of table using upadte command with where clause but its failing due to below if condition as i mentioned in the sqlite3_prepare--lockBtree if(memcmp...) page1_init fail cheers kritesh On Oct 24, 2012 2:12 AM, Simon Slavin slav...@bigfraud.org wrote: On 23 Oct 2012, at 5:58pm, kritesh tripathi tripathi.krit...@gmail.com wrote: 4- Confirm by opening the .db file in sqlite browser tht dtabase table insert the records 5- Again Open the the database 6- Whenever Executing Sqlite_Exec to Update the colum value of database table . .Getting the Errror in Sqlite3_Prepare()---lockBtree(BtShared *pBt)-- if( memcmp(page1, zMagicHeader, 16)!=0 ){ goto page1_init_failed; Everytimes above if condition True hence page1_init_failed and returns rc = SQLITE_NOTADB; Try it without step 4. Do you still have the problem ? Try it with steps 3, 4, or 5. Do you still have the problem ? What SQL command results in the SQLITE_NOTADB ? Simon. ___ 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] Getting Error SQLITE_NOTADB
OK...here it is again using an updatestill works for me. Does it work for you? run it like this...first run with no args creates the table simple simple 1 2 simple 2 3 The args just update from/to values so you can see them changing using and update/where clause. #1 What OS? #2 What language #3 Where's your code? #include stdio.h #include sqlite3.h int main(int argc, char *argv[]) { sqlite3 *db; int rc; rc=sqlite3_open(test.db,db); if (rc != SQLITE_OK) { puts(sqlite3_errmsg(db)); } if (argc == 1) { sqlite3_exec(db,create table t (i integer);,NULL,NULL,NULL); rc=sqlite3_exec(db,insert into t values(1);,NULL,NULL,NULL); } else { char sql[4096]; if (argc != 3) { printf(Need 2 args, old/new values\n); exit(1); } sprintf(sql,update t set i=%s where i=%s,argv[2],argv[1]); rc=sqlite3_exec(db,sql,NULL,NULL,NULL); } if (rc != SQLITE_OK) { puts(sqlite3_errmsg(db)); } sqlite3_close(db); return 0; } Michael D. Black Senior Scientist Advanced Analytics Directorate Advanced GEOINT Solutions Operating Unit Northrop Grumman Information Systems From: sqlite-users-boun...@sqlite.org [sqlite-users-boun...@sqlite.org] on behalf of kritesh tripathi [tripathi.krit...@gmail.com] Sent: Tuesday, October 23, 2012 1:44 PM To: General Discussion of SQLite Database Subject: EXT :Re: [sqlite] Getting Error SQLITE_NOTADB hi michale there is no problem in creating and inserting the records in table ...but after tht i am trying to update the coloum value of table and using update command with where clause ..here every time sqlite_exec command failing and rc returns in sqlite3_prepare such as SQLITE_NOTADB CHEERS KRITESH On Oct 24, 2012 2:10 AM, Black, Michael (IS) michael.bla...@ngc.com wrote: I assume you have some program doing the sqlite_exec? Care to show us your code? I just ran a test doing what you describe with SQLite Database Browser Version 2.0b1 and the following program compiled against 3.7.13; After the 2nd run of this program there are 2 records in test.db which the browser showsno errors occur. #include stdio.h #include sqlite3.h int main() { sqlite3 *db; int rc; rc=sqlite3_open(test.db,db); if (rc != SQLITE_OK) { puts(sqlite3_errmsg(db)); } sqlite3_exec(db,create table t (i integer);,NULL,NULL,NULL); rc=sqlite3_exec(db,insert into t values(1);,NULL,NULL,NULL); if (rc != SQLITE_OK) { puts(sqlite3_errmsg(db)); } sqlite3_close(db); } Michael D. Black Senior Scientist Advanced Analytics Directorate Advanced GEOINT Solutions Operating Unit Northrop Grumman Information Systems From: sqlite-users-boun...@sqlite.org [sqlite-users-boun...@sqlite.org] on behalf of kritesh tripathi [tripathi.krit...@gmail.com] Sent: Tuesday, October 23, 2012 11:58 AM To: sqlite-users@sqlite.org Subject: EXT :[sqlite] Getting Error SQLITE_NOTADB Hi I am using Sqlite for my project and getting Error like -SQLITE_NOTADB whenever i am trying below scenario- 1- Open and create the database 2- Execute Sqlite_Exec to Insert the record in the database table 3- Close the database 4- Confirm by opening the .db file in sqlite browser tht dtabase table insert the records 5- Again Open the the database 6- Whenever Executing Sqlite_Exec to Update the colum value of database table . .Getting the Errror in Sqlite3_Prepare()---lockBtree(BtShared *pBt)-- if( memcmp(page1, zMagicHeader, 16)!=0 ){ goto page1_init_failed; Everytimes above if condition True hence page1_init_failed and returns rc = SQLITE_NOTADB; Anybody have any idea what would be the reason if db table is creating properly then why does failing in this condition . Cheers kritesh I am getting Error lockBtree -- Regards kritesh tripathi ___ 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 ___ sqlite-users mailing list sqlite-users@sqlite.org http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users
Re: [sqlite] Getting Error SQLITE_NOTADB
hi michael thanks for the responnse bt still getting the same problem language-C++ RTOS-micro itron where-creating db in digital camera external sd card and afterwards usin this db file for some wifi feature present in digital camera so that user can see all those images in tv or mobile. after debug i find tht in tht if condition using memcmp which compares between page1 and zmagicheaderbt value of page1= is this a problem ? cheers kritesh On Oct 24, 2012 3:57 AM, Black, Michael (IS) michael.bla...@ngc.com wrote: OK...here it is again using an updatestill works for me. Does it work for you? run it like this...first run with no args creates the table simple simple 1 2 simple 2 3 The args just update from/to values so you can see them changing using and update/where clause. #1 What OS? #2 What language #3 Where's your code? #include stdio.h #include sqlite3.h int main(int argc, char *argv[]) { sqlite3 *db; int rc; rc=sqlite3_open(test.db,db); if (rc != SQLITE_OK) { puts(sqlite3_errmsg(db)); } if (argc == 1) { sqlite3_exec(db,create table t (i integer);,NULL,NULL,NULL); rc=sqlite3_exec(db,insert into t values(1);,NULL,NULL,NULL); } else { char sql[4096]; if (argc != 3) { printf(Need 2 args, old/new values\n); exit(1); } sprintf(sql,update t set i=%s where i=%s,argv[2],argv[1]); rc=sqlite3_exec(db,sql,NULL,NULL,NULL); } if (rc != SQLITE_OK) { puts(sqlite3_errmsg(db)); } sqlite3_close(db); return 0; } Michael D. Black Senior Scientist Advanced Analytics Directorate Advanced GEOINT Solutions Operating Unit Northrop Grumman Information Systems From: sqlite-users-boun...@sqlite.org [sqlite-users-boun...@sqlite.org] on behalf of kritesh tripathi [tripathi.krit...@gmail.com] Sent: Tuesday, October 23, 2012 1:44 PM To: General Discussion of SQLite Database Subject: EXT :Re: [sqlite] Getting Error SQLITE_NOTADB hi michale there is no problem in creating and inserting the records in table ...but after tht i am trying to update the coloum value of table and using update command with where clause ..here every time sqlite_exec command failing and rc returns in sqlite3_prepare such as SQLITE_NOTADB CHEERS KRITESH On Oct 24, 2012 2:10 AM, Black, Michael (IS) michael.bla...@ngc.com wrote: I assume you have some program doing the sqlite_exec? Care to show us your code? I just ran a test doing what you describe with SQLite Database Browser Version 2.0b1 and the following program compiled against 3.7.13; After the 2nd run of this program there are 2 records in test.db which the browser showsno errors occur. #include stdio.h #include sqlite3.h int main() { sqlite3 *db; int rc; rc=sqlite3_open(test.db,db); if (rc != SQLITE_OK) { puts(sqlite3_errmsg(db)); } sqlite3_exec(db,create table t (i integer);,NULL,NULL,NULL); rc=sqlite3_exec(db,insert into t values(1);,NULL,NULL,NULL); if (rc != SQLITE_OK) { puts(sqlite3_errmsg(db)); } sqlite3_close(db); } Michael D. Black Senior Scientist Advanced Analytics Directorate Advanced GEOINT Solutions Operating Unit Northrop Grumman Information Systems From: sqlite-users-boun...@sqlite.org [sqlite-users-boun...@sqlite.org] on behalf of kritesh tripathi [tripathi.krit...@gmail.com] Sent: Tuesday, October 23, 2012 11:58 AM To: sqlite-users@sqlite.org Subject: EXT :[sqlite] Getting Error SQLITE_NOTADB Hi I am using Sqlite for my project and getting Error like -SQLITE_NOTADB whenever i am trying below scenario- 1- Open and create the database 2- Execute Sqlite_Exec to Insert the record in the database table 3- Close the database 4- Confirm by opening the .db file in sqlite browser tht dtabase table insert the records 5- Again Open the the database 6- Whenever Executing Sqlite_Exec to Update the colum value of database table . .Getting the Errror in Sqlite3_Prepare()---lockBtree(BtShared *pBt)-- if( memcmp(page1, zMagicHeader, 16)!=0 ){ goto page1_init_failed; Everytimes above if condition True hence page1_init_failed and returns rc = SQLITE_NOTADB; Anybody have any idea what would be the reason if db table is creating properly then why does failing in this condition . Cheers kritesh I am getting Error lockBtree -- Regards kritesh tripathi ___ sqlite-users mailing list sqlite
Re: [sqlite] Getting Error SQLITE_NOTADB
Save yourself some time and show some code, it will make it easy for us to help you. Genius might have limitations, but stupidity is no handicap -Original Message- From: sqlite-users-boun...@sqlite.org [mailto:sqlite-users-boun...@sqlite.org] On Behalf Of kritesh tripathi Sent: Tuesday, October 23, 2012 10:32 PM To: General Discussion of SQLite Database Subject: Re: [sqlite] Getting Error SQLITE_NOTADB hi michael thanks for the responnse bt still getting the same problem language-C++ RTOS-micro itron where-creating db in digital camera external sd card and afterwards usin this db file for some wifi feature present in digital camera so that user can see all those images in tv or mobile. after debug i find tht in tht if condition using memcmp which compares between page1 and zmagicheaderbt value of page1= is this a problem ? cheers kritesh On Oct 24, 2012 3:57 AM, Black, Michael (IS) michael.bla...@ngc.com wrote: OK...here it is again using an updatestill works for me. Does it work for you? run it like this...first run with no args creates the table simple simple 1 2 simple 2 3 The args just update from/to values so you can see them changing using and update/where clause. #1 What OS? #2 What language #3 Where's your code? #include stdio.h #include sqlite3.h int main(int argc, char *argv[]) { sqlite3 *db; int rc; rc=sqlite3_open(test.db,db); if (rc != SQLITE_OK) { puts(sqlite3_errmsg(db)); } if (argc == 1) { sqlite3_exec(db,create table t (i integer);,NULL,NULL,NULL); rc=sqlite3_exec(db,insert into t values(1);,NULL,NULL,NULL); } else { char sql[4096]; if (argc != 3) { printf(Need 2 args, old/new values\n); exit(1); } sprintf(sql,update t set i=%s where i=%s,argv[2],argv[1]); rc=sqlite3_exec(db,sql,NULL,NULL,NULL); } if (rc != SQLITE_OK) { puts(sqlite3_errmsg(db)); } sqlite3_close(db); return 0; } Michael D. Black Senior Scientist Advanced Analytics Directorate Advanced GEOINT Solutions Operating Unit Northrop Grumman Information Systems From: sqlite-users-boun...@sqlite.org [sqlite-users-boun...@sqlite.org] on behalf of kritesh tripathi [tripathi.krit...@gmail.com] Sent: Tuesday, October 23, 2012 1:44 PM To: General Discussion of SQLite Database Subject: EXT :Re: [sqlite] Getting Error SQLITE_NOTADB hi michale there is no problem in creating and inserting the records in table ...but after tht i am trying to update the coloum value of table and using update command with where clause ..here every time sqlite_exec command failing and rc returns in sqlite3_prepare such as SQLITE_NOTADB CHEERS KRITESH On Oct 24, 2012 2:10 AM, Black, Michael (IS) michael.bla...@ngc.com wrote: I assume you have some program doing the sqlite_exec? Care to show us your code? I just ran a test doing what you describe with SQLite Database Browser Version 2.0b1 and the following program compiled against 3.7.13; After the 2nd run of this program there are 2 records in test.db which the browser showsno errors occur. #include stdio.h #include sqlite3.h int main() { sqlite3 *db; int rc; rc=sqlite3_open(test.db,db); if (rc != SQLITE_OK) { puts(sqlite3_errmsg(db)); } sqlite3_exec(db,create table t (i integer);,NULL,NULL,NULL); rc=sqlite3_exec(db,insert into t values(1);,NULL,NULL,NULL); if (rc != SQLITE_OK) { puts(sqlite3_errmsg(db)); } sqlite3_close(db); } Michael D. Black Senior Scientist Advanced Analytics Directorate Advanced GEOINT Solutions Operating Unit Northrop Grumman Information Systems From: sqlite-users-boun...@sqlite.org [sqlite-users-boun...@sqlite.org] on behalf of kritesh tripathi [tripathi.krit...@gmail.com] Sent: Tuesday, October 23, 2012 11:58 AM To: sqlite-users@sqlite.org Subject: EXT :[sqlite] Getting Error SQLITE_NOTADB Hi I am using Sqlite for my project and getting Error like -SQLITE_NOTADB whenever i am trying below scenario- 1- Open and create the database 2- Execute Sqlite_Exec to Insert the record in the database table 3- Close the database 4- Confirm by opening the .db file in sqlite browser tht dtabase table insert the records 5- Again Open the the database 6- Whenever Executing Sqlite_Exec to Update the colum value of database table . .Getting the Errror in Sqlite3_Prepare()---lockBtree(BtShared *pBt)-- if( memcmp(page1, zMagicHeader, 16)!=0 ){ goto