Loading...
 
Architecture / Installation

Architecture / Installation


Re: SQL error on Search

posts: 26

The fix was to create a second full text index for just 'data'. The create table script below creates a full text index for data and title.

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,title)
) TYPE=MyISAM AUTO_INCREMENT=1 ;

2
-- C --

There are no comments at this time.

Upcoming Events

1)  18 Apr 2024 14:00 GMT-0000
Tiki Roundtable Meeting
2)  16 May 2024 14:00 GMT-0000
Tiki Roundtable Meeting
3)  20 Jun 2024 14:00 GMT-0000
Tiki Roundtable Meeting
4)  18 Jul 2024 14:00 GMT-0000
Tiki Roundtable Meeting
5)  15 Aug 2024 14:00 GMT-0000
Tiki Roundtable Meeting
6)  19 Sep 2024 14:00 GMT-0000
Tiki Roundtable Meeting
7) 
Tiki birthday
8)  17 Oct 2024 14:00 GMT-0000
Tiki Roundtable Meeting
9)  21 Nov 2024 14:00 GMT-0000
Tiki Roundtable Meeting
10)  19 Dec 2024 14:00 GMT-0000
Tiki Roundtable Meeting