[FLOW3-general] #1025 - Error while doing doctrine update

[Robert Lemke]

Hi Mario,

On 27.03.2013, at 17:54, Mario Beiser <mariobeiser at googlemail.com> wrote:

> I deleted a former OneToOne relation within my model because it isn't
> needed anymore.
> By triggering doctrine update I am receiving an error as follow:
> 
> Uncaught Exception
>  An exception occurred while executing 'DROP INDEX UNIQ_B84BB6A67D3656A4
>  ON test_package_domain_model_prospect':
> 
>  SQLSTATE[HY000]: General error: 1025 Error on rename of
>  './test_package/#sql-4ac_ee6' to
>  './test_package/test_package_domain_model_prospect' (errno: 150)
> 
> Any idea on how to solve this?

In general you can get more information about the conflict by running this SQL query:

SHOW ENGINE INNODB STATUS;

This might guide you to what is the root conflict. In the end you will have to create a Doctrine
migration script (check the Flow package for some examples) and adjust it in a way which
avoids the conflict.

./flow doctrine:update is really only for ad-hoc adjustments and not a replacement for migration
scripts.

Cheers,
Robert