Error when trying to open Email templates

[belbagri]

Description

Error when trying to open Email templates: Home > Email Templates

How to reproduce

Php: 7.2.28 DB: Server version: 5.5.64-MariaDB - MariaDB Server Symphony: 4.3.8

Go to: home > Email Templates

Possible Solution

Additional context

The following is the error message:

[Syntax Error] line 0, col 138: Error: Expected Doctrine\ORM\Query\Lexer::T_IDENTIFIER, got '/'

Query exception: Doctrine\ORM\Query\QueryException: [Syntax Error] line 0, col 138: Error: Expected Doctrine\ORM\Query\Lexer::T_IDENTIFIER, got '/'

at vendor/doctrine/orm/lib/Doctrine/ORM/Query/QueryException.php:54 at Doctrine\ORM\Query\QueryException::syntaxError('line 0, col 138: Error: Expected Doctrine\ORM\Query\Lexer::T_IDENTIFIER, got \'/\'', object(QueryException)) (vendor/doctrine/orm/lib/Doctrine/ORM/Query/Parser.php:457) at Doctrine\ORM\Query\Parser->syntaxError('Doctrine\ORM\Query\Lexer::T_IDENTIFIER') (vendor/doctrine/orm/lib/Doctrine/ORM/Query/Parser.php:325) at Doctrine\ORM\Query\Parser->match(102) (vendor/doctrine/orm/lib/Doctrine/ORM/Query/Parser.php:1084) at Doctrine\ORM\Query\Parser->PathExpression(12) (vendor/doctrine/orm/lib/Doctrine/ORM/Query/Parser.php:1130) at Doctrine\ORM\Query\Parser->SingleValuedPathExpression() (vendor/doctrine/orm/lib/Doctrine/ORM/Query/Parser.php:2844) at Doctrine\ORM\Query\Parser->ArithmeticPrimary() (vendor/doctrine/orm/lib/Doctrine/ORM/Query/Parser.php:2801) at Doctrine\ORM\Query\Parser->ArithmeticFactor() (vendor/doctrine/orm/lib/Doctrine/ORM/Query/Parser.php:2769) at Doctrine\ORM\Query\Parser->ArithmeticTerm() (vendor/doctrine/orm/lib/Doctrine/ORM/Query/Parser.php:2743) at Doctrine\ORM\Query\Parser->SimpleArithmeticExpression() (vendor/doctrine/orm/lib/Doctrine/ORM/Query/Parser.php:2730) at Doctrine\ORM\Query\Parser->ArithmeticExpression() (vendor/doctrine/orm/lib/Doctrine/ORM/Query/Parser.php:3063) at Doctrine\ORM\Query\Parser->ComparisonExpression() (vendor/doctrine/orm/lib/Doctrine/ORM/Query/Parser.php:2594) at Doctrine\ORM\Query\Parser->SimpleConditionalExpression() (vendor/doctrine/orm/lib/Doctrine/ORM/Query/Parser.php:2475) at Doctrine\ORM\Query\Parser->ConditionalPrimary() (vendor/doctrine/orm/lib/Doctrine/ORM/Query/Parser.php:2451) at Doctrine\ORM\Query\Parser->ConditionalFactor() (vendor/doctrine/orm/lib/Doctrine/ORM/Query/Parser.php:2424) at Doctrine\ORM\Query\Parser->ConditionalTerm() (vendor/doctrine/orm/lib/Doctrine/ORM/Query/Parser.php:2394) at Doctrine\ORM\Query\Parser->ConditionalExpression() (vendor/doctrine/orm/lib/Doctrine/ORM/Query/Parser.php:1361) at Doctrine\ORM\Query\Parser->WhereClause() (vendor/doctrine/orm/lib/Doctrine/ORM/Query/Parser.php:881) at Doctrine\ORM\Query\Parser->SelectStatement() (vendor/doctrine/orm/lib/Doctrine/ORM/Query/Parser.php:848) at Doctrine\ORM\Query\Parser->QueryLanguage() (vendor/doctrine/orm/lib/Doctrine/ORM/Query/Parser.php:261) at Doctrine\ORM\Query\Parser->getAST() (vendor/doctrine/orm/lib/Doctrine/ORM/Query/Parser.php:360) at Doctrine\ORM\Query\Parser->parse() (vendor/doctrine/orm/lib/Doctrine/ORM/Query.php:286) at Doctrine\ORM\Query->_parse() (vendor/doctrine/orm/lib/Doctrine/ORM/Query.php:298) at Doctrine\ORM\Query->_doExecute() (vendor/doctrine/orm/lib/Doctrine/ORM/AbstractQuery.php:967) at Doctrine\ORM\AbstractQuery->executeIgnoreQueryCache(null, 4) (vendor/doctrine/orm/lib/Doctrine/ORM/AbstractQuery.php:922) at Doctrine\ORM\AbstractQuery->execute(null, 4) (vendor/doctrine/orm/lib/Doctrine/ORM/AbstractQuery.php:803) at Doctrine\ORM\AbstractQuery->getSingleResult(4) (vendor/doctrine/orm/lib/Doctrine/ORM/AbstractQuery.php:831) at Doctrine\ORM\AbstractQuery->getSingleScalarResult() (vendor/uvdesk/core-framework/Repository/EmailTemplatesRepository.php:48) at Webkul\UVDesk\CoreFrameworkBundle\Repository\EmailTemplatesRepository->getEmailTemplates(object(ParameterBag), object(srcApp_KernelDevDebugContainer)) (vendor/uvdesk/core-framework/Controller/Email.php:105) at Webkul\UVDesk\CoreFrameworkBundle\Controller\Email->templatesxhr(object(Request)) (vendor/symfony/http-kernel/HttpKernel.php:151) at Symfony\Component\HttpKernel\HttpKernel->handleRaw(object(Request), 1) (vendor/symfony/http-kernel/HttpKernel.php:68) at Symfony\Component\HttpKernel\HttpKernel->handle(object(Request), 1, true) (vendor/symfony/http-kernel/Kernel.php:198) at Symfony\Component\HttpKernel\Kernel->handle(object(Request)) (public/index.php:25)

