I cloned the git repository and checked out branch 5.x-3.x (SHA ID f879a4d2fa8e401189f2dc03d22193933fe75470), to use it with my drupal 5.7 server. Upon copying the module to the sites/all/modules/contrib folder and enabling the module as well as all the filters the following errors happened:

user warning: 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 /*!40100 DEFAULT CHARACTER SET utf8 */' at line 15 query: CREATE TABLE bayesian_tokens ( tid int(10) unsigned NOT NULL auto_increment, class varchar(32) NOT NULL default '', token varchar(255) NOT NULL default '', yes_count int(10) unsigned default '0', no_count int(10) unsigned default '0', probability int(10) unsigned default '0', last int(11) unsigned default '0', PRIMARY KEY tid (tid), UNIQUE KEY token (class, token), KEY yes_count (yes_count), KEY no_count (no_count), KEY probability (probability), KEY last (last) ) TYPE=MyISAM /*!40100 DEFAULT CHARACTER SET utf8 */; in database.mysql.inc on line 172.

user warning: 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 /*!40100 DEFAULT CHARACTER SET utf8 */' at line 16 query: CREATE TABLE spam_custom ( cid int(11) unsigned NOT NULL auto_increment, filter varchar(255) NOT NULL default '', style int(3) unsigned default '0', # text, regex, URL status int(2) signed default '0', # spam, notspam... scan int(3) unsigned default '0', # header, body, referrer action int(3) unsigned default '0', # delete, mail matches int(11) unsigned default '0', # counter last int(11) unsigned default '0', # last match weight int(3) signed default '0', # order filters PRIMARY KEY cid (cid), KEY filter (filter), KEY matches (matches), KEY last (last), KEY weight (weight) ) TYPE=MyISAM /*!40100 DEFAULT CHARACTER SET utf8 */; in database.mysql.inc on line 172.

user warning: 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 /*!40100 DEFAULT CHARACTER SET utf8 */' at line 17 query: CREATE TABLE spam_duplicate ( iid INT(11) UNSIGNED NOT NULL AUTO_INCREMENT, sid INT(11) UNSIGNED NOT NULL DEFAULT '0', content_hash CHAR(32) NOT NULL DEFAULT '', hostname VARCHAR(15) NOT NULL DEFAULT '', duplicate_hash INT(11) NOT NULL DEFAULT '0', duplicate_ip INT(11) NOT NULL DEFAULT '0', spam TINYINT NOT NULL DEFAULT '0', expired TINYINT NOT NULL DEFAULT '0', timestamp INT(11) UNSIGNED DEFAULT '0', PRIMARY KEY (iid), KEY (sid), KEY (content_hash), KEY (hostname), KEY (spam), KEY (timestamp) ) TYPE=MyISAM /*!40100 DEFAULT CHARACTER SET utf8 */; in database.mysql.inc on line 172.

user warning: 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 /*!40100 DEFAULT CHARACTER SET utf8 */' at line 15 query: CREATE TABLE spam_filters ( fid INT(11) UNSIGNED NOT NULL AUTO_INCREMENT, gid INT(11) UNSIGNED DEFAULT '0' NOT NULL, name VARCHAR(128) NOT NULL DEFAULT '', module VARCHAR(128) NOT NULL DEFAULT '', status TINYINT UNSIGNED DEFAULT '0' NOT NULL, weight TINYINT DEFAULT '0' NOT NULL, gain TINYINT UNSIGNED DEFAULT '0' NOT NULL, PRIMARY KEY fid (fid), KEY gid (gid), KEY name (name), KEY module (module), KEY status (status), KEY weight (weight) ) TYPE=MyISAM /*!40100 DEFAULT CHARACTER SET utf8 */; in database.mysql.inc on line 172.

user warning: 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 /*!40100 DEFAULT CHARACTER SET utf8 */' at line 7 query: CREATE TABLE spam_filters_groups ( gid INT(11) UNSIGNED NOT NULL AUTO_INCREMENT, name VARCHAR(255) NOT NULL DEFAULT '', weight TINYINT DEFAULT '0' NOT NULL, PRIMARY KEY gid (gid), KEY weight (weight) ) TYPE=MyISAM /*!40100 DEFAULT CHARACTER SET utf8 */; in database.mysql.inc on line 172.

user warning: 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 /*!40100 DEFAULT CHARACTER SET utf8 */' at line 6 query: CREATE TABLE spam_filters_groups_data ( gid INT(11) UNSIGNED NOT NULL AUTO_INCREMENT, content_type VARCHAR(64) NOT NULL DEFAULT '', PRIMARY KEY gid_content_type (gid,content_type), KEY content_type (content_type) ) TYPE=MyISAM /*!40100 DEFAULT CHARACTER SET utf8 */; in database.mysql.inc on line 172.

