do you have write permissions on mdiadb and the directory??? BanuPrakash G <[EMAIL PROTECTED]> 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
