[hemham914Participant]

I’ve attempted to implement this process in my application like so:

<?php namespace Stc\Bundle\SalesBundle\Migrations\Schema\v1_99; use Doctrine\DBAL\Schema\Schema; use Oro\Bundle\EntityExtendBundle\Migration\Extension\ExtendExtension; use Oro\Bundle\EntityExtendBundle\Migration\Extension\ExtendExtensionAwareInterface; use Oro\Bundle\MigrationBundle\Migration\Migration; use Oro\Bundle\MigrationBundle\Migration\QueryBag; class StcSalesBundle implements Migration, ExtendExtensionAwareInterface { protected $extendExtension; public function setExtendExtension(ExtendExtension $extendExtension) { $this->extendExtension = $extendExtension; } public function up(Schema $schema, QueryBag $queries) { $table = $schema->getTable('orocrm_sales_lead'); $this->extendExtension->addOneToManyRelation( $schema, $table, 'leads_bands', 'stc_bands', ['name'], ['description','tributeto'], ['name'], [ 'extend' => ['is_extend' => true] ] ); $this->extendExtension->addManyToManyRelation( $schema, $table, 'leads_venues', 'stc_venues', ['name'], ['description'], ['id'], [ 'extend' => ['is_extend' => true] ] ); } }

1 2 3 4 5 6 7 8 9 10 11 12 13 14 15 16 17 18 19 20 21 22 23 24 25 26 27 28 29 30 31 32 33 34 35 36 37 38 39 40 41 42 43 44 45 46 47 48 49 50 51 52 53

<?php   namespace Stc\Bundle\SalesBundle\Migrations\Schema\v1_99;   use Doctrine\DBAL\Schema\Schema; use Oro\Bundle\EntityExtendBundle\Migration\Extension\ExtendExtension; use Oro\Bundle\EntityExtendBundle\Migration\Extension\ExtendExtensionAwareInterface; use Oro\Bundle\MigrationBundle\Migration\Migration; use Oro\Bundle\MigrationBundle\Migration\QueryBag;   class StcSalesBundle implements Migration, ExtendExtensionAwareInterface {     protected $extendExtension;       public function setExtendExtension(ExtendExtension $extendExtension)     {         $this->extendExtension = $extendExtension;     }       public function up(Schema $schema, QueryBag $queries)     {         $table = $schema->getTable('orocrm_sales_lead');           $this->extendExtension->addOneToManyRelation(             $schema,             $table,             'leads_bands',             'stc_bands',             ['name'],             ['description','tributeto'],             ['name'],             [                 'extend' => ['is_extend' => true]             ]         );           $this->extendExtension->addManyToManyRelation(             $schema,             $table,             'leads_venues',             'stc_venues',             ['name'],             ['description'],             ['id'],             [                 'extend' => ['is_extend' => true]             ]         );       } }

It seems to work fine when i run oro:migration:load --force --show-queries, however when I update the schema with the oro:entity-extend:update-schema command, I get the following error:

[Doctrine\DBAL\DBALException] An exception occurred while executing 'DROP INDEX UNIQ_73DB4633261574D ON orocrm_sales_lead': SQLSTATE[HY000]: General error: 1025 Error on rename of './oro_crm/#sql-75c_2bbe3' to './oro_crm/orocrm_sales_lead' (errno: 150) [PDOException] SQLSTATE[HY000]: General error: 1025 Error on rename of './oro_crm/#sql-75c_2bbe3' to './oro_crm/orocrm_sales_lead' (errno: 150)

1 2 3 4 5 6 7 8 9 10

[Doctrine\DBAL\DBALException]   An exception occurred while executing 'DROP INDEX UNIQ_73DB4633261574D ON orocrm_sales_lead':   SQLSTATE[HY000]: General error: 1025 Error on rename of './oro_crm/#sql-75c_2bbe3' to './oro_crm/orocrm_sales_lead' (errno: 150)     [PDOException]   SQLSTATE[HY000]: General error: 1025 Error on rename of './oro_crm/#sql-75c_2bbe3' to './oro_crm/orocrm_sales_lead' (errno: 150)

Any ideas?

---

~Coding my life away~

[hemham914Participant]

Hi,

I think that an option like that would cause an increase in both spam and things like what may be called pseudo-scams – such as someone holding off on giving the best answer until they are compensated. I would consider the forum to be a integral piece of the OroCRM documentation (given that the current official documentation is not finished).

That aside, most of the answers come from the oro staff anyway because of the fact that there is so little official documentation…the docs in the code provide more of a reference than a how-to, so that’s the reason this forum is so useful.

