Problems with sqlite support with 1.4.8: no such table: uniqueid_temp

[Colin Guthrie]

Rich wrote:
> i saw the same messages yesterday on a completely clean slackware 
> install and 1.4 svn branch, revision 778156.
> 
> i didn't pay much attention to those, as i assumed it was because of the 
> initial scan - but looking at the messages, they refer to _temp tables, 
> which should have been created, should they not ?

They should be created before a scan and removed afterwards. I've traced
the calls and they *do* get created but they just don't appear to stick
around. I think it must be either some mutli-threading or transaction
commit type bug but I'm nowhere near certain.

> for me, deviceid in those messages is '-1' (even though i haven't 
> explicitly disabled dynamic collection and all the settings are defaults).

This is expected: Local disk gets a device id of -1.

> i'm on p3/733, so arch doesn't seem to make a difference here :)

Thanks, 1 down, 41 more variables to go ;)

Col