search

uvdesk / automation-bundle

Automate operations within your UVDesk Community Helpdesk System based on pre-defined events triggered from your application.
MIT License
21 stars 26 forks source link

Uncaught exception on the prepared responses page #22

Closed KlaasT closed 4 years ago

KlaasT commented 4 years ago

In the administration panel I cannot open the menu for prepared responses. The loading bubbles are moving but nothing is being displayed.

I get this in the log:

[2019-09-17 07:55:35] request.CRITICAL: Uncaught PHP Exception Doctrine\ORM\Query\QueryException: "[Syntax Error] line 0, col 144: Error: Expected =, <, <=, <>, >, >=, !=, got 'en'" at /var/www/vhosts/xxx/vendor/doctrine/orm/lib/Doctrine/ORM/Query/QueryException.php line 52 {"exception":"[object] (Doctrine\ORM\Query\QueryException(code: 0): [Syntax Error] line 0, col 144: Error: Expected =, <, <=, <>, >, >=, !=, got 'en' at /var/www/vhosts/xxx/vendor/doctrine/orm/lib/Doctrine/ORM/Query/QueryException.php:52, Doctrine\ORM\Query\QueryException(code: 0): SELECT COUNT(DISTINCT pr.id) FROM Webkul\UVDesk\AutomationBundle\Entity\PreparedResponses pr LEFT JOIN pr.user ud LEFT JOIN ud.user u WHERE pr./en/member/prepared-responses/ajax = :/en/member/prepared-responses/ajax ORDER BY pr.id DESC at /var/www/vhostsxxx/vendor/doctrine/orm/lib/Doctrine/ORM/Query/QueryException.php:41)"} []

ghost commented 4 years ago

Could you please share a screenshot of PreparedResponsesRespository.php file. Path: vendor/uvdesk/automation-bundle/Repository/PreparedResponsesRepository.php