Custom Entity Issue

Hi,

I created a custom entity “test_entity” using UI. I checked the box under Communication & Collaboration tab Activities -> Notes

I deleted the custom entity later on using the UI and updates Schema. But the Entity still exists in the DB under oro_entity_config table.

This was creating issues since when I try to update cache using php bin/console cache:clear with below error

PHP

Processor failed: "oro_api.collect_subresources.initialize_subresources". Reason: Processor failed: "oro_api.get_config.complete_definition". Reason: Cann ot resolve dependency to "open_projects_ef5289fc" specified for "Oro\Bundle\NoteBundle\Entity\Note::activityTargets". Check "depends_on" option for this f ield.

1 2 3

Processor failed: "oro_api.collect_subresources.initialize_subresources". Reason: Processor failed: "oro_api.get_config.complete_definition". Reason: Cann   ot resolve dependency to "open_projects_ef5289fc" specified for "Oro\Bundle\NoteBundle\Entity\Note::activityTargets". Check "depends_on" option for this f   ield.

Things I have tried so far:

– Deleting the custom entity from DB in oro_entity_config table but that didnt help

– Tried php bin/console oro:entity-config:update –force hoping that Meatdata could be out of sync with real DB but that didnt help

– Created the entity again with the same name using the UI and this time didnt check the box for Notes. I was hoping that would update the dependencies, but that didnt help.

At this point I am unable to clear cache because of this. This is error I am getting now:

PHP

In AbstractMySQLDriver.php line 79: An exception occurred while executing 'SELECT t0.serialized_data AS serialized_data_1, t0.id AS id_2, t0.name AS name_3, t0.formatting_code AS formatting_ code_4, t0.created_at AS created_at_5, t0.updated_at AS updated_at_6, t0.language_id AS language_id_7, t0.parent_id AS parent_id_8 FROM oro_localization t 0 ORDER BY t0.name ASC': SQLSTATE[42S22]: Column not found: 1054 Unknown column 't0.serialized_data' in 'field list' In PDOConnection.php line 109: SQLSTATE[42S22]: Column not found: 1054 Unknown column 't0.serialized_data' in 'field list' In PDOConnection.php line 107: SQLSTATE[42S22]: Column not found: 1054 Unknown column 't0.serialized_data' in 'field list'

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

In AbstractMySQLDriver.php line 79:     An exception occurred while executing 'SELECT t0.serialized_data AS serialized_data_1, t0.id AS id_2, t0.name AS name_3, t0.formatting_code AS formatting_   code_4, t0.created_at AS created_at_5, t0.updated_at AS updated_at_6, t0.language_id AS language_id_7, t0.parent_id AS parent_id_8 FROM oro_localization t   0 ORDER BY t0.name ASC':     SQLSTATE[42S22]: Column not found: 1054 Unknown column 't0.serialized_data' in 'field list'     In PDOConnection.php line 109:     SQLSTATE[42S22]: Column not found: 1054 Unknown column 't0.serialized_data' in 'field list'     In PDOConnection.php line 107:     SQLSTATE[42S22]: Column not found: 1054 Unknown column 't0.serialized_data' in 'field list'

I’d appreciate any help with this!

Topic

[emcopley2Participant]

Never mind I just added a another custom entity and updated Schema and this seemed to have solved the issue.

Would be great to know if you have come across this in the past and why it happened but its solved for now.

Thanks!

[emcopley2Participant]

After clearing the cache I am getting HTTP: 500 error and cant access the log in page. Any thoughts?

PHP

PHP Fatal error: Uncaught TypeError: Argument 1 passed to Oro\Bundle\DistributionBundle\OroKernel::getBundlesMapping() must be of the type array, string given, called in /opt/bitnami/apps/orocrm/htdocs/vendor/oro/platform/src/Oro/Bundle/DistributionBundle/OroKernel.php on line 143 and defined in /opt/bitnami/apps/orocrm/htdocs/vendor/oro/platform/src/Oro/Bundle/DistributionBundle/OroKernel.php:163 Stack trace: #0 /opt/bitnami/apps/orocrm/htdocs/vendor/oro/platform/src/Oro/Bundle/DistributionBundle/OroKernel.php(143): Oro\Bundle\DistributionBundle\OroKernel->getBundlesMapping('...') #1 /opt/bitnami/apps/orocrm/htdocs/vendor/oro/platform/src/Oro/Bundle/DistributionBundle/OroKernel.php(65): Oro\Bundle\DistributionBundle\OroKernel->collectBundles() #2 /opt/bitnami/apps/orocrm/htdocs/src/AppKernel.php(35): Oro\Bundle\DistributionBundle\OroKernel->registerBundles() #3 /opt/bitnami/apps/orocrm/htdocs/vendor/symfony/symfony/src/Symfony/Component/HttpKernel/Kernel.php(488): AppKernel->registerBundles() #4 /opt/bitnami/apps/orocrm/htdo in /opt/bitnami/apps/orocrm/htdocs/vendor/oro/platform/src/Oro/Bundle/DistributionBundle/OroKernel.php on line 163

1 2 3 4 5 6 7

PHP Fatal error:  Uncaught TypeError: Argument 1 passed to Oro\Bundle\DistributionBundle\OroKernel::getBundlesMapping() must be of the type array, string given, called in /opt/bitnami/apps/orocrm/htdocs/vendor/oro/platform/src/Oro/Bundle/DistributionBundle/OroKernel.php on line 143 and defined in /opt/bitnami/apps/orocrm/htdocs/vendor/oro/platform/src/Oro/Bundle/DistributionBundle/OroKernel.php:163 Stack trace: #0 /opt/bitnami/apps/orocrm/htdocs/vendor/oro/platform/src/Oro/Bundle/DistributionBundle/OroKernel.php(143): Oro\Bundle\DistributionBundle\OroKernel->getBundlesMapping('...') #1 /opt/bitnami/apps/orocrm/htdocs/vendor/oro/platform/src/Oro/Bundle/DistributionBundle/OroKernel.php(65): Oro\Bundle\DistributionBundle\OroKernel->collectBundles() #2 /opt/bitnami/apps/orocrm/htdocs/src/AppKernel.php(35): Oro\Bundle\DistributionBundle\OroKernel->registerBundles() #3 /opt/bitnami/apps/orocrm/htdocs/vendor/symfony/symfony/src/Symfony/Component/HttpKernel/Kernel.php(488): AppKernel->registerBundles() #4 /opt/bitnami/apps/orocrm/htdo in /opt/bitnami/apps/orocrm/htdocs/vendor/oro/platform/src/Oro/Bundle/DistributionBundle/OroKernel.php on line 163

[Andrey YatsenkoModerator]

Looks like you have corrupted src/AppKernel.php file or some other related file, please compare it with the default one. $bundles argument must be an array, but it is a string.
https://github.com/oroinc/crm-application/blob/master/src/AppKernel.php

Also, you can reinstall vendors to make sure there are no manual changes in the vendor folder, as it must not be edited manually anyway.

[Author]

Replies