SA Bugzilla – Bug 6626
Newer MySQL chokes on TYPE=MyISAM syntax
Last modified: 2011-09-21 00:29:31 UTC
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.
Created attachment 4927 [details] docs change: prefer BayesStore::MySQL over BayesStore::SQL trunk: Bug 6626: Newer MySQL chokes on TYPE=MyISAM syntax' ci Sending sql/README.bayes Sending sql/awl_mysql.sql Sending sql/bayes_mysql.sql Committed revision 1139015. (also changes awl.email data type from varchar to varbinary -related to Bug 6625)
closing, fixed for 3.4