On Aug 26, 2009, at 8:09 PM, Paul Whipp wrote:

> Thanks for the reply Robert. It helps to know that it 'should' work.
>
> I get exactly the same result as you from "dpkg -l sqlite3"
>
> I uninstalled (aptitude purge sqlite3) and reinstalled and got  
> exactly the
> same segmentation fault.
>
> Clearly, as its working on your system and not on mine there must be
> something in the dependencies causing the issue. Nothing on my system
> appears broken that is likely to relate to this so I'm stumped on  
> where to
> look next.
>
> I use firefox which creates and manages sqlite files for its cookies  
> etc.
> too making this doubly strange.
>
> Does anyone know what I should investigate or where I should look  
> next to
> solve this problem?
>

Go to the website and download three source files (all conveniently  
packaged in a tarball on the download page):

     sqlite3.c
     sqlite3.h
     shell.c

Then run:

     gcc -static -o sqlite3 -DSQLITE_THREADSAFE=0 sqlite3.c shell.c -ldl

Then move the resulting stand-alone, dependency-free executable  
"sqlite3" to someplace on your $PATH.


D. Richard Hipp
[email protected]



_______________________________________________
sqlite-users mailing list
[email protected]
http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users

Reply via email to