You are viewing a plain text version of this content. The canonical link for it is here.
Posted to dev@spamassassin.apache.org by bu...@bugzilla.spamassassin.org on 2005/10/13 18:27:41 UTC
[Bug 4633] New: Syntax error using MySQL backend
http://bugzilla.spamassassin.org/show_bug.cgi?id=4633
Summary: Syntax error using MySQL backend
Product: Spamassassin
Version: 3.1.0
Platform: Other
OS/Version: Linux
Status: NEW
Severity: critical
Priority: P5
Component: spamassassin
AssignedTo: dev@spamassassin.apache.org
ReportedBy: bpacheco@acisa.es
Dear all,
I've updated my spamassassin to the newset 3.1.0 release. After doing this, and
reconfiguring everything I've decide to use MySQL instead of database files.
I've configured everything and seems to work fine, but when I've started the
daemon in debug mode, it claims about some SQL syntax error...
bayes: _put_tokens: SQL error: 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 'ON DUPLICATE KEY UPDATE spam_count = GREATEST(spam_count + '0',
My env is the following one:
OS: SuSE Linux
Spamassassin: 3.1.0
MySQL: 4.0.15
DBI: 1.47.3
DBD-MySQL: 2.9004
perl 5.8.6
The scripts I've used to created tables, etc are the following ones (just only
mysql ones...):
http://spamassassin.apache.org/full/3.1.x/dist/sql/
------- You are receiving this mail because: -------
You are the assignee for the bug, or are watching the assignee.
[Bug 4633] Syntax error using MySQL backend
Posted by bu...@bugzilla.spamassassin.org.
http://bugzilla.spamassassin.org/show_bug.cgi?id=4633
------- Additional Comments From parkerm@pobox.com 2005-10-13 10:20 -------
Subject: Re: Syntax error using MySQL backend
>
>I'm not too sure about upgrading MySql to 4.1. If I don't upgrade mysql, should
>spamassassin work changing bayes storage module for the generic SQL?
>
>
>
Yes, you should be able to use the SQL storage engine.
Michael
------- You are receiving this mail because: -------
You are the assignee for the bug, or are watching the assignee.
[Bug 4633] Syntax error using MySQL backend
Posted by bu...@bugzilla.spamassassin.org.
http://bugzilla.spamassassin.org/show_bug.cgi?id=4633
bpacheco@acisa.es changed:
What |Removed |Added
----------------------------------------------------------------------------
Component|spamassassin |Plugins
------- You are receiving this mail because: -------
You are the assignee for the bug, or are watching the assignee.
[Bug 4633] Syntax error using MySQL backend
Posted by bu...@bugzilla.spamassassin.org.
http://bugzilla.spamassassin.org/show_bug.cgi?id=4633
parkerm@pobox.com changed:
What |Removed |Added
----------------------------------------------------------------------------
Status|NEW |RESOLVED
Resolution| |INVALID
------- Additional Comments From parkerm@pobox.com 2005-10-13 10:09 -------
http://spamassassin.apache.org/full/3.1.x/dist/sql/README.bayes
If you want to use the MySQL bayes storage module then you have to use MySQL 4.1+.
------- You are receiving this mail because: -------
You are the assignee for the bug, or are watching the assignee.
[Bug 4633] Syntax error using MySQL backend
Posted by bu...@bugzilla.spamassassin.org.
http://bugzilla.spamassassin.org/show_bug.cgi?id=4633
------- Additional Comments From bpacheco@acisa.es 2005-10-13 10:16 -------
(In reply to comment #1)
> http://spamassassin.apache.org/full/3.1.x/dist/sql/README.bayes
>
> If you want to use the MySQL bayes storage module then you have to use MySQL 4.1+.
Parker,
I'm not too sure about upgrading MySql to 4.1. If I don't upgrade mysql, should
spamassassin work changing bayes storage module for the generic SQL?
Thanks
------- You are receiving this mail because: -------
You are the assignee for the bug, or are watching the assignee.