Re: [sqlite] problem with sqlite 4

David Empson wrote: SQLite Expert Personal is a third party product which uses the SQLite > database engine. It is not using “SQLite 4” (which is in early development > stages and not been released), but will be using some version of SQLite 3. > This mailing list is not an appropriate place to get

[sqlite] problem with sqlite 4

In reply to > On 3/01/2017, at 4:48 AM, [email protected] David Empson wrote: SQLite Expert Personal is a third party product which uses the SQLite > database engine. It is not using “SQLite 4” (which is in early development > stages and not been released), but will be using some versi

Re: [sqlite] problem with sqlite 4

> The current version of SQLite Expert Personal is 4.2.0, available here: > > http://www.sqliteexpert.com/download.html > > They don’t appear to give any clues as to which version of SQLite the > application is using. The SQLite version is displayed just below the ribbon on the right hand side of

Re: [sqlite] problem with sqlite 4

> On 3/01/2017, at 4:48 AM, [email protected] wrote: > > Hi, > > The problem described here occurs both with the x32 and x64 versions of the > expert personal 4 (Windows 10). Hereafter, a little database to show the bug. > > The table "sample" is used to store words occurring in t

[sqlite] problem with sqlite 4

Hi, The problem described here occurs both with the x32 and x64 versions of the expert personal 4 (Windows 10). Hereafter, a little database to show the bug. The table "sample" is used to store words occurring in texts. Texts are identified by an id number. CREATE TABLE IF NOT EXISTS sample

[sqlite] Problem with SQLite version 3.9.2 together with user authentication extension

Am 26.11.2015 um 01:30 schrieb Simon Slavin: > > On 25 Nov 2015, at 8:25pm, Ulrich Telle wrote: > >> SELECT name, rootpage, sql FROM 'main'.sqlite_master ORDER BY rowid > > Can you try that again without the quotes around "main" ? > > SELECT name, rootpage, sql FROM main.sqlite_master ORDER BY row

[sqlite] Problem with SQLite version 3.9.2 together with user authentication extension

On 25 Nov 2015, at 8:25pm, Ulrich Telle wrote: > SELECT name, rootpage, sql FROM 'main'.sqlite_master ORDER BY rowid Can you try that again without the quotes around "main" ? SELECT name, rootpage, sql FROM main.sqlite_master ORDER BY rowid Simon.

[sqlite] Problem with SQLite version 3.9.2 together with user authentication extension

I further tracked the problem down to lines 379 to 384 in build.c: #if SQLITE_USER_AUTHENTICATION else if( pParse->db->auth.authLeveldb->auth.authLevel != 0 && pParse->db->auth.authLevel SQLite version 3.8.7 introduced the user authentication extension. This > extension worked well for all 3

[sqlite] Problem with SQLite version 3.9.2 together with user authentication extension

SQLite version 3.8.7 introduced the user authentication extension. This extension worked well for all 3.8.x versions. Now I intended to upgrade to SQLite version 3.9.2. However, if I enable the user authentication extension using the compile time define SQLITE_USER_AUTHENTICATION I experience p

[sqlite] Problem with SQLite in C++. DB is BUSY (Multithread)

On 11 August 2015 at 06:22, Simon Slavin wrote: > If you did set a timeout then SQLite wais a very short time (a millisecond > ?) before it tries again, then it waits a little longer, then a little > longer still, etc.. It gradually increases the time until the total time > reaches the time you

[sqlite] Problem with SQLite in C++. DB is BUSY (Multithread)

Thank you for answers, but I have already solved this problem. I set busy timeout for both connections. ???, 11 ??? 2015 ?. Simon Slavin ???: > > On 11 Aug 2015, at 2:28am, ch > > wrote: > > > Is this because we don't create and handle savepoints correct? > > Have you set

[sqlite] Problem with SQLite in C++. DB is BUSY (Multithread)

Thank you for help and explain WAL mode. 2015-08-11 1:22 GMT+03:00 Simon Slavin : > > On 10 Aug 2015, at 11:12pm, ??? ??? wrote: > > > But what is minimum period? > > The minimum period doesn't matter. > > The number you set the timeout to is the /maximum/ period. SQLite will > cont

[sqlite] Problem with SQLite in C++. DB is BUSY (Multithread)

