Mautic Community Forums

New contacts have no points and the Engagements chart does not show any data

Theses features does not work since the update to 2.9.0. The problem has been identified in 2 installations. Another 2 installations on the same server do not have the issue.

All 4 installations are in the exact same server (same system, php version, database (MySQL))

All cron jobs are correctly configured (the feature has worked for last five months)



This is the log output:

Code:
[2017-07-14 09:53:10] mautic.CRITICAL: Uncaught PHP Exception DoctrineORMQueryQueryException: "[Semantical Error] line 0, col 67 near 'createdBy) =': Error: Invalid PathExpression. Must be a SingleValuedAssociationField." at /var/www/clients/client0/web12/web/vendor/doctrine/orm/lib/Doctrine/ORM/Query/QueryException.php line 63 {"exception":"[object] (DoctrineORMQueryQueryException(code: 0): [Semantical Error] line 0, col 67 near 'createdBy) =': Error: Invalid PathExpression. Must be a SingleValuedAssociationField. at /var/www/clients/client0/web12/web/vendor/doctrine/orm/lib/Doctrine/ORM/Query/QueryException.php:63, DoctrineORMQueryQueryException(code: 0): SELECT r FROM MauticReportBundleEntityReport r WHERE IDENTITY(r.createdBy) = :dDzPvenT AND r.name LIKE :mLpiTJQq ORDER BY r.name ASC at /var/www/clients/client0/web12/web/vendor/doctrine/orm/lib/Doctrine/ORM/Query/QueryException.php:41)"} []

Anyone is getting this issue or have a idea for solution?

Theses features does not work since the update to 2.9.0. The problem has been identified in 2 installations. Another 2 installations on the same server do not have the issue.
All 4 installations are in the exact same server (same system, php version, database (MySQL))
All cron jobs are correctly configured (the feature has worked for last five months)

This is the log output:

[2017-07-14 09:53:10] mautic.CRITICAL: Uncaught PHP Exception DoctrineORMQueryQueryException: "[Semantical Error] line 0, col 67 near 'createdBy) =': Error: Invalid PathExpression. Must be a SingleValuedAssociationField." at /var/www/clients/client0/web12/web/vendor/doctrine/orm/lib/Doctrine/ORM/Query/QueryException.php line 63 {"exception":"[object] (DoctrineORMQueryQueryException(code: 0): [Semantical Error] line 0, col 67 near 'createdBy) =': Error: Invalid PathExpression. Must be a SingleValuedAssociationField. at /var/www/clients/client0/web12/web/vendor/doctrine/orm/lib/Doctrine/ORM/Query/QueryException.php:63, DoctrineORMQueryQueryException(code: 0): SELECT r FROM MauticReportBundleEntityReport r WHERE IDENTITY(r.createdBy) = :dDzPvenT AND r.name LIKE :mLpiTJQq ORDER BY r.name ASC at /var/www/clients/client0/web12/web/vendor/doctrine/orm/lib/Doctrine/ORM/Query/QueryException.php:41)"} []

Anyone is getting this issue or have a idea for solution?