https://issues.apache.org/SpamAssassin/show_bug.cgi?id=6626
Bug #: 6626
Summary: Newer MySQL chokes on TYPE=MyISAM syntax
Product: Spamassassin
Version: 3.3.2
Platform: PC
OS/Version: All
Status: NEW
Severity: normal
Priority: P2
Component: Documentation
AssignedTo: [email protected]
ReportedBy: [email protected]
Classification: Unclassified
Newer version of MySQL throw a syntax error when bayes_mysql.sql schema
is applied. The offending part is the 'TYPE=MyISAM':
ERROR 1064 (42000): 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 'TYPE=MyISAM'
It is also becoming a FAQ telling newcomers that they'd better be
using the Mail::SpamAssassin::BayesStore::MySQL storage engine with
InnoDB, instead of a generic Mail::SpamAssassin::BayesStore::SQL.
Proposed is a documentation change to README.bayes to talk
about BayesStore::MySQL first and about BayesStore::SQL second;
and to replace TYPE=MyISAM with ENGINE=InnoDB in schemas and
document how to change it back if necessary.
--
Configure bugmail:
https://issues.apache.org/SpamAssassin/userprefs.cgi?tab=email
------- You are receiving this mail because: -------
You are the assignee for the bug.
