OroCRM Forums

Covering OroCRM topics, including community updates and company announcements.

This topic contains 1 reply, has 2 voices, and was last updated by  ignat 8 years, 3 months ago.

Starting from March 1, 2020 the forum has been switched to the read-only mode. Please head to StackOverflow for support.

  • Creator
    Topic
  • #26747

    adrianllopis
    Participant

    Hi all!
    I edited SalesFunnel Entity (Sales Process) and enabled all Communication & Collaboration checks.
    Now, i can’t create new Sales Process because I’m getting this error:

    [2015-10-26 13:52:55] request.CRITICAL: Uncaught PHP Exception Doctrine\DBAL\Exception\InvalidFieldNameException: "An exception occurred while executing 'SELECT count(o0_.id) AS sclr_0 FROM oro_comment o0_ WHERE o0_.sales_funnel_8fafc444_id IN (?) AND o0_.organization_id = 1' with params ["1"]: SQLSTATE[42S22]: Column not found: 1054 Unknown column 'o0_.sales_funnel_8fafc444_id' in 'where clause'" at /var/www/vhosts/crm.netik.es/httpdocs/crm-application/vendor/doctrine/dbal/lib/Doctrine/DBAL/Driver/AbstractMySQLDriver.php line 71 {"exception":"[object] (Doctrine\\DBAL\\Exception\\InvalidFieldNameException: An exception occurred while executing 'SELECT count(o0_.id) AS sclr_0 FROM oro_comment o0_ WHERE o0_.sales_funnel_8fafc444_id IN (?) AND o0_.organization_id = 1' with params [\"1\"]:\n\nSQLSTATE[42S22]: Column not found: 1054 Unknown column 'o0_.sales_funnel_8fafc444_id' in 'where clause' at /var/www/vhosts/crm.netik.es/httpdocs/crm-application/vendor/doctrine/dbal/lib/Doctrine/DBAL/Driver/AbstractMySQLDriver.php:71, Doctrine\\DBAL\\Driver\\PDOException: SQLSTATE[42S22]: Column not found: 1054 Unknown column 'o0_.sales_funnel_8fafc444_id' in 'where clause' at /var/www/vhosts/crm.netik.es/httpdocs/crm-application/vendor/doctrine/dbal/lib/Doctrine/DBAL/Driver/PDOStatement.php:93, PDOException: SQLSTATE[42S22]: Column not found: 1054 Unknown column 'o0_.sales_funnel_8fafc444_id' in 'where clause' at /var/www/vhosts/crm.netik.es/httpdocs/crm-application/vendor/doctrine/dbal/lib/Doctrine/DBAL/Driver/PDOStatement.php:91)"} []

    I tried to do oro:platform:update and clear cache, but error continues…

Viewing 1 replies (of 1 total)
  • Author
    Replies
  • #26748

    ignat
    Participant

    Hi adrianllopis,

    Maybe it’s already not an actual issue. But it looks like the problem with schema migration. Application is expecting to have relation between comment and sales process entity in your DB but you don’t have it.

    Do you have such schema migration and how it looks like? If you don’t have it maybe this is a problem of your development environment and you need to reinstall your application.

    Thanks,
    Ignat

Viewing 1 replies (of 1 total)

The forum ‘OroCRM – Installation/Technical Issues or Problems’ is closed to new topics and replies.

Back to top