( ! ) 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.0000245520{main}( ).../index.php:0
20.04464722232afw\Application->run( ).../index.php:16
30.04464723456afw\Front->dispatch( ).../Application.php:346
40.15587802152afw\Controller->action( ).../Front.php:234
50.15587802616userController->searchesAction( ).../Controller.php:87
60.15607820624App\Service\SrvProfileSearch->getListCustom( ).../userController.php:802
70.15607821576App\Service\SrvProfileSearch->_getUsersList( ).../SrvProfileSearch.php:103
80.15848070176Doctrine\DBAL\Query\QueryBuilder->execute( ).../SrvProfileSearch.php:142
90.15858071296Doctrine\DBAL\Connection->executeQuery( ).../QueryBuilder.php:185
100.16088110736query ( ).../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 < 1544170144 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.0000245520{main}( ).../index.php:0
20.04464722232afw\Application->run( ).../index.php:16
30.04464723456afw\Front->dispatch( ).../Application.php:346
40.15587802152afw\Controller->action( ).../Front.php:234
50.15587802616userController->searchesAction( ).../Controller.php:87
60.15607820624App\Service\SrvProfileSearch->getListCustom( ).../userController.php:802
70.15607821576App\Service\SrvProfileSearch->_getUsersList( ).../SrvProfileSearch.php:103
80.15848070176Doctrine\DBAL\Query\QueryBuilder->execute( ).../SrvProfileSearch.php:142
90.15858071296Doctrine\DBAL\Connection->executeQuery( ).../QueryBuilder.php:185