user warning: 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 /*!40100 DEFAULT CHARACTER SET utf8 */' at line 14 query: CREATE TABLE spam_tracker ( sid INT(11) UNSIGNED NOT NULL AUTO_INCREMENT, content_type VARCHAR(128) NOT NULL DEFAULT '', content_id INT(11) UNSIGNED DEFAULT '0', score INT(4) UNSIGNED DEFAULT '0', hostname VARCHAR(15) NOT NULL DEFAULT '', timestamp INT(11) UNSIGNED DEFAULT '0', PRIMARY KEY sid (sid), UNIQUE KEY content_id_content_type (content_id,content_type), KEY content_type (content_type), KEY score (score), KEY hostname (hostname), KEY timestamp (timestamp) ) TYPE=MyISAM /*!40100 DEFAULT CHARACTER SET utf8 */; in database.mysql.inc on line 172.

user warning: 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 /*!40100 DEFAULT CHARACTER SET utf8 */' at line 18 query: CREATE TABLE spam_filters_errors ( bid INT(11) UNSIGNED NOT NULL AUTO_INCREMENT, uid INT(11) UNSIGNED NOT NULL DEFAULT '0', content_type VARCHAR(128) NOT NULL DEFAULT '', content_id INT(11) UNSIGNED DEFAULT '0', content_hash CHAR(32) NOT NULL DEFAULT '', content TEXT NOT NULL, form TEXT NOT NULL, feedback TEXT NOT NULL, hostname VARCHAR(15) NOT NULL DEFAULT '', timestamp INT(11) UNSIGNED DEFAULT '0', PRIMARY KEY bid (bid), KEY id_type (content_id,content_type), UNIQUE KEY content_hash (content_hash), KEY content_type (content_type), KEY hostname (hostname), KEY timestamp (timestamp) ) TYPE=MyISAM /*!40100 DEFAULT CHARACTER SET utf8 */; in database.mysql.inc on line 172.

user warning: 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 /*!40100 DEFAULT CHARACTER SET utf8 */' at line 19 query: CREATE TABLE spam_log ( lid int(11) UNSIGNED NOT NULL AUTO_INCREMENT, trid int(11) UNSIGNED NOT NULL DEFAULT '0', level int(2) UNSIGNED NOT NULL DEFAULT '0', content_type VARCHAR(128) NULL DEFAULT '', content_id INT(11) UNSIGNED DEFAULT '0', uid int(10) UNSIGNED NOT NULL DEFAULT '0', function varchar(255) NOT NULL DEFAULT '', message varchar(255) NOT NULL DEFAULT '', hostname VARCHAR(15) NOT NULL DEFAULT '', timestamp int(11) UNSIGNED DEFAULT '0', PRIMARY KEY lid (lid), KEY trid (trid), KEY content_type_content_id (content_type, content_id), KEY message (message), KEY uid (uid), KEY hostname (hostname), KEY timestamp (timestamp) ) TYPE=MyISAM /*!40100 DEFAULT CHARACTER SET utf8 */; in database.mysql.inc on line 172.

user warning: 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 /* 40100 DEFAULT CHARACTER SET utf8 */' at line 8 query: CREATE TABLE spam_statistics ( stid int(11) UNSIGNED NOT NULL AUTO_INCREMENT, name varchar(64) NOT NULL DEFAULT '', count int(11) UNSIGNED NOT NULL DEFAULT '0', timestamp int(11) UNSIGNED DEFAULT '0', PRIMARY KEY stid (stid), UNIQUE KEY name (name) ) TYPE=MyISAM /* 40100 DEFAULT CHARACTER SET utf8 */; in database.mysql.inc on line 172.

CommentFileSizeAuthor
#1 spam-5x3x-MyISAM-bug.patch7.88 KBench0
Support from Acquia helps fund testing for Drupal Acquia logo

Comments

ench0’s picture

ench0 CreditAttribution: ench0 commented
FileSize
spam-5x3x-MyISAM-bug.patch7.88 KB

I was able to get rid of these errors by looking for all occurences of TYPE=MyISAM in the .install files and replacing them with DEFAULT CHARACTER SET utf8.

Attaching patch, but no idea if this is the proper way to fix this error.. just reporting here what I did to get these tables created...

apaderno’s picture

apaderno
he/him
Primary language Italian
Location Brescia, 🇮🇹 🇪🇺
CreditAttribution: apaderno as a volunteer commented
Status: Active » Closed (outdated)

I am closing this issue, since Drupal 5 isn't supported anymore.