Re: SQL error on Search
I had this problem with a clean install of 1.8 on WinXP. I removed the ,title from the FULLTEXT KEY entry used to create the table which now allows the search to function. I'm a new user so I'm unclear whether this will break anything else. Maybe someone closer the the project can shed some light?
Anyway, I ran the following SQL to drop and recreate the table. Let me know how you get on.
DROP TABLE IF EXISTS tiki_blog_posts;
CREATE TABLE tiki_blog_posts (
postId int(8) NOT NULL auto_increment,
blogId int(8) NOT NULL default '0',
data text,
data_size int(11) unsigned NOT NULL default '0',
created int(14) default NULL,
user varchar(200) default NULL,
trackbacks_to text,
trackbacks_from text,
title varchar(80) default NULL,
PRIMARY KEY (postId),
KEY data 255,
KEY blogId (blogId),
KEY created (created),
FULLTEXT KEY ft (data)
) TYPE=MyISAM AUTO_INCREMENT=1 ;