Re: [sqlite] Precompiled download of sqlite3 (v3.3.13) for Linux
On Thu, 2007-03-08 at 12:14 -0500, Friedman, Eluzor wrote: > Hi, > > There is one for windows. Where is the one for Linux? > > Thanks > > PS I am a newbie. > Same page as for the windows versions, http://sqlite.org/download.html -- G. Roderick Singleton <[EMAIL PROTECTED]> PATH tech smime.p7s Description: S/MIME cryptographic signature
Re: [sqlite] stupid man's manual to sqlite?
On Thu, 2007-03-08 at 17:43 +0100, A.J.Millan wrote: > > > Thank you i will try my possibilities buying from amazon, while i am based > in > > the Czech republic. > > Unfortunately it is little bit expensive for me, to buy it without looking > > into it before. > > Jakub > > I would recommend not to waste your's money in that book. > > More of a half is about SQL generalities, an a quarter a copy-paste of the > on-line manual without more comment. At the end, the horrific index i've > ever seen. > I have found SQL in a Nutshell very useful over the past 5 years. You might try http://safari.oreilly.com/0596004818 -- G. Roderick Singleton <[EMAIL PROTECTED]> PATH tech smime.p7s Description: S/MIME cryptographic signature
Re: [sqlite] Abuse of the SQLite website
On Tue, 2007-01-30 at 12:58 +, [EMAIL PROTECTED] wrote: > Last night, a single user (or, at least, a single IP address) > in China that self-identified as running windows98 and > Mozilla 4.0 attempted to download sqlite-3.3.12.tar.gz > 24980 times and sqlite-source-3_3_12.zip 25044 times > over about a 5 hour period, sucking up significant > bandwidth in the process. > > I've seen this type of thing before and have on occasion > banned specific IP addresses from the website using > >iptables -A INPUT -s -j DROP > > But lately, there have been so many problems coming from > win98 and moz4 that I'm thinking of banning all traffic > that self-identifies as such in the User-Agent string of > the HTTP header. > > Thoughts anyone? Are there less drastic measures that might > be taken to prevent this kind of abuse? > Richard, You might like to explore using mod_security with some custom rules to help eliminate problems like this. See http://www.modsecurity.org/ -- G. Roderick Singleton <[EMAIL PROTECTED]> PATH tech smime.p7s Description: S/MIME cryptographic signature
Re: [sqlite] How to conditionally drop a table?
On Thu, 2007-01-25 at 18:40 +, Martin Jenkins wrote: > G. Roderick Singleton wrote: > > On Thu, 2007-01-25 at 11:13 -0600, John Stanton wrote: > > > >> If you find a way to drop a table which dosn't exist. let us know how > >> you do it. > >> > > Thanks for your insight. However what's your point? That the OP didn't > > check the website, that my reference was incorrect or what? > > > He's not making a point - it's British (dry, subtle) humour. > In bad taste if that what the attempt was. ;-( -- G. Roderick Singleton <[EMAIL PROTECTED]> PATH tech smime.p7s Description: S/MIME cryptographic signature
Re: [sqlite] How to conditionally drop a table?
On Thu, 2007-01-25 at 11:13 -0600, John Stanton wrote: > If you find a way to drop a table which dosn't exist. let us know how > you do it. > > G. Roderick Singleton wrote: > > On Thu, 2007-01-25 at 10:35 -0500, Anderson, James H (IT) wrote: > > > >>I need a way to drop a table only if that table exists. How would I do > >>that? > >> > >>Thanks, > > > > > > Are you asking if http://sqlite.org/lang_droptable.html works or have > > you had problems? > > Thanks for your insight. However what's your point? That the OP didn't check the website, that my reference was incorrect or what? -- G. Roderick Singleton <[EMAIL PROTECTED]> PATH tech smime.p7s Description: S/MIME cryptographic signature
Re: [sqlite] How to conditionally drop a table?
On Thu, 2007-01-25 at 10:35 -0500, Anderson, James H (IT) wrote: > I need a way to drop a table only if that table exists. How would I do > that? > > Thanks, Are you asking if http://sqlite.org/lang_droptable.html works or have you had problems? -- G. Roderick Singleton <[EMAIL PROTECTED]> PATH tech smime.p7s Description: S/MIME cryptographic signature
RE: [sqlite] date - SQL extraction from day, month and year
On Tue, 2006-12-26 at 12:43 -0500, Anderson, James H (IT) wrote: > Where are the date support functions documented? > On the wiki > -Original Message- > From: John Stanton [mailto:[EMAIL PROTECTED] > Sent: Tuesday, December 26, 2006 12:40 PM > To: sqlite-users@sqlite.org > Subject: Re: [sqlite] date - SQL extraction from day, month and year > > Everybody? Most Sqlite users know that Sqlite implements a DATE type > and has date support functions. > > Karsten Koschinski wrote: > > Hey, > > > > I have a database with a field where dates are stored! As everybody > knows SQLite has no special date support such as a special datatype for > date or something else. Now I want to select only those records, where > the year ist e.g. 2005. How can I do this? > > > > "SELECT * FROM database WHERE (EXTRACT DAY FROM date) = 2005" does not > work. > > > > The database was created with SQLite Analyzer 3.0.8. The datatyp of > the field date ist Text. > > > > Thanks > > > > Karsten > > > > - > To unsubscribe, send email to [EMAIL PROTECTED] > > - > > > NOTICE: If received in error, please destroy and notify sender. Sender does > not intend to waive confidentiality or privilege. Use of this email is > prohibited when received in error. > > --------- > To unsubscribe, send email to [EMAIL PROTECTED] > - > -- G. Roderick Singleton <[EMAIL PROTECTED]> PATH tech smime.p7s Description: S/MIME cryptographic signature
Re: [sqlite] INSERT Abilities?
gt; dim print_string
> dim col
>
> set clave=tabla.indexes("PrimaryKey")
> print_string=""
> for each col in clave.fields
> print_string = print_string & "," & col.name
> next
> 'WScript.Echo print_string
>
> colsClave="(" & mid(print_string ,2) & ")"
>
> end function
>
> Private Sub exportDatabase(ByVal database_path , ByVal username , ByVal
> password , _
>ByVal outfile )
> Dim fso,ts
> Dim print_string
> Dim db
> Dim tabla, columna
> Dim wrkJet
> Dim table_name
> Dim table_sql_name
> Dim field_name
> Dim field_sql_name
> Dim field_type
> dim dbEng
> dim col
> dim ref
>
> ' Create Microsoft Jet Workspace object.
> set dbEng=createobject("DAO.DBEngine.36")
> Set wrkJet = dbEng.CreateWorkspace("", username, password, dbUseJet)
>
> Set db = wrkJet.OpenDatabase(database_path, , True)
>
> If (outfile = "") Then outfile = "sqlite_db_out.sql"
> Set fso = CreateObject("Scripting.FileSystemObject")
> Set ts = fso.CreateTextFile(outfile, True)
>
> ts.writeline "SET DEFINE OFF;" 'Así no fastidian los caracteres &
> For each tabla in db.TableDefs
> table_name = tabla.name
> table_sql_name = sql_name(table_name)
> If Left(table_name, 4) <> "MSys" Then
> WScript.Echo tabla.name
> ts.writeline "DROP TABLE " & table_sql_name & ";"
> ts.writeline "COMMIT;"
> print_string = "CREATE TABLE " & table_sql_name & " ( "
> For each columna in tabla.Fields
> field_name = columna.name
> field_sql_name = sql_name(field_name)
> field_type = getSQLiteFieldType(columna, False)
> if field_type <> "BINARY" then
> print_string = print_string & field_sql_name & " "
> print_string = print_string & field_type
> if columna.required then
> print_string = print_string & " NOT NULL"
> end if
> print_string = print_string & ", "
> end if
> Next
> ts.writeline print_string
> ts.write " primary key "
> ts.write colsClave(tabla)
> ts.writeline ");"
>
> For each columna in tabla.Fields
> field_type = getSQLiteFieldType(columna, False)
> If InStr(field_type, "-- error") = 1 Then
> ts.writeline field_type
> End If
> Next
>
> Call exportDatabaseTable(db, tabla, ts)
> End If
> Next
>
> exportaReferencias db,ts
>
> ts.writeline "QUIT;" 'Si no, se queda
> ts.close
>
> db.Close
> wrkJet.Close
> Exit Sub
>
> DB_Error:
> MsgBox "Could not open database " & database_path & ". Check the path and
> permissions."
>
> End Sub
>
> Public Sub Main(mdb_db)
>
> Dim outfile
> 'keywords i took from sqlite/tokenizer.c
> sql_keywords1 = Array( _
> "ABORT", "AFTER", "ALL", "AND", "AS", "ASC", "ATTACH", _
> "BEFORE", "BEGIN", "BETWEEN", "BY", "CASCADE", "CASE", _
> "CHECK", "CLUSTER", "COLLATE", "COMMIT", "CONFLICT", _
> "CONSTRAINT", "COPY", "CREATE", "CROSS", "DATABASE", _
> "DEFAULT", "DEFERRED", "DEFERRABLE", "DELETE", _
> "DELIMITERS", "DESC", "DETACH", "DISTINCT", "DROP", _
> "END", "EACH", "ELSE", "EXCEPT", "EXPLAIN", "FAIL", _
> "FOR", "FOREIGN", "FROM", "FULL", "GLOB", "GROUP" _
> )
> sql_keywords2 = Array( _
> "HAVING", "IGNORE", "IMMEDIATE", "IN", "INDEX", _
> "INITIALLY", "INNER", "INSERT", "INSTEAD", "INTERSECT", _
> "INTO", "IS", "ISNULL", "JOIN", "KEY", "LEFT", "LIKE", _
> "LIMIT", "MATCH", "NATURAL", "NOT", "NOTNULL", "NULL", _
> "OF", "OFFSET", "ON", "OR", "ORDER", "OUTER", "PRAGMA", _
> "PRIMARY", "RAISE", "REFERENCES", "REPLACE", "RESTRICT", _
> "RIGHT", "ROLLBACK", "ROW", _
> "SELECT", "SET", "STATEMENT", "TABLE", "TEMP", _
> "TEMPORARY", "THEN", "TRANSACTION", "TRIGGER", _
> "UNION", "UNIQUE", "UPDATE", "USING", "VACUUM", _
> "VALUES", "VIEW", "WHEN", "WHERE" _
> )
>
>
> If Right(mdb_db, 4) <> ".mdb" Then
> outfile = mdb_db & ".sql"
> Else
> outfile = Replace(mdb_db, ".mdb", ".sql")
> End If
>
> Call exportDatabase(mdb_db, "admin", "", outfile)
>
> End Sub
>
> main "lienzoSinSorolla.mdb"
--
G. Roderick Singleton <[EMAIL PROTECTED]>
PATH tech
smime.p7s
Description: S/MIME cryptographic signature
Re: [sqlite] High Ascii in path causes database load failures
On Thu, 2006-10-12 at 13:19 +, [EMAIL PROTECTED] wrote: > Teg <[EMAIL PROTECTED]> wrote: > > Hello sqlite-users, > > > > I'm on a US English version of windows XP, latest patches. From time > > to time my users report that they can't open a database that's > > clearly sitting there in the file system. > > > > I've tracked the problem down to high ascii in the path. > > > > SQLite requires UTF8 pathnames (or UTF16 for the ...16() apis, > of course.) Please convert your pathnames to UTF8 prior to > sending them to SQLite. I suspect this is a Windows problem rather than one with SQLite. The OpenOffice.org QA people have encountered and similar problem and isolated it to Windows. See http://www.openoffice.org/issues/show_bug.cgi?id=67649 -- G. Roderick Singleton <[EMAIL PROTECTED]> PATH tech smime.p7s Description: S/MIME cryptographic signature
Re: [sqlite] Regarding removing create view and some other components in SQLite
On Fri, 2006-10-06 at 12:10 +0530, Vivek R wrote: > Hi List, >we have ported SQLite to one of our consumer products. We require some > minimal applications only like creating and deleting table and Inserting , > Querying, deleting rows in a table. We want to reduce the code size So, We > are planning to remove some of the features like create view and etc , as we > are facing some memory problems Could you please suggest me what are the > things to be done to remove the features like views and others ( which we > usually not required) . > > Hmm, after the work to put this in, you want it gone :-) May I suggest you check out http://sqlite.org/support.html particularly the professional support section. All this assumes you do not have staff to do the programming. -- G. Roderick Singleton <[EMAIL PROTECTED]> PATH tech smime.p7s Description: S/MIME cryptographic signature
[sqlite] Prepared statements and temp ffiles
The following issue, http://www.sqlite.org/cvstrac/tktview?tn=1959 has proved a bit of a stopper with the OpenOffice.org driver. I recall a discussion on prepared statements and how to manage them but cannot find the details. If I remember correctly, there is a way to handle temps via prepared statements but need some pointers, please. -- G. Roderick Singleton <[EMAIL PROTECTED]> PATH tech smime.p7s Description: S/MIME cryptographic signature
Re: [sqlite] Major projects using SQLite
On Fri, 2006-07-14 at 15:16 +0100, Martin Jenkins wrote: > Jon García de Salazar Bilbao wrote: > > Hi, > > Could you give examples of some major software projects using SQLite? > > Thanks, Jon. > > Solaris 10 - http://blogs.sun.com/roller/page/eric_boutilier/20050405 > > Martin http://fedoraproject.org/wiki/Tools/yum -- G. Roderick Singleton <[EMAIL PROTECTED]> PATH tech smime.p7s Description: S/MIME cryptographic signature
Re: [sqlite] How do you unsubscribe?
On Thu, 2006-06-01 at 09:28 -0700, Richard Battagline wrote: > How do you unsubscribe? > Send an email to [EMAIL PROTECTED] which will return all the information about the list or check your sqlite mailbox for the welcome message. -- G. Roderick Singleton <[EMAIL PROTECTED]> PATH tech smime.p7s Description: S/MIME cryptographic signature
Re: [sqlite] How to unsubscribe?
On Fri, 2006-01-13 at 08:12 -0800, [EMAIL PROTECTED] wrote: > > Hello, > > When I visit http://www.sqlite.org/support.html there is plenty of > information about joining this list but nothing about how to unsubscribe. > > Anyone know how to do that? > > Thanks, > > Tom > This information is in the headers of every message. Look for List-Unsubscribe: <mailto:[EMAIL PROTECTED]> Remember to send it from the address with which you subscribed. -- G. Roderick Singleton <[EMAIL PROTECTED]> PATH tech
Re: [sqlite] ANN: Sqlite3Explorer version 2.0 released
On Mon, 2005-10-03 at 19:52 +0300, Cariotoglou Mike wrote: > this is a major release, with a lot of changes. please see the readme at > www.singular.gr/sqlite. > Pls read the whole page carefully, as support for datatypes is now a lot > more powerful, but slightly different than > the previous versions. > Report users : you will need to download an extra dll, it is bookmarked > in the above link. > > you can see the changes at a glance in > www.singular.gr/sqlite/changes.htm > > Interesting tool. Are sources available for porting to other OSes? I would like to try on FC4. -- G. Roderick Singleton <[EMAIL PROTECTED]> PATH tech
Re: [sqlite] Crash while creating a table
On Sat, 2005-10-01 at 22:19 +0200, denys wrote: > Hi all, > > I'm trying to create a table but I always get an "assertion failed" > crash :-( > > Here is the statement: > CREATE TABLE Media (id INTEGER PRIMARY KEY, keywords TEXT, original > INTEGER, used INTEGER, picture TEXT, note INTEGER, comment BLOB, note > INTEGER, type INTEGER, idSpec INTEGER); > > And here is the error: > Assertion failed: pCol->zType==0, file build.c, line 955 > This application has requested the Runtime to terminate it in an unusual > way. > Please contact the application's support team for more information. > > I'm using SQLite 3.2.2 under Windows XP. > Does anyone see what could be wrong with that?? > > Thanks by advance for all the hints. > > D I would recommend an upgrade. See http://www.sqlite.org/changes.html -- G. Roderick Singleton <[EMAIL PROTECTED]> PATH tech
Re: [sqlite] Survey: NULLs and GROUP BY
On Thu, 2005-09-01 at 14:51 -0400, D. Richard Hipp wrote: > I'm rewriting the aggregate function processing in SQLite > (so that it runs faster and uses less memory) and I want to > make sure I get it right. In particular, I want to make > sure that SQLite handles NULLs in GROUP BY values the same > as other database engines. > > Can I get some volunteers to run the SQL shown below on various > other SQL database engines and tell me what the output is? > >CREATE TABLE t1(a INTEGER, b INTEGER, c INTEGER); >INSERT INTO t1 VALUES(1,2,1); >INSERT INTO t1 VALUES(NULL,2,2); >INSERT INTO t1 VALUES(1,NULL,4); >INSERT INTO t1 VALUES(NULL,NULL,8); >INSERT INTO t1 SELECT * FROM t1; >SELECT a, b, sum(c) FROM t1 GROUP BY a, b ORDER BY 3; > > Thanks. Dumb forgot the version. Postgresql 8.0.3 psql template1 PATH tech
Re: [sqlite] Survey: NULLs and GROUP BY
On Thu, 2005-09-01 at 14:51 -0400, D. Richard Hipp wrote: > I'm rewriting the aggregate function processing in SQLite > (so that it runs faster and uses less memory) and I want to > make sure I get it right. In particular, I want to make > sure that SQLite handles NULLs in GROUP BY values the same > as other database engines. > > Can I get some volunteers to run the SQL shown below on various > other SQL database engines and tell me what the output is? > >CREATE TABLE t1(a INTEGER, b INTEGER, c INTEGER); >INSERT INTO t1 VALUES(1,2,1); >INSERT INTO t1 VALUES(NULL,2,2); >INSERT INTO t1 VALUES(1,NULL,4); >INSERT INTO t1 VALUES(NULL,NULL,8); >INSERT INTO t1 SELECT * FROM t1; >SELECT a, b, sum(c) FROM t1 GROUP BY a, b ORDER BY 3; > > Thanks. Postgresql. psql template1 PATH tech
Re: [sqlite] Please test prior to version 3.1.5. Was: Delete crashes with Version 3.2.4 in Windows XP
On Wed, 2005-08-24 at 14:23 -0400, D. Richard Hipp wrote: > On Wed, 2005-08-24 at 13:08 -0500, Jolan Luff wrote: > > I am trying to test this in my environment but it looks like the > > build scripts were subtly broken as I can no longer run 'make test': > > > > What is your environment? The build scripts have hardly changed > since 3.2.2 so it is hard to imagine what might have broken... > I recall that running make test as root gives very strange results. -- G. Roderick Singleton <[EMAIL PROTECTED]> PATH tech
Re: [sqlite] unit tests
On Sun, 2005-05-22 at 14:01 -0500, Kurt Welgehausen wrote: > > How do I run the unit tests in Linux? > > make test Running make test as root can give odd results. Use a user account. -- G. Roderick Singleton <[EMAIL PROTECTED]> PATH tech
Re: [sqlite] sqlite 3.2.1 lock-2.8 test hangs
On Wed, 2005-04-27 at 16:55 -0500, Jolan Luff wrote: > hi, > > when running the sqlite 3.2.1 regression tests, the lock-2.8 test hangs > indefinitely. if i disable that test, all others pass. > > is this a bug in the regression test or is this something i should be > concerned about? > > thanks, > > - jolan Thanks. -- G. Roderick Singleton <[EMAIL PROTECTED]> PATH tech
Re: [sqlite] Windows question
On Wed, 2005-04-27 at 16:57 -0400, D. Richard Hipp wrote: > On Wed, 2005-04-27 at 16:47 -0400, G. Roderick Singleton wrote: > > I ask because I have been building my own Linux releases from source > > and > > now have a need for a windows version I can send to a friend. > > All those windows things on the website are build on Linux > using mingw and gcc configured as a cross-compiler. I highly > recommend that solution as it seems to work much better than > trying to compile things under windows. Well I sorta guessed that. I guess what I am asking is which of the zipfiles are recommended for install and in what order. e.g. which of the beasties is the important one? Am I right in guessing sqlite-3_2_1.zip ? The rest I can figure out, I think. It's that the offerings are all similar in size so I am confused. :-( tia -- G. Roderick Singleton <[EMAIL PROTECTED]> PATH tech
[sqlite] Windows question
Hi, I see various windows binaries available but to be honest I do not know which is which WRT what is needed to get SQLite running under windows. I ask because I have been building my own Linux releases from source and now have a need for a windows version I can send to a friend. So please help the windowless guy with some basic directions like: you only need to get this binary or that binary. I believe I can figure out where to stuff the binary when I get it but even a hint or two in that direction wouldn't go amiss. TIA -- G. Roderick Singleton <[EMAIL PROTECTED]> PATH tech
Re: [sqlite] 50MB Size Limit?
On Mon, 2005-04-11 at 12:05 -0400, Jonathan Zdziarski wrote: > D. Richard Hipp wrote: > > Are you sure your users are not, in fact, filling up their disk > > drives? > > nope, plenty of free space on the drives. The 50MB limit seems to be > very exact as well...exactly 51,200,000 bytes. I'm stumped too. quotas? -- G. Roderick Singleton <[EMAIL PROTECTED]> PATH tech
Re: [sqlite] Problem with compiling 3.2.1
On Fri, 2005-04-01 at 15:11 -0500, G. Roderick Singleton wrote: > On Fri, 2005-04-01 at 14:37 -0500, D. Richard Hipp wrote: > > On Fri, 2005-04-01 at 09:06 -0500, G. Roderick Singleton wrote: > > > Running make test as a normal user, make test halts in wait() at the > > > following test: > > > > > > [snipped] With D. Richard Hipp's help the problem appears to be FC3 specific. A new Makefile fixed the problem. See Ticket 1198 for an update. ger -- G. Roderick Singleton <[EMAIL PROTECTED]> PATH tech
Re: [sqlite] Problem with compiling 3.2.1
On Fri, 2005-04-01 at 14:37 -0500, D. Richard Hipp wrote: > On Fri, 2005-04-01 at 09:06 -0500, G. Roderick Singleton wrote: > > Running make test as a normal user, make test halts in wait() at the > > following test: > > > > lock-2.1... Ok > > lock-2.2... Ok > > lock-2.3.1... Ok > > lock-2.3.2... Ok > > lock-2.4.1... Ok > > lock-2.4.2... Ok > > lock-2.5... Ok > > lock-2.8... > > > > What is supposed to happen? Last time I had failed tests the solution > > was run as user. Now ... Do prior releases need to be removed from the > > system before building the new? > > > > The test that is "locking up" (lock-2.8) is a test of the > sqlite3_busy_timeout() API. It suppose to time out after > 400 milliseconds. It works fine on my SuSE 9.2 box. > > If you want to help debug this, recompile "testfixture" > with debugging symbols turned on. Then run testfixture > in gdb with argument ../sqlite/test/lock.test. Set a > breakpoint on sqliteDefaultBusyCallback(). Try to figure > out what is going wrong. Between posting my message and now, I enabled debug in the Makefile and re-made sqlite. I also am re-running fulltest. -- G. Roderick Singleton <[EMAIL PROTECTED]> PATH tech
[sqlite] Problem with compiling 3.2.1
Running make test as a normal user, make test halts in wait() at the following test: lock-2.1... Ok lock-2.2... Ok lock-2.3.1... Ok lock-2.3.2... Ok lock-2.4.1... Ok lock-2.4.2... Ok lock-2.5... Ok lock-2.8... What is supposed to happen? Last time I had failed tests the solution was run as user. Now ... Do prior releases need to be removed from the system before building the new? -- G. Roderick Singleton <[EMAIL PROTECTED]> PATH tech
Re: [sqlite] Does sqlite has isnull function?
On Sun, 2005-03-06 at 09:12 -0400, [EMAIL PROTECTED] wrote: > Hi All, > > I don't think sqlite support isnull function, but I wonder is there > other function has same functionality but different name? > > thanks, > > Ming Is the function IS NULL? According to http://www.metrokc.gov/gis/kb/Content/SQLTipNull.htm it is. -- G. Roderick Singleton <[EMAIL PROTECTED]> PATH tech
Re: [sqlite] Ticket 1153: make test on 3.1.3 throws 11 errors
On Tue, 2005-03-01 at 12:59 -0500, G. Roderick Singleton wrote: > On Tue, 2005-03-01 at 12:37 -0500, D. Richard Hipp wrote: > > On Tue, 2005-03-01 at 11:36 -0500, G. Roderick Singleton wrote: > > > I tried posting via gmane and was unsuccessful as this mailing list > > > rejected the posting. I subsequently entered this ticket for evaluation. > > > I tried combing the list archives and the docs but found nothing that > > > would indicate that the failure of test was expected. Can someone please > > > let me know. > > > > The ticket fails to mention some important facts: > > > > * What operating system you are using > > FC3 > > > * What compiler you are using > > gcc version 3.4.2 20041017 (Red Hat 3.4.2-6.fc3) > > I would have update the ticket but am only on the mailing lists. Found how to update the ticket and the problem is solved. I discovered that sqlite should be compiled and tested as a user rather than as root. I tend to build system level stuff as root out of long habit and this is not documented in the README or externally. > > > > All the tests pass on the developer's platforms. We are going > > to need some hints if you want us to look into your problem. > > Consider the above hints. -- G. Roderick Singleton <[EMAIL PROTECTED]> PATH tech
Re: [sqlite] Ticket 1153: make test on 3.1.3 throws 11 errors
On Tue, 2005-03-01 at 12:37 -0500, D. Richard Hipp wrote: > On Tue, 2005-03-01 at 11:36 -0500, G. Roderick Singleton wrote: > > I tried posting via gmane and was unsuccessful as this mailing list > > rejected the posting. I subsequently entered this ticket for evaluation. > > I tried combing the list archives and the docs but found nothing that > > would indicate that the failure of test was expected. Can someone please > > let me know. > > The ticket fails to mention some important facts: > > * What operating system you are using FC3 > * What compiler you are using gcc version 3.4.2 20041017 (Red Hat 3.4.2-6.fc3) I would have update the ticket but am only on the mailing lists. > > All the tests pass on the developer's platforms. We are going > to need some hints if you want us to look into your problem. Consider the above hints. -- G. Roderick Singleton <[EMAIL PROTECTED]> PATH tech
[sqlite] Ticket 1153: make test on 3.1.3 throws 11 errors
I tried posting via gmane and was unsuccessful as this mailing list rejected the posting. I subsequently entered this ticket for evaluation. I tried combing the list archives and the docs but found nothing that would indicate that the failure of test was expected. Can someone please let me know. -- G. Roderick Singleton <[EMAIL PROTECTED]> PATH tech
[sqlite] Gname support is poor
The mailing gateway from gmane is not allowing postings. Is this intentional because the newsgroup is superior to this list. -- G. Roderick Singleton <[EMAIL PROTECTED]> PATH tech
