problem working with migrations

Hello, I have a bundle where I am using bundle inheritance of OroCRM contact bundle, inside my custom bundle I created a migration class bellow, I ran the app/console oro:migration:load –force and the result is that the field is added to the database table but I can not see it on orocrm entities page, and can not use it on forms, can anybody help ?

PHP

class AddOroCRMCustomFields implements Migration { public function up(Schema $schema, QueryBag $queries) { $table = $schema->getTable('orocrm_contact'); $table->addColumn( 'cpf', 'bigint', ['notnull' => false], array('oro_options' => array( 'extend' => array('is_extend' => true, 'owner' => ExtendScope::OWNER_CUSTOM), 'datagrid' => array('is_visible' => true), 'merge' => array('display' => true), 'dataaudit' => ['auditable' => true], 'searchable' => true )) ); $table->addIndex(['cpf'], 'cpf_idx', []); } }

1 2 3 4 5 6 7 8 9 10 11 12 13 14 15 16 17 18 19 20 21 22

class AddOroCRMCustomFields implements Migration {     public function up(Schema $schema, QueryBag $queries)     {         $table = $schema->getTable('orocrm_contact');         $table->addColumn(             'cpf',             'bigint',             ['notnull' => false],             array('oro_options' => array(                 'extend' => array('is_extend' => true, 'owner' => ExtendScope::OWNER_CUSTOM),                 'datagrid' => array('is_visible' => true),                 'merge' => array('display' => true),                 'dataaudit' => ['auditable' => true],                 'searchable' => true             ))         );           $table->addIndex(['cpf'], 'cpf_idx', []);       } }

Topic

[Yurii MuratovParticipant]

Hi, @pauloasterio.

Your error in addColumn method call. This function has only 3 parameters, but you set 4.

So, the right code will be:

PHP

public function up(Schema $schema, QueryBag $queries) { $table = $schema->getTable('orocrm_contact'); $table->addColumn( 'cpf', 'bigint', [ 'notnull' => false, 'oro_options' => [ 'extend' => ['is_extend' => true, 'owner' => ExtendScope::OWNER_CUSTOM], 'datagrid' => ['is_visible' => true], 'merge' => ['display' => true], 'dataaudit' => ['auditable' => true], 'searchable' => true ] ] ); }

1 2 3 4 5 6 7 8 9 10 11 12 13 14 15 16 17 18

public function up(Schema $schema, QueryBag $queries)     {         $table = $schema->getTable('orocrm_contact');         $table->addColumn(             'cpf',             'bigint',             [                 'notnull'     => false,                 'oro_options' => [                     'extend'     => ['is_extend' => true, 'owner' => ExtendScope::OWNER_CUSTOM],                     'datagrid'   => ['is_visible' => true],                     'merge'      => ['display' => true],                     'dataaudit'  => ['auditable' => true],                     'searchable' => true                 ]             ]         );     }

Additional note.

You should not add index for your field manually because you set datagrid parameter as true. In this case, index will be created automatically for this field.

[Author]

Replies