>> Nope, automatically quoted by the database layers.
>>
>> Where is it bombing out?
>>
>
> [2009/06/19-17:09:09 - 8802] [GREYLISTING] ERROR: Database insert
> failed: cbp::dblayer::DBDo(125): Error executing command: You have an
> error in your SQL syntax; check the manual that corresponds to your
> MySQL server version for the right syntax to use near '?,?,?,?)' at line 4
>
> That's all that is in cbpolicyd.log. I assume it is in the inserting of
> the autowhitelist entries as they are still not being added.
>
>
That is very very very odd .... I cannot see how that query can fail.
Forgive me for asking, but did you modify anything in that file? from
my best guess it should look like this on those lines ...
# Update whitelisting to the new details
$sth = DBDo('
INSERT INTO greylisting_autowhitelist
(TrackKey,Added,LastSeen,Comment)
VALUES
(?,?,?,?)
',
$key,$sessionData->{'UnixTimestamp'},$sessionData->{'UnixTimestamp'},$whitelist
);
Regards
Nigel
_______________________________________________
Users mailing list
[email protected]
http://lists.policyd.org/mailman/listinfo/users
