[Flow] Upgrade from FLOW3 1.1 to Flow 2.0: error with doctrine:migrate

[François Suter]

Hi all,

I got back to that topic.

> I'm trying to upgrade an existing Flow application from 1.1 to 2.0. I'm
> following the instructions given in [1].
>
> Regarding the database, it says the first step is to run:
>
> ./flow doctrine:migrate

I got further, generated the migration file and tried to execute it, but 
I run into the same kind of problem:

$ ./flow doctrine:migrationexecute --version 20130826170217 --direction up

Uncaught Exception
   An exception occurred while executing 'ALTER TABLE
   cobweb_monitoring_domain_model_server DROP PRIMARY KEY':

   SQLSTATE[HY000]: General error: 1025 Error on rename of
   './flow3_test/#sql-c9_7' to
   './flow3_test/cobweb_monitoring_domain_model_server' (errno: 150)

More Information
   Exception code      #0
   File 
/Users/fsuter/Sites/flow2/Packages/Libraries/doctrine/dbal/lib/Doctrine/DBAL/DBALException.php 
line 47

I had some server variables which were still set as latin1 (or related 
collations) and changed them all to have utf8, in the hope that it could 
help as it did for the first problem, but to no avail.

Any idea what could be wrong this time?

Cheers

-- 

Francois Suter

Work: Cobweb Development Sarl - http://www.cobweb.ch

TYPO3: Help the project! - http://typo3.org/contribute/

Appreciate my work? Support me -
http://www.monpetitcoin.com/en/francois/support-me/