Just my thoughts anyways.

---

~Coding my life away~

[hemham914Participant]

Hello Hiro. I’m having the same error and it started happening after I updated to the latest release (1.3.0). The workaround you posted does work, however if you want to make this modification without actually changing code in the vendor directory, you can override any template like so :

1. Make a new folder under the app/Resources and name it the Symfony short name version of the bundle (ex: “OroEmailBundle” or “OroCRMSalesBundle”)

2. Inside that folder you are going to replicate wherever the template’s directory under its view folder of the template you want to override and name the file the same as the original. In this case, my app/Resources folder looks like this:

app/ Resources/ OroEmailBundle/ views/ Dashboard/ recentEmailsGrid.html.twig

1 2 3 4 5 6 7 8

app/    Resources/        OroEmailBundle/            views/                Dashboard/                    recentEmailsGrid.html.twig

3. Copy the entire original file contents to the blank one under the app/ folder and make any modifications you want to in this new file.

Essentially, this mechanism overrides the default template and instead will use your modified version. The folder & file names must be exact for this to work.

Hope it helps at least until there’s a fix released.

---

~Coding my life away~

[hemham914Participant]

Try updating composer:

php composer.phar update

Then re-run your database:create command

---

~Coding my life away~

[hemham914Participant]

Your absolutely right that was the problem Thank you!

---

~Coding my life away~

[hemham914Participant]

I don’t see where that is in the code I posted above. Where do you see that at?

If it helps the code is on github :

---

~Coding my life away~

[hemham914Participant]

I have a related question. On the dashboard I remember I somehow changed the navigation to be a bitchin slimmed down left hand sided dropdown panel but now that I have upgraded the navigation is back to the old horizontal (sugary) panel.

Does anyone happen to know how and where to adjust this? I doubt the feature would be deprecated in the newest release so it has to be something small I’m not seeing.

---

~Coding my life away~

[hemham914Participant]

Btw thank you for the help thus far.

---

~Coding my life away~

[hemham914Participant]

The command ran successfully, however I now have these problems:
– Any route with the ‘#url’ param on the end of it will not work at all, spitting out an ‘unexpected content format’ error in firebug console
– I still see the 2 warnings I wrote in my previous post
– The datatables are all misaligned & have parts of the horizontal rules missing
– The labels appear as the label name (i.e. oro.datagrid.pagination.label)

I do have custom bundles but they’ve never caused any problems like this.

It might also be interesting to note that as I look at the database itself, I’m noticing multiple tables with strange names like ‘oro_rel_26535370b28b6f386b760ee’. There’s 4 of them and they are seem to be related to the ’email’ entity.

I am now puzzled.

---

~Coding my life away~

[hemham914Participant]

Okay I fixed the content displaying by running oro:migration:load –force.

However now I’m getting 2 warnings that I have no clue how to address:

1. Warning: Cannot redeclare class in C:\xampp\htdocs\orocrm\crm-application\vendor\oro\platform\src\Oro\Bundle\EntityExtendBundle\Tools\ExtendClassLoadingUtils.php on line 77

2. Deprecated: This method is deprecated. You really need this setter ? Please tell us in what conditions by creating an issue at http://github.com/KnpLabs/KnpMenu. in C:\xampp\htdocs\orocrm\crm-application\vendor\knplabs\knp-menu\src\Knp\Menu\Matcher\Voter\UriVoter.php on line 22

Any ideas on these items would be appreciated, thank you.

---

~Coding my life away~

[hemham914Participant]

One last note.

In firebug I can see that there is some type of javascript error that reads : ” Error: The route “oro_api_get_calendarevents” does not exist. ”

---

~Coding my life away~

[hemham914Participant]

I made an error in my description of this issue..

The navigation menus do display, however they are not clickable and the dropdowns don’t function on scroll over either.

---

~Coding my life away~

[hemham914Participant]

I also experience this problem. I do have a few custom modules but they really don’t do anything too crazy but still the platform seems slow. I thought of trying to install an accelerator for php and seeing if that helps mitigate some of the wait time.

It could be the caching system inside oro that may or may not be optimized (which is to be expected given the age of the project). All in all it does seem sluggish. Still like it though!

---

~Coding my life away~

[hemham914Participant]

Okay so in my first example what would I do if I just wanted a single item to be selected of a custom entity type?

---

~Coding my life away~

[hemham914Participant]

You are awesome worked like a charm. Since we are on the subject, how would I go about selecting multiple contacts in a form?

Thank you

---

~Coding my life away~

[Author]

Replies