But what is minimum period? 2015-08-11 0:56 GMT+03:00 Simon Slavin : > > On 10 Aug 2015, at 10:49pm, ??? ??? wrote: > > > When I set timeout to 12 ms (2 minutes). It starts work. But as I > > understand from reading SQLite C interface, when DB in WAL journal mode > it > > should

[sqlite] Problem with SQLite in C++. DB is BUSY (Multithread)

When I set timeout to 12 ms (2 minutes). It starts work. But as I understand from reading SQLite C interface, when DB in WAL journal mode it should work without busytimeout. Can it work without busy timeout? 2015-08-10 17:11 GMT+03:00 Simon Slavin : > > On 9 Aug 2015, at 10:37pm, ??? ???

[sqlite] Problem with SQLite in C++. DB is BUSY (Multithread)

On 2015-08-10 11:49 PM, ??? ??? wrote: > When I set timeout to 12 ms (2 minutes). It starts work. But as I > understand from reading SQLite C interface, when DB in WAL journal mode it > should work without busytimeout. > > Can it work without busy timeout? It can work without Tim

[sqlite] Problem with SQLite in C++. DB is BUSY (Multithread)

On 10 Aug 2015, at 11:12pm, ??? ??? wrote: > But what is minimum period? The minimum period doesn't matter. The number you set the timeout to is the /maximum/ period. SQLite will continue to try to access the file until that amount of time has passed. Then it will give up, retu

[sqlite] Problem with SQLite in C++. DB is BUSY (Multithread)

On 10 Aug 2015, at 10:49pm, ??? ??? wrote: > When I set timeout to 12 ms (2 minutes). It starts work. But as I > understand from reading SQLite C interface, when DB in WAL journal mode it > should work without busytimeout. > > Can it work without busy timeout? It is correct tha

[sqlite] Problem with SQLite in C++. DB is BUSY (Multithread)

On 9 Aug 2015, at 10:37pm, ??? ??? wrote: > I've got a problem. I'm using sqlite3 in my C++ project. In the log I've > got error's *DB is locked error code 5*. As I know error code 5 means, that > DB is busy. For testings, please use

[sqlite] Problem with SQLite in C++. DB is BUSY (Multithread)

Hello! I've got a problem. I'm using sqlite3 in my C++ project. In the log I've got error's *DB is locked error code 5*. As I know error code 5 means, that DB is busy. To solve this I started to use WAL journal mode. But it doesn't help. In my program I've got 2 connections to the same db. I use m

[sqlite] problem with sqlite cache

Hello,I am asking you for ideas to resolve my problem. I create WinForm application in Visual Studio 2003. This app accessing the sqlite database by sqlite3.c and sqlite.h source code. Everything goes well, but after some changes (I dont know what I change) when I read from or write to database

[sqlite] Problem with SQLite on client machine under .net framework 4 client profile

Hello, I'm trying to launch our application .exe on a client machine. We've rebuilt the project under .NET framework 4 client profile. I have this error on launch: "The specified store provider cannot be found in the configuration, or is not valid". Do you have an idea of what to do? Everything

[sqlite] Problem with SQLite when deployed.

Hi, I have an application written in C# .Net 4.0 Framework. I use SQLite within the application. I have recently updated from an older version of SQLite to the latest version as I have moved to .Net Framework 4.0 and I received error messages about Mixed Mode Frameworks. Anyway, I do the dev

Re: [sqlite] Problem with sqlite and codeblocks (mingw)

Am 28.01.2012 17:07, schrieb Robert Gdula: No becuase, I need encryption and it is not supported bu wxslite3, Not true. wxSQLite3 supports encryption using the official SQLite API. wxSQLite3 even provides it's own SQLite encryption extension implementation (supporting 128 bit and 256 bit AES

Re: [sqlite] Problem with sqlite and codeblocks (mingw)

[email protected]] > Sent: Saturday, January 28, 2012 9:46 AM > To: [email protected] > Subject: EXT :[sqlite] Problem with sqlite and codeblocks (mingw) > > Hi, I have a problem with compilation sqlite for mingw and code:blocks, > everything is ok and compilation do

Re: [sqlite] Problem with sqlite and codeblocks (mingw)

Information Systems From: [email protected] [[email protected]] on behalf of Robert Gdula [[email protected]] Sent: Saturday, January 28, 2012 9:46 AM To: [email protected] Subject: EXT :[sqlite] Problem with sqlite and codeblocks (mingw) Hi, I have a prob

Re: [sqlite] Problem with sqlite and codeblocks (mingw)

