[sam] DB Error: null value violates not-null constraint ...

[Marc G. Fournier]

On Fri, 11 Jun 2004, Jan Schneider wrote:

> Zitat von "Marc G. Fournier" <scrappy at hub.org>:
>
>> On Fri, 11 Jun 2004, Jan Schneider wrote:
>> 
>>> Zitat von "Marc G. Fournier" <scrappy at hub.org>:
>>> 
>>>> Trying to save a 'hit level' of 5 to the database, nothing else set, 
>>>> I'm
>>>> getting:
>>>> 
>>>>    Cannot set options: DB Error: null value violates not-null 
>>>> constraint
>>>> 
>>>> According to the backend:
>>>> 
>>>>    ERROR:  null value in column "horde_id" violates not-null 
>>>> constraint
>>>> 
>>>> This is SAM from CVS from around the beginning of May, so this might 
>>>> be
>>>> something that has been since fixed ... ?
>>> 
>>> Try it. I changed some driver code yesterday, maybe I catched it. Btw.
>>> giving us some information that might help locating the problem would be
>>> nice, e.g. the driver and configuration you use.
>> 
>> never sure exactly what details to provide, sorry :(
>> 
>> backend is a postgresql database ... 'spamd_sql' ... beyond that?
>
> I just added some query logs to the spamd_sql driver. Update and tell us the
> query that causes that error, if it still happens.

still happening, after doing a CVS update on sam, but I'm not getting 
anything in the logs at all ... I'm getting errors logs from nag, so 
logging is working ...

I take it that SAM is working for you? :(

----
Marc G. Fournier           Hub.Org Networking Services (http://www.hub.org)
Email: scrappy at hub.org           Yahoo!: yscrappy              ICQ: 7615664