[Typo3] indexed search: no indexing

[Michael Kaufmann]

Peter Niederlag wrote:

>
> what version of TYPO3?
> what version of tx_indexedsearch?
>
> What does Install-Tool/Db-Analyzer/db-compare tell about the status of 
> your DB?
>
> Cheers,
> Peter


Typo3 version 3.7
indexed_search: 2.1.3

ahh ...

There seems to be a number of differencies between the database and the 
selected SQL-file. Please select which statements you want to execute in 
order to update your database:


      Add tables

	CREATE TABLE index_grlist (
phash int(11) DEFAULT '0' NOT NULL,
phash_x int(11) DEFAULT '0' NOT NULL,
hash_gr_list int(11) DEFAULT '0' NOT NULL,
gr_list tinytext NOT NULL,
uniqid int(11) DEFAULT '0' NOT NULL auto_increment,
PRIMARY KEY (uniqid),
KEY joinkey (phash,hash_gr_list),
KEY phash_grouping (phash_x,hash_gr_list)
) TYPE=MyISAM;
	CREATE TABLE index_section (
phash int(11) DEFAULT '0' NOT NULL,
phash_t3 int(11) DEFAULT '0' NOT NULL,
rl0 int(11) unsigned DEFAULT '0' NOT NULL,
rl1 int(11) unsigned DEFAULT '0' NOT NULL,
rl2 int(11) unsigned DEFAULT '0' NOT NULL,
page_id int(11) DEFAULT '0' NOT NULL,
uniqid int(11) DEFAULT '0' NOT NULL auto_increment,
PRIMARY KEY (uniqid),
KEY joinkey (phash,rl0),
KEY page_id (page_id),
KEY rl0 (rl0,rl1,phash),
KEY rl0_2 (rl0,phash)
) TYPE=MyISAM;
	CREATE TABLE index_stat_search (
uid int(11) DEFAULT '0' NOT NULL auto_increment,
searchstring tinytext NOT NULL,
searchoptions blob NOT NULL,
tstamp int(11) DEFAULT '0' NOT NULL,
feuser_id int(11) unsigned DEFAULT '0' NOT NULL,
cookie varchar(10) DEFAULT '' NOT NULL,
IP tinytext NOT NULL,
hits int(11) DEFAULT '0' NOT NULL,
PRIMARY KEY (uid)
) TYPE=MyISAM;
	CREATE TABLE index_stat_word (
uid int(11) DEFAULT '0' NOT NULL auto_increment,
word varchar(30) DEFAULT '' NOT NULL,
index_stat_search_id int(11) DEFAULT '0' NOT NULL,
tstamp int(11) DEFAULT '0' NOT NULL,
PRIMARY KEY (uid),
KEY tstamp (tstamp,word)
) TYPE=MyISAM;

maybe i should update them ;)

mfg