No becuase, I need encryption and it is not supported bu wxslite3, I try Sqlcipher and I have exactly the same problem... http://forums.codeblocks.org/index.php/topic,15849.0.html I described it here but nobody can help me ___ sqlite-users mailing list s

Re: [sqlite] Problem with sqlite and codeblocks (mingw)

rday, January 28, 2012 5:46 PM >Subject: [sqlite] Problem with sqlite and codeblocks (mingw) > >Hi, I have a problem with compilation sqlite for mingw and code:blocks, >everything is ok and compilation don't show any abnormal information, but >when I try only add library of

[sqlite] Problem with sqlite and codeblocks (mingw)

Hi, I have a problem with compilation sqlite for mingw and code:blocks, everything is ok and compilation don't show any abnormal information, but when I try only add library of sqlite to the linker of sample wxwidgets program it doesn't work. Everything is ok when I use normal cosole program for C

[sqlite] Problem with sqlite

Hi everyone, I'm in the same situation as this person, http://www.mail-archive.com/[email protected]/msg08106.html I would like to know if it's feasible to user column alias in the same query... This old suggestion is correct in this example, but i have very long request so that's why I'm

Re: [sqlite] Problem with SQLite library.

> Error is " error C3861: 'sqlite_open': identifier not found". Indeed there's no sqlite_open function. There's sqlite3_open. Does it fixes the problem? Pavel On Thu, May 27, 2010 at 11:31 AM, lukasz aaa wrote: > Hello. Sorry for my English. > I have a problem with the SQLite library reloaded

[sqlite] Problem with SQLite library.

Hello. Sorry for my English. I have a problem with the SQLite library reloaded correctly (use in project). I'm using VC++ 2010 and Dev. I add to project sqlite3.h, copy to folder with source sqlite3.dll and sqlite3.lib. I add sqlite3.lib to linker - i search information on forums, but can't comp

Re: [sqlite] Problem with sqlite providing different programs different data

Hey thanks for the advice after further testing I found this to be a windows file system issue. windows made a boo boo and had discrepancy between what could be accessed on the command line and what was shown in windows On Thu, Apr 1, 2010 at 3:11 PM, Tim Romano wrote: > I should add that when yo

Re: [sqlite] Problem with sqlite providing different programs different data

I should add that when you create a SQLite database outside of Adobe and use INT PK, in Adobe's implementation joins will return perfectly plausible yet often completely inaccurate results, grabbing rows from the joined table with the RowID not the actual PK. http://forums.adobe.com/message/236598

Re: [sqlite] Problem with sqlite providing different programs different data

I don't know what your specific problem may be but check to make sure that you are using INTEGER [exactly I-N-T-E-G-E-R] primary keys (not INT or any other variant form). I documented on Adobe's bug database and in their AIR discussion forum a problem with the Adobe implementation of SQLite --Adobe

Re: [sqlite] Problem with sqlite providing different programs differentdata

That's not the issue i am 100 percent certain i am pointing to the file On Apr 1, 2010 1:17 PM, "Igor Tandetnik" wrote: Felipe Aramburu wrote: > So heres the basica scenario: > > 1. i update my data... My guess would be, you actually have two different database files (maybe with the same name b

Re: [sqlite] Problem with sqlite providing different programs different data

>Both of these tools show a version of the database that is different >from what i see in the command line and they are equivalent in their >discrepancies (they are different from the command line but the same >as each other). > >So heres the basica scenario: > >1. i update my database with the co

Re: [sqlite] Problem with sqlite providing different programs differentdata

Felipe Aramburu wrote: > So heres the basica scenario: > > 1. i update my database with the code i wrote > 2. those changes are reflected in the command line > 3. those changes are not reflected in Lita/SEP > > 1. I update information in Lita/SEP on that same database file > 2. those changes are

[sqlite] Problem with sqlite providing different programs different data

I have some code that is using flex sdk 3.2 and I am updating and inserting into a database with the following queries: stmt.text = 'INSERT INTO Question( hotlist, name, label, datatypeid, advanced, multivalue, measurementtypeid) VALUES (@hotlist, @name,@label,@datatypeid,@advanced,@multivalue,@me

Re: [sqlite] Problem with SQLite in BCB 4

