Elefterios Stamatogiannakis wrote:
> Madis is a extensible relational database system built upon the SQLite
> database and with extensions written in Python (via APSW SQLite
> wrapper). Its is developed at:
>
> http://madis.googlecode.com
>
> Due to Madis’ SQLite core, the database format of Ma
On 23 Feb 2010, at 10:06pm, Simon Slavin wrote:
> Change the two error messages so the first one has a '1' in it and the second
> one has a '2' in it. Then run it again and tell us which of the two error
> messages is being shown.
Ignore that. I got confused. Heh heh.
Simon.
__
On 23 Feb 2010, at 5:44pm, newlog wrote:
> With the following code :
>
> -
>
> sqlite3*db = NULL;
>
> if( sqlite3_open( "D:\Test3.db", &db) != SQLITE_OK )
> {
>// Exit if error while opening.
>wxMessageBox( wxString
It doesn't look like the wiki is editable. I suppose you have your
reasons for that. On the page below, I have a suggestion.
http://www.sqlite.org/cvstrac/wiki?p=LibraryRoutineCalledOutOfSequence
It is my experience that you can get "library routine called out of
sequence" if you call sqlite3_s
OK,
With the following code :
-
sqlite3*db = NULL;
if( sqlite3_open( "D:\Test3.db", &db) != SQLITE_OK )
{
// Exit if error while opening.
wxMessageBox( wxString( "Error while opening :\n") <<
sqlite3_errmsg(db) );
The application runs as a singleton; there are no other applications
accessing the data base.
I do not run the command-line tool while testing.
I've cut down the example code:
SqlStatus = sqlite3_open16 ( db_loc_string
, &SqlDB
) ;
if
Madis is a extensible relational database system built upon the SQLite
database and with extensions written in Python (via APSW SQLite
wrapper). Its is developed at:
http://madis.googlecode.com
Due to Madis’ SQLite core, the database format of Madis is exactly the
same as SQLite’s one. This me
On 23 February 2010 16:46, newlog wrote:
> Hi Simon,
>
> Thanx for your answer,
>
>
> IN case of error when trying to open the file, we close db pointer and
> exit the sub-routine ( return keyword follows closing ).
>
> So 'sqlite3_close' can't be called twice.
My point was that if the database o
Hi Simon,
Thanx for your answer,
IN case of error when trying to open the file, we close db pointer and
exit the sub-routine ( return keyword follows closing ).
So 'sqlite3_close' can't be called twice.
Sincerely,
John
On Feb 23, 2:40 pm, Simon Davies
wrote:
> On 23 February 2010 12:51, J
On Tue, Feb 23, 2010 at 1:56 AM, 4eanlss <4ean...@engineer.com> wrote:
> Shane Harrelson writes:
>
> >
> > I was unable to duplicate your error with the CLI and 3.6.22 (compiled
> with
> > cygwin\gcc or msvc):
> Ok, so Borland not supported and windows API not followed.
> Just as I expected from
Thanks lot Pavel,
>I only had two problem tables and luckily these seldom change, for
these I went back to the week old backup and cut them out of the dump
file and applied them to the newly created database. Now I
integrity_check more often
i will try out ".dump option", i done last time als
In which version of SQLite does this happen?
I am using version-3.5.8
Please do not print this email unless it is absolutely necessary.
The information contained in this electronic message and any attachments to
this message are intended for the exclusive use of the addressee(s) and may
cont
What's the actual code output from your program? i.e. which
sqlite3_close() is it failing on?
Can you call sqlite3_errmsg() when sqlite3_open() failed to initialise
the db struct? I would have thought "db" would be invalid at that
point. Try setting db to NULL when declaring it, as otherwise yo
I recently had a similar problem, not wanting to fall back to a week
old dump of the database, what I did was to command line ".dump"ed the
defective database and attempt a reload.
I only had two problem tables and luckily these seldom change, for
these I went back to the week old backup and cut
On 23 February 2010 12:51, John wrote:
> Forgot to say that the error occurs at the sqlite3_close function.
>
> John
>
>> The very simple C-code below returns error message " library routine
>> called out of sequence" .
>> I really don't understand why ?
>>
>> I'm using SQLite 3.6.22 under Wind
Forgot to say that the error occurs at the sqlite3_close function.
John
On Feb 23, 11:17 am, John wrote:
> Hi All,
>
> The very simple C-code below returns error message " library routine
> called out of sequence" .
> I really don't understand why ?
>
> I'm using SQLite 3.6.22 under Windows X
Hi All,
The very simple C-code below returns error message " library routine
called out of sequence" .
I really don't understand why ?
I'm using SQLite 3.6.22 under Windows XP
Any idea/suggestion would be really appreciated !
--
Shane Harrelson writes:
>
> I was unable to duplicate your error with the CLI and 3.6.22 (compiled with
> cygwin\gcc or msvc):
Ok, so Borland not supported and windows API not followed.
Just as I expected from open source software.
___
sqlite-user
> How can i recover this kind of DB, is it possible? and is there any way
> to avoid these
> unused pages, will enable auto_vacuum solve the problem ?
'VACUUM' is not designed to recover malformed database. Yes, there are
some kinds of problems that can be eliminated during vacuuming, but
not all
Thanks Alexey and Anton!
You guys really know your stuff!
This is a great help!
-Original Message-
From: Alexey Pechnikov [mailto:pechni...@mobigroup.ru]
Sent: Tuesday, 23 February 2010 21:35
To: sqlite-users@sqlite.org
Cc: Matthew Smith
Subject: Tcl VFS integration for Sqlite3
Hello!
Hi All,
I found the DB corruption (malformed database), reporting some unused
pages,
please find the below trace,
*** in database main ***
Main freelist: 21 of 21 pages missing from overflow list starting at 0
Page 1604: sqlite3BtreeInitPage() returns error code 11
Page 1461 is never used
Page
Hello!
See the solution here:
http://www.siftsoft.com/tclsqlitevfs.html
Best regards, Alexey Pechnikov.
http://pechnikov.tel/
___
sqlite-users mailing list
sqlite-users@sqlite.org
http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users
The official test-suite is proprietary. If you really wish to get your
hands on it, you may enter in a contract with Hwaci as seen described at
http://sqlite.org/consortium.html
On Tue, 2010-02-23 at 08:55 +0800, xuecaili wrote:
> Hello!
> I'm a sqlite user and I want to use sqlite to deve
23 matches
Mail list logo
