You are hereBlogs / vinayras's blog / memetracker & MySql 4.x
memetracker & MySql 4.x
Hi,
I was trying to setup Memetracker (http://drupal.org/project/memetracker) - and since this system is heavily dependent on PHP 5.x & MySQL 5.x - i had to face few issues.
While creating tables in MySQL 4.x i was getting this error
* user warning: Column length too big for column 'content' (max = 255); use BLOB or TEXT instead
Since MySql 4.x does not support Varchar field to be more than 255 chars - things were not working at my end.
I created tables manually at my end using following SQL.
Hope this helps (in case you have MySQL 4.x)
Vinay
--
-- Table structure for table `memetracker_search_1`
--
CREATE TABLE IF NOT EXISTS `memetracker_search_1` (
`cid` int(10) unsigned NOT NULL default '0',
`content` varchar(255) NOT NULL default '0',
KEY `cid` (`cid`),
FULLTEXT KEY `content_index` (`content`)
) TYPE=MyISAM;
--
-- Table structure for table `memetracker_search_2`
--
CREATE TABLE IF NOT EXISTS `memetracker_search_2` (
`cid` int(10) unsigned NOT NULL default '0',
`content` varchar(255) NOT NULL default '0',
KEY `cid` (`cid`),
FULLTEXT KEY `content_index` (`content`)
) TYPE=MyISAM;
--
-- Dumping data for table `memetracker_search_2`
--
-- --------------------------------------------------------
--
-- Table structure for table `memetracker_search_3`
--
CREATE TABLE IF NOT EXISTS `memetracker_search_3` (
`cid` int(10) unsigned NOT NULL default '0',
`content` varchar(255) NOT NULL default '0',
KEY `cid` (`cid`),
FULLTEXT KEY `content_index` (`content`)
) TYPE=MyISAM;
--
-- Dumping data for table `memetracker_search_3`
--
-- --------------------------------------------------------
--
-- Table structure for table `memetracker_search_4`
--
CREATE TABLE IF NOT EXISTS `memetracker_search_4` (
`cid` int(10) unsigned NOT NULL default '0',
`content` varchar(255) NOT NULL default '0',
KEY `cid` (`cid`),
FULLTEXT KEY `content_index` (`content`)
) TYPE=MyISAM;
--
-- Dumping data for table `memetracker_search_4`
--
-- --------------------------------------------------------
--
-- Table structure for table `memetracker_search_5`
--
CREATE TABLE IF NOT EXISTS `memetracker_search_5` (
`cid` int(10) unsigned NOT NULL default '0',
`content` varchar(255) NOT NULL default '0',
KEY `cid` (`cid`),
FULLTEXT KEY `content_index` (`content`)
) TYPE=MyISAM;
--
-- Dumping data for table `memetracker_search_5`
--
-- --------------------------------------------------------
--
-- Table structure for table `memetracker_search_6`
--
CREATE TABLE IF NOT EXISTS `memetracker_search_6` (
`cid` int(10) unsigned NOT NULL default '0',
`content` varchar(255) NOT NULL default '0',
KEY `cid` (`cid`),
FULLTEXT KEY `content_index` (`content`)
) TYPE=MyISAM;
--
-- Dumping data for table `memetracker_search_6`
--
-- --------------------------------------------------------
--
-- Table structure for table `memetracker_search_7`
--
CREATE TABLE IF NOT EXISTS `memetracker_search_7` (
`cid` int(10) unsigned NOT NULL default '0',
`content` varchar(255) NOT NULL default '0',
KEY `cid` (`cid`),
FULLTEXT KEY `content_index` (`content`)
) TYPE=MyISAM;
--
-- Dumping data for table `memetracker_search_7`
--
-- --------------------------------------------------------
--
-- Table structure for table `memetracker_search_8`
--
CREATE TABLE IF NOT EXISTS `memetracker_search_8` (
`cid` int(10) unsigned NOT NULL default '0',
`content` varchar(255) NOT NULL default '0',
KEY `cid` (`cid`),
FULLTEXT KEY `content_index` (`content`)
) TYPE=MyISAM;
--
-- Dumping data for table `memetracker_search_8`
--
-- --------------------------------------------------------
--
-- Table structure for table `memetracker_search_9`
--
CREATE TABLE IF NOT EXISTS `memetracker_search_9` (
`cid` int(10) unsigned NOT NULL default '0',
`content` varchar(255) NOT NULL default '0',
KEY `cid` (`cid`),
FULLTEXT KEY `content_index` (`content`)
) TYPE=MyISAM;
--
-- Dumping data for table `memetracker_search_9`
--
-- --------------------------------------------------------
--
-- Table structure for table `memetracker_search_10`
--
CREATE TABLE IF NOT EXISTS `memetracker_search_10` (
`cid` int(10) unsigned NOT NULL default '0',
`content` varchar(255) NOT NULL default '0',
KEY `cid` (`cid`),
FULLTEXT KEY `content_index` (`content`)
) TYPE=MyISAM;
--
-- Dumping data for table `memetracker_search_10`
--
I've been trying to setup memetracker with my existing host. Can you help me?
Hi,
I can certainly help you. Please contact me via "contact" tab on my profile.
Good Day
Vinay Yadav
VinayRas Infotech, Nagpur
http://www.vinayras.com
I am getting the following error:
user warning: Table 'mathe341_drpl1.memetracker_search_1' doesn't exist query: SELECT content FROM memetracker_search_1 WHERE cid = 1 in /home/mathe341/public_html/drupal/modules/memetracker/content.inc on line 172.
Post new comment