---
title: "Indexed Search - Fehler in SQL Dateien"
url: "https://www.typo3.net/d/68367-indexed-search-fehler-in-sql-dateien"
source: "typo3.net"
tags: ["Extensions","Frage"]
created: "2007-09-19"
last_reply: "2007-09-19"
replies: 1
solved: false
page: 1
pages: 1
lang: "de"
---

# Indexed Search - Fehler in SQL Dateien

Extensions · 1 Antwort · gestartet 2007-09-19

## Eröffnungsbeitrag

**timmy2007** · 2007-09-19 · [Beitrag #1](https://www.typo3.net/d/68367-indexed-search-fehler-in-sql-dateien/1)

Ich habe folgende Tabellen seit mehreren Tagen über den "DatabaseAnalyser" und der Compare Funktion versucht zu bearbeiten.

Komischerweise lassen sich die folgenden Tabellen **nicht** in der MySQL Datenbank installieren:

> 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;

Woran kann das liegen?

Nutze Typo3 4.1.2, PHP 4.4.4 und MySQL 4.0.2.3 Version.

## Antworten

### [#2](https://www.typo3.net/d/68367-indexed-search-fehler-in-sql-dateien/2) · nicki4lu · 2007-09-19

Was wird denn für ein Fehler zurück gegeben?

---

Quelle: „Indexed Search - Fehler in SQL Dateien“, typo3.net, https://www.typo3.net/d/68367-indexed-search-fehler-in-sql-dateien
Beiträge von Mitgliedern des Forums. Bitte mit Link auf die Diskussion zitieren.