http://bugzilla.spamassassin.org/show_bug.cgi?id=3519 ------- Additional Comments From parkerm@pobox.com 2004-06-17 16:30 -------
Subject: Re: make test failures for bayessql.t
On Thu, Jun 17, 2004 at 04:01:55PM -0700, bugzilla-daemon@bugzilla.spamassassin.org wrote:
> ------- Additional Comments From snyder@roguewave.com 2004-06-17 16:01 -------
> spamassassin=# \d bayes_token
> Table "public.bayes_token"
> Column | Type | Modifiers
> ------------+--------------+----------------------
> id | integer | not null default '0'
> token | character(5) | not null default ''
> spam_count | integer | not null default '0'
> ham_count | integer | not null default '0'
> atime | integer | not null default '0'
> Indexes: bayes_token_pkey primary key btree (id, token)
This looks fine, it's a little different than mine:
spamassassin=# \d bayes_token;
Table "public.bayes_token"
Column | Type | Modifiers
------------+--------------+-----------------------------
id | integer | not null default 0
token | character(5) | not null default ''::bpchar
spam_count | integer | not null default 0
ham_count | integer | not null default 0
atime | integer | not null default 0
Indexes:
"bayes_token_pkey" primary key, btree (id, token)
But that is probably because I'm running 7.4.3.
> perl-DBD-Pg-1.21-2 is the rpm
>
DBD::Pg < 1.31 is known to have problems with the Bayes SQL code, see
this in README.bayes:
NOTE: Some users have reported problems using DBD::Pg v1.22. There
appears to be a bug in how parameters are quoted in that version, we
recommend you upgrade to at least v1.31.
Also, Bug 3415.
Upgrade to at least 1.31 and see if the error still occurs.
> It's possible that the database was created while my locale was set to
> en_US.UTF-8 instead of en_US. I'll poke around a bit more.
>
I've seen problems in the past with the locale setting, might be a red
herring, but something to keep in mind.
Michael
------- You are receiving this mail because: -------
You are the assignee for the bug, or are watching the assignee.