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

[Regine Rosewich]

Hi Francois,

as I have a Flow-Application with a very large database I occasionally got
that error as well and did not know where it came from. In the end I found
out that my Mac had different php.ini files for the web-server and the
cli-commands. Enlarging the amount of memory available to the php-cli
[memory-limit] process to the maximum possible solved my problem.

Regine


Am 26.08.13 18:04 schrieb "François Suter" unter <fsu-lists at cobweb.ch>:

>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/DB
>AL/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/
>
>_______________________________________________
>Flow mailing list
>Flow at lists.typo3.org
>http://lists.typo3.org/cgi-bin/mailman/listinfo/flow