[TYPO3-core] database indexes

Alexander Opitz opitz at pluspol.info
Mon Aug 19 13:40:41 CEST 2013


I've no problems with this statement.

Can you look in your mysql.log file, if there is an error written?

Greetings Alex//

Steffen Kamper wrote:
> i tried with other index names, still the same problem.
> I have no idea why eg this sql fails:
> CREATE TABLE `cf_extbase_reflection` (
>   `id` int(11) unsigned NOT NULL AUTO_INCREMENT,
>   `identifier` varchar(250) NOT NULL DEFAULT '',
>   `expires` int(11) unsigned NOT NULL DEFAULT '0',
>   `content` mediumblob,
>   PRIMARY KEY (`id`),
>   KEY `cache_id` (`identifier`,`expires`)
> the .ibd file of the table is created, but no .frm file, the errno: -1
> does not help.
> I already googled for simular problems, but no clue was helpful.
> I tried same create statement with different column names, but also with
> no success.

More information about the TYPO3-team-core mailing list