( ! ) 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.0001245576{main}( ).../index.php:0
20.05194722016afw\Application->run( ).../index.php:16
30.05194723240afw\Front->dispatch( ).../Application.php:346
40.16727800880afw\Controller->action( ).../Front.php:234
50.16727801344userController->searchesAction( ).../Controller.php:87
60.16757818336App\Service\SrvProfileSearch->getList( ).../userController.php:804
70.16757819264App\Service\SrvProfileSearch->_getUsersList( ).../SrvProfileSearch.php:84
80.17028067880Doctrine\DBAL\Query\QueryBuilder->execute( ).../SrvProfileSearch.php:142
90.17038069000Doctrine\DBAL\Connection->executeQuery( ).../QueryBuilder.php:185
100.17198108344query ( ).../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 < 1544170126 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.0001245576{main}( ).../index.php:0
20.05194722016afw\Application->run( ).../index.php:16
30.05194723240afw\Front->dispatch( ).../Application.php:346
40.16727800880afw\Controller->action( ).../Front.php:234
50.16727801344userController->searchesAction( ).../Controller.php:87
60.16757818336App\Service\SrvProfileSearch->getList( ).../userController.php:804
70.16757819264App\Service\SrvProfileSearch->_getUsersList( ).../SrvProfileSearch.php:84
80.17028067880Doctrine\DBAL\Query\QueryBuilder->execute( ).../SrvProfileSearch.php:142
90.17038069000Doctrine\DBAL\Connection->executeQuery( ).../QueryBuilder.php:185