[TYPO3-core] database indexes

Jigal van Hemert jigal.van.hemert at typo3.org
Mon Aug 19 13:46:15 CEST 2013


Hi,

On 19-8-2013 12:14, Steffen Kamper wrote:
> ERROR 1005 (HY000) at line 672: Can't create table
> 'cf_extbase_reflection_tags' (errno: -1)

Very strange. The manual [1] mentions:

  1005 (ER_CANT_CREATE_TABLE)

Cannot create table. If the error message refers to error 150, table 
creation failed because a foreign key constraint was not correctly 
formed. If the error message refers to error –1, table creation probably 
failed because the table includes a column name that matched the name of 
an internal InnoDB table.

That would mean that all your tables are internal InnoDB tables :-)

A quick search indicates some origins of such errors:
- insufficient disk space
- table files were removed instead of dropping the tables first. InnoDB 
still has the table names somewhere and refuses to recreate them.

> What makes me wonder is that indexes are used with same name, so there
> are a lot of duplicate index names. I will retry with renaming all these
> indexes to see if this is the problem.

Indexes only have a name to identify them. This is needed when you drop 
or alter an index, explain a query or use them as a hint for the query 
optimizer. Tables, columns, indexes, etc. can all have identical names 
without any technical problems.

[1] http://dev.mysql.com/doc/refman/5.5/en/innodb-error-codes.html

-- 
Jigal van Hemert
TYPO3 CMS Active Contributor

TYPO3 .... inspiring people to share!
Get involved: typo3.org


More information about the TYPO3-team-core mailing list