sqlite problems on Mac OS X 10.4 (was Re: bogofilter-0.96.1 - aka 1.0.0-rc1)

[David Relson]

On Mon, 5 Sep 2005 12:30:49 -0400
Jim Correia wrote:

> When building with the sqlite database engine on Mac OS X 10.4,  
> t.lock3 hangs. Hints on further diagnosis and solutions?
> 
> Then I try the built binary from the command line
> 
> $ ./src/bogofilter -C -d ~/Desktop/bfwordlists/
> bogofilter[16559]: cannot compile SELECT value FROM bogofilter WHERE  
> key=? LIMIT 1;: no such table: bogofilter_
> 
> and an empty wordlists.db file is created.
> 
> Is there something wrong with my build? Pilot error?
> 
> Thanks,
> Jim

Jim,

You might be a mite bit off course.  The following is how I create an
empty database:

  bogofilter -C -v -d ~/.bogofilter -n < /dev/null

The "-n < /dev/null" is the significant difference.

I anticipate Matthias will chime in on the t.lock3 problem.

By the way, what version of sqlite3 are you running?  "bogofilter -V"
should provide the needed info.