Sorry if this has already been logged in the support queue - I couldn't see anything similar at first glance.
Upon installation of memetracker module (before installing machinelearningapi), I get a string of SQL errors (pasted below). System: drupal 6.4, PHP version 5.2.5, MySQL version 4.1.2. The same reoccurs if I uninstall the module and try to install it again.

Thanks making this module!

* user warning: Column length too big for column 'content' (max = 255); use BLOB or TEXT instead query: CREATE TABLE memetracker_search_1 ( `cid` INT unsigned NOT NULL DEFAULT 0, `content` VARCHAR(500) NOT NULL DEFAULT '0', INDEX cid (cid) ) /*!40100 DEFAULT CHARACTER SET UTF8 */ in /home/webgazet/public_html/newmediaworld/tracker/includes/database.inc on line 514.
* user warning: Column length too big for column 'content' (max = 255); use BLOB or TEXT instead query: CREATE TABLE memetracker_search_2 ( `cid` INT unsigned NOT NULL DEFAULT 0, `content` VARCHAR(500) NOT NULL DEFAULT '0', INDEX cid (cid) ) /*!40100 DEFAULT CHARACTER SET UTF8 */ in /home/webgazet/public_html/newmediaworld/tracker/includes/database.inc on line 514.
* user warning: Column length too big for column 'content' (max = 255); use BLOB or TEXT instead query: CREATE TABLE memetracker_search_3 ( `cid` INT unsigned NOT NULL DEFAULT 0, `content` VARCHAR(500) NOT NULL DEFAULT '0', INDEX cid (cid) ) /*!40100 DEFAULT CHARACTER SET UTF8 */ in /home/webgazet/public_html/newmediaworld/tracker/includes/database.inc on line 514.
* user warning: Column length too big for column 'content' (max = 255); use BLOB or TEXT instead query: CREATE TABLE memetracker_search_4 ( `cid` INT unsigned NOT NULL DEFAULT 0, `content` VARCHAR(500) NOT NULL DEFAULT '0', INDEX cid (cid) ) /*!40100 DEFAULT CHARACTER SET UTF8 */ in /home/webgazet/public_html/newmediaworld/tracker/includes/database.inc on line 514.
* user warning: Column length too big for column 'content' (max = 255); use BLOB or TEXT instead query: CREATE TABLE memetracker_search_5 ( `cid` INT unsigned NOT NULL DEFAULT 0, `content` VARCHAR(500) NOT NULL DEFAULT '0', INDEX cid (cid) ) /*!40100 DEFAULT CHARACTER SET UTF8 */ in /home/webgazet/public_html/newmediaworld/tracker/includes/database.inc on line 514.
* user warning: Column length too big for column 'content' (max = 255); use BLOB or TEXT instead query: CREATE TABLE memetracker_search_6 ( `cid` INT unsigned NOT NULL DEFAULT 0, `content` VARCHAR(500) NOT NULL DEFAULT '0', INDEX cid (cid) ) /*!40100 DEFAULT CHARACTER SET UTF8 */ in /home/webgazet/public_html/newmediaworld/tracker/includes/database.inc on line 514.
* user warning: Column length too big for column 'content' (max = 255); use BLOB or TEXT instead query: CREATE TABLE memetracker_search_7 ( `cid` INT unsigned NOT NULL DEFAULT 0, `content` VARCHAR(500) NOT NULL DEFAULT '0', INDEX cid (cid) ) /*!40100 DEFAULT CHARACTER SET UTF8 */ in /home/webgazet/public_html/newmediaworld/tracker/includes/database.inc on line 514.
* user warning: Column length too big for column 'content' (max = 255); use BLOB or TEXT instead query: CREATE TABLE memetracker_search_8 ( `cid` INT unsigned NOT NULL DEFAULT 0, `content` VARCHAR(500) NOT NULL DEFAULT '0', INDEX cid (cid) ) /*!40100 DEFAULT CHARACTER SET UTF8 */ in /home/webgazet/public_html/newmediaworld/tracker/includes/database.inc on line 514.
* user warning: Column length too big for column 'content' (max = 255); use BLOB or TEXT instead query: CREATE TABLE memetracker_search_9 ( `cid` INT unsigned NOT NULL DEFAULT 0, `content` VARCHAR(500) NOT NULL DEFAULT '0', INDEX cid (cid) ) /*!40100 DEFAULT CHARACTER SET UTF8 */ in /home/webgazet/public_html/newmediaworld/tracker/includes/database.inc on line 514.
* user warning: Column length too big for column 'content' (max = 255); use BLOB or TEXT instead query: CREATE TABLE memetracker_search_10 ( `cid` INT unsigned NOT NULL DEFAULT 0, `content` VARCHAR(500) NOT NULL DEFAULT '0', INDEX cid (cid) ) /*!40100 DEFAULT CHARACTER SET UTF8 */ in /home/webgazet/public_html/newmediaworld/tracker/includes/database.inc on line 514.
* user warning: Table 'webgazet_65.memetracker_search_1' doesn't exist query: CREATE FULLTEXT INDEX content_index ON memetracker_search_1 (content) in /home/webgazet/public_html/newmediaworld/tracker/sites/all/modules/memetracker/memetracker.install on line 465.
* user warning: Table 'webgazet_65.memetracker_search_2' doesn't exist query: CREATE FULLTEXT INDEX content_index ON memetracker_search_2 (content) in /home/webgazet/public_html/newmediaworld/tracker/sites/all/modules/memetracker/memetracker.install on line 467.
* user warning: Table 'webgazet_65.memetracker_search_3' doesn't exist query: CREATE FULLTEXT INDEX content_index ON memetracker_search_3 (content) in /home/webgazet/public_html/newmediaworld/tracker/sites/all/modules/memetracker/memetracker.install on line 469.
* user warning: Table 'webgazet_65.memetracker_search_4' doesn't exist query: CREATE FULLTEXT INDEX content_index ON memetracker_search_4 (content) in /home/webgazet/public_html/newmediaworld/tracker/sites/all/modules/memetracker/memetracker.install on line 471.
* user warning: Table 'webgazet_65.memetracker_search_5' doesn't exist query: CREATE FULLTEXT INDEX content_index ON memetracker_search_5 (content) in /home/webgazet/public_html/newmediaworld/tracker/sites/all/modules/memetracker/memetracker.install on line 473.
* user warning: Table 'webgazet_65.memetracker_search_6' doesn't exist query: CREATE FULLTEXT INDEX content_index ON memetracker_search_6 (content) in /home/webgazet/public_html/newmediaworld/tracker/sites/all/modules/memetracker/memetracker.install on line 475.
* user warning: Table 'webgazet_65.memetracker_search_7' doesn't exist query: CREATE FULLTEXT INDEX content_index ON memetracker_search_7 (content) in /home/webgazet/public_html/newmediaworld/tracker/sites/all/modules/memetracker/memetracker.install on line 477.
* user warning: Table 'webgazet_65.memetracker_search_8' doesn't exist query: CREATE FULLTEXT INDEX content_index ON memetracker_search_8 (content) in /home/webgazet/public_html/newmediaworld/tracker/sites/all/modules/memetracker/memetracker.install on line 479.
* user warning: Table 'webgazet_65.memetracker_search_9' doesn't exist query: CREATE FULLTEXT INDEX content_index ON memetracker_search_9 (content) in /home/webgazet/public_html/newmediaworld/tracker/sites/all/modules/memetracker/memetracker.install on line 481.
* user warning: Table 'webgazet_65.memetracker_search_10' doesn't exist query: CREATE FULLTEXT INDEX content_index ON memetracker_search_10 (content) in /home/webgazet/public_html/newmediaworld/tracker/sites/all/modules/memetracker/memetracker.install on line 483.

Comments

kyle_mathews’s picture

Status: Active » Closed (duplicate)

You're running into the same problem as this feller. See my comment here.
http://drupal.org/node/296133#comment-1010766

I'm going to try changing things up to see if Memetracker will work on a MySQL 4 install. When I make the changes, can you test it for me?