[FLOW3-general] Doctrine Migration on Adding OneToOne Relationship to TYPO3.Media:Image

[Karsten Dambekalns]

Hi.

On 13.11.12 01:02, Cedric Ziel wrote:
>   SQLSTATE[HY000]: General error: 1005 Can't create table
>   'car_dev.#sql-47f_f8' (errno: 150)

The most important piece of MySQL knowledge when dealing with FK
constraints is how to get to the real error message:

 http://dev.mysql.com/doc/refman/5.1/en/show-engine.html

Immediately after the error has occurred, run the following SQL:

 SHOW ENGINE INNODB STATUS

This produces a lot of information, among them the last InnoDB error,
and that is way more helpful than the "can't create table" from above.

See http://dev.mysql.com/doc/refman/5.1/en/innodb-monitors.html for an
explanation of all the InnoDB status output.

Regards,
Karsten
-- 
Karsten Dambekalns
TYPO3 Core Developer, Neos / Flow Team

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