OK, I did a backup of the structure of the database:
Code: Select all
#
# Table structure for table `article_articles`
#
CREATE TABLE article_articles (
id int(11) NOT NULL auto_increment,
picdir int(11) NOT NULL default '0',
name text NOT NULL,
title varchar(255) NOT NULL default '',
cat int(11) NOT NULL default '0',
description text,
author text NOT NULL,
website text NOT NULL,
websitetitle text NOT NULL,
type varchar(255) NOT NULL default '',
featured varchar(255) NOT NULL default '1',
article text,
info text NOT NULL,
uptime varchar(255) NOT NULL default '',
parent int(11) NOT NULL default '0',
pending varchar(255) NOT NULL default 'y',
email text NOT NULL,
views int(11) NOT NULL default '0',
PRIMARY KEY (id),
FULLTEXT KEY title (title,article)
) TYPE=MyISAM;
That one doesn't work...
The I found this script
http://www.onlamp.com/pub/a/onlamp/2003 ... ltext.html... here is the table...
Code: Select all
CREATE TABLE blog_entries
(
entryID INT(9) UNSIGNED NOT NULL DEFAULT '0' AUTO_INCREMENT,
posted INT(11) UNSIGNED NOT NULL DEFAULT '0',
categoryID TINYINT(2) UNSIGNED NOT NULL DEFAULT '0',
title CHAR(255) NOT NULL DEFAULT '',
entry TEXT NOT NULL DEFAULT '',
PRIMARY KEY (entryID),
KEY (posted),
KEY (categoryID),
FULLTEXT(title,entry)
);
That one works... Why does that one work and mone doesn't?
Ben