Hi Ken, Thanks for your Reply ! I am not able to run it on my PPC Architecture with this ISSUE i.e. " BFOS:root> ./sqlite3 bhanu.db SQLite version 3.5.7 Enter ".help" for instructions sqlite> .databases seq name file --- --------------- ---------------------------------------------------------- 0 main /root/bhanu.db sqlite> CREATE TABLE t1(a INTEGER, b INTEGER, c VARCHAR(100)); SQL error: database or disk is full
I will Summarize on How i am using SQLITE: 1. Cross Compiled SQLITE3.5.7 for PPC Architecture 2. Copied all the dependent libraries and the executable to my PPC machine 3. Exported LD_LIBRAY_PATH to the working directory where I copied the libraries 4. Created db I.e. ./sqlite3 my.db 5. Started Executing SQLITE QUERIES. I could see in the code: ** If the journal file could not be written because the disk is full, ** then this routine returns SQLITE_FULL and does an immediate rollback. ** All subsequent write attempts also return SQLITE_FULL until there ** is a call to sqlite3PagerCommit() or sqlite3PagerRollback() to ** reset. */ Can I know where/HOW the Journal file is being written so that i can check on my switch whether I have sufficient write privileges enabled for journal file. Moreover I am using ext3 tinyfilesystem ....somewhat similar to busybox file system ! Attached are the Makefile and libtoo which I have modified for CROSS COMPILATION RULES; Can you please point out if I need to Include/exclude some Flags/Rules if I compile it for a different Architecture! If you have used SQLITE for PPC or any please help me with some pointers to resolve these issues ! Thanks in Advance Bhanu ________________________________ From: Ken [mailto:[EMAIL PROTECTED] Sent: Wednesday, March 26, 2008 9:54 PM To: BanuPrakash G Subject: RE: [sqlite] SQL error: SQL logic error or missing database maybe a ulimit on the file size?? Have you check you systems log files (linux: /var/log/messages) HTH, Ken BanuPrakash G <[EMAIL PROTECTED]> wrote: yes i have write permissions ! -----Original Message----- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] On Behalf Of Ken Sent: Wednesday, March 26, 2008 7:55 PM To: General Discussion of SQLite Database Subject: Re: [sqlite] SQL error: SQL logic error or missing database do you have write permissions on mdiadb and the directory??? BanuPrakash G wrote: Database or disk is full is the Error message i get from the sqlite :root> ./sqlite3 mediadb.sql SQLite version 3.5.7 Enter ".help" for instructions sqlite> CREATE TABLE t1(a INTEGER, b INTEGER, c VARCHAR(100)); SQL error: database or disk is full sqlite> BFOS:root> df Filesystem 1k-blocks Used Available Use% Mounted on /dev/root 495016 190848 278616 41% / /dev/hda1 494984 141452 327984 30% /mnt :root> ???? -----Original Message----- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] On Behalf Of BanuPrakash G Sent: Wednesday, March 26, 2008 12:19 PM To: General Discussion of SQLite Database Subject: Re: [sqlite] SQL error: SQL logic error or missing database Even create a database i.e. ./sqlite mydb.db3 when i attemt to execute any command i.e. create tables,insert etc i see the ERROR Message SQL error: SQL logic error or missing database. I think because of some library dependency this issue is being observed ...any pointers ?? Thanks /BP -----Original Message----- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] On Behalf Of Prabowo Murti Sent: Tuesday, March 25, 2008 9:18 PM To: General Discussion of SQLite Database Subject: Re: [sqlite] SQL error: SQL logic error or missing database BanuPrakash G wrote: > Hi, > > I have used the latest verision of sqlite i.e. sqlite-3.5.7 > Amalgamation release for PPC Arch. > > I was able to cross compile it successfull and when i use the db to > create tables I see on the SQLITE shell the ERROR message as "SQL > error: SQL logic error or missing database". > > i.e. > > ./sqlite3 > SQLite version 3.5.7 > Enter ".help" for instructions > sqlite> CREATE TABLE t1(a INTEGER, b INTEGER, c VARCHAR(100)); > SQL error: SQL logic error or missing database > > > > Can anybody point me out where exactly I am wrong ? > > > Thanks > /BP > > > > _______________________________________________ > sqlite-users mailing list > sqlite-users@sqlite.org > http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users > > Hi You have to create a database first. Create a table before a database is like build a window without house :) I am using sqlite3 on Ubuntu. $ sqlite3 mydb.db3 I am new in sqlite. Cmiiw. _______________________________________________ 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 _______________________________________________ sqlite-users mailing list sqlite-users@sqlite.org http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users