Correction: I didnt delete this one ;) Database::Database(char* filename) { ___ sqlite-users mailing list [email protected] http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users

Re: [sqlite] Problem with SQLite in BCB 4

Solved. I found very interesting post on forum http://marc.info/?l=sqlite-users&m=117751256117132&w=2 So... I deleted some part of code: unit1.cpp: // DLL handle HANDLE DLLHandle = LoadLibrary("sqlite3.dll"); // SQLite class Database::Database(char* filename) { sqlite3_open = (int (__cd

Re: [sqlite] Problem with SQLite in BCB 4

Thank you very much for your clarification! This is what I suspected. Regards, Samuel - Original Message From: Igor Tandetnik a1rex wrote: > What about void *p = sqlite3_column_blob()? > From my tests it looks that pointer p survives sqlite3_finalize(). > Is it just a coincidence?

Re: [sqlite] Problem with SQLite in BCB 4

a1rex wrote: > What about void *p = sqlite3_column_blob()? > From my tests it looks that pointer p survives sqlite3_finalize(). > Is it just a coincidence? It "survives" in the same sense as in this example: char* p = (char*)malloc(10); strcpy(p, "Hello"); free(p); printf(p); Chances are high

Re: [sqlite] Problem with SQLite in BCB 4

- Original Message >From: Simon Davies >The return from sqlite3_column_text is not valid after subsequent calls to any >of >sqlite3_step/sqlite3_reset/sqlite3_finalize. Yes. What about void *p = sqlite3_column_blob()? >From my tests it looks that pointer p survives sqlite3_finali

Re: [sqlite] Problem with SQLite in BCB 4

>> 2010/3/6 Chimerian : >> values.push_back((char*)sqlite3_column_text(statement, col)); >> // HERE IS ERROR ! >From: Simon Davies >What error? >I can not see why THIS line should provoke any error; This line will produce a runtime error when sqlite3_column_text(statement, col); returns NULL p

Re: [sqlite] Problem with SQLite in BCB 4

2010/3/6 Chimerian : > I have a problem with SQLite in BCB 4.0. I wrote my own application - > I found very useful information on > http://www.dreamincode.net/forums/index.php?showtopic=122300 > > On form (Form1) I have: Memo1 and Button3. > > File Unit1.cpp: > > . . . .>                        

Re: [sqlite] Problem with SQLite in BCB 4

[email protected] >Sent: Mon, March 8, 2010 12:18:53 PM >Subject: Re: [sqlite] Problem with SQLite in BCB 4 >Unfortunately I cant print the value of val before it's pushed to the >values vector because when do that I got this same error - I think >the problem is with po

Re: [sqlite] Problem with SQLite in BCB 4

Unfortunately I cant print the value of val before it's pushed to the values vector because when do that I got this same error - I think the problem is with pointer: char * ptr = (char*)sqlite3_column_text(statement, col); Maybe it hold wrong address ? I compile this code on Borland C++ Builder 6

Re: [sqlite] Problem with SQLite in BCB 4

te.org Sent: Sun, March 7, 2010 4:23:30 PM Subject: Re: [sqlite] Problem with SQLite in BCB 4 Unfortunately it still doesn't work. I have error in line values.push_back(val); I tried to run program on Windows XP - I have this same error. Links to error screens: http://chimerian.net/error1.jpg

Re: [sqlite] Problem with SQLite in BCB 4

Unfortunately it still doesn't work. I have error in line values.push_back(val); I tried to run program on Windows XP - I have this same error. Links to error screens: http://chimerian.net/error1.jpg http://chimerian.net/error2.jpg if(result == SQLITE_ROW)

Re: [sqlite] Problem with SQLite in BCB 4

h_back(values); } else { break; } Enjoy, Samuel BTW nice usage of STL + SQlite. - Original Message From: Chimerian To: [email protected] Sent: Sat, March 6, 2010 12:05:51 PM Subject: [sqlite]

[sqlite] Problem with SQLite in BCB 4

I have a problem with SQLite in BCB 4.0. I wrote my own application - I found very useful information on http://www.dreamincode.net/forums/index.php?showtopic=122300 On form (Form1) I have: Memo1 and Button3. File Unit1.cpp: //---

Re: [sqlite] problem with sqlite in c#.net

do you try a COMMIT? manp escribió: > when i execute a query like this > UPDATE setting SET value="red" WHERE name="color" > the row will update temporary while app is running , when i close app noting > appear in DB > i use ManagedSQLite dll ___ sqlite-

Re: [sqlite] problem with sqlite in c#.net

