Re: [sqlite] SQL error: SQL logic error or missing database

2008-03-27 Thread Kees Nuyt
On Thu, 27 Mar 2008 03:10:33 -0700, you wrote: >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. Journal files are written in the same directory as the database file. The database fi

Re: [sqlite] SQL error: SQL logic error or missing database

2008-03-27 Thread BanuPrakash G
, 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:

Re: [sqlite] SQL error: SQL logic error or missing database

2008-03-26 Thread BanuPrakash G
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

Re: [sqlite] SQL error: SQL logic error or missing database

2008-03-26 Thread BanuPrakash G
sage- 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

Re: [sqlite] SQL error: SQL logic error or missing database

2008-03-26 Thread Dennis Cote
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> B

Re: [sqlite] SQL error: SQL logic error or missing database

2008-03-26 Thread Ken
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.

Re: [sqlite] SQL error: SQL logic error or missing database

2008-03-26 Thread BanuPrakash G
Prakash 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 Mes

Re: [sqlite] SQL error: SQL logic error or missing database

2008-03-25 Thread BanuPrakash G
-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

Re: [sqlite] SQL error: SQL logic error or missing database

2008-03-25 Thread P Kishor
On 3/25/08, Prabowo Murti <[EMAIL PROTECTED]> wrote: > 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

Re: [sqlite] SQL error: SQL logic error or missing database

2008-03-25 Thread Prabowo Murti
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 > e

Re: [sqlite] SQL error: SQL logic error or missing database

2008-03-25 Thread Ken
Try ./sqlite3 BanuPrakash G <[EMAIL PROTECTED]> 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 "S

[sqlite] SQL error: SQL logic error or missing database

2008-03-25 Thread BanuPrakash G
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. ./s