( ! ) Fatal error: Uncaught exception 'PDOException' with message 'SQLSTATE[42000]: Syntax error or access violation: 1064 You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near 'AND hidden_profile = 0 FROM profiles.user_data WHERE gender = 'w' AND state in ' at line 1' in /var/www/best-couple/vendors/doctrine/dbal/lib/Doctrine/DBAL/DBALException.php on line 47
( ! ) PDOException: SQLSTATE[42000]: Syntax error or access violation: 1064 You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near 'AND hidden_profile = 0 FROM profiles.user_data WHERE gender = 'w' AND state in ' at line 1 in /var/www/best-couple/vendors/doctrine/dbal/lib/Doctrine/DBAL/Connection.php on line 646
Call Stack
#TimeMemoryFunctionLocation
10.0000245544{main}( ).../index.php:0
20.03694722064afw\Application->run( ).../index.php:16
30.03704723288afw\Front->dispatch( ).../Application.php:346
40.13357801384afw\Controller->action( ).../Front.php:234
50.13357801848userController->searchesAction( ).../Controller.php:87
60.13377819856App\Service\SrvProfileSearch->getListCustom( ).../userController.php:802
70.13387820784App\Service\SrvProfileSearch->_getUsersList( ).../SrvProfileSearch.php:103
80.13588069416Doctrine\DBAL\Query\QueryBuilder->execute( ).../SrvProfileSearch.php:142
90.13598070536Doctrine\DBAL\Connection->executeQuery( ).../QueryBuilder.php:185
100.13718110008query ( ).../Connection.php:646
( ! ) Doctrine\DBAL\DBALException: An exception occurred while executing 'SELECT *, IF(reg_date > UNIX_TIMESTAMP() - 1209600, 1, 0) as is_new AND hidden_profile = 0 FROM profiles.user_data WHERE gender = 'w' AND state in (2,3) AND reg_date < 1544169918 ORDER BY is_new DESC, random DESC LIMIT 10 OFFSET 0': SQLSTATE[42000]: Syntax error or access violation: 1064 You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near 'AND hidden_profile = 0 FROM profiles.user_data WHERE gender = 'w' AND state in ' at line 1 in /var/www/best-couple/vendors/doctrine/dbal/lib/Doctrine/DBAL/DBALException.php on line 47
Call Stack
#TimeMemoryFunctionLocation
10.0000245544{main}( ).../index.php:0
20.03694722064afw\Application->run( ).../index.php:16
30.03704723288afw\Front->dispatch( ).../Application.php:346
40.13357801384afw\Controller->action( ).../Front.php:234
50.13357801848userController->searchesAction( ).../Controller.php:87
60.13377819856App\Service\SrvProfileSearch->getListCustom( ).../userController.php:802
70.13387820784App\Service\SrvProfileSearch->_getUsersList( ).../SrvProfileSearch.php:103
80.13588069416Doctrine\DBAL\Query\QueryBuilder->execute( ).../SrvProfileSearch.php:142
90.13598070536Doctrine\DBAL\Connection->executeQuery( ).../QueryBuilder.php:185