On 12/05/2009 9:30 AM, John Machin wrote: > On 12/05/2009 8:31 AM, manp wrote: >> when i execute a query like this >> UPDATE setting SET value="red" WHERE name="color" >> the row will update temporary while app is running , when i close app noting >> appear in DB >> i use ManagedSQLite dll > > I p

Re: [sqlite] problem with sqlite in c#.net

On 12/05/2009 8:31 AM, manp wrote: > when i execute a query like this > UPDATE setting SET value="red" WHERE name="color" > the row will update temporary while app is running , when i close app noting > appear in DB > i use ManagedSQLite dll I presume that you refer to this: http://code.google.com

[sqlite] problem with sqlite in c#.net

when i execute a query like this UPDATE setting SET value="red" WHERE name="color" the row will update temporary while app is running , when i close app noting appear in DB i use ManagedSQLite dll -- View this message in context: http://www.nabble.com/problem-with-sqlite-in-c-.net-tp23492813p234

[sqlite] problem with sqlite storing TCL scripts

Hello all,   I've used sqlite3 .read command to read in an SQL file from (exported via TOAD) Oracle that contains TCL scripts.   The .read worked fine, but now I'm noticing that my multi-line scripts are not running properly on the shell when I retrieve them from the sqlite table.   I notice that

[sqlite] Problem with sqlite in mac

Hi, I have a problem using sqlite in mac. When I run my application(executable jar) from Windows OS, it works perfectly. But when I try to launch the application from Mac, I get the following error apples-imac:CreateJar apple$ java -jar TreeTable.jar Unable to load sqlite: java.lang. UnsatisfiedLi

Re: [sqlite] Problem with sqlite overall or not?

I just noticed that you are returning from your function before finalize. On Tue, Jun 10, 2008 at 10:12 AM, piotro <[EMAIL PROTECTED]> wrote: > Hello. I really need help with this, because Im almost out of > ideas here. Help please! > > sqldata is a vector< vector < char* > > > row is a vector <

Re: [sqlite] Problem with sqlite overall or not?

For starters sqlite3_column_count( ) should be after prepare once. You don't need to do it for every step. The other thing is do you have to use STL when you can do everything by using SQLite? Tell us in English what you want to accomplish with your code. We can come up with a pure SQLite solution

Re: [sqlite] Problem with sqlite overall or not?

