Bug #17620
closedIndexed_Search is making mistakes after installation.....
0%
Description
I tried to install the indexed_search extension. The installation was successfully. But after this it created error messages in the FrontEnd and Backend.
There seems something wrong in the SQL Datas of this extension. No tables will be created with some tables.
These are the tables which I can not install in the MySQL Database:
CREATE TABLE index_phash (
phash int(11) NOT NULL default '0',
phash_grouping int(11) NOT NULL default '0',
cHashParams tinyblob NOT NULL,
data_filename tinytext NOT NULL,
data_page_id int(11) unsigned NOT NULL default '0',
data_page_reg1 int(11) unsigned NOT NULL default '0',
data_page_type tinyint(3) unsigned NOT NULL default '0',
data_page_mp tinytext NOT NULL,
gr_list tinytext NOT NULL,
item_type varchar(5) NOT NULL default '',
item_title tinytext NOT NULL,
item_description tinytext NOT NULL,
item_mtime int(11) NOT NULL default '0',
tstamp int(11) unsigned NOT NULL default '0',
item_size int(11) NOT NULL default '0',
contentHash int(11) NOT NULL default '0',
crdate int(11) NOT NULL default '0',
parsetime int(11) NOT NULL default '0',
sys_language_uid int(11) NOT NULL default '0',
item_crdate int(11) NOT NULL default '0',
externalUrl tinyint(3) NOT NULL default '0',
recordUid int(11) NOT NULL default '0',
freeIndexUid int(11) NOT NULL default '0',
freeIndexSetId int(11) NOT NULL default '0',
PRIMARY KEY (phash),
KEY phash_grouping (phash_grouping),
KEY freeIndexUid (freeIndexUid)
) TYPE=InnoDB;
CREATE TABLE index_fulltext (
phash int(11) NOT NULL default '0',
fulltextdata mediumtext NOT NULL,
PRIMARY KEY (phash)
) TYPE=InnoDB;
CREATE TABLE index_rel (
phash int(11) NOT NULL default '0',
wid int(11) NOT NULL default '0',
count tinyint(3) unsigned NOT NULL default '0',
first tinyint(3) unsigned NOT NULL default '0',
freq smallint(5) unsigned NOT NULL default '0',
flags tinyint(3) unsigned NOT NULL default '0',
PRIMARY KEY (phash,wid),
KEY wid (wid,phash)
) TYPE=InnoDB;
CREATE TABLE index_words (
wid int(11) NOT NULL default '0',
baseword varchar(60) NOT NULL default '',
metaphone int(11) NOT NULL default '0',
is_stopword tinyint(3) NOT NULL default '0',
PRIMARY KEY (wid),
KEY baseword (baseword,wid),
KEY metaphone (metaphone,wid)
) TYPE=InnoDB;
CREATE TABLE index_section (
phash int(11) NOT NULL default '0',
phash_t3 int(11) NOT NULL default '0',
rl0 int(11) unsigned NOT NULL default '0',
rl1 int(11) unsigned NOT NULL default '0',
rl2 int(11) unsigned NOT NULL default '0',
page_id int(11) NOT NULL default '0',
uniqid int(11) 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=InnoDB;
CREATE TABLE index_grlist (
phash int(11) NOT NULL default '0',
phash_x int(11) NOT NULL default '0',
hash_gr_list int(11) NOT NULL default '0',
gr_list tinytext NOT NULL,
uniqid int(11) NOT NULL auto_increment,
PRIMARY KEY (uniqid),
KEY joinkey (phash,hash_gr_list),
KEY phash_grouping (phash_x,hash_gr_list)
) TYPE=InnoDB;
CREATE TABLE index_stat_search (
uid int(11) NOT NULL auto_increment,
searchstring tinytext NOT NULL,
searchoptions blob NOT NULL,
tstamp int(11) NOT NULL default '0',
feuser_id int(11) unsigned NOT NULL default '0',
cookie varchar(10) NOT NULL default '',
IP tinytext NOT NULL,
hits int(11) NOT NULL default '0',
PRIMARY KEY (uid)
) TYPE=InnoDB;
CREATE TABLE index_stat_word (
uid int(11) NOT NULL auto_increment,
word varchar(30) NOT NULL default '',
index_stat_search_id int(11) NOT NULL default '0',
tstamp int(11) NOT NULL default '0',
pageid int(11) NOT NULL default '0',
PRIMARY KEY (uid),
KEY tstamp (tstamp,word)
) TYPE=InnoDB;
These tables I canĀ“t compare with the DatabaseAnalyser in the Install Tool.
(issue imported from #M6371)
Updated by Michael Stucki about 17 years ago
So, what does the log say? Turn on $TYPO3_CONF_VARS['SYS']['sqlDebug'] to see more details.
This is definitely not a TYPO3 bug.
Updated by maddin about 17 years ago
The log says following:
caller t3lib_DB::admin_query
ERROR Can't create table './d00246ab/index_phash.frm' (errno: 121)
lastBuiltQuery CREATE TABLE index_phash (
phash int(11) NOT NULL default '0',
phash_grouping int(11) NOT NULL default '0',
cHashParams tinyblob NOT NULL,
data_filename tinytext NOT NULL,
data_page_id int(11) unsigned NOT NULL default '0',
data_page_reg1 int(11) unsigned NOT NULL default '0',
data_page_type tinyint(3) unsigned NOT NULL default '0',
data_page_mp tinytext NOT NULL,
gr_list tinytext NOT NULL,
item_type varchar(5) NOT NULL default '',
item_title tinytext NOT NULL,
item_description tinytext NOT NULL,
item_mtime int(11) NOT NULL default '0',
tstamp int(11) unsigned NOT NULL default '0',
item_size int(11) NOT NULL default '0',
contentHash int(11) NOT NULL default '0',
crdate int(11) NOT NULL default '0',
parsetime int(11) NOT NULL default '0',
sys_language_uid int(11) NOT NULL default '0',
item_crdate int(11) NOT NULL default '0',
externalUrl tinyint(3) NOT NULL default '0',
recordUid int(11) NOT NULL default '0',
freeIndexUid int(11) NOT NULL default '0',
freeIndexSetId int(11) NOT NULL default '0',
PRIMARY KEY (phash),
KEY phash_grouping (phash_grouping),
KEY freeIndexUid (freeIndexUid)
) TYPE=InnoDB;
debug_backtrace sc_mod_tools_em_index->main // sc_mod_tools_em_index->showextdetails // sc_mod_tools_em_index->updatesform // sc_mod_tools_em_index->checkdbupdates // t3lib_install->performupdatequeries // t3lib_db->admin_query // t3lib_db->debug
caller t3lib_DB::admin_query
ERROR Can't create table './d00246ab/index_fulltext.frm' (errno: 121)
lastBuiltQuery CREATE TABLE index_fulltext (
phash int(11) NOT NULL default '0',
fulltextdata mediumtext NOT NULL,
PRIMARY KEY (phash)
) TYPE=InnoDB;
debug_backtrace sc_mod_tools_em_index->main // sc_mod_tools_em_index->showextdetails // sc_mod_tools_em_index->updatesform // sc_mod_tools_em_index->checkdbupdates // t3lib_install->performupdatequeries // t3lib_db->admin_query // t3lib_db->debug
caller t3lib_DB::admin_query
ERROR Can't create table './d00246ab/index_rel.frm' (errno: 121)
lastBuiltQuery CREATE TABLE index_rel (
phash int(11) NOT NULL default '0',
wid int(11) NOT NULL default '0',
count tinyint(3) unsigned NOT NULL default '0',
first tinyint(3) unsigned NOT NULL default '0',
freq smallint(5) unsigned NOT NULL default '0',
flags tinyint(3) unsigned NOT NULL default '0',
PRIMARY KEY (phash,wid),
KEY wid (wid,phash)
) TYPE=InnoDB;
debug_backtrace sc_mod_tools_em_index->main // sc_mod_tools_em_index->showextdetails // sc_mod_tools_em_index->updatesform // sc_mod_tools_em_index->checkdbupdates // t3lib_install->performupdatequeries // t3lib_db->admin_query // t3lib_db->debug
caller t3lib_DB::admin_query
ERROR Can't create table './d00246ab/index_words.frm' (errno: 121)
lastBuiltQuery CREATE TABLE index_words (
wid int(11) NOT NULL default '0',
baseword varchar(60) NOT NULL default '',
metaphone int(11) NOT NULL default '0',
is_stopword tinyint(3) NOT NULL default '0',
PRIMARY KEY (wid),
KEY baseword (baseword,wid),
KEY metaphone (metaphone,wid)
) TYPE=InnoDB;
debug_backtrace sc_mod_tools_em_index->main // sc_mod_tools_em_index->showextdetails // sc_mod_tools_em_index->updatesform // sc_mod_tools_em_index->checkdbupdates // t3lib_install->performupdatequeries // t3lib_db->admin_query // t3lib_db->debug
caller t3lib_DB::admin_query
ERROR Can't create table './d00246ab/index_section.frm' (errno: 121)
lastBuiltQuery CREATE TABLE index_section (
phash int(11) NOT NULL default '0',
phash_t3 int(11) NOT NULL default '0',
rl0 int(11) unsigned NOT NULL default '0',
rl1 int(11) unsigned NOT NULL default '0',
rl2 int(11) unsigned NOT NULL default '0',
page_id int(11) NOT NULL default '0',
uniqid int(11) 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=InnoDB;
debug_backtrace sc_mod_tools_em_index->main // sc_mod_tools_em_index->showextdetails // sc_mod_tools_em_index->updatesform // sc_mod_tools_em_index->checkdbupdates // t3lib_install->performupdatequeries // t3lib_db->admin_query // t3lib_db->debug
caller t3lib_DB::admin_query
ERROR Can't create table './d00246ab/index_grlist.frm' (errno: 121)
lastBuiltQuery CREATE TABLE index_grlist (
phash int(11) NOT NULL default '0',
phash_x int(11) NOT NULL default '0',
hash_gr_list int(11) NOT NULL default '0',
gr_list tinytext NOT NULL,
uniqid int(11) NOT NULL auto_increment,
PRIMARY KEY (uniqid),
KEY joinkey (phash,hash_gr_list),
KEY phash_grouping (phash_x,hash_gr_list)
) TYPE=InnoDB;
debug_backtrace sc_mod_tools_em_index->main // sc_mod_tools_em_index->showextdetails // sc_mod_tools_em_index->updatesform // sc_mod_tools_em_index->checkdbupdates // t3lib_install->performupdatequeries // t3lib_db->admin_query // t3lib_db->debug
caller t3lib_DB::admin_query
ERROR Can't create table './d00246ab/index_stat_search.frm' (errno: 121)
lastBuiltQuery CREATE TABLE index_stat_search (
uid int(11) NOT NULL auto_increment,
searchstring tinytext NOT NULL,
searchoptions blob NOT NULL,
tstamp int(11) NOT NULL default '0',
feuser_id int(11) unsigned NOT NULL default '0',
cookie varchar(10) NOT NULL default '',
IP tinytext NOT NULL,
hits int(11) NOT NULL default '0',
PRIMARY KEY (uid)
) TYPE=InnoDB;
debug_backtrace sc_mod_tools_em_index->main // sc_mod_tools_em_index->showextdetails // sc_mod_tools_em_index->updatesform // sc_mod_tools_em_index->checkdbupdates // t3lib_install->performupdatequeries // t3lib_db->admin_query // t3lib_db->debug
caller t3lib_DB::admin_query
ERROR Can't create table './d00246ab/index_stat_word.frm' (errno: 121)
lastBuiltQuery CREATE TABLE index_stat_word (
uid int(11) NOT NULL auto_increment,
word varchar(30) NOT NULL default '',
index_stat_search_id int(11) NOT NULL default '0',
tstamp int(11) NOT NULL default '0',
pageid int(11) NOT NULL default '0',
PRIMARY KEY (uid),
KEY tstamp (tstamp,word)
) TYPE=InnoDB;
debug_backtrace sc_mod_tools_em_index->main // sc_mod_tools_em_index->showextdetails // sc_mod_tools_em_index->updatesform // sc_mod_tools_em_index->checkdbupdates // t3lib_install->performupdatequeries // t3lib_db->admin_query // t3lib_db->debug
What can I do now?
Updated by Christian Kuhn over 15 years ago
This should be resolved with no change required. This is not a TYPO3 bug, but a problem with the local mysql installation or environment or something like that.
Please torture your favorite search engine for more informations on this error message.
Updated by Michael Stucki over 15 years ago
Seems like the MySQL table is corrupt. Please search for the error message on the Internet. It is definitely not a TYPO3 issue.