[Flow] [partially SOLVED] typo3.flow:doctrine:migrate: 'Could not find any migrations to execute.' on Oracle DB

[Axel Wüstemann]

I've got it for now:

./flow typo3.flow:doctrine:create --output ora.sql

wrote statements with identifiers of maximum 30 characters to the 
ora.sql file. So I could create all Flow tables by Oracles SQLDeveloper.

But this seems only to be a workaround...

So in summery

- typo3.flow:doctrine:migrate does not find any migrations
- typo3.flow:doctrine:update & migrationgenerate generate identifiears 
with more than 30 characters
- typo3.flow:doctrine:create does it correctly

but in my case I needed to extract all my given applications tables. Is 
there an annotation to avoid there including within a migration?

Axel


Am 01.10.2013 13:42, schrieb Axel Wüstemann:
> With typo3.flow:doctrine:migrationgenerate I now generated a migration
> file.
>
> I commented all out but not the Flow tables an put the file in my
> application package in Migrations/Oracle and started than the migrate
> command again.
>
> The migration started but ended up with the "too long identifier" message.
>
> We had this a time ago (in june "Does Oracle work with Flow?"). But by
> my knowledge, this had been fixed with version 2.0.0?
>
> https://review.typo3.org/#/c/21327/
>
> Hmmm, how could I get it to work?
>
>
> Am 01.10.2013 12:19, schrieb Axel Wüstemann:
>> Hello,
>>
>> I'm developping on Oracle. My Flow instance seemed to have some trouble
>> so I decided to create it new (Flow v.2.0.0).
>>
>> So on a fresh Flow instance I try to create the Flow database tables
>> with 'typo3.flow:doctrine:migrate'.
>>
>> There is no further package installed, only the database setting points
>> to my Oracle database. The database is not empty but contains tables
>> from my project. I need to build my project on given tables, instead of
>> those generated by doctrine.
>>
>> Therefore my goal here is to create only the appropriate Flow tables,
>> but I can't.
>>
>> The result is 'Could not find any migrations to execute.'
>>
>> There apears a new table in my database: FLOW_DOCTRONE_MIGRATIONSTATUS
>> with one row.
>>
>> If I try 'typo3.flow:doctrine:update', I get
>>
>> An exception occurred while executing 'CREATE TABLE
>>    typo3_flow_resource_resourcepointer (hash VARCHAR2(255) NOT NULL,
>> PRIMARY
>>    KEY(hash))':
>>
>>    ORA-00972: identifier is too long
>>
>> Oracle allows only 30 characters for identifiers.
>>
>> What should I do?
>>
>> Thanks for any hint
>> Axel
>> _______________________________________________
>> Flow mailing list
>> Flow at lists.typo3.org
>> http://lists.typo3.org/cgi-bin/mailman/listinfo/flow
>
>


-- 
Qbus Werbeagentur GmbH

18055 Rostock, Heiligengeisthof 5
Tel:   0381 4 61 39 - 10 | Fax: - 22
21029 Hamburg, Chrysanderstraße 69A
Tel:   040 60 94 59 75
Mobil: 0179 46 455 46

www.xing.com/profile/Axel_Wuestemann
www.issuu.com/QbusAgentur/docs/qbus-referenzen?mode=embed

Handelsregister: HRB 11218 beim Amtsgericht Rostock Sitz der
Gesellschaft: Hansestadt Rostock
Geschäftsführer: Dipl.-Ing. Axel Wüstemann

www.qbus.de | www.qbus.de/qblog
www.facebook.com/QbusAgentur