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