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

[sqlite] problem with sqlite 4

In reply to > On 3/01/2017, at 4:48 AM, claude.del-vi...@laposte.net 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

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, claude.del-vi...@laposte.net 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

[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

[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

[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

[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

[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

[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 >

[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

[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,

[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

[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

Re: [sqlite] Problem compiling SQLite 3.8.4.1 with SQLITE_MAX_MMAP_SIZE=0

2014-03-14 12:06 GMT+01:00 Stephan Beal : > i posted it to sqlite-dev on Feb. 19th, but Brad was on CC, and maybe that > list elides mails with CCs. Well, I just finished running the test-suite "make test" for the Cygwin64 build of SQLite 3.8.4.1 (with the

Re: [sqlite] Problem compiling SQLite 3.8.4.1 with SQLITE_MAX_MMAP_SIZE=0

On Fri, Mar 14, 2014 at 12:04 PM, Jan Nijtmans wrote: > Hey, that's exactly the same solution! Pity that Brad didn't report > that upstream, the fix could have been in SQLite 3.8.4.1 already. > i posted it to sqlite-dev on Feb. 19th, but Brad was on CC, and maybe that

Re: [sqlite] Problem compiling SQLite 3.8.4.1 with SQLITE_MAX_MMAP_SIZE=0

2014-03-14 11:48 GMT+01:00 Stephan Beal : > See also this fix: > > http://fossil.wanderinghorse.net/repos/libfossil/index.cgi/info/a9263730f2 > > that's from Brad Harder, for BSD. Hey, that's exactly the same solution! Pity that Brad didn't report that upstream, the fix

Re: [sqlite] Problem compiling SQLite 3.8.4.1 with SQLITE_MAX_MMAP_SIZE=0

On Fri, Mar 14, 2014 at 11:46 AM, Jan Nijtmans wrote: > I just found out that I was too quick upgrading libfossil to use > the latest SQLite 3.8.4.1 amalgamation: > < > http://fossil.wanderinghorse.net/repos/libfossil/index.cgi/info/2de81ae7b6 > > > this broke the

[sqlite] Problem compiling SQLite 3.8.4.1 with SQLITE_MAX_MMAP_SIZE=0

Hi all, I just found out that I was too quick upgrading libfossil to use the latest SQLite 3.8.4.1 amalgamation: this broke the Cygwin build ;-(. The reason is that libfossil is very strict, considering any

[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?

[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

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)

obert Gdula [robert.gd...@gmail.com] > Sent: Saturday, January 28, 2012 9:46 AM > To: sqlite-users@sqlite.org > 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 an

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

on Systems From: sqlite-users-boun...@sqlite.org [sqlite-users-boun...@sqlite.org] on behalf of Robert Gdula [robert.gd...@gmail.com] Sent: Saturday, January 28, 2012 9:46 AM To: sqlite-users@sqlite.org Subject: EXT :[sqlite] Problem with sqlite and codeblocks (mingw) Hi, I have a problem with c

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

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

lite.org >Sent: Saturday, 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 ad

[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

[sqlite] Problem with sqlite

Hi everyone, I'm in the same situation as this person, http://www.mail-archive.com/sqlite-users@sqlite.org/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 <zsu...@wp.pl> wrote: > Hello. Sorry for my English. > I have

[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

Re: [sqlite] problem porting sqlite amalgamation 3.6.23.1 to vxworks 6.5 pentium3 DKM

Hi, -- Forwarded message -- From: ZhiHua Huang Date: 2009/8/26 Subject: Re: [sqlite] port sqlite to VxWorks To: General Discussion of SQLite Database Hi, use these definitions. -DOS_VXWORKS_660=660\

[sqlite] problem porting sqlite amalgamation 3.6.23.1 to vxworks 6.5 pentium3 DKM

I created a vxworks 6.5 Pentium3 downloadable kernel module project . Sqlite3.c and sqlite3.h were imported into project. But when I compiled the sqlite3.c I got the following error output. I wonder whether this package can be directly put into use without any problem with vxworks 6.5. Hope

[sqlite] problem porting sqlite amalgamation 3.6.23.1 to vxworks 6.5 DKM

I created a downloadable kernel module project . Sqlite3.c and sqlite3.h were imported into project. But when I compiled the sqlite3.c I got the following error output. I wonder whether this package can be directly put into use without any problem with vxworks 6.5. Hope someone can help me

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: >

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.

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

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

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

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 >

[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,

Re: [sqlite] Problem with SQLite in BCB 4

Correction: I didnt delete this one ;) Database::Database(char* filename) { ___ sqlite-users mailing list sqlite-users@sqlite.org 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=117751256117132=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 (__cdecl

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

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

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,

Re: [sqlite] Problem with SQLite in BCB 4

2010/3/6 Chimerian <chimer...@o2.pl>: > 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 Button

Re: [sqlite] Problem with SQLite in BCB 4

Chimerian, I compiled and tested the tutorial example (which you pointed out) with VC++ on XP Pro. Example is fine, except with the problem of not checking for NULL pointer, which I fixed for you. DB is created and values are stored and retrieved. No problem with SQLite or STL. I do

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

qlite3_finalize(statement); } return results; } and it works for me fine. Could you print the value of val before it is pushed to the values vector? Of course the problem is not Sqlite problem but the proper usage of STL. - Original Message From: Chimerian <chime

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

12:05:51 PM Subject: [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 Butto

[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 using sqlite in a C++/CLI .Net application

>>>>> > >>>>>> Hi, > >>>>>> > >>>>>> you can look at System.Data.SQLite <http://sqlite.phxsoftware.com/> > >> and > >>>>>>

Re: [sqlite] Problem using sqlite in a C++/CLI .Net application

>>> >>>>>> Hi, >>>>>> >>>>>> you can look at System.Data.SQLite <http://sqlite.phxsoftware.com/> >> and >>>>>> look at the sources. >>

Re: [sqlite] Problem using sqlite in a C++/CLI .Net application

> >>>> Sylvain > >>>> > >>>> > >>>> On Thu, Jan 28, 2010 at 12:23 AM, Edward Diener < > >>>> eldlistmaili...@tropicsoft.com> wrote: > >>>> > >>>>> I am able to compile a C++/CLI .Net applica

Re: [sqlite] Problem using sqlite in a C++/CLI .Net application

I .Net application using sqlite. But when >>>>> it links it complains with some linker warnings: >>>>> >>>>> xxx.obj : warning LNK4248: unresolved typeref token (011D) for >>>>> 'sqlite3'; image

Re: [sqlite] Problem using sqlite in a C++/CLI .Net application

gt; >>> it links it complains with some linker warnings: > >>> > >>> xxx.obj : warning LNK4248: unresolved typeref token (011D) for > >>> 'sqlite3'; image may not run > >>> xxx.obj : warning LNK4248: unresolved typeref token (011F) for >

Re: [sqlite] Problem using sqlite in a C++/CLI .Net application

ker warnings: >>> >>> xxx.obj : warning LNK4248: unresolved typeref token (011D) for >>> 'sqlite3'; image may not run >>> xxx.obj : warning LNK4248: unresolved typeref token (011F) for >>> 'sqlite3_stmt'; image may not run >>> >&

Re: [sqlite] Problem using sqlite in a C++/CLI .Net application

t;> 'sqlite3'; image may not run >> xxx.obj : warning LNK4248: unresolved typeref token (011F) for >> 'sqlite3_stmt'; image may not run >> >> This is because the 'sqlite3' and 'sqlite3_stmt' structures are >> completely opaque in the sqlite3.h header

Re: [sqlite] Problem using sqlite in a C++/CLI .Net application

because the 'sqlite3' and 'sqlite3_stmt' structures are > completely opaque in the sqlite3.h header files, and the MSIL is > evidently trying to create code for it. > > Is there a workaround for this possible problem ? > > ___ >

[sqlite] Problem using sqlite in a C++/CLI .Net application

'; image may not run This is because the 'sqlite3' and 'sqlite3_stmt' structures are completely opaque in the sqlite3.h header files, and the MSIL is evidently trying to create code for it. Is there a workaround for this possible problem ? ___ sqlite

[sqlite] Problem passing SQLite field values to TCL function

I start off passing a central latitude ($lat_degrees) and longitude ($long_degrees) and a radius ($radius) to a TCL script. Using the spherical cosine law to calculate distance, I want to select all sites in a table within that given radius. Here are 2 code fragments from the script...

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 ___

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

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:

[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-w

[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

[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

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

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>

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

[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. > >

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.

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 >

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

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

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

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,

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

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

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

> > - Original Message > From: Zbigniew Baniewski <[EMAIL PROTECTED]> > To: sqlite-users@sqlite.org > 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

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

[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,

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:

  1   2   >