[vaishaliwebkul]

Hello @belbagri

refer the solution as described in this issue https://github.com/uvdesk/community-skeleton/issues/232

Thanks,

[belbagri]

Thank you @vaishaliwebkul

When I remove the ? in the .htaccess file, I end up with "No input file specified" on all pages.

Thanks,

[belbagri]

Problem solved after changing php setting from fastcgi to cgi

[vaishaliwebkul]

Nice to hear that your issue has been resolved !! :+1:

[taoufiqaitali]

i'm on a shared hosting and i have other websites, i'm not allowed to change from fastcgi to cgi how i can solve this issue?? When I remove the ? in the .htaccess file, I end up with "No input file specified" on all pages.

[vaishaliwebkul]

@taoufiqaitali You don't need to remove ? , please let me know if it's working on fresh setup or what exact issue you are facing?

[taoufiqaitali]

@vaishaliwebkul if i keep it i have this problem "[Syntax Error] line 0, col 138: Error: Expected Doctrine\ORM\Query\Lexer::T_IDENTIFIER, got '/'" in email templates and customers page

i did fresh setup

[vaishaliwebkul]

@taoufiqaitali could you please tell me the uvdesk version? I recommend you to install the latest version of uvdesk https://github.com/uvdesk/community-skeleton/releases

Thanks

[taoufiqaitali]

@vaishaliwebkul yes latest i installed using composer create-project uvdesk/community-skeleton helpdesk it not have "?" in htaccess but if i not add it i get "No input file specified" if i add it, i get the above error in other pages

[papnoisanjeev]

@taoufiqaitali

Do not add ? as after using this many URL will start giving you error after login.

Please check here may be it can help you to change php setting as per need.

[taoufiqaitali]

@papnoisanjeev i followed the link you sent but im on a shared hosting im not able to disable fastcgi,