Wednesday, June 11, 2008, 12:12:33 AM, you wrote: p> Hello. I really need help with this, because Im almost out of p> ideas here. Help please! p> sqldata is a vector< vector < char* > > p> row is a vector < char* > p> sqldata sql3wrapper::pobierzPodmiot(){ p> const char* tail; p> sqlite3

Re: [sqlite] Problem with sqlite overall or not?

Isn't this simply a vector problem? You have a vector where you store char pointers. The pointers returned from sqlite3_column_text will be destroyed when you step afaik. Try making it a vector instead. Then you will implicitly make copies of the text in your vector instead. /Jonas On Tue, Jun 10

[sqlite] Problem with sqlite overall or not?

Hello. I really need help with this, because Im almost out of ideas here. Help please! sqldata is a vector< vector < char* > > row is a vector < char* > sqldata sql3wrapper::pobierzPodmiot(){ const char* tail; sqlite3_stmt* statement; std::string query = squery("SELECT * FROM %;"

Re: [sqlite] Problem with SQLite FastCGI module "malformed database schema"

On Fri, Aug 03, 2007 at 11:38:57AM -0700, Joe Wilson wrote: > > Of course I'm not. The PHP4 module uses sqlite2.x, and - besides - it > > :-) > > "Of course"? That's rich. "Of course" - just because I haven't any possibility to do that. > > OK, I'll try to ask maintainers about that. > > Goo

Re: [sqlite] Problem with SQLite FastCGI module "malformed database schema"

--- Zbigniew Baniewski <[EMAIL PROTECTED]> wrote: > On Fri, Aug 03, 2007 at 09:27:22AM -0700, Joe Wilson wrote: > > > You are not checking the return code of the sqlite3 connection close. > > Of course I'm not. The PHP4 module uses sqlite2.x, and - besides - it :-) "Of course"? That's rich. I

Re: [sqlite] Problem with SQLite FastCGI module "malformed database schema"

On Fri, Aug 03, 2007 at 09:27:22AM -0700, Joe Wilson wrote: > You are not checking the return code of the sqlite3 connection close. Of course I'm not. The PHP4 module uses sqlite2.x, and - besides - it doesn't return any value when using sqlite_close. > I have no idea if the PHP sqlite3 wrapper

Re: [sqlite] Problem with SQLite FastCGI module "malformed database schema"

--- Zbigniew Baniewski <[EMAIL PROTECTED]> wrote: > > Your trace seems to indicate it has 20 or so open > > connections to the same database file in the same process. > > I think, at last I've traced the problem: > > One of the scripts doesn't make use out of database contents at all. But at > t

Re: [sqlite] Problem with SQLite FastCGI module "malformed database schema"

On Fri, Aug 03, 2007 at 06:42:39AM -0700, Joe Wilson wrote: > Why do you think that the sqlite connection closes itself automatically? > Did you examine the PHP wrapper code to verify it closes each connection > in a timely fashion? No, I read it months ago in some manual/tutorial - but cannot fi

Re: [sqlite] Problem with SQLite FastCGI module "malformed database schema"

--- Zbigniew Baniewski <[EMAIL PROTECTED]> wrote: > On Wed, Aug 01, 2007 at 03:04:35PM -0700, Joe Wilson wrote: > > > Maybe the php wrapper is not closing sqlite connections correctly > > (or at all). > > > > See if you can get the stack traces of all threads in the php process > > 162 via psta

Re: [sqlite] Problem with SQLite FastCGI module "malformed database schema"

On Wed, Aug 01, 2007 at 03:04:35PM -0700, Joe Wilson wrote: > Maybe the php wrapper is not closing sqlite connections correctly > (or at all). > > See if you can get the stack traces of all threads in the php process > 162 via pstack, lsstack or by attaching gdb to it at runtime. Before I'll m

Re: [sqlite] Problem with SQLite FastCGI module "malformed database schema"

Maybe the php wrapper is not closing sqlite connections correctly (or at all). See if you can get the stack traces of all threads in the php process 162 via pstack, lsstack or by attaching gdb to it at runtime. > COMMAND PID USER FD TYPE DEVICE SIZE/OFF NODE NAME > php

Re: [sqlite] Problem with SQLite FastCGI module "malformed database schema"

On Thu, Jul 26, 2007 at 04:26:41PM -0700, [EMAIL PROTECTED] wrote: > If it works and then later stops working, it's much more likely that > you're having a problem with some file descriptor that is not closed > properly (on the temp db most likely). > If it dies after let's say a week, you can che

Re: [sqlite] Problem with SQLite FastCGI module "malformed database schema"

--- Zbigniew Baniewski <[EMAIL PROTECTED]> wrote: > Starting from 101st it just keeps reporting "malformed..." error everytime, > when one tries to access the database using any of PHP-scripts. Until I > "manually" restart lighttpd server. I have no idea about the architecture of lighttpd and its

Re: [sqlite] Problem with SQLite FastCGI module "malformed database schema"

On Thu, Jul 26, 2007 at 05:29:15PM -0700, Joe Wilson wrote: > What happens on the 102nd time? Starting from 101st it just keeps reporting "malformed..." error everytime, when one tries to access the database using any of PHP-scripts. Until I "manually" restart lighttpd server. > If it fails, the

Re: [sqlite] Problem with SQLite FastCGI module "malformed database schema"

On Thu, Jul 26, 2007 at 04:26:41PM -0700, [EMAIL PROTECTED] wrote: > If it works and then later stops working, it's much more likely that > you're having a problem with some file descriptor that is not closed > properly (on the temp db most likely). > If it dies after let's say a week, you can che

Re: [sqlite] Problem with SQLite FastCGI module "malformed database schema"

-- Zbigniew Baniewski <[EMAIL PROTECTED]> wrote: > The problem is, that the error message actually gives not any clue. It just > tells, that "there was problem while truing to open temporary database file" > - but there (considering the above) shouldn't be any problem. /var/tmp has > rwxrwxrwx priv

Re: [sqlite] Problem with SQLite FastCGI module "malformed database schema"

> > - Original Message > From: Zbigniew Baniewski <[EMAIL PROTECTED]> > To: [email protected] > Sent: Thursday, July 26, 2007 4:12:00 PM > Subject: Re: [sqlite] Problem with SQLite FastCGI module "malformed database > schema" > > >

Re: [sqlite] Problem with SQLite FastCGI module "malformed database schema"

On Thu, Jul 26, 2007 at 12:59:45PM -0700, Joe Wilson wrote: > /var on my machine is drwxr-xr-x, and I don't have any issues with sqlite > reading and writing temp files to /var/tmp/. Even if the permissions of /var > were d--x--x--x, it would also be fine. As long as /var/tmp is rwx for > the sql

Re: [sqlite] Problem with SQLite FastCGI module "malformed database schema"

--- Zbigniew Baniewski <[EMAIL PROTECTED]> wrote: > On Thu, Jul 26, 2007 at 08:11:22AM -0700, Joe Wilson wrote: > > > Try > > > > PRAGMA temp_store_directory = 'directory-name'; > > > > Otherwise, the temp file location order for UNIX is: > > > > "/var/tmp", > > "/usr/tmp", > >

Re: [sqlite] Problem with SQLite FastCGI module "malformed database schema"

On Thu, Jul 26, 2007 at 08:11:22AM -0700, Joe Wilson wrote: > Try > > PRAGMA temp_store_directory = 'directory-name'; > > Otherwise, the temp file location order for UNIX is: > > "/var/tmp", > "/usr/tmp", > "/tmp", > ".", Thanks, I'll try to. Although is rather temporar

Re: [sqlite] Problem with SQLite FastCGI module "malformed database schema"

--- Zbigniew Baniewski <[EMAIL PROTECTED]> wrote: > > While using SQLite as FastCGI module from within PHP-scripts, sometimes I'm > getting error messages, like: > > (mod_fastcgi.c.2551) FastCGI-stderr: PHP Warning: > sqlite_open() [function.sqlite-open > malformed database schema - unable to o

[sqlite] Problem with SQLite FastCGI module "malformed database schema"

While using SQLite as FastCGI module from within PHP-scripts, sometimes I'm getting error messages, like: (mod_fastcgi.c.2551) FastCGI-stderr: PHP Warning: sqlite_open() [function.sqlite-open malformed database schema - unable to open a temporary database file for storing temporary tables in /

Re: [sqlite] Problem with SQLite Pecl extension for PHP4

Brandon Eley <[EMAIL PROTECTED]> writes: > No, I can't upgrade to PHP5, yet. We're on PHP4. I was accessing sqlite 2.8.x databases with PHP4 a number of years ago. It worked fine. The page I referred you to previously _initially_ discusses the object interface for the sqlite functions. That, A

Re: [sqlite] Problem with SQLite Pecl extension for PHP4

Brandon Eley <[EMAIL PROTECTED]> writes: > Thank you for this information. How would I access the 2.8.x database from > within PHP? is it even possible? Go to http://www.php.net. Type "sqlite" into the search box at the top. The page it brings you to describes the sqlite 2.8.x interface. The

Re: [sqlite] Problem with SQLite Pecl extension for PHP4

Hi Brandon, Is there a way to upgrade the module to SQLite 3 on PHP4? I think so. I recall reading something about it, but since I was able to just install PHP5 I went via that route. Try Google: http://www.google.com.au/search?q=SQLite3+PHP4 Tom -

Re: [sqlite] Problem with SQLite Pecl extension for PHP4

No, I can't upgrade to PHP5, yet. We're on PHP4. Brandon Eley [EMAIL PROTECTED] On May 10, 2007, at 9:04 AM, Chris Peachment wrote: I think I have misread your original posting. Can you upgrade your version of PHP? I use PHP version 5.2.1. Running phpinfo() reveals the PDO driver to be: PE

Re: [sqlite] Problem with SQLite Pecl extension for PHP4

It's ShopSite (www.shopsite.com) and I'm building add-on modules for the cart that need to access information in the DB. Unfortunately, we can't upgrade to PHP5 just yet, as we have quite a few sites on the server running open source software and we haven't verified they are all compatible

Re: [sqlite] Problem with SQLite Pecl extension for PHP4

I think I have misread your original posting. Can you upgrade your version of PHP? I use PHP version 5.2.1. Running phpinfo() reveals the PDO driver to be: PECL version: 1.0.1 $Id: pdo_sqlite.c,v 1.10.2.6.2.1 2007/01/01 09:36:05 sebastian Exp $ Sqlite Library: 3.3.7undefined Since you can run s

Re: [sqlite] Problem with SQLite Pecl extension for PHP4

It's the other way round: Your database is 3.x, your SQLite library used by PHP is 2.8.14. Upgrade your PHP. Ulrich On Thursday 10 May 2007 14:46, Brandon Eley wrote: > Thank you for this information. How would I access the 2.8.x database > from within PHP? is it even possible? > > The database

Re: [sqlite] Problem with SQLite Pecl extension for PHP4

Hi Brandon, I've had my web host install the PECL extension and the following is what is in my phpinfo(); sqlite SQLite support enabled PECL Module version 1.0.3 $Id: sqlite.c,v 1.62.2.25 2004/07/10 SQLite Library 2.8.14 How would I access the 2.8.x database from within PHP? is it eve

Re: [sqlite] Problem with SQLite Pecl extension for PHP4

Thank you for this information. How would I access the 2.8.x database from within PHP? is it even possible? The database is created from a shopping cart program, so I can't upgrade it, it has to remain the same version (for now). Brandon Eley [EMAIL PROTECTED] On May 9, 2007, at 10:59 PM

Re: [sqlite] Problem with SQLite Pecl extension for PHP4

There was a change of file structure with version 3.x.x and this is described in the documentation under Version 3 Overview. You are attempting to use Sqlite3 on a version 2.8.x database and the formats are not compatible. On Wed, 9 May 2007 19:42:06 -0400, Brandon Eley wrote: >I've gone throug

Re: [sqlite] Problem with SQLite Pecl extension for PHP4

What user is httpd running as? Enter: ps aux | grep -v grep | grep httpd Does that user (typically 'nobody') have permission to access the file at your: /home/xxx/data/xxx.db ? On 5/9/07, Brandon Eley <[EMAIL PROTECTED]> wrote: I've gone through a few tutorials and can't seem to get this ri

[sqlite] Problem with SQLite Pecl extension for PHP4

I've gone through a few tutorials and can't seem to get this right. I've had my web host install the PECL extension and the following is what is in my phpinfo(); sqlite SQLite support enabled PECL Module version 1.0.3 $Id: sqlite.c,v 1.62.2.25 2004/07/10 12:25:33 wez Exp $ SQLite Library

Re: [sqlite] problem with sqlite velocity the revenge

Kurt Welgehausen wrote: >> ... only the first index is opened ... > > That's right. SQLite uses only one index, and it doesn't keep > statistics, so it may pick the wrong index if it has to choose. > Try forcing it to use the other index by dropping the one that > it's using now. > > Changing 'tab

Re: [sqlite] problem with sqlite velocity the revenge

> ... only the first index is opened ... That's right. SQLite uses only one index, and it doesn't keep statistics, so it may pick the wrong index if it has to choose. Try forcing it to use the other index by dropping the one that it's using now. Changing 'table1, table2 where' to 'table1 join ta

Re: [sqlite] problem with sqlite velocity the revenge

Hi , just to give you other info here is the output of the explain command C:\sviluppo\sqlite>sqlite.exe ex2 SQLite version 2.8.15 Enter ".help" for instructions sqlite> explain select parole.id,mega.id from parole JOIN mega ON mega.word=parole.word; 0|ColumnName|0|0|parole.id 1|ColumnName|1|1|m

Re: [sqlite] problem with sqlite velocity

Hi, thank for your response , I tired your suggestion but results where nearly the same . Here is the schema ouput sqlite> .schema CREATE TABLE "Mega"("ID" integer,"word" varchar(255)); CREATE TABLE "parole"("ID" integer,"file" varchar(255),"word" varchar (255),"tag" varchar(255),"lemma" varchar(2

Re: [sqlite] problem with sqlite velocity

alessandro bonvicini wrote: Hi all, I ask you an help because I don't understand what I am doing wrong with sqlite. First of all,anyway, I would like to thanks all of you for this software. Now I have some problem but I only need to understand where are my errors and I am sure that sqlite will be

[sqlite] problem with sqlite velocity

Hi all, I ask you an help because I don't understand what I am doing wrong with sqlite. First of all,anyway, I would like to thanks all of you for this software. Now I have some problem but I only need to understand where are my errors and I am sure that sqlite will be as fast as everyone says.

[sqlite] Problem with SQLite

Hi, I've been using MySQL, but now I want to change to SQLite. The problem is after I install it, it said table employe could not be found. So it must have conect to the database, but why it can't find table employee. I create table employee using sqlitecc and save it as nehnu.sqlt. below is